Cascated Prompts and Prompt Variables

[carlosalvidrez]

Hi,
How to display a cascated prompt as a prompt variable?

Scenario
+++
Report1: States
Report2: Cities, Prompts for one sigle State.
Report3: Main Report, with fields x, y and c (imagine info relative to the selected cities).

Prompt Variables
+++
It is easy to insert a prompt variable that will show the selected Cities. Question is... how do we show the selected State in the header of the report?

Justification
+++
User wants to have a print-out of the report with something that will remind she/he what prompt values were selected to produce the sheets.

Any help will be highly appreciated.
Thanks in advance!

 

[griffindm]

Carlos,

The only way I know of to do this is to pass a concatenation of the State and City to the final report. If you use a distinctive delimiter you can parse them back into their separate values in the final report.

Hope this helps,

Dave Griffin



The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com

 

[nagrajm]

As the user will be prompted only for a single state, insert the STATE column in the header by selecting INSERT->DATA. If multiple STATE selections are involved, you may group the report by STATE and create a group header for the report.

 

[griffindm]

Nagrajm's solution will work if the state is part of the schema for the final report's data sources, or can be referenced via a join. It's a simpler solution. If it's not, I'd stick with my note above. In the real world it should be accessible and should be part of the filter anyway. Otherwise a report filtering on "Kansas City" would get both cities in Kansas and Missouri.

Dave G.



The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com