Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: How to assign initial value to a running total Post Reply Post New Topic
Author Message
cross
Newbie
Newbie


Joined: 03 Apr 2007
Online Status: Offline
Posts: 12
Quote cross Replybullet Topic: How to assign initial value to a running total
    Posted: 11 Apr 2007 at 3:24am
Hi All!

I'm designing a report to generate a bank statement.  Two of the columns are debit and credit and the third column is a running total.  I used the built in running total generator in CR to do this.
My problem is that i need to assign an initial value to the running total.  This initial value is  the balance of the account as of the end of month.  Basically, the running balance starts from this.  How can I modify the running total so that It would use that amount as the initial value?

Thanks!
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 11 Apr 2007 at 3:36pm
You can't.  However, you can use the running total in a formula to calculate it when you need it.  For example:
 
{table.beginning_balance} + {#Running_total}
 
You then put this formula on the report instead of the running total.
 
-Dell
IP IP Logged
cross
Newbie
Newbie


Joined: 03 Apr 2007
Online Status: Offline
Posts: 12
Quote cross Replybullet Posted: 11 Apr 2007 at 5:52pm
Hi Dell,

Thanks for the tip, that's exactly what I needed to do.
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 11 Apr 2007 at 10:55pm
Damn, that's a good technique. I didn't know how to answer this question.  
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
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.