In this article I will show you how to create Reporting services (SSRS) project and report step by step. This is a first step before we will be able to create report. To even start working with Reporting Services tool, we need to meet these requirements:

  • Visual studio 2019 (or SSDT) – in case we use Visual studio 2019 we have to install extra SSRS add-in. In case we are going to use something like SSDT, everything is prepared after installation, no action needed.
  • SQL Server instance for storing data with SQL Server Management studio to be able to query a database
  • Microsoft AdventureWorksDW2014 sample database or some data to play with

SSRS Project and Report Creation

SSRS projects are files containing reports, datasets and data connectors in form of XML code. The file contains basically everything for the succesfull communication of a report with a data source (typically a database). The file can be graphically represented in some program – we use Visual studio. There are couple of options after we launch Visual studio. Let’s create a new project and on the next screen select Report Server Project (see screenshots below).

Create SSRS Project
[1] Create SSRS project screenshot 1
SSRS project selection
[2] Create SSRS project screenshot 2
Now it is a time to create our SSRS project. We can do that by right-clicking on folder named Reports in Solution explorer. Then select either:

  • Add new report – in this case, report creation wizard is activated. It will guide you through all stuff. I personally do not like report wizard and therefore I use the second option
  • Add New item followed by selecting Report – wizard does not activated this case. You can make everything by your own. So, create report named “Prodeje po produktech” (Czech screenshots) – translation is Sales by products. You can see that out report has been successfully created with .rdl extension

SSRS Report creation in Solution Explorer
[3] Create SSRS report in Solution Explorer
Naming new SSRS report
[4] Giving a name to our new SSRS report
If you followed these steps ou should see something like this below

SSRS Project and report are successfully created
[5] SSRS Project and report are successfully created
You can take a look at this video on how to create a report in reporting services (SSRS) in SQL server data tools 2015 (no sound, czech labels)

We just created empty report in reporting services project. What’s next is creating Data source for SSRS to our source of data

Rate this post

Ing. Jan Zedníček - Data Engineer & Controlling

My name is Jan Zedníček and I have been working as a freelancer for many companies for more than 10 years. I used to work as a financial controller, analyst and manager at many different companies in field of banking and manufacturing. When I am not at work, I like playing volleyball, chess, doing a workout in the gym.

🔥 If you found this article helpful, please share it or mention me on your website

Leave a Reply

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