aaronburro
Programmer
I've got an interesting situation here, so I'll describe it 
I'm doing a report where I am showing information on Invoice information, as well as InvoiceDetail information. I am grouping by Invoice and CustomerNumber, with Invoice being on the inside. I'd like to find the sum for FreightCost, which is located in a table linked to the Invoice table, which is of course at the Invoice level in the report, and not the InvoiceDetail level.
Obviously, the Invoice level is a group, and not a detail, so as I am currently doing it, I am summing the freight cost for each detail item, which is fine, as long as there is only one detail item in the invoice. However, that isn't usually the case, so my Freight cost gets inflated.
My question is this: Is there an elegant way to sum on the group and not have it sum for each detail element as well? I have already found a solution to this, but it is far from elegant. I was thinking that there might be an intrinsic method available in CR that already did this that I am blindly missing... thx in advance!
BTW, we are using CR8.5 for MAS200.
I'm doing a report where I am showing information on Invoice information, as well as InvoiceDetail information. I am grouping by Invoice and CustomerNumber, with Invoice being on the inside. I'd like to find the sum for FreightCost, which is located in a table linked to the Invoice table, which is of course at the Invoice level in the report, and not the InvoiceDetail level.
Obviously, the Invoice level is a group, and not a detail, so as I am currently doing it, I am summing the freight cost for each detail item, which is fine, as long as there is only one detail item in the invoice. However, that isn't usually the case, so my Freight cost gets inflated.
My question is this: Is there an elegant way to sum on the group and not have it sum for each detail element as well? I have already found a solution to this, but it is far from elegant. I was thinking that there might be an intrinsic method available in CR that already did this that I am blindly missing... thx in advance!
BTW, we are using CR8.5 for MAS200.