SSRS Tutorial Part 1 – Creating SSRS Project and Report in Reporting Services

Last modified date:

This miniseries focused on making a report in Reporting services will show you how to create SSRS project and report step by step. Let’s take this as a preparation of place where we will create the report itself. To even start working with Reporting Services tool, we need:

  • SQL Server Data tools 2015 (or older) – SSDT in further readings. We can also use Report builder (SSRS desktop app) but this one has limited options. I will talk about it in different post.
  • SQL instance either on local or factory SQL Server. If you have neither of these, just install SQL Server Express (guide here). After installation, upload Microsoft AdventureWorksDW2014 sample database so you have some data for the reports. Installation guide can be found here.

You can take a look at this video to see how to create a report in reporting services (SSRS) in SQL server data tools 2015 interface (no sound, czech labels):

SSRS Project and Report Creation

SSRS projects are kinds of packages containing reports, datasets and data connectors. Basically everything for the correct communication of report with sql database and correct functioning. There are 2 options after SSDT launch. We either have so project in works or we can create a new one. We create a new project and on the next screen select Report Server Project.

Založení SSRS projektu

[1] SSRS project creation

SSRS Výběr typu projektu

[2] SSRS project selection

 

 

 

 

 

 

 

 

To create and select a project, report creation is needed. You will do that by right-clicking above folder report in Solution explorer. Then select either:

  • Add new report – in this case, wizard is activated. It will guide you through connection of reports to datasets etc. I personally do not like report wizard and therefore I use the second option
  • Add New item followed by selecting Report – wizard does not bother you in this case. You can make everything up to your needs. So, create report of Sales by products. You can see that reporting services files have rdl extension

Založení reportu v Solution Exploreru

[3] Report creation in Solution Explorer

Pojmenování nového SSRS reportu

[4] Naming new SSRS report

 

 

 

 

 

 

 

 

 

If you followed these steps then this view is expecting you. (or little bit different maybe, depends on SQL Server data tools version).

SSRS Projekt a report jsou úspěšně založeny

[5] SSRS Project and report are successfully created

Report in reporting services project is created. What’s next is creating Data source for SSRS and creating Dataset from which will the report import data. But that is for another article.

My name is Jan Zedníček and I work as a BI Developer at Kentico Software in Brno. Mostly you can see me there working in the office, but I also work partly as a freelancer. I have been working as a freelancer for many companies for more than 5 years, but Kentico is the matter of my heart. I used to work as a financial controller at companies like Aero Vodochody or Sberbank and I also used to be a bond program manager in Unicapital Investment group. When I am not at work, I like playing volleyball, chess, doing a workout in the gym and I enjoy tasting of best quality rums. I am trying to summarize all my knowledge on this website not to forget them (because of the rum effect, you know =) and to put them forward to anyone. Don´t worry about asking for help or writing some comments.

Category: SSRS - Reporting Services

About Ing. Jan Zedníček - BI Developer, Finance controller

My name is Jan Zedníček and I work as a BI Developer at Kentico Software in Brno. Mostly you can see me there working in the office, but I also work partly as a freelancer. I have been working as a freelancer for many companies for more than 5 years, but Kentico is the matter of my heart. I used to work as a financial controller at companies like Aero Vodochody or Sberbank and I also used to be a bond program manager in Unicapital Investment group. When I am not at work, I like playing volleyball, chess, doing a workout in the gym and I enjoy tasting of best quality rums. I am trying to summarize all my knowledge on this website not to forget them (because of the rum effect, you know =) and to put them forward to anyone. Don´t worry about asking for help or writing some comments.

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.