| how when new group when start new page [message #181865] |
Wed, 12 July 2006 00:18 |
mfa786
Messages: 210
Registered: February 2006
Location: karachi
|
Senior Member |
|
|
hi master
sir i have group report
my need is when new group start then start new page
is use this code for balance
cs_1 this is summrise colunm and count then record no
is new group then is statr from 1
if :cs_1 =1 then
:cp_1 :=0;
if nvl(:drbal,0)>0 and nvl(:debit,0)>0 then
:cp_1 :=nvl(:drbal,0) + nvl(:debit,0);
end if;
else
if nvl(:cp_1,0)<0 and nvl(:credit,0)>0 then
:cp_1 :=(nvl(:cp_1,0) - nvl(:credit,0));
end if;
end if;
return :cp_1;
end;
this my code check group status if new group start then start new balance
same is i need new page when i start new group
please give me idea
thank
aamir
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
