Hi ...
This is regarding prompt along with report header .....
I need to display data in the report ,based on the value of the prompt and also Report header needs to reflect the same value of the Prompt.
For example: I have a query item Country:
If COUNTRY = 'US' is chosen ,the US data needs to be displayed and Report header should display "" US Only ""
IF other country chosen we need to display Non-US data and heading as NON-US (COUNTRY NOT= 'US').
Please help me in accomplishing the prompt.
Thanks in Adv,
Kbasha
Create a boolean variable based on your prompt
in your case ?Country? = 'US'
place a text item in your report header and assign the boolean variable to the text source variable of the text item and display the text accordingly
Hi Gopinath,
Thanks for your reply. Unfortunately I cannot create a boolean variable as we need to give the user a choice to see US, Non-US or both US and Non-US data. When both is chosen then I need to display 1st US Data followed by Non-US data. The trick here is not only the data needs to be US related but Report Tile(dynamic heading as per the value chosen in prompt) should reflect "This is US Data" followed by Non-US data along with Report Title changed to "This is Non-US Data".
So, I think I need to create a string variable. But I'm not sure what type of prompt I need to create for this (I tried to create value prompt, but that did not show any values). Can you please suggest a solution.
Thanx in advance for the help extended!
Kbasha
Create calculation Data Item
Try With ParamDisplayValue('Country') in Report Header.
Regards,
Venu.Y
Thanks
Hi Kbasha,
how about something like this:
If ?Country? = 'US' then (?Country? + ' ' + 'Only')
else ('Not US')
Hope that helps