Hi,
I created a report with two lists and two optional prompts. Based on the selection of the prompt one list has to be hidden .
Example:
Prompt 1 - Optional prompt on Year (text box Prompt)
Prompt 2 - Optional prompt on Month (text box prompt)
In the report page there are two lists one will show year data and the other one will show month data.
If the user enters value in the year prompt then year list should display and month list should hide.
Similarly if the value entered in month Prompt month list should display then year list should hide.
Can some one please help me to do this that would be really appreciated.
Thank you so much in advance.
Create a boolean variable per prompt, and add ParamCount(<paramater name>)>0
Meaning if the parameter holds a value, meaning user has entered any thing, variable boolean will be true else false.