Drillthrough Report with count

• adb2303

  SSCertifiable

  Points: 7588

  More actions

  September 25, 2015 at 4:17 am

  #321492

  Hi,

  I have an SSRS report with a drillthrough table on it. There are 12 columns, each column is expandable to another level. Depending on which columns expanded, I would like a "count" column at the end of the table that shows the number of rows in that group,

  

  https://www.sqlservercentral.com/Forums/Uploads/image-unavailable.png

  So, if I was to collapse the group in Col1 upto UK, the rowcount would be of all the counties/towns/roads in the UK. CountRows seems to work fine, but I can't get it to change its scope based on the group expanded.

  Thanks,

  Andrew

• sql Sarah

  SSCrazy

  Points: 2081

  More actions

  September 28, 2015 at 8:15 am

  #1829890

  Do you have grouping? If you put an expression in the group footer, and set the visibility for that row the same as the row that expands, it should show the total when row is expanded.