March 4, 2021
Hot Topics:

SQL Server Reporting Services: Getting Started

  • By Vikas Goyal
  • Send Email »
  • More Articles »
  • Drag and drop the fields available on to the report. Following is the sample report designed for this walkthrough.

  • Click here for a larger image.

    Figure 8: Report Layout in Design Mode

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

  • Click here for a larger image.

    Figure 9: Report Manager

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

  • Click here for a larger image.

    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

This article was originally published on November 14, 2007

Enterprise Development Update

Don't miss an article. Subscribe to our newsletter below.

Thanks for your registration, follow us on our social networks to keep up-to-date