Report has 10 prompt page items (combinations of date, checkbox, radio buttons, multi-select). One of the items is just a single checkbox 'Include 0's' for the user to select if they want to see all rows/column even if the values are 0. By default, the box is not checked and the value is 'N'. If the box is selected then parameter p_Include0 = 'Y'.
I have 2 crosstab reports:-
1st crosstab is for default p_Include0 = 'N', the Crosstab - Properties - Suppression is set to Rows/Coumns.
2nd crosstab is for p_Include0 = 'Y', the Suppression property is not set.
I used a Render Variable - v_Include0 (where it equals to p_Include0) to conditionally render the correct Crosstab depending if the checkbox is selected or not.
Now, in Event Studio (to set up an agent and schedule the report), all prompt critieria are displayed except for the checkbox 'Include 0's'. I supposed Report Studio did not think this prompt item is needed in the report and no dataitem is associated to it and therefore will not display. But the user needs this criteria item as part of the agent. What can I to get this item to be available for selection???