Report Studio

Running Report Studio Reports

Run your report to see the data that is retrieved. You can save time by validating it first to check for errors.

You can specify not to render a report page if it does not contain any data.

When you run a report in an export format such as PDF, delimited text (CSV) or Excel (XLS) the report name is used as the export file name.

If you run a report that uses functions or features not supported by the data source, an error message appears. You should periodically test your reports as you create them to ensure you do not encounter multiple error messages when you run the report.

To Run A Report in Report Studio:

Open the report you want to run.
If you want to clear parameters values stored on the PPM server, from the File menu, click Clear Parameter Values.
Parameter values stored by the Cognos server include signon, validation and prompt information.
If you want to view only the tabular data, from the Run menu, click View Tabular Data .

If the report contains multiple queries, you must first click an object, such as a list or crosstab, that uses the query for which you want to view the tabular data.

Use this command to ensure that the right results appear. For example, you create a calculation and you want to ensure it is giving you the results you want. Note: You can also view tabular data in Query Studio, which is useful when you are building queries.

If you want to set run options, from the Run menu, click Run Options.

The run options you set apply only to the current session. When you close Report Studio, the options return to the default settings.
Change any values for the current session:

Option	Notes
Format	Specify to change the default format from HTML.
Paper size	Specify only if the output format is PDF.
Paper orientation	Specify only if the output format is PDF.
Data mode	Specify how much data is returned. All Data returns all data. Limited Data limits the amount of data returned based on design mode filters defined in the package. No Data returns artificial data instead of actual data from the data source.
Language	The content language sets the preferred language for the data, Report Viewer, dates, and so on.
Rows per page	Specifies the number of rows to appear on each page. A Rows Per Page property exists in the Properties pane for lists and crosstabs. If you specify a value for this property, it overrides the same-named run option. This property applies to both HTML and PDF outputs.
Prompt	Select to be prompted for each prompt defined, unless the prompt is defined in a report page. If you clear the check box, you are prompted only if the report cannot run without user intervention. For example, if a report has a single parameterized filter that is optional, you are not prompted when you run the report.

From the Run menu, click one of the options to produce the report in the format you want.

You can produce a report in HTML, PDF, CSV, various Excel formats, and XML. You cannot produce a report in CSV format if you have more than one query defined in the report, unless the additional queries are used for prompts.

The report runs in Report Studio. Once the report has finished running, you can run the report again in the same format or in a different format. If you run the report again in CSV or XLS format, the report will appear in a new browser window.