how to do this financial statement in stimulsoft

[SayedOthman]

hello every body ,
how i can do same the the attached file with stimulsoft report specially calculating the balance column ,

Untitled.png (6.83 KiB) Viewed 1539 times

before i was do it with microsoft excel and crystal report ,now how we can do with stimulsoft .

thank you

[Alex K.]

Hello,

Can you please send us a test data for analysis.

Thank you.

[SayedOthman]

i have data table has columns same the attached picture without balance column
i want to add balance column in report and apply this equation
Current balance = (previous balance + debit) - credit
on each row in my data table

thanks for response .

[Alex K.]

Hello,

As a way, you can use the additional variable and in BeforePrint event of Databand use the following code:
VariableBalance = VariableBalance + DataSource1.Debit - DataSource1.Credit

Thank you.