Rectangle 27 0

You probably figured this out a year ago, but just in case, try this:

SUM({@CanadianCommissionFormula},{SalesRep})

Put this formula in your SalesRep's Group Footer section.

formula - Conditional group SUM in Crystal Reports - Stack Overflow

crystal-reports formula
Rectangle 27 0

I would assume that rexem's suggestion should work but since you said it gives you a total all of the sales reps you could change the sum to running total. Before doing this I'd double check that you have your field in the correct footer section though.

To do the running total, group by Sales Rep, and then set up your running total to evaluate on every record and reset on the change of the group. Then you can put this running total in the group footer and it will show subtotals.

how do I get it to reset on the change of the group?

You can setup running totals through functions, or use the Running Total feature in the same widget where you list the functions/etc.

When you set up the new running total field you will see a "Reset" section which is where you set it to "On change of group" and then select your group. This will reset the field back to zero every time that group changes.

formula - Conditional group SUM in Crystal Reports - Stack Overflow

crystal-reports formula
Rectangle 27 0

Create a group based on the sales rep in the Crystal Report, and place the:

SUM({@CanadianCommissionFormula})

...in the footer of the group.

that, unfortunately gives me the sum for all the sales reps

Then you aren't grouping by sales rep, or the sales rep info isn't what you think it is.

When I look at the Group Expert I see the field SalesRep in the "Group By" portion. Then, using the formulas I've got listed above, I add the formula from your answer in the GroupFooterSection1 area, it then displays the total SUM for all Canadian Commissions, not the individual rep.

So on the report, you see a group header above the details section, and the corresponding group footer underneath - the formula is in the group footer section...

Is any other data relating to sales rep coming out properly in the grouping?

formula - Conditional group SUM in Crystal Reports - Stack Overflow

crystal-reports formula