Upload files to a folder

You can upload files from the file system and store them as managed items in a report server database. What happens when you upload a file depends on the file type.

  • Uploading an .rdl file is equivalent to publishing a report.

  • Uploading any other file adds it to the report server database as a single binary object. These files are published to a report server as a resource. Resources can be any file type. If the file extension matches a known MIME type, an icon for that MIME type is used to identify the resource type. Otherwise, a generic file icon indicates a resource.

    Note

    You can't upload a report data source (.rds) file to create a shared data source. An .rds file is used only in Report Designer. It can't provide the content for a shared data source item that you define and manage through the web portal. As an alternative to uploading, you can write a script that creates a shared data source based on a .rds file.

The maximum file size for uploaded items is 2 GB, and can be set using the MaxFileSizeMb property in Management Studio.

Visually, files that you upload to a report server database are represented in the folder hierarchy with the following icons.

When you upload a file, the file is always placed in the folder that is currently selected. You can navigate to the folder that you want to contain the item first, or you can upload a file and then move it to a final location later.

To upload a file, use the web portal. Whether you can upload files to a report server depends on tasks that are part of your role assignment. If you're using default security, local administrators can add items to a report server. If My Reports is enabled, any user who has a My Reports folder has permission to upload items to that folder. If you use custom role assignments, the role assignment must include tasks that support folder management.

To do this action Include these tasks
Upload an .rdl file to a folder Manage reports
Upload any file as a binary object Manage resources
View the contents of a folder View resources, View reports

The web portal of a report server (SSRS native mode)
Grant permissions on a native mode report server
Tasks and permissions
Upload a file or report in the report server