SQL Server Reporting Services

SQL Reporting Services 2008 and above is a great product for building quick reports. A Report Developer can easily create a report using SQL and Visual Studio Professional. The problem is that there are many data consumers that are not Visual Studio and SQL experts. The solution is to use SQLRS (SQL Reporting Services) and Web Based .NET Report Builder and SSAS (SQL Server Analysis Services).

Clicking on Report Builder button the Report Builder is installed using the .NET Framework

We are going to create a Table Report. Select new datasource and Analysis Services

Select values in a shown in the following


Row Groups a Vertical, Column Groups are Horizontal in the report.

Accept the defaults and you now have a nice basic report that is filtered to the main page.

This is very basic but it was quick. Next article we will visit report models right off the cube.