ERPstuff - Oracle EBS Community

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

Dear Aamir,

First of All Most of the Time yours Question is not Clear and not understandable by me. I dont know about any other Group member that what they think about ur questions.
Please u must have to recheck ur Question before submiting.

i'm replying according to what i understand from ur Question.

1. Select the Repeating Group Frame in the Report LAYOUT.
2. Press F4 (for Property Page of Repeating Frame).
3. Find the Property Maximum Records Per Page.
4. Change its Value = 1 (default is 0).

Now Run the report again.
u will Find ur Desired Result.

if any Problem Contact again.



Best Regards.

Muhammad Kashif