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
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