Hi. I've been banging my head on the wall for a while on a report and I could use some suggestions. I'm working on a report where I really need to get a summary of a group field, which Crystal won't let you do. Is there any kind of work around for this? Here's some details:
I'm pulling a sub-total of two fields in my details into my group section. I then have a formula field that calculates a value off of those sub-totals. I need to add up the formula values for each occurrence of the group in the report. Is there a way to do this? For a little more detail, I'm grouping by customer, and calculating commissions based on the sub-total sales vs cost for each customer. So if my sales guy gets $500 for one customer, and $250 for another, and $250 for a third, I want to be able to print "Total Commission=$1000" at the end of the report.
Any help would be appreciated.
I'm pulling a sub-total of two fields in my details into my group section. I then have a formula field that calculates a value off of those sub-totals. I need to add up the formula values for each occurrence of the group in the report. Is there a way to do this? For a little more detail, I'm grouping by customer, and calculating commissions based on the sub-total sales vs cost for each customer. So if my sales guy gets $500 for one customer, and $250 for another, and $250 for a third, I want to be able to print "Total Commission=$1000" at the end of the report.
Any help would be appreciated.