Upload File Page (Report Manager)
Applies To: SQL Server 2016
Use the Upload File page to publish a file from the file system into the report server database. Uploaded files are represented as items in the report server folder hierarchy.
Uploaded .rdl files are published to a report server as reports.
Uploaded .smdl files are published as report models if they contain data source view information. If they are missing a data source view reference, an error occurs during the upload. Data source view information might be missing if you upload an .smdl file from a Microsoft Visual Studio report model project. In report model projects, data source view information is stored in a separate file rather than in the .smdl file itself.
Model files that do contain data source view information (and can therefore be successfully uploaded) are those that have been previously published to a report server and then saved from the server to a file on the file system. If you open the General Properties page of a model and click Edit to open the model, you can save it to a file and then upload it as a new model on the report server. The .smdl file that you subsequently upload will have all of information that is necessary for model publication.
All other file types that you upload are stored as resources. This includes .rds files that contain report data source connection information. Uploading an .rds file does not produce a shared data source item on the report server.
When you upload an item, it is placed in the current folder. After the upload is complete, you can move the item to a different location.
This feature is not available in every edition of SQL Server. For a list of features that are supported by the editions of SQL Server, see Features Supported by the Editions of SQL Server 2016.
Use the following procedure to navigate to this location in the user interface (UI).
Open Report Manager, and navigate to the folder in which you want to upload a file.
In the toolbar, click Upload File.
- File to Upload
Displays the fully qualified path to the file you are copying from the file system.
Click to choose a file from the file system.
Type the name of the file, as it will appear in the report server namespace. A name must contain at least one alphanumeric character. It can also include spaces and certain symbols. Do not use the characters ; ? : @ & = + , $ * < > | " or / when specifying an item name.
- Overwrite item if it exists
Select this check box if you want to replace an existing item with a newer version. To overwrite an existing version, the name of the new item and the existing item must be an exact match.