If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Global Prompt on page not working for detail report.

Started by maxchuie, 17 Feb 2014 09:27:35 AM

Previous topic - Next topic

maxchuie


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'



maxchuie

i added this prompt macro and it still does not work case #prompt('pRankGroup','string',sq('pRankGroup'))#

maxchuie

Ok I am still having this issue where the global filter does not flow to the detail tab report