Edit

Find and Viewing Reports in the web portal (Report Builder and SSRS)

  • Article

Report Manager is a Web-based tool that includes features for viewing and managing reports. It's part of a report server installation. To open Report Manager, type the Report Manager URL in a browser window. For information on browser requirements, see Browser Support for Reporting Services. For more information about how a Report Manager URL might be configured on your report server, contact your system administrator. For more information, see Configure Report Manager (Native Mode).

The system administrator sets permissions on the report server. Those permissions determine what you can see when you use Report Manager. Permissions are granted via a role assignment. To find and view reports, your role assignment must include the View Reports task. To find a report on a report server, search for it by name or description, or browse report server folders. You can only search or browse for reports that have been published or uploaded to the report server.

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.

To browse for the reports that you want to run, you can use the Home page, which appears automatically when you start Report Manager and when you open any folder in the folder hierarchy. The Home page shows only the items that you have permission to view. The folder path is displayed as a row of links at the top of the Home page. Folder names are listed in sequence, starting with the root folder (Home). As you open each additional folder, the folder name is added to the folder path at the top of the page. (1) in the image below. When you open a report, the name of the report is also added to the folder path.

Report Manager Ribbon and Navigation. Report Manager Ribbon

Use the following techniques to navigate through a folder hierarchy:

  • To view the contents of a folder, select the folder name on the Home page. A folder page opens, displaying the contents of the folder.

  • To navigate down through the folder hierarchy, open a subfolder of the current folder. Folders contain reports, resources, shared data source items, and other folders. Selecting a folder icon opens the folder, showing the contents of the hierarchy one level down.

  • To navigate up through the folder hierarchy, in the row of links at the top of the page, select the name of the folder whose contents you want to see. (1) in the above image.

Open a Report

After you find a report, select the report name to open it. The report is rendered in HTML and appears in the Contents page in Report Manager. Reports are always cached by the browser session, so if you open a report, you can usually return to it by selecting the Back button. This is true even if you were required to supply a user name and password to run the report. You can't fully close a rendered report until you close the browser.

Not all reports that are visible in the folder hierarchy are immediately accessible. Some reports may prompt you for your user name and password to determine whether you can access the data source for the report.

You can also browse to and open a report from the report server directly from Report Builder.

Search for Items

  • To search for items in Report Manager, type a search string in the Search text box at the top of the page. (2) in the above image. Searches begin at the top node in the folder hierarchy and then proceed through every branch. If you do not have permission to access a specific branch, that branch is skipped. This applies to My Reports folders that belong to other users, and to other folders that are not generally available. Only reports and items that you have permission to view are included in the search results.

  • To search for an item by name or description, specify all or part of the text that you want to match. The search string is not case-sensitive. You can't use search operators such as plus (+) or minus (-) symbols to require or exclude search criteria.

  • To search for specific text within a report, use the toolbar at the top of the report.

See also

Finding, Viewing, and Managing Reports (Report Builder and SSRS )