runing total when group change add master column i
Posted: Wed Jun 14, 2006 6:40 am
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
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