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

Cascading Pages in Cognos

Started by srini2mk, 29 Apr 2011 05:56:55 AM

Previous topic - Next topic

srini2mk

Hi,

I have a report which can be run by two different sets of parameteres. I need to find a method where the first prompt page prompts the users to choose eithere method A or B. If A is chooses  it should take to oen page with 10 sets of parameters. Else if method B is selected  a new page should appear containing another 10 set of parameters. In short the report can be filtered by 20 sets of parameters, 10 at a time based on user selection.How to acheive this?. Thanks for your help

Thanks,
Srinivasan

cognostechie

1> Create a Prompt Page and out the first Prompt there which will let the user select Method A or B.
2> Create another Prompt Page and put 10 prompts for Method A.
3> Create another Prompt Page and put 10 prompts for Method B.
4> Create a conditional variable to say

          If (paramdisplayvalue(?pMethod?) = 'A') then ('Page1') else ('Page2)

5> Associate both the pages with Render variable property. First page with 'Page1' and second page with 'Page2'.

srini2mk

What kind of conditional variable should I use. Render variable is not hiding a prompt page and in style variable, I dont have the option at all.

Thanks,
Srini

cognostechie

You don't have to hide when you use a Render Variable. When you associate the Page to the variable, select only
the value that you need for that Page (either Page1 or Page2). You are probably selecting both the values in both the pages.