June 30, 2017 at 7:32 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?
June 30, 2017 at 12:06 pm
NineIron - Friday, June 30, 2017 7:31 AMI 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)
June 30, 2017 at 12:12 pm
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