Reputation: 1
I am not much familiar with Crystal Reports. I facing one issue regarding the Detail fields in Crystal report.
Lets assume I have 5 fields in Details band.
Field a, b, c, d, e and the record set for the below fields will be as below
A B C D E
111 1 20 30 222
111 1 21 31 222
111 1 22 32 222
111 2 11 11 222
111 2 12 12 222
111 2 13 13 222
Now I need to display the details by grouping the field B and get the sum for C and D. And at the end my result should be as below
A B C D E
111 1 20 30 222
21 31
22 32
------- ------
Total 63 93
111 2 11 11 222
12 12
13 13
------- ------
Total 36 36
Can some one help me how do I do this kind of Stuff.
Upvotes: 0
Views: 7992
Reputation: 1
Urik is correct !
I just want to add some points as par the output user1464855 want.
I hope this will help you. kindly correct me if I am wrong !
Upvotes: 0
Reputation: 1728
You should use the group option (Insert --> Group) and select field B.
Then, use running total to sum the wanted fields. (View --> Field Explorer, then, on the field explorer right-click on 'Running Total Fields' --> New). Create the wanted running total using this expert and then drag into your report in order to show it.
Insert text boxes as needed for the caption of the group header and "Total".
Upvotes: 1