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. |
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. |
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. |