Post reply

Drillthrough Report with count

  • 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

  • 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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply