- Launch Query Studio
- Query Studio High-Level Interface
- Report Types
- Open an Existing Report
- Create a List Report
- Run the Report
- Change Layout
- Create a Crosstab Report
- Create Filters
- Summarize Report
- Sort Data
- Create Calculations
- Create Charts
- Define Conditional Styles
- In a Nutshell: Reviewing by IBM Cognos BI Audience
Run the Report
To see the output of the report or to run the report in another format, that is, PDF, Excel 2007, and so on, use the Run Report menu option, as shown in Figure 5.5.
Figure 5.5. Run data options – preview with no data and preview with limited data.
When you run the report, you can choose to run it without any data (Preview with No Data), with limited data (Preview with Limited Data), or all data (Run with All Data). While designing the report, running with no data or limited data is a good option because it reduces the traffic to the server to retrieve data until you are ready to test the data in the report.
You noticed that summaries were automatically generated when you added a numeric column to the report. You can suppress this via the Run Report > Advanced Options... > uncheck the Automatically Generate Footer Summaries for Measure option.
Running the report always displays current data from the database.
Steps to Run the Report
Figure 5.6 demonstrates steps to run a report in Query Studio as described in the list that follows.
Figure 5.6. Run a report.
- Click Run Report menu > ensure Run with All Data is selected.
Click Specify PDF Options... > select Paper size A3.
NOTE: You can specify Orientation as Portrait (default) or Landscape via the radio button and enable or disable the Page scaling option via the check box.
- Click OK.
- Click Advanced Options... > under the Query Options section uncheck Automatically Generate Footer Summaries for Measures.
NOTE: You can also enable or disable the option Automatically Summarize Detail Values, Suppressing Duplicates (enabled by default).
- Click OK.
NOTE: Notice that the Summaries are now removed from the report.
Click View in PDF.
You can access most options by right-clicking the report, as shown in Figure 5.7.
Figure 5.7. Options available via right-clicking.
Additional options are available to you from here, for example, Lineage and Glossary. The Lineage option is available to you only if it has been configured by your Cognos BI Administrator. Lineage is helpful if you want to trace the data item in the report to its source, for example, which item it maps to in the package and the data sources the package uses. This is especially useful if similar data items exist in multiple data sources used in the package or report. It also enables you to view the filters applied by the data modeler and report author. You can either use the Lineage tool that comes with your IBM Cognos BI software or use another one that your Cognos BI Administrator can configure. The Glossary includes the terms and definitions in your IBM Cognos BI environment.