Getting Started Guide for Report Readers (Windows Azure SQL Reporting)
Get started with viewing reports on SQL Reporting report servers. Reports are typically viewed in a browser or in an application with embedded reports.
You primarily interact with a report by using buttons on the report toolbar. Other types of report interactivity are defined by the report author. Parameter default values and available value lists, links (to bookmarks in the report, to other reports, or to Web sites), document maps, expand/collapse toggles, and interactive sort buttons are all features that a report author can add to a report.
In This Article
Before you can view a report, you must have the following:
Fully qualified URL to the reporting service or to the report.
Reporting service credentials that grant a minimum of view permissions on the report (this permission level is granted through the Browser role).
For more information, see Before You Begin.
Viewing a Report
In SQL Reporting, you view reports in a browser by navigating the reporting service and then clicking on the report. You access the report server directly by using a fully qualified URL or from the management portal.
Navigate to a report in the report server folder hierarchy
Enter the fully qualified URL to the report server in your browser. For example: https://<ServerName>.reporting.windows.net/ReportServer.
Enter your reporting service credentials to connect to the report.
Click through the folder hierarchy to the folder that contains the report, and then click the report name.
For additional procedures for locating and running reports, see How to: Run a Report (Windows Azure SQL Reporting), and How to: Access a Report Server by Using a URL (Windows Azure SQL Reporting).
Rendering a report in a different format
You can render a report in a different format in the following ways:
On the report viewer toolbar, export the report to a different file format. For more information, see HTML Viewer and the Report Toolbar.
Use URL access syntax to render reports. For more information, see URL Access.
For an example of URL access syntax that renders a report to the PDF file format, see How to: Run a Report (Windows Azure SQL Reporting).
Using the report toolbar
In the report, you can view the report page-by-page or go to a specific page, search the report for text, export the report to multiple formats, choose parameters, change the zoom factor, and interact with a report by using features enabled by the report author. For more information, see HTML Viewer and the Report Toolbar.
Working with parameter values
If a report has a valid default value for each report parameter, the report runs automatically when you view it.
By design, selecting different values for parameters does not automatically refresh the report. If a report has cascading parameters (where the value you pick for one parameter determines the valid values for the following parameter), then the parameter order on the toolbar is important. As you select a value for each parameter, then the drop-down list for the next parameter is populated with values that are valid for that choice.
After you finish selecting values for all report parameters, you must click the View Report button on the report toolbar to run the report with the new values.