Summing between a range of dates 1

[Kivairu]

Iam trying to sum data between a range of parameters but the sum is coming to a zero.Please help

 

[Madawc]

Please post your formula.

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP

 

[Kivairu]

here's the formula

if@date<?todate and@date>?fromdate then sum GLAMOUNT

 

[CoSpringsGuy]

are you using your parameters anywhere else? Like in the record selection formula?

_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 

[lbass]

You should be creating a formula like this, to be placed in the detail section:

if {@date} < {?todate} and
{@date} > {?fromdate} then
{table.GLAMOUNT}

Then right click on this formula and insert a summary (sum) at a group and/or grand total level.

-LB

 

[Madawc]

Do you have some other use for records outside the date range? If not, it would be more efficient to put the range check in record selection.

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP

 

[Kivairu]

Now am able to sum in the date range.Iam wondering how I can make the closing balance of one period to be the opening balance of the next period.

 

[Madawc]

You should really start a new thread for a new topic. But if you created a running total with a formula based on dates, you could use it in several places, just so long as all of the relevant records have been printed.

The use of Crystal's automated totals is outlined at FAQ767-6524.

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP