Help please I have Created a value prompt called ?RankGroup? in both the global prompt and detail report
with static values of
Top 5
Top 10
Top 50
All.
I created a calculated data item as
[RankCutoff] =
CASE ?RankGroup?
WHEN 'Top 5' THEN 5
WHEN 'Top 10' THEN 10
WHEN 'Top 50' THEN 50
ELSE 'All' (or you could use a large number here)
END
Used a filter at the query level as follows:
[YourRankDataItem] <= [RankCutoff] or ?RankGroup? = 'All'
i added this prompt macro and it still does not work case #prompt('pRankGroup','string',sq('pRankGroup'))#
Ok I am still having this issue where the global filter does not flow to the detail tab report