SQL Server Reporting Services: Getting Started
- Drag and drop the fields available on to the report. Following is the sample report designed for this walkthrough.
- Once you are through with designing the report, save the report. It will get deployed directly and published on Report Server.
- After the successful 'Save', the Home of Report Server will have an entry for the report, as shown in Figure 9.
- To view the report, click on the Report. The report will get generated in HTML format with the option of exporting the report in various other formats, as shown in Figure 10.
Figure 8: Report Layout in Design Mode
Click here for a larger image.
Figure 9: Report Manager
Figure 10: Generated Report
SQL reporting Services provides an excellent out-of-the-box solution for managing and distributing reports. The Web Service endpoints of SSRS give an excellent integration opportunity to .NET application developers to expose reports using SSRS without building the overheads on their own.
About the Author
Vikas Goyal is a Microsoft MVP Solutions Architect with several years of industry experience. He is involved mainly in designing products/solutions for the Financial industry. He can be contacted via his blog, http://dotnetwithme.blogspot.com.
Page 4 of 4