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

Prompt Page with conditional prompts

Started by MikeThrel, 14 Jul 2011 05:11:10 PM

Previous topic - Next topic

MikeThrel

I'm not sure how to accomplish what I'm wanting to do so I'm asking for help from experts such as yourselves:

We have three different reports that has data summarized and presented a different way.  I need to display a specific report based on the user's choices on a prompt page.

The user selects a date.
Then the user selects what level they want to see the data summarized to:  Region, Center, Officer.

Now I can't figure out how to do what I want to do next:
If the user chooses "Region", display a dropdown list of Regions to choose from; or if the user chooses Center, display a dropdown list of Centers for the user to choose from.

Then, once the user has made those choices, I need a button/link that will drill through to the proper report; either the region level report, or the center level report, or the officer level report.

Here's a screenshot of the form so far.


I don't know what to do next.  I don't know how to make the page react and display the correct dropdowns; and how do I make the "Run" button display a specific report based on the user's selection in the radio button group (or maybe hide/show a predefined button based on the selections).

Thanks in advance for any help and/or advice that you can give on the best way to design this and make it work.

Mike T.

blom0344

I would simplify the approach. Instead of the second prompt directly use 3 list prompts for Region,Center,Officer and make these optional. 
Create 3 reports pages for each case and then use render variables on the page to make sure only the report page is shown where something is selected from the prompt.
This is a matter of defining a variable that checks wether the associated prompt parameter  is null or not.
When set right this will only show part of the entire report

ksr

I am attaching XML report specification for the cognos 8.4 and I created it on gosales package

Just open the given file
ctrl + a (to select )
press ctrl+c
open report studio
tools menu, select "Open report from clip board"
run it and enjoy