Cognos Limited Run Types

UCSD has Cognos set up to run as HTLM (preferred), PDF (preferred), Excel, Excel data, CSV and XML.

Report developers can limit these options by setting the report to only display when specific run types are selected.

Create a Variable so that Cognos can identify the report output the consumer has selected and display only for the values that the report developer has indicated.

1. From the Report carrot menu, select "Variables"
   1. 
2. Drag and drop the "String Variable" into the "Variables" box.  In the "Expression Definitions:" box enter the value ReportOutput().  Click OK.
   1. 
3. Optional - change the name of your variable by using the properties area
   1. 
4. Use the + to add options for which the report could be run - both you want and do not want.  Click OK.
   1. 
5. Set each page of your reports to recognize the variable.  You do not have to use the same value for each page.
6. From the Report carrot menu, select the Report folder.
   
   1. 
7. Select a page.  In the page properties, select "Render variable"
8. In the Variable drop down, select the variable you created and de-select the report output for which you do not want the report to use.  Click OK.
   1. 
9. Apply to other pages as needed.
10. Run the report in the different output to ensure the variable is working.