Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: summary on group header Post Reply Post New Topic
Author Message
taniarto
Groupie
Groupie
Avatar

Joined: 15 Oct 2010
Online Status: Offline
Posts: 52
Quote taniarto Replybullet Topic: summary on group header
    Posted: 20 Apr 2016 at 7:48pm
I have data as below :
No.    Name      qty
1.     A        100
2.     B        300
3.     C        100
4.     A        100

I want to make the summary like this :

total all : 600
No.    Name      qty
1.     A        100
2.     B        300
3.     C        100
4.     A        100

so the summary display at the header of the report, it is possible without any subreport creation ?

thx


IP IP Logged
Valert16
Groupie
Groupie
Avatar

Joined: 21 Mar 2016
Location: Spain
Online Status: Offline
Posts: 57
Quote Valert16 Replybullet Posted: 20 Apr 2016 at 11:20pm
Insert Summary. Choose these options: field: qty; Summary: Sum; Summary location: Grand Total (Report Footer).
Move the summary to the report header.
I suppose you have a report with no groups.
IP IP Logged
taniarto
Groupie
Groupie
Avatar

Joined: 15 Oct 2010
Online Status: Offline
Posts: 52
Quote taniarto Replybullet Posted: 21 Apr 2016 at 12:12am
there is a groups, and the result is reset following the summary of the groups. Could it summarized totally?

thx
IP IP Logged
Valert16
Groupie
Groupie
Avatar

Joined: 21 Mar 2016
Location: Spain
Online Status: Offline
Posts: 57
Quote Valert16 Replybullet Posted: 21 Apr 2016 at 12:34am
What do you mean with " the result is reset"? What result, and why is it reset? Anyway, even if you are grouping, I don't see why the solution I gave to you is not working.
Please, could you explain in more detail?
IP IP Logged
taniarto
Groupie
Groupie
Avatar

Joined: 15 Oct 2010
Online Status: Offline
Posts: 52
Quote taniarto Replybullet Posted: 21 Apr 2016 at 3:25pm
reset mean is the summary always return to the summary of the groups. for example : A --> 200
                             B --> 300
                             C --> 100
it is because I put group by Name. If there were no groups I can't copy as you tell into page header is like cannot copy to the area..

thx
IP IP Logged
taniarto
Groupie
Groupie
Avatar

Joined: 15 Oct 2010
Online Status: Offline
Posts: 52
Quote taniarto Replybullet Posted: 21 Apr 2016 at 5:40pm
sorry there's a miss it is working if there's a group as you said. But my report doesn't have groups...is it possible ?

thx
IP IP Logged
Valert16
Groupie
Groupie
Avatar

Joined: 21 Mar 2016
Location: Spain
Online Status: Offline
Posts: 57
Quote Valert16 Replybullet Posted: 21 Apr 2016 at 11:30pm
Let's try to clarify.
Please, read carefully my first answer. If you insert a summary with these settings, then you'll end with a Gran Total at the report header showing the value 600 which is the sum you want. Is it correct?
The result is the same whether you are grouping by Name or not.
Note I don't tell you "copy into page header". I do tell "move the summary to the report header"
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.031 seconds.