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

Reprompting a Data Item from static choices

Started by JG75, 22 Mar 2015 04:25:55 PM

Previous topic - Next topic

JG75

Hello All,

This is my first post and might sound a silly question so please bear with me. I have a list report and I want to set up a prompt page where in I want to have 2 static choice (x and y). When x is selected I want it to take me to the second prompt which is a data item, say x1, on the list report. When y is selected I want to see a prompt for different data item, say y1, on the same list report.
I am sort of having brain farts trying to think about this. There are some more requirements like cascading other prompts either from x1 or y1 depending on requirement but I think that can achieved by simply creating more value prompt and proving the cascading source. I am currently stuck at first step itself. Any help will be highly appreciated. Thank in advance.
Regards,
JG

Lynn

If you base your second prompt on a query you can create a data item in that query whose expression will resolve to one or the other of your data items depending on the answer to the first prompt. Is this what you were after?

case ?x_or_y?
when 'x' then [x1]
when 'y' then [y1]
end