SQL Server Reporting Services: Getting Started

November 14, 2007
By Vikas Goyal

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

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.

0 Comments (click to add your comment)

Comment and Contribute

Solid State Drives: The Future of Data Storage?

Solid state disks (SSDs) made a splash in consumer technology, and now the technology has its eyes on the enterprise storage market. Download this eBook to see what SSDs can do for your infrastructure and review the pros and cons of this potentially game-changing storage technology.