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.