Total between Columns
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22640
Printed Date: 05 May 2024 at 4:15am
Topic: Total between Columns
Posted By: dax007
Subject: Total between Columns
Date 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.
|
Replies:
Posted By: dax007
Date 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.
|
|