Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SSRS Calculating counts across row and column groups

I'm building a report of case results with a parent-child grouping on the row group and single column grouping:

  • Parent Row Group: Location
    • Child Row Group: Result
  • Column Group: Month

Running across the report are months in the year, and running down the report are the location and the different result breakdowns for the location in the given month. Looks something like this:

                    Jan     Feb     Total
                    %   #   %   #   %   #
Main Office
        Pass        ?   5   ?   6   55% 11
        Fail        ?   5   ?   4   45% 9
        Total           10      10      20

Other Office
        Pass        ?   3   ?   2   25% 5
        Fail        ?   7   ?   8   75% 15
        Total           10      10      20

I have everything working except for the percentage breakdowns as indicated by the question marks above. I can't seem to get that total (the 10 for each month/location set above) reflected into my expression caclulation. Any ideas on how to setup my groups and variables to properly render these percentages?

Here's my attempts so far:

Count(Fields!Result.Value, "dsResults") = 40

Count(Fields!Result.Value, "LocationRowGroup") = 20

Count(Fields!Result.Value, "ResultRowGroup") = 11 - (for the Main Office/January/Pass cell, which is the total for the whole year for that result)

Count(Fields!Result.Value, "MonthColumnGroup") = 20

SSRS gets the count correct on the total line right, so there must be a way to reproduce that scope within the data cells?

like image 486
RyanW Avatar asked Jun 09 '10 13:06

RyanW


1 Answers

I sometimes work around annoying SSRS scope issues by pre-calculating my totals, subtotals and percentages. Take a look at this response (to a different post) for an example. I know it is unsatisfying, but it works: pre-calc values suggestion

like image 151
soo Avatar answered Oct 22 '22 04:10

soo