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.

Rate this post

Ing. Jan Zedníček - Data & Finance

My name is Jan Zedníček and I work as a freelancer. 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 and I enjoy tasting of best quality rums.
I am trying to summarize all my knowledge on this website not to forget them and to put them forward to anyone.

Leave a Reply

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