Create groups based on formula results
I've got a report where I need custom groupings based on a formula. Two fields need to be compared against one another. Based on the results groups need to be created. The results wll be 3 scenarios resulting in 3 different status possibilities:
Scenario 1 - If Field B >0 and Field A < Field B then Status ="Paritally Recevied"
Scenario 2 - If Field A =Field B then Status ="Recevied"
Scenario 3 - If Field B =0 then Status ="Not Recevied"
So the 3 groups would be Partially Received, Received, Not Received and all are based on running all report records through the formula before displaying them in those groups.
I have no idea of the correct syntax for this but have soem experince in the Crystal Reports formula deisgner. I also don't know how to add the correct formula to the group paramters,
Any help is appreciated.