![]() In the Tablix Group, select Group by: option. ![]() Right-click the details group (in the Row Groups section as shown in the screenshot) and select Add Group > Parent Group… Step 1: The first step is to add a Parent Group at the Category level. The Drill-down report is what we need in this scenario. I will be using the same Parameterized report that I created in one of my earlier articles (Go to Creating a parameterized report in SSRS using mdx ). You can see that we have 4 columns in this report – Category, Subcategory, Product and Internet Sales Amount. When we execute the report in its current form we see all the column values by default.īut consider a scenario where the requirement is that only the Category values (with sub-totals at Category Level) should be visible when the report is initially rendered. If the user wanted to view the next level of details, like viewing the report at the Sub category or product level, then he should be able to do it easily. ![]() In this article, let us start to create a Drill-down report, another common type of report, using SSRS 2012. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |