Publishing a Report Model

When you are ready to deploy the model for the first time, you need to publish the entire report model project to the report server database or to the SharePoint library. When you do this, both the data source and semantic model files are published. The data source view file is combined with the semantic model file when the report model is published. As you continue to adjust the model, you can publish just the updated .smdl file.

To specify the location where the model should be published, you need to complete the information in the Model Property Pages dialog box. The following information needs to be specified.

Target	Location
TargetDataSourceFolder	The name of the folder in which to store the published shared data sources. If you do not specify a folder, the data source is published to the same folder as the model. If the folder does not exist on the report server, Model Designer creates the folder when the model is published. When publishing to a report server running in native mode, specify the full path of the folder hierarchy starting at the root. For example, Folder1/Folder2/Folder3. When publishing to a report server running in SharePoint integrated mode, type a URL to a library or library folder. For example, http://TestServer/TestSite/Documents/DataSources. If left blank, the default is the TargetModelFolder value.
TargetModelFolder	The name of the folder in which to store the published model. By default, the folder is Models. If the folder does not exist on the report server, Model Designer creates the folder when the model is published. When publishing to a report server running in native mode, specify the full path of the folder hierarchy starting at the root. For example, Folder1/Folder2/Folder3. When publishing to a report server running in SharePoint integrated mode, type a URL to a library or library folder. For example, http://TestServer/TestSite/Documents. A value must be specified for this property.
TargetServerURL	The URL of the target report server. Before you publish a model, you must set this property to a valid report server URL. When publishing to a report server running in native mode, use the URL of the virtual directory of the report server. For example, https://server/reportserver or https://<server>/reportserver. This is the virtual directory of the report server, not Report Manager. By default, the report server is installed in a virtual directory named "reportserver". When publishing to a report server running in SharePoint integrated mode, type a URL to a SharePoint top-level site or subsite. If you do not specify a site, the default top-level site is used. For example, https://servername, https://servername/site, or https://servername/site/subsite.

Important

To deploy a report model to a SharePoint library, you must use a URL to the library or library folder, for example, http://TestServer/TestSite/Shared Documents/.

You can modify the properties by right-clicking the report model project and selecting Properties.

If a shared data source already exists on the report server, you can publish a report model by uploading just the .smdl file to the report server or library. For more information, see Uploading Files to a Folder and Deploying Reports, Models, and Shared Data Sources to a SharePoint Site.

Note

When uploading a .smdl file from a local computer to a report server or SharePoint library, you must rebind the .smdl file to the data source file. For more information, see How to: Bind a Report or Model to a Shared Data Source.

After your model is published, you might want to assign role-based security permissions in SQL Server Management Studio. For more information, see Managing Permissions and Security for Reporting Services.

See Also

Tasks

How to: Upload Documents to a SharePoint Library (SharePoint Integrated Mode)

Concepts

Ad Hoc Reporting with Report Models
Working with Model Designer
Model Designer How-to Topics
Deploying Reports, Models, and Shared Data Sources to a SharePoint Site

Other Resources

Model Designer F1 Help

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release	History
12 December 2006	Changed content: Added information about SharePoint libraries.
14 April 2006	New content: Default paths for publishing report model projects.