Monday, January 5, 2009

Simple SSRS Reports Using Report Builder

SQL Reporting Services is functionality that's included with Microsoft SQL Server. There are many reports that are delivered out-of-the-box with GP that can be deployed to your SSRS site. But there is also an easy to use reporting tool that allows you to create custom reports.

Report Builder is accessed through the SSRS site. It allows you to use existing objects from which to report; and the objects are pretty standard. When you create a new report you have the option of creating a table style, matrix style, or chart report. You can easily drag and drop fields on to the report, and format the report to look the way your wish.

Once you have your report you can utilize the functionality in SSRS to schedule and deliver the reports. The report export options include: XML, CSV, PDF, Excel, and others.

If you have not yet tried creating a report in SSRS, you should. It's easy to get started, and I'm sure you'll like the results. Here is a report I created in five minutes. Think what you could do in 20.



Labels: , ,

0 Comments:

Post a Comment

<< Home