Hello,
I have sql query that gives my following output

UNam   Ja Fa
AAA    77 44
BBB    48 34
CCC    34 23
DDD    22 28
AAA11 83 77
BBB12 23 34
CCC13 22 55
DDD14 73 11

Now I would like to use same query in crystal report but the report out come should be as follow


UNam   Ja Fa
AAA    77 44
BBB    48 34
CCC    34 23
DDD    22 28
TOTAL 181 129
AAA11 83 77
BBB12 23 34
CCC13 22 55
DDD14 73 11
TOTAL 201 177

So if I put Unam in Detail section it will give me list of all "Unam" So how do I insert "TOTAL" in between?

Any advice/help?

Thank you.