Adding value in 1st record only

i am preparing a stock statement report, where i show opening balance of the material (on 01/04/2014 FY year) .

when the report starts depending upon the transaction of the 1st record the opening balance should be added. Actually its 20th today so already the 1st record is know to me its a purchase so what i want to do is to add the opening balance to this purchase. From the next record its should start working accordingly. I am using Formula field to calculate daily stock like credit debit entries are made.

if u see the images the right most column is the daily stock of the material. I want to add the opening balance(10) to only 1st record. Ho i should achieve using Crystal Report. i am suing formula to calculate the right most column value which is as below

if ({stockledger.transactionType}='DM')
then

numberVar tSum := tSum - {stockledger.qty}

else

numberVar tSum := tSum + {stockledger.qty}

but how i should add the opening balance to only 1st record and it should get added to right most column of daily stock...

its a live project and i m horrible stuck up plz guide me thanks in advance...

Global NumberVar openingbalance; openingbalance := 10 (Or you can set this from a db field)

Then add this formuala field to report header, and set suppress to hide it.

Then change your posted formula to add this too like below.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Nilanka Dharmadasa12y ago
Hi Kedar,

What you are trying to do is not very clear for me. But I guess this is what you need.

First add another formula and define a global variable in it and set the opening balance to it.
```
Global NumberVar openingbalance;   openingbalance := 10 (Or you can set this from a db field)


Then add this formuala field to report header, and set suppress to hide it.

Then change your posted formula to add this too like below.
```
if ({stockledger.transactionType}='DM')
then

numberVar tSum := tSum + openingbalance - {stockledger.qty}

else

numberVar tSum := tSum + openingbalance + {stockledger.qty}