Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2016 : Technical Questions
Message Icon Topic: Total between Columns Post Reply Post New Topic
Author Message
dax007
Newbie
Newbie


Joined: 17 May 2018
Online Status: Offline
Posts: 25
Quote dax007 Replybullet Topic: Total between Columns
    Posted: 11 Jul 2018 at 4:06am
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.
IP IP Logged
dax007
Newbie
Newbie


Joined: 17 May 2018
Online Status: Offline
Posts: 25
Quote dax007 Replybullet Posted: 11 Jul 2018 at 4:59am
I think I got it.. I have added a new detail section and it create a formula to display after the column where i wanted.
Thank you.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.047 seconds.