Publishing a Report Model

Publishing a Report Model

Community Content

In this section

Statistics Annotations (0)

Click here to expand

Collapse All

Other versions are also available for the following:

SQL Server 2005

SQL Server 2008 Books Online (November 2009)

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.

Model Size Limitations

By default, ASP.NET limits the size of files that can be uploaded to a server to 4 MB. If your model is more than 4 MB in size and you are unable to deploy it to a server, change the default value in the web.config file for each report server to which you want to deploy the model. To change the default value, open the the web.config.comments file in a text editor, copy the maxRequestLength element from the <httpRunTime> section of the file, and paste it into the <httpRunTime> section of the web.config file that is located in the report server installation folder. After you paste the element into the file, change the default size to the size that you want to use.

Typically, the web.config.comments file is located in the following path: <drive>:\Windows\Microsoft.NET\Framework\v2.0.50727\CONFIG.

Typically, the web.config file for the report server is located in the following path: <drive>:\Program Files\Microsoft SQL Server\<instance id>\Reporting Services\ReportServer.

If you want to upload large models using Report Manager you must repeat the steps outlined above for the Report Manager web.config file. Typically, the web.config file for the Report Manager is located in the following path: <drive>:\Program Files\Microsoft SQL Server\<instance id>\Reporting Services\ReportManager.

If you want to change the settings for the entire server, repeat the steps outlined above for the machine.config file. Typically the machine.config file is located in the following path: <drive>:\Windows\Microsoft.NET\Framework\v2.0.50727\CONFIG.

Specifying a Publication Location

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

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.

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.

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 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 Report Manager. For more information, see Granting Permissions on a Native Mode Report Server.

Concepts

Other Resources

Help and Information