anilsharma
asked on
How to force page break based on some condition.
I have data like
sno descrip amount page_skip
--------------------------
1 aaaaaaa 4000 n
2 bbbbbbbb 30 N
3 c 10 N
4 d 40 Y
5 f 50 B
6 dddddu 100 C
I want to give a page break when Page_Skip='Y'
sno descrip amount page_skip
--------------------------
1 aaaaaaa 4000 n
2 bbbbbbbb 30 N
3 c 10 N
4 d 40 Y
5 f 50 B
6 dddddu 100 C
I want to give a page break when Page_Skip='Y'
ASKER
Good solution.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
1)Design your report layout.
2)Just below the "page_skip" column, create a small object (like a line) within the same repeating frame.
3)Set "page break before" property for this object
4)Create format trigger on this object like:
function B_1FormatTrigger return boolean is
begin
if :page_skip = 'Y' Then
return (TRUE);
else
return false;
end if;
end;
You can set the color of the object to white to prevent it from being printed.
HTH
Ali