Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Publishing a Report Model

Updated: 12 December 2006

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, http://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, http://servername, http://servername/site, or http://servername/site/subsite.

ms159226.note(en-US,SQL.90).gifImportant:
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.

ms159226.note(en-US,SQL.90).gifNote:
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.

Release History

12 December 2006

Changed content:
  • Added information about SharePoint libraries.

14 April 2006

New content:
  • Default paths for publishing report model projects.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.