Hi, I am a bit new SQL Server 2005 Reporting Services. I have designed the following Report using Visual Studio 2005 but won't be able to drill down to the Detail. I want to Drill down the Calculated values (Sum) of faults for their detail. In the following screen shot 24 is Sum of Fault which are mapped in my Reports Data Set and I would like to have a + sign (Drill Down Sign) with Calculated value 24 which will display me the fault detail. Deferred Document Update Fixed Closed Fatal 24 2 Major 575 31 Minor 254 12 Discard Fatal Major 5 Minor 2 1 Fixed Fatal 2013 Major 22990 Minor 8088 New Fatal 11 73 Major 234 908 Minor 109 575 Not Fixed Fatal 2 6 Major 22 119 Minor 9 40 Open Fatal 129 17 Major 3060 1 255 Minor 930 129 Deferred Document Update Fixed Closed Fatal 24 2 Major 575 31 Minor 254 12 Discard Fatal Major 5 Minor 2 1 Fixed Fatal 2013 Major 22990 Minor 8088 New Fatal 11 73 Major 234 908 Minor 109 575 Not Fixed Fatal 2 6 Major 22 119 Minor 9 40 Open Fatal 129 17 Major 3060 1 255 Minor 930 129 Regards, Shakeel

Go through the following article - http://thavash.wordpress.com/2008/01/29/building-drill-down-reports-using-the-tablix-control/

To get + buttons(drill down), you have to select the first column and go to textbox properties--select visibility----Check Disply can be toggled by this report item and select a column which has to be hide. Let me know if it works or not. Thanks Tarak