How to sum an aggregate expression

  • I have a subreport grouped by EdStatusName. The subreport is counting the number of patients in each status. I would like to add a Grand Total. The expression for the EdStatusName count is =Count(Fields!EdStatusName.Value). I inserted a row outside the group but, can't get the correct Sum. Any thoughts?

  • NineIron - Friday, June 30, 2017 7:31 AM

    I have a subreport grouped by EdStatusName. The subreport is counting the number of patients in each status. I would like to add a Grand Total. The expression for the EdStatusName count is =Count(Fields!EdStatusName.Value). I inserted a row outside the group but, can't get the correct Sum. Any thoughts?

    Not sure, as I can't exactly see your report design.  You'll have to provide a lot more details.   You may need to use a variable to accumulate that Grand Total, or it might be a matter of where you place the calculation.   Sometimes, you end up needing to put something hidden in a details section in order to have something you can SUM up later.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

  • I figured it out. I added a group with a footer then, I added the expression =Count(Fields!EdStatusName.Value) in a cell in the footer.
    Thanx.

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

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