I am having a requirement at cognos letz say am having columns like year,month,quarter and revenue. I need a prompt with multi select and respected static value in year,month,quarter. In the prompt If i choose year it will display year and revenue. If I choose multiple value like year and quarter it will display both year,quarter with respective revenue. How can I achieve such scenario in report studio.
- Create 3 Boolean variables, 1 ea for each of the 3 time prompts... set to true only when there is a selection made in the associated prompt control/parameter.
- Set each of the 3 time-based listColumn objects to render when the appropriate correlated variable is true, using the Render Variable property.