Page 1 of 1

runing total when group change add master column i

Posted: Wed Jun 14, 2006 6:40 am
by mfa786
hi master

how runing total when group change add master column in detail runing total

Sir I have

I have master detail table
I master I have column

Accid
Opdr
Opcr

Detail table column
accid
Debit
Credit

Sir I create report in report I need accumulative total or running total
Then I use one summary column in detail section and my result right but
I need add the opdr or opcr from master table in summary column when group change
Then add opdr in summary column and display this addition only in first row of group changing

Such as we use in formula column and placeholder column

If group= change then
:placeholdercolumn := :debit+:opdr
Else
:placeholdercolumn := :placeholdercolumn +:debit
End if;
Return :placeholdercolumn;

My question is how I know when group change
If I get when group change then I add master opdr in detail dr column

Pleas give me idea how I add master column in detail running column when group change

Thank

aamir

Posted: Wed Jun 14, 2006 10:32 am
by imranhad
can u tell ur required output