3 Level Master Detail Report using ReportViewer

Question

User-1654626721 posted

Hi Folks

I need some help creating a Master Detail report That has 3 levels

We have  Goal the Goals have Indicators and the Indicators have montly values. I have looked every where trying to find a good tutroial on creating this type of report but i am not finding much. I even tried paying for a class on lynda dot com and it didn't help they just barely even mentioned reporting...

Can someone please help with getting going the right direction. If you know of a video that i can even watch to learn how that would be great. I learn quicker watching someone do it other than reading about it. Only to fidn out what i just spent hours on was the incorrect verson of report viewer. :(

Thanks

CapJLP

Answer 1

User-96295490 posted

Hi,

From your problem statement i believe you are looking out for the drill down report in ssrs.

Once you get the values for the Master Detail Report having three levels through stored procedures or so in sql getting the drill down report is much easier.

Go through the following link that will help you accomplish the drill down report.

http://www.mssqltips.com/sqlservertip/1329/drill-down-techniques-in-ssrs-with-the-visibility-property/

Regards,

P.Anish Shenoy.

"Mark this post as answer if this post helps you it might help others also"

Answer 2

User-1051986203 posted

Hi....

check this link:-

http://blog.hoegaerden.be/category/sqlserver/reporting-services-sqlserver/page/2/

http://bisherryli.wordpress.com/2011/02/19/ssrs-how-to-toggle-the-details-with-invisibility-property-for-tablerow/