Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Formula calculates in next row instead of initial row

Status
Not open for further replies.

lthomas6

MIS
Aug 22, 2007
87
US
I have a report which has several columns. The first column has a subreport to calculate reserve. The second column has a subreport to calculate cost. There is a third column in the report that calculates the value. So it has a formula which = reserves - costs.

The issue I am seeing is that the formula calculates the information correctly, but for some reason it starts with a zero and then the correct calculation starts on the next row. Would you know why it is doing this?

the formula is set to:
whileprintingrecords;
{@Reserv_total} - {@cost_total}

@cost_total = shared NumberVar cost_tot
@reserv_total = shared NumberVar reserve_tot

This is Crystal 10 with SQL database.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top