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.



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.
• Post a comment
• Email Article
• Print Article
• Share Articles
  • Digg
  • del.icio.us
  • Slashdot
  • DZone
  • Reddit
  • StumbleUpon
  • Facebook
  • FriendFeed
  • Furl
  • Newsvine
  • Google
  • LinkedIn
  • MySpace
  • Technorati
  • Twitter
  • Windows Live
  • YahooBuzz



Click here for a larger image.

Figure 10: Generated Report

Conclusion

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.