To display the Reports tab:
On the Navigation menu, click Reports.
Click the report category to display: Cost Analysis, Workflow, Progress or Schedule.
On the Reporting form, select a report and click Preview.
On the Preview screen, click
.
Use this dialog box to view report information and view report version number.
Report Query — This returns the query that was executed by the report. Because the query is returned in XML format, it can be copied and pasted directly into Microsoft SQL Server Management Studio Query window or onto the Report Designer Data tab where it can be executed. Since the Report Designer Data Tab and Microsoft SQL Server Management Studio do not execute XML SQL directly, you need to make a few edits. It does not matter if you edit the query in your favorite XML editor or save it to a file. In either case, you will see something that resembles the following when you view the query information:
<Query><![CDATA[SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED … ]]></Query>
To run this query within Microsoft SQL Server Management Studio, you must modify the XML to resemble the following:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
After you complete this modification, the query will execute without issue.
Report Options — This returns the options that were selected on the PM Compass report Options dialog box when the report was rendered. The options are returned in XML format. This XML cannot be placed within the RDL Code.
Report Data Source — The report data source information is built using a combination of the connection information (credentials for accessing data) and the data source (the database) used in the report.
Report Definition (RDL File) — This provides you with the exact .rdl file that was used to load the report instance as it was rendered on the SSRS report server. When you preview this .rdl file within Report Designer, it looks exactly like the one in the PM Compass Reports preview window.
Use this field to view the version number.
Click this button to launch the File Download confirmation dialog box.
Click this button to close the Report Information dialog box.