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 , , , , , , , , , , , | 5 Comments

5
Leave a Reply

avatar
3 Comment threads
2 Thread replies
0 Followers
 
Most reacted comment
Hottest comment thread
4 Comment authors
uday arumillisaichandTjunoRoni Wanko Recent comment authors
  Subscribe  
newest oldest most voted
Notify of
Roni Wanko
Guest
Roni Wanko

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
Tjuno

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.

saichand
Guest
saichand

hi udaya
i am attending msbi dev interviews, what extant sql the one helps me
mainly u listed out companies and interview q?s are all there in this book
please confirm me