Click here to Skip to main content
15,940,246 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi all,
I have two columns Amt,SchCode coming from database

Data is

Amt SchCode

123.34 1
435.44 1
435.45 2
334.46 1
2234.4 2

i want to display difference of "sum of Amt where schcode=1 and sum of Amt where Schcode=2" in variable of crystal report.How can i do this..

Please suggest me.
Updated 4-Jul-13 21:16pm

1 solution


create a group with schcode,

create a summary
- field to sum: amt
- what to do: sum
- place: group previously created

You'll get

SchCode Amt
1 1001.24
2 2669.85
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900