• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2372
  • Last Modified:

SSRS Sum issues in Group footer

I'm working on SSRS 2005

Im having an issue with Sum of a report group in the report footer to get my grand totals. This report is grouped by Vendor. Some vendors we have credits with but an over all balance. Other vendors we have an over all credit with. I want to show both but dont want to sum the ones with an over all credit. This is so our totals will come out right but we can see who we need to collect these credits from. In the example below I dont want to sum any amount from Vendor D. Vendor A has a sum of 0 dollar so its OK. In the below example I would like to see a grand total of $105.00 not $95.00 which is what I get if I just sum my net amount due.


Vendor A = $0.00 (This is my Net amount due for Vendor A)

Vendor B = $25.00

Vendor C = $80.00

Vendor D = ($10.00)

I have created the below expression in the group total so that Vendor D will show 0 dollar in hops I could just sum the textbox with group totals.
=(iif(sum (Fields!net_amnt_due.Value)<=0,0,sum (Fields!net_amnt_due.Value)))
Below is the expression I have in my report footer textbox.
It says that the value expression for the Report Footer uses a numeric aggregate function on the data that is not numeric.

Any ideas will be helful as I've been trying different things over the past weekend with no luck.
  • 3
1 Solution
Try using the same formula from your group footer.
abarefootAuthor Commented:
I'm having issues with group footer so I don't see how that will help.
abarefootAuthor Commented:
Maybe if someone knows how to make an iif statement be numeric that would fix my issue.
abarefootAuthor Commented:
OK I figured out that adding Val around my statement changed it to numeric.  I'm still having issues as I cant sum a ReportItems! in the body of the report.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now