Getting Started Guide for Report Readers (Windows Azure SQL Reporting)

• Previous Steps
  
  
• Viewing a report
  
  
• Rendering a report in a different format
  
  
• Using the report toolbar
  
  
• Working with parameter values
  
  

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.

Back to top

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

You can render a report in a different format in the following ways:

1. On the report viewer toolbar, export the report to a different file format. For more information, see HTML Viewer and the Report Toolbar.
   
   
2. 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).

Back to top

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.

Back to top

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.

Back to top

Reference

Concepts

Other Resources