Deploying Reports Through SQL Server Management Studio


Deploying Reports Through SQL Server Management Studio

Deploying reports through SQL Server Management Studio is not incredibly different from using Report Manager. The concepts are the same (as are the steps); the only difference is that you use a smart client tool instead of a web browser.

Creating a New Folder

Complete the following steps to create a new folder using SQL Server Management Studio:

1.
Open SQL Server Management Studio.

2.
Change the server type to Reporting Services. See Figure 17.9.

Figure 17.9. Using SQL Server Management Studio to connect to SSRS.


3.
Click the Connect button.

4.
In Object Explorer, navigate to the Home folder, as shown in Figure 17.10.

Figure 17.10. SQL Server Management Studio's Object Explorer.

5.
Right-click on the Home folder and select New Folder.

6.
Change the Name field to AdventureWorks Reports.

7.
Change the Description field to "Reports for Adventure Works Inc." See Figure 17.11.

Figure 17.11. Adding a new folder in SQL Server Management Studio.

8.
Click OK.

Setting Up a Data Source

SQL Server Management Studio can be used to create data sources, just like Report Manager. To set up a data source using SQL Server Management Studio, complete the following steps:

1.
Right-click on the new folder and select New Data Source.

2.
In the Name text box, enter AdventureWorks DataSource.

3.
In the Description field, enter "Connects to the AdventureWorks database on the local SQL Server instance."

4.
On the Connection tab, select Microsoft SQL Server for the Data Source Type.

5.
Enter the following connection string: Data Source=localhost;Initial Catalog=AdventureWorks .

6.
Select Windows Integrated Security.

7.
Your screen should look similar to Figure 17.12. Click OK.

Figure 17.12. Adding a new data source through SQL Server Management Studio.

Uploading a Report File

After creating the folder and adding a data source, you are now ready to upload the RDL files to the Report Server. Just like everything else so far, SQL Server Management Studio does not differ all that much in concept. Complete the following steps to upload a report:

1.
Right-click on the Adventure Works folder, and select Import File.

2.
Select the file to upload.

3.
Your screen should look similar to Figure 17.13. Click OK.

Figure 17.13. Uploading a file through SQL Server Management Studio.



Microsoft SQL Server 2005 Reporting Services
Microsoft SQL Server 2005 Reporting Services
ISBN: 0672327996
EAN: 2147483647
Year: 2004
Pages: 254

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net