SSRS Tutorial Part 4 – Creating Report in SSRS – Reporting Services

Last modified date:

Last 3 SSRS tutorials were kind of preparation phase, maybe a calm before a storm :). After creating SSRS project, defining data source and dataset, it is finally time to create a simple report in SSRS. Reporting services offers plenty of useful tools you can use to create nice and practical tables/graphs. We will not do anything complicated as this miniseries is focused mainly on beginners and semi-advanced.

Our Dataset from previous part (Part 3 – How to configure Dataset in SSRS) contains sales data organized by product and product group in individual year/month. We will create simple table which will only display the result of the dataset.

How to Create Report in SSRS

Let me just repeat that after our previous work, our project should look like this.

1) Creating Table in SSRS

We finally reach core of the thing and it is time to work on data visualization. It is good to think through how will the structure of the report look like so the user will be able to navigate in it. We could start by adding a well-arranged table. Visualization tools can be found in “Toolbox“. Select tool Table and use mouse to drag it into the report area [2].

[1] Display of Reporting Toolbox

[2] Dragging table to the report area

 

 

 

 

 

 

Right now, the table is not bound to any data. We have to “tell” the table which data is relevant to it. It will logically be the data from our dataset. Press the right button on the left upper corner of the table and then select Tablix properties [3]. Link the dataset to “Dataset name” in the properties [4].

[3] Table properties

[4] Table reference to dataset

 

 

 

 

 

 

Table is now bound to the data. Only thing we need to do in the table  is link to the field in dataset. You can do that by clicking into the cell of the table, list of the dataset fields will appear [5]. We will then gradually fill up the table with links to the dataset. You can play with the formatting since it works in a similar manner as in the Excel. Every cell has its own properties. We should get to the same result as the one on the screen [6].

[5] Filling the table through reference to dataset

[6] Prepared table in report

 

 

 

 

 

 

You can see the result of our work using Preview button.

Report v SSRS

In the next part (Part 5 – configuring parameter in SSRS), we will take a look at how to configure report to parameters so the whole table will not show up every time. Instead, it should react to selected requirement inserted into report parameters.

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.