Hi!
I'm a little lost here, so I'll appreciate any help.
I have always worked with Transformer PowerCubes, but this time I'm no: I'm using a FrameWork Manager package as data source for my report.
I have a value prompt and 2 different crosstabs. What I need is to show the first crosstab if no selection was made on the value prompt, or the second one in the "else case". I guess it is possible to achieve with display variable, but I don't know how to set up a display variable based on a prompt.
Any ideas?
Thanks.
Hi,
Create
Value Prompt static choices
1stCrosstab
2ndCrosstab
default
1stCrosstab
Render Variable
paramSelectCrosstab = 2ndCrosstab
Place the value prompt on the report page and by default you will see the 1st crosstab and when you select the 2ndcrosstab in the prompt 2nd crosstab will also be displayed.
create another variable to hide the 1stcrosstab if 2ndcrosstab is selected.
paramSelectCrosstab = 1stCrosstab
You can also use conditional blocks and string variable to achieve the same.
Good luck
New guy