How to get below result using Crystal Report

Posted by Bubaibanerjee under ASP.NET on 12/29/2014 | Points: 10 | Views : 1166 | Status : [Member] | Replies : 1
CODE EMP_OP E1 E2
1 200000 2000 2000
1 377209 2371 2134
2 190159 2248 2024
2 254707 0 1848
3 969704 5000 5000

I am using Crystal Report.
I want result like below.

CODE EMP_OP Emp Contribution(E1+E2)
1 577209 8505
2 444866 6120
3 969704 10000

I am fresher.Can anybody please help me. Any help will be highly acceptable.Thanks in advance.




Responses

Posted by: vishalneeraj-24503 on: 12/29/2014 [Member] [MVP] Platinum | Points: 25

Up
0
Down
Hi,You can apply formula for summimg e1 and e2 in crystal report.When you open report,on left hand side,there is a formula field.Just create your formula name then from dataset select e1 and e2 as

sum({ReportTable01.e1})+{ReportTable01.e2}


then save it and drag your formula variabla to your report.

Bubaibanerjee, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response