Using My Reports (Report Builder and SSRS)

  • Article

On a report server configured in native mode, the My Reports folder is a personal workspace that you can use to store and work with reports that you own. Other report server folders are public and typically require users to have advanced permissions to add to or modify folder contents. In contrast, the My Reports folder is a user-managed workspace. You can add or remove reports and folders and save linked reports with personalized settings.

Conceptually, the My Reports folder is similar to the My Documents folder in the Windows file system. Although each user has a folder called My Reports, the folder that each accesses is different from all other users. Except for report server administrators, other users cannot access the contents of the My Reports folder that belongs to you.

The My Reports feature is optional and can be disabled by a report server administrator. If it is enabled, you will see a My Reports folder in the Home folder, which you can access using the Report Manager or a Web browser. For more information, see Finding and Viewing Reports in Report Manager (Report Builder and SSRS).

On a report server configured in SharePoint integrated mode, there is no equivalent to the My Reports folder. For more information, see Finding, Viewing, and Managing Reports (Report Builder and SSRS ).

Note

You can create and modify report definitions (.rdl) in Report Builder and in Report Designer in SQL Server Data Tools. Each authoring environment provides different ways to create, open, and save reports and related items. For more information, see Designing Reports in Report Designer and Report Builder (SSRS) on the Web at microsoft.com.

Ways to Use My Reports

My Reports is empty until you add reports, folders, and other items. Here are some ways to add content to My Reports.

  • Create a personal linked report and store it in My Reports. Not all reports are available for linking. For more information, see Create a Linked Report.

  • Upload a report definition (.rdl) file, report model (.smdl) file, or other files from the file system. You can upload any file, but the report server only processes report files that have an .rdl or .smdl file extension. For more information, see Report Definitions" in the Reporting Services documentation in SQL Server Books Online and Upload a File or Report (Report Manager).

  • Create and publish your own reports to My Reports. For more information, see Report Design View (Report Builder).

Usually, permissions on My Reports allow you to manage the folder yourself. However, the report server administrator ultimately determines which tasks users can perform. If insufficient permissions prevent you from working with My Reports, see your report server administrator.

Searching My Reports

When you search a report server database, the contents of your My Reports folder are included in the search, while the contents of other user's My Reports folders are excluded. Search results list only the reports to which you have access.

See Also

Concepts

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