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

Sum in Details Section

I need to sum the number of discounts and the amount of the discount in the detail section of Crystal Reports 2008.

I have a possible 750 {Discount.ID}'s and need to total the ({DISCOUNT_RECORD.Amount}) for each. I need this information to be displayed in the details sections of my mailing labels report.

How can I achieve this?

I know you can't use a where formula but I need something like this...

sum({DISCOUNT_RECORD.Amount}) where {Discount.ID} = {Discount.ID}

----------I figured it out-----------

Used Running Totals and  hid the previous IDs if they matched.
1 Solution
You could also group by the discount Id field and use the summary functions on the group


Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

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