runing total when group change add master column i

To discuss Oracle Forms & Reports related technical issues.
Post Reply
mfa786
Posts: 51
Joined: Thu Jun 01, 2006 4:37 am
Location: Pakistan

runing total when group change add master column i

Post 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
imranhad
Posts: 56
Joined: Thu Apr 06, 2006 6:57 am
Location: Pakistan

Post by imranhad »

can u tell ur required output
Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests