Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Displaying at the group header Post Reply Post New Topic
Author Message
Rajasekharsv
Newbie
Newbie


Joined: 15 Jul 2010
Online Status: Offline
Posts: 9
Quote Rajasekharsv Replybullet Topic: Displaying at the group header
     Posted: 28 Jul 2010 at 12:45am
Hi,i have calculated sum of amount and it is being diaplyed in the group footer,and now i want the value of groupFooter to be in GroupHeade
ex:
GH------------------Total Value(60)-----I want the total to be displayed this way.
Name                                      Amount
A                                             10
B                                             20
C                                             30
GF(Group Footer)-----------------------(60)---(This is what  i am displaying currently)
 
i am calculating this value by using formula fields
i have taken Three fields.
 Reset and Display
in the Reset field declaring shared numbervar a;a:=0;
in the Display field declaring shared numbervar a;a:=a+{tbl.fieldAmount};
 
Display field is placed on Details tab and Reset field is Placed on GroupHeader by appling my condition when it is to be set as a 0.
 
 i have taken another FormulaField Result and in that i am calling the Display field, and it was displayed on the Group Footer
 
Now the Value in the Result Field must be displayed in the GroupHeader.
 
thanks in advance
 
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 28 Jul 2010 at 3:50am
Is there  a reason you did not use the Insert Summary (sigma sign) function as a SUM of fieldamount?
That is the easiest solution.
Click on the Sigm Sign
Select the 'fieldamount' field you were using in your shared variable
Set it as a SUM
Summary Location is group footer
Once created drag it fromt he footer to the header


Edited by DBlank - 28 Jul 2010 at 3:50am
IP IP Logged
Rajasekharsv
Newbie
Newbie


Joined: 15 Jul 2010
Online Status: Offline
Posts: 9
Quote Rajasekharsv Replybullet Posted: 29 Jul 2010 at 7:19pm
Ya, i tried that one also but ,i coudn't found my formula in the list of report fields list or other.then how can i do that,plz give some advice regarding this.
Thanks & Regards
IP IP Logged
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