Upload Files to a Folder
Applies To: SQL Server 2016
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.
The maximum file size for uploaded items is determined by ASP.NET. By default, the maximum size is 4 megabytes (MB).
Visually, files that you upload to a report server database are represented in the folder hierarchy with the following icons.
report model icon
generic resource icon
When you upload a file, it 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 Report Manager. Whether you can upload files to a report server depends on tasks that are part of your role assignment. If you are 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||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|