Drill Down Reports in SSRS with examples

UDAYARUMILLI_REPORTS

Drill Down Reports in SSRS with examples

We will see how to deal with drill down reports in SSRS with examples. For this report you can create a table and populate data from the post.

Let’s create a report using SQL Server 2012 Data tools. Create SSRS report using SSRS report wizard.

Sales Table Creation Script: sales_table_script



Substitute the query in design query window.





Now the report looks like below.

Do required alignments and update the report name and now the report looks like below.

Preview the report to make sure it’s been working fine and retrieving data.

Now we’ll go ahead and design drill down report base don year.

Under row group add a parent group for the column year.



Preview the report to have a drill down report.

Now edit the group details as below.

Now preview the report.

Expand the year check the view.

To give more clear view we will remove the column “Year”  (repeated values).

Preview the report; it will be the final view of the drill down report.

            This is the way to implement drill down view for SSRS reports.

Posted in MSBI, SQL Development, SQL Server DBA, SSRS | Tagged , , , , , , , , , , , | 3 Comments

Leave a Reply

3 Comments on "Drill Down Reports in SSRS with examples"

Notify of
avatar
Sort by:   newest | oldest | most voted
Roni Wanko
Guest

I know this if off topic but I’m looking into starting my own weblog and was wondering what all is required to get setup? I’m assuming having a blog like yours would cost a pretty penny? I’m not very internet savvy so I’m not 100% sure. Any suggestions or advice would be greatly appreciated. Cheers

Tjuno
Guest

I CANNOT GET THE DATASET(the query provided for data set is not in SQL2012 DB).
Kindly advice on the database you used for your data source.

wpDiscuz