how when new group when start new page

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

how when new group when start new page

Post by mfa786 »

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
Kashif
Posts: 137
Joined: Wed Apr 26, 2006 5:57 am
Location: Pakistan
Contact:

Post by Kashif »

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
Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests