cancel
Showing results for 
Search instead for 
Did you mean: 

How to get the Previous record field value in Crystal Report?

former_member373051
Participant
0 Kudos

Hi friends,

                I have designed  crystal report ,in detail section Opening_pallet,IN,OUT and closing balance.

In this, the previous row closing balance will be the next day's opening balance. Please suggest me to get the Previous day Closing Balance which will

be in the Open balance field.

Thanks in advance...

Accepted Solutions (1)

Accepted Solutions (1)

abhilash_kumar
Active Contributor
0 Kudos

Hi Mani,

Use this code please:

If OnFirstRecord then

0 else

Previous ({closing balance})

-Abhilash

Answers (3)

Answers (3)

former_member373051
Participant
0 Kudos

Great.. It's working.

Thanks to all..

Regards,

Mani

former_member205840
Active Contributor
0 Kudos

Hi Manikandan,

Do you have any groups in your report on date or you want only detail section closing balance as your opening balance ?

If it is in detail then you can use :

Previous({ClosingBalance})

if it is in group :

previous({ClosingBalance},{GroupName})

Thanks,

Sastry

Former Member
0 Kudos

Hi Try this,

Previous(closing balance)