"No one is harder on a talented person than the person themselves" - Linda Wilkinson ; "Trust your guts and don't follow the herd" ; "Validate direction not destination" ;

December 19, 2009

Drill Down Report in SSRS

This is in continuation with my first blog entry link

1. Create a new report based on Wizard


2. Provide the stored proc in the query builder window


In the next window select Tabular form.
3. Choose options for group by based on city as described below


4. Select option for Drilldown


5. Complete the next steps to complete the report
6. Goto Dataset Properties


7. Change it into a stored proc.

8. You will see the report output like the drill down report option. The input parameter and the proc need to be modified to show it as a drop down list.


No comments: