Brett Romershausen – Applications Consultant
Are you looking for a great reporting solution and are not quite sure where to start? You may already have one and simply not realize it. If you have Microsoft SQL Express Advanced, SQL Server Standard Edition or greater, then you have SQL Server Reporting Services (SSRS) available at no extra charge. With Reporting Services, you get a lot of great ways to present the data to the user. The package allows for a mixture of tables, lists, charts, gauges, and maps. A created report can be used stand-alone, as a sub-report within another SSRS report, or as a linked report. Think of all the possibilities! Besides traditional reports, now you can create dashboard style reports that combine charts and/or reports, chart trends, reports with a table of contents, and reports that allow you to drill down into the details. You can also design your own presentations in SSRS, such as a calendar view we created for a healthcare organization that displays data in monthly or biweekly calendar formats. Reporting Services has some neat features and visualizations built-in. Some include:
SSRS reports can be presented directly to the user with desktop apps, web apps, or SharePoint. Another built-in feature is exporting a report to PDF, Word, CSV, XML, and MHMTL. In addition to viewing and printing a report via the provided viewer, you can choose to schedule and email a report in any of these formats. Here are a few other things to consider:
An important feature of SSRS is the ability to allow users to filter report data based on selection criteria or parameters. You can insert a dropdown parameter list tied to a SQL table. You can configure optional selection criteria, required criteria, and criteria that allow you to select one or many values. These features are based on a few simple settings when defining the parameters, and then you just need to account for them in your query statement.
There are links to some of my favorite free info for Reporting Services:
Wise Owl SQL Procedures and Programming Tutorial Series
How to Locate and Start Reporting Services Tools
Conditional Formatting in SSRS
If you need help getting started or would like to hear how SQL Server Reporting Services can benefit your organization, please contact us at Keller Schroeder.