Creating SQL Server Reporting Services reports

SQL Server Reporting Services (SSRS) is Microsoft most accomplishing reporting tool. No matter which tool you decided to use in the Microsoft Business Intelligence offerings, SSRS will likely play a part if you really want one solution that does most of what you need. SSRS is part of the SQL Server “Suite” of applications and has its own application services, configuration tool, and website. It is truly a full-service reporting solution that can compete with other vendors reporting solutions.

Types of SSRS Installations

There are two types of SSRS installations – Integrated and Standalone.  Integrated SSRS installation is installed as part of SharePoint and all of the SSRS components run under the SharePoint system. This provides some real advantages when it comes to using SSRS reporting within SharePoint sites and reports. Conversely, Standalone SSRS installations have been install on its own dedicated server and does not share space or resources with SharePoint. This is the “traditional” SSRS installation and allows organizations to use SSRS without the need of a costly SharePoint implementation.  The type of installation you choose will depend primarily on the availability of SharePoint and who’s responsible for reporting.

Why SSRS?

Simply put, SSRS allow for the most creating and sophisticated of reports of any Microsoft reporting offering. It allows much more flexibility and creativity than most reporting solutions on the market. This is my favorite reporting tool and I’ve used a lot of them. It does lack the dynamic in-memory reporting that you’ll often see on the market but often those offerings are more style than substance.

Demonstration of SSRS dashboard creation

In this demonstration I will show you the process of creating a SSRS from scratch. This process will start by first creating the SSRS data sources, datasets, and SSRS Report objects.

Leave a Comment

Your email address will not be published. Required fields are marked *