Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: How to generate Grand Total Post Reply Post New Topic
Author Message
Anto
Newbie
Newbie
Avatar

Joined: 06 May 2009
Location: India
Online Status: Offline
Posts: 2
Quote Anto Replybullet Topic: How to generate Grand Total
    Posted: 06 May 2009 at 11:28pm
Hi All
 
I am in need to create a report for billing.
 
I have generated a sql query according through the date selected.
 
only two fields Item and Amount
 
Its working fine and no problem.
 
I need
 
At the report footer I need to display the Grant Total of the field Amount
 
I dont know how to do it. Can anybody tell me the steps for how to do it.
 
Advance Thank you.
 
Smile
Regards
-Anto
IP IP Logged
Mailman
Newbie
Newbie
Avatar

Joined: 21 Apr 2008
Location: United Kingdom
Online Status: Offline
Posts: 12
Quote Mailman Replybullet Posted: 07 May 2009 at 2:58am
Hi in field explorer create a new running total called grand ammount .In field to summarise place in ammount .
 
Evaluate for each record.
 
Reset Never .
 
This will then produce a running total for the field ammount.
 
Place in group or report footer.
 
Hope this helps.
IP IP Logged
Anto
Newbie
Newbie
Avatar

Joined: 06 May 2009
Location: India
Online Status: Offline
Posts: 2
Quote Anto Replybullet Posted: 08 May 2009 at 12:13am
Hi Mailman
 
Thank you very much for your valuable reply.
 
 
Regards
-Anto
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.