SSRS reports examples for 2012

SSRS reports examples for 2012


I wanted to explore the different types of SSRS report hence I would be starting with a simple report. We’ll see creating SSRS report example in 2012.

To have more meaningful format for reports I am going to create a table with data which can help us in looking into different types of reports.

T-SQL Script:

Script File: sales_table_script


Now we have ready with the required data. Create a new SSRS report using “SQL Server Data Tools”.

As we are creating a new report using Wizard just follow the instructions.

A stored procedure is being called here. The result set returned by the procedure will be used in report.

Now the report look like below.

Add an image to the report.

After adding the image update report name as below and execute the report.


It’s just a simple report to retrieve a dataset using a stored procedure. Our main intension is to looking into SSRS functionality rather than query / procedure using for result set which is retrieving from database.

Posted in MSBI, SSRS | Tagged , , , , , , , , , , | 1 Comment

Leave a Reply

1 Comment on "SSRS reports examples for 2012"

newest oldest most voted
Notify of

[…] We will see how to deal with drill down reports using SSRS 2012. For this report you can create a table and populate data from the post. […]