View Table or Chart with prompt

In report you often want to switch between a crosstab/table or a chart. You can give the user this selection with a prompt and a variable.

1. Insert a value prompt above the table. Parameter is p_view

2. Insert static choises:

Use      View

Table   Table

Chart   Chart

3. Set standard selection to the type you want to see default, eg. Chart

4. Create a variable “VarView” with the expression: If (ParamValue(‘p_view’) = ‘Table’) then ‘Table’ else ‘Chart’

5. Add values to the variable: Table, Chart

6. Make sure that the crosstab/table is placed in a table. Also the chart has to be placed in a table.

7. Click once on the table cell the crosstab/table is placed in

8. Choose Stylevariable = “VarView”

9. Click once an the table cell the chart is placed in

10. Choose Stylevariable = “VarView”

11. Now select the value “table” from the variable, the centre gets green

12. Select the tablecell where the chart is placed and set “box type” to “none”

13. Now select the value “chart” from the variable

14. Select the tablecell where the crosstab/table is placed and set “box type” to “none”

15. Add some script with a html item next to the value prompt to hide the first 2 lines.

      See the article Hide 2 top rows in prompt on this site

Hide and Show Fields Based on Prompt Values

Information on hide and show fields based on prompt value can be found on the following URL:

Open the ZIP with information direct:

Hide Cognos Connection objects


It is possible in cognos Connection to hide objects such as reports, packages, pages, folders and so on, for normal users. This can be done to be sure that users don’t start reports they don’t need.

Reports that are hidden can be accessed through an drill-through link.


Login as administrator in Cognos Connection

Go to  my area –> my preferences –> highlight “Show hidden items”

Go to a folder with reports

Choose properties of a report you want to hide

Choose “Hide this item”

The hidden report icon becomes vague and is not visible unless the user also selects “Show hidden items” in their preferences.

For more detailed information go to the IBM Cognos URL: