Run a Report (Azure SQL Reporting)
Updated: May 9, 2014
|SQL Reporting will discontinue service on October 31, 2014. See this FAQ for details. For reporting on Microsoft Azure, visit Virtual Machines on WindowsAzure.com.|
You can run a report directly from a report URL or from the Dashboard page of a SQL Reporting service. The following illustration shows a report server page with reports, folders, and data sources.
When you run the report, it renders in the HTML format. After you run the report, you can export it to a different file format such as Excel or PDF. You can use URL access syntax to render the report directly in the HTML format or specify a different format. For more information, see Access a Report Server by Using a URL (Azure SQL Reporting).
|When you upload reports that use shared data sources, you need to deploy the data source before you upload the reports. The upload process binds the report to the data source, enabling the reports to use the data source. If you reverse the order, the data source is not bound to the report and the report fails. For more information, see Upload a Report (Azure SQL Reporting).|
Open a report from the management portal
Open a Web browser, and launch the Azure Platform Management Portal by specifying the appropriate Microsoft Azure credentials. Open the SQL Reporting server.
Click Dashboard and then scroll to the bottom of the page to click the Web service URL.
Click the Web service URL.
On the sign in page, enter the credentials of a user with permission to run reports. The account must be a SQL Reporting account (see Manage Users (Azure SQL Reporting)) with a minimum permission level of Browser.
A read-only report server page opens in a new browser window.
Note that you cannot edit, upload or delete items from a report server page, not even if you have additional permissions via other roles.
Navigate to the folder that contains the report that you want run.
If you want to go back up the folder hierarchy, click To Parent Directory.
Note The report server opens at the root folder. If you navigated to a folder, before you clicked [Link], you need to navigate to it again.
Click the report name.
Depending on the type of credentials that the report uses, you might be prompted for a user name and password to access the report data source. If this occurs, enter a SQL Database username and password.
The report renders in a new browser window.
If the report has parameters, select parameter values in the Report Viewer and click View Report.
Optionally, explore the report by displaying different report pages, searching for values in the report, and exporting the report to a different format.
Report interaction and the report toolbar
You primarily interact with a report by using buttons on the report toolbar. Other types of report interaction 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 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.
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 Run a Report (Azure SQL Reporting).
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.