carlmahon
asked on
Group and total records by value
I am new to crystal reports and am trying to figure out how to make this work. I need a report that selects all money accounts (positive, negative and 0) value. I want to put all the positive accounts first & total them. Then the negative accounts & total them and exclude any account with 0 values. Finally total them all. I have crystal reports 10 and it is all in a single table.
Example:
Acct 1 123456 $10.00
Acct 2 789123 $22.00
Acct 3 456789 $12.00
Acct 4 012345 $30.00
______________________
$74.00
________________________
Acct 5 987654 -$2.00
Acct 6 765443 -$3.00
________________________
-$5.00
===================
$69.00
Thank you
Example:
Acct 1 123456 $10.00
Acct 2 789123 $22.00
Acct 3 456789 $12.00
Acct 4 012345 $30.00
______________________
$74.00
________________________
Acct 5 987654 -$2.00
Acct 6 765443 -$3.00
________________________
-$5.00
===================
$69.00
Thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Glad i could help
mlmcc
mlmcc
ASKER