Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: grandtotal Post Reply Post New Topic
Author Message
zakal1983
Newbie
Newbie


Joined: 24 Nov 2009
Online Status: Offline
Posts: 8
Quote zakal1983 Replybullet Topic: grandtotal
    Posted: 24 Dec 2009 at 9:34am
My report structure is like
 
group #1        | value1    value1/grandtotal   
 
report footer  | value1total        
 
so the report should look like :
 
name1    5     25%            
name1    5     25%            
name1    5     25%            
name1    5     25%            
 
total      20    100%
 
 
but I got
 
name1    5     100%            
name1    5     50%            
name1    5     33%            
name1    5     25%            
 
total      20    100%
 
I tried to use a dummy formula field that is written like :
whilereadingrecords;
"";
 
and for grandtotal
evaluateafter({@dummyformula});
(so that the percent calculation hopefuly takes places after)
This doesn't work.
 
"insert summary" would not work as I have more one columns.
I cannot use "cross-tab" due to its design limit.
"SQL command" wouldn't work because this report takes two parameters, which are start and end date.
 
Please tell me how to get the actual grandtotal in group section.
 
 


Edited by zakal1983 - 24 Dec 2009 at 10:56am
IP IP Logged
jkwrpc
Senior Member
Senior Member


Joined: 19 Jun 2007
Location: United States
Online Status: Offline
Posts: 432
Quote jkwrpc Replybullet Posted: 24 Dec 2009 at 1:33pm
I would guess that it is because of the way the grand total is created. If you have the grand total in the group footer, it is increasing as each item is added. CR does not calculate the grand total in the footer, then come back and add the rows to the report. It add the rows firts and increments the total by amount in the row that is part of the grand totals. Hence the first row is a 100%, Second row 50% and so on.
 
Place the total in in the group header and all should be fine.There other ways to do this but this should be the easiest.
 
Hope this helps.
 
Regards,
 
John W.
 
IP IP Logged
zakal1983
Newbie
Newbie


Joined: 24 Nov 2009
Online Status: Offline
Posts: 8
Quote zakal1983 Replybullet Posted: 28 Dec 2009 at 4:36pm

Hi John,

Can you tell me other ways of getting a grand total.
I tried to put it in the group header but I still get the same result..
 
Thanks
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.