Hi,
In my cross tab I have country field as
rows,Sales and Orders as
measures. I created a prompt with parameter name
selection with two static choice values like Sales and Orders.
My requirement is as below:
Req 1) When I select 'Sales' from the prompt during run time only Sales measure should be visible in Cross-tab.
Req 2) When I select 'Orders' from the prompt during run time only Order measure should be visible in Cross-tab.
Req 3) When the report is run without selecting any values then both Sales and Orders need to be displayed in the Cross-tab. (I should not be using '
none ' or '
both ' as a third Static choice value.)
To achieve the same
I created a data item using the expression #prompt('selection','token','[Sales]')#
I created a radio-prompt selection with static choices for Sales and Orders.
In doing so, I was able to achieve Req1 and Req2.
Please advise if there is a way to achieve
Req 3 for the above scenario using conditional styles
Regards,
Sameena
ideally, you can try to set the radio prompt to optional. But since it's a prompt and you are using macro it needs a parameter to pass.
can you change the prompt to be a dropdown selection? then instead of haveing "none" or "both" you can have another static choice as "selection" which will be the default selection. This will act as title/label for the prompt.
just a suggestion.