Lesson 3: Create drill down view in SSRS (Tutorial)

Lets create a drill down report using SSRS.

Right click on column that you need to group by and select Add Group and then Parent Group. In below case I have selected Genre as to group by.

Select Genre in Group By dropbox and check “Add group header”

Preview the report.

Right click on Details in the Row Groups section, available at the bottom of VS. Select the option Group Properties.

You will get prompted with Group Properties window. Navigate to Visibility tab, select checkbox “Hide”, select radio button “Display can be toggles by this report item” and in dropbox select field “Genre1”.

Delete the column “Genre”.

Preview the report. The grouping can be view in the report preview.

Conclusion:

Drill down report is ready. 


Related topics:

Lesson 1: CREATE A SIMPLE SSRS REPORT (TUTORIAL)
Lesson 2: CREATE A SSRS REPORT WHICH EXCEPTS INPUT PARAMETER (TUTORIAL)Lesson 4: NAVIGATING BETWEEN SSRS REPORTS (TUTORIAL)
Lesson 5: WORKING WITH SUB REPORT IN SSRS (TUTORIAL)
Lesson 6: WORKING WITH EXPRESSIONS IN SSRS (TUTORIAL)
Lesson 7: WORKING WITH GRAPHS AND INDICATOR IN SSRS (TUTORIAL)
Lesson 8: MISCELLANEOUS OPTIONS IN SSRS (TUTORIAL)