The drilldown functionality works either at the row level, the column level, or the group (column or row) level.įirst, a field is selected as the toggle button location. This detail includes both the row and columns desired for the lowest level viewing needed. In order to define a drilldown action, a tablix must first be created with the appropriate level of aggregation all the way to the level of drilldown detail desired. DrilldownĪ drilldown report is actually a slight misnomer the true name is a drilldown action.
#Sql report builder 2012 how to
The remainder of this article will review how to create each of these different report options while also discussing some of the benefits and drawbacks of each choice. Which option is best certainly depends on your specific needs and uses. Alternate methods of providing this detail include: Often this situation arises while looking at a summary or dashboard type report, and the end user would like to see "what makes up" a particular number. SolutionĪs you work with SSRS, you will quickly find a need to offer end users the ability to see additional details about the data they are currently viewing.
What options are available for creating reports with these features? In this tip we will look at the different options and how they can be used. SQL Server Reporting Services (SSRS) 2012 includes many drilldown / drillthrough features. By: Scott Murray | Updated: | Comments (17) | Related: > Reporting Services Drill Through