Home > Sample chapters > Programming > SQL Server

Microsoft SQL Server 2008 Reporting Services: Deploying Reports to a Server

Chapter 10 Quick Reference

To

Do This

Set report server project properties

In Solution Explorer, right-click the project, select Properties, and then specify a target data sources folder, a target report folder, and the target report server URL.

Deploy a report server project

In Solution Explorer, right-click the project, and select Deploy.

Upload a report to the report server

Native mode: In Internet Explorer, open Report Manager, navigate to the folder in which to store the report, click the Upload File button on the Report Manager toolbar, click Browse, navigate to the report on the file system, and select the report definition file.

Integrated mode: In Internet Explorer, open the reports library on the SharePoint site, click the Upload button on the reports library toolbar, click Browse, navigate to the report on the file system, and select the report definition file.

Deploy reports with the Rs utility on a native-mode report server

Create a script file that uses the CreateFolder and CreateReport methods, and provide the path to this script file as an input argument for the Rs utility by using the following syntax: rs –i inputfile –s http://<servername>/ReportServer.

Add a folder to a report server

Native mode: In Report Manager, navigate to an existing folder, and click the New Folder button on the Report Manager toolbar.

Integrated mode: In the SharePoint reports library, on the reports library toolbar, click the arrow on the New button, and select Folder.

Move a report to a new folder

Native mode: In Report Manager, navigate to the report’s parent folder, click the Show Details button on the Report Manager toolbar, select the report’s check box, click the Move button, and select a target folder.

Integrated mode: In the upper-right corner of a page in the SharePoint site, click Site Actions, select Manage Content And Structure, select Reports Library in the tree view, select the report’s check box, click the arrow on the Actions button, select Move, and select a target folder.

Create a linked report on a native-mode report server

In Report Manager, open the base report, click the Properties tab, click Create Linked Report, provide a name for the linked report, and then, if you want, click Change Location and select a target location.

Create a report copy on an integrated-mode report server

In a SharePoint site, in the navigation bar, click Reports, point to a report in the library, click the Edit button appearing to the right of the report title, select Send To, click Other Location, type the name of a target document library or folder, and type a name for the report copy.

Configure report parameter properties

Native mode: In Report Manager, open the report, click the Properties tab, click the Parameters link, and, if you want, clear the Has Default check box, provide an alternate default value, select the Hide check box, clear the Prompt User check box, or change the Display Text for the report parameter prompt.

Integrated mode: In the SharePoint reports library, point to the report, click the Edit button appearing to the right of the report title, select Manage Parameters, click a parameter link, and, if you want, select a new default value, select Do Not Use A Default Value, change the Prompt text, or hide the parameter by selecting Hidden or Internal.

Configure a data source

Native mode: In Report Manager, open the shared data source or open a report, click the Properties tab, click the Data Sources link, select A Custom Data Source, select a data source type, and provide a connection string. Select the applicable Connect Using option to configure one of the following authentication methods: prompted credentials, stored credentials (which requires supplying the login name and password), Windows integrated security, or no credentials.

Integrated mode: In SharePoint, open the Data Connections folder on the site, and select a data source link or, in a reports library, point to a report, click the Edit button appearing to the right of the report title, select Manage Data Source, click the data source link, and select Custom Data Source. Select a data source type, and provide a connection string. Select the applicable Credentials option and configure one of the following authentication methods: Windows integrated security, prompted credentials, stored credentials (which requires supplying the login name and password), or the unattended report processing account.

Configure report execution properties

Native mode: In Report Manager, open the report, click the Properties tab, click the Execution link, and then specify an execution type (on demand, caching, or snapshot) and a report execution timeout setting.

Integrated mode: In SharePoint, open the reports library, point to a report, click the Edit button located to the right of the report title, select Manage Processing Options, and then specify an execution type (on demand, caching, or snapshot) and a report execution timeout setting.

Enable report history

Native mode: In Report Manager, open the report, click the Properties tab, click the History link, and select a method for adding snapshots to report history and a limit to the number of snapshots to keep in report history.

Integrated mode: In SharePoint, open the reports library, point to a report, click the Edit button located to the right of the report title, select Manage Processing Options, and select a method for adding snapshots to the report history and a limit to the number of snapshots to keep in report history.