Muokkaa

Jaa

Find and view reports with a browser (Report Builder and SSRS)

  • Artikkeli

You can use any supported web browser to view a report through a direct connection to a report server. Every report has a URL address on a report server. You can enter the Web address of a report to open it in a browser window independently of a web application. The report opens in HTML format and includes the report toolbar so that you can navigate pages or search on data values within the report. You can set parameters on the URL to hide the toolbar or select the output format of the report.

Opening a report through its Web address is suitable for viewing a report, but not managing a report. You can't access an item's property pages or subscription definition pages. You must use Report Manager or a SharePoint site for those tasks.

If you don't know the web address of a report, you can open the web address of the report server. Then, you can browse the report server folder hierarchy to select the report you want to view. The following diagram illustrates a folder hierarchy as it appears in a browser window.

Screenshot of folders in a browser.

Note

If you're accessing a report from a handheld device, you must use a browser to open a report. Report Manager isn't scaled for handheld devices.

For more information about types of browsers that you can use, see Browser support for Reporting Services.

Note

You can create and modify paginated report definition (.rdl) files in Microsoft Report Builder, Power BI Report Builder, and in Report Designer in SQL Server Data Tools.

You can use a web browser to navigate report server folders and run reports. Reports and items are displayed as links in the folder hierarchy. You can select links to open a report, resource, or folder, or view the contents of a shared data source. Navigating the folder hierarchy is useful if you don't know the URL of a report. You can specify the report server Web address to open a browser connection at the root node of the folder hierarchy, and then select folder links to navigate through the hierarchy.

When you access a report server virtual directory, you see only the folders, reports, and uploaded items to which you have access. The user interface shows only the folder hierarchy and basic information, such as creation or modification date, file size, and item type for individual items:

  • A link with no other indicator is a report or a model.

  • The tag <ds> indicates a shared data source.

  • The tag <dir> indicates a folder item.

  • A file name extension indicates a resource. The file name extension identifies the MIME type of the resource. For example, .jpg indicates an image in JPEG format.

Enter the URL address of a report

Reporting Services supports URL access to specific items on a report server. The URL must include a fully qualified path to the report and commands to render the report. If the report includes parameters, you must also specify any values that are required to open the report. If you add a URL for a report that includes spaces in the path, parameter values, or a rendering extension, you must incorporate URL encoded characters into the URL. This addition ensures that you get the results you expect.

The following example illustrates a report URL that includes encoding for spaces in the path name, parameters, and a rendering extension:

https://<Webservername>/reportserver?/<reportfolder>/employee+sales+summary&ReportYear=2004&ReportMonth=06&EmpID=24&rs:Command=Render&rs:Format=HTML4.0

The maximum limit for a URL in Internet Explorer is 2,083 characters. For more information, see Maximum URL length in Internet Explorer.

For more information about how to access a report through a URL, including information on how a URL is constructed, see URL access.