"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

clip_image002

2. Provide the stored proc in the query builder window

clip_image004

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

clip_image006

4. Select option for Drilldown

clip_image008

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

clip_image010

7. Change it into a stored proc.
clip_image012

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.

clip_image014

No comments: