Hello everybody.
I need to print a frame containing three fields at the end of each report page.
The report has a product break, problem I am having is that when a product has more than one page, it does not print the frame on all of the product, only in the last.
Does anyone know how to force the frame printing on each report page? NOTE: The frame can not be on the margin of the more section and yes in the body, because I make a control in it
att.
Print frame at the end of each report patch
-
- Rank: Oracle Guru
- Posts: 448
- Joined: Tue, 16 Jun 2009 3:07 pm
- Location: Parobé - RS
Sérgio Luiz Bonemberger Junior
Programador Junior
Parobé RS
[]s
Programador Junior
Parobé RS
[]s
Try to set the Print Object On property for All Pages.
-
- Rank: Programador Sênior
- Posts: 54
- Joined: Thu, 18 Sep 2008 10:22 pm
- Location: São Paulo - SP
Moloukos Rox
Did not work.
The Repeating Frame that is above him, when the product has more than one page, pushes the frame for the last page, not printing on the other previous ones.
How are the levels of frames and repeats in the report:
- Frame Group
- Repeating Frame (with the product data)
- Frame (with the message and fields to be printed at the end of each report page).
The Repeating Frame that is above him, when the product has more than one page, pushes the frame for the last page, not printing on the other previous ones.
How are the levels of frames and repeats in the report:
- Frame Group
- Repeating Frame (with the product data)
- Frame (with the message and fields to be printed at the end of each report page).
-
- Rank: Oracle Guru
- Posts: 448
- Joined: Tue, 16 Jun 2009 3:07 pm
- Location: Parobé - RS
Sérgio Luiz Bonemberger Junior
Programador Junior
Parobé RS
[]s
Programador Junior
Parobé RS
[]s
Do so, put a frame around your repeating frame and the vertical elasticty property for fixed and stops a size that for you to put another frame below with the lines you have to repeat throughout this page this will also Vertical property Elasticy Fixed.
Fished ??
Any doubts put AEW.
Fished ??
Any doubts put AEW.
-
- Rank: Programador Sênior
- Posts: 54
- Joined: Thu, 18 Sep 2008 10:22 pm
- Location: São Paulo - SP
Moloukos Rox
beleza Sergio, it worked!
- Frame Group - Vertical Elasticy Fixed
- Repeating Frame (within the Frame Group)
- Frame222 (inside the Frame Group with vertical elasticy fixed).
Only I have another problem, when I manage the report it first prints this Frame222 . However, this frame will only appear depending on values ??from a formula that is in Query and is done a treatment in the Format Trigger of the frame222 , True or False.
How to do this?
Make this frame print for last and Formula first?
- Frame Group - Vertical Elasticy Fixed
- Repeating Frame (within the Frame Group)
- Frame222 (inside the Frame Group with vertical elasticy fixed).
Only I have another problem, when I manage the report it first prints this Frame222 . However, this frame will only appear depending on values ??from a formula that is in Query and is done a treatment in the Format Trigger of the frame222 , True or False.
How to do this?
Make this frame print for last and Formula first?
-
- Rank: Oracle Guru
- Posts: 448
- Joined: Tue, 16 Jun 2009 3:07 pm
- Location: Parobé - RS
Sérgio Luiz Bonemberger Junior
Programador Junior
Parobé RS
[]s
Programador Junior
Parobé RS
[]s
So, dude.
You're on the right track.
in the format trigger of the frame thou test
in this case if the formula returns x then it will turn the Frame.
As for the order that will appear in the layout, it places it under your frame that has the Repeating Group and hit their order in the Object Navigator.
You're on the right track.
in the format trigger of the frame thou test
in this case if the formula returns x then it will turn the Frame.
As for the order that will appear in the layout, it places it under your frame that has the Repeating Group and hit their order in the Object Navigator.
-
- Rank: Programador Sênior
- Posts: 54
- Joined: Thu, 18 Sep 2008 10:22 pm
- Location: São Paulo - SP
Moloukos Rox
beleza, I already have the code in the format trigger of the frame, bringing the value of the formula and returning true or false;
What happens is that the frame printing is coming before the formula is performed. I put a message inside the frame and the formula to see which was shot before.
Ai The value of the formula comes null for the frame and sticks all my control of True or False.
I need the formula to be performed before the frame printing, pos ai when printing the frame the formula will pass the right amount to make the comparison !!!
to do this? Control this?
What happens is that the frame printing is coming before the formula is performed. I put a message inside the frame and the formula to see which was shot before.
Ai The value of the formula comes null for the frame and sticks all my control of True or False.
I need the formula to be performed before the frame printing, pos ai when printing the frame the formula will pass the right amount to make the comparison !!!
to do this? Control this?
-
- Rank: Oracle Guru
- Posts: 448
- Joined: Tue, 16 Jun 2009 3:07 pm
- Location: Parobé - RS
Sérgio Luiz Bonemberger Junior
Programador Junior
Parobé RS
[]s
Programador Junior
Parobé RS
[]s
Face tries to order right in Object Navigator.
If it does not work Dae uses your imagination for this.
I know it, creates a field that receives null in the Trigger Before Report, and your formula will populate it.
and in format trigger you test if the field is then return (false).
You know Dae, but that's right you have to "dribble".
But I do not know what is happening, I never had problems with this, I already hid some frames according to the results of a field, or a formula.
If it does not work Dae uses your imagination for this.
I know it, creates a field that receives null in the Trigger Before Report, and your formula will populate it.
and in format trigger you test if the field is then return (false).
You know Dae, but that's right you have to "dribble".
But I do not know what is happening, I never had problems with this, I already hid some frames according to the results of a field, or a formula.
- dr_gori
- Moderador
- Posts: 5024
- Joined: Mon, 03 May 2004 3:08 pm
- Location: Portland, OR USA
- Contact:
Thomas F. G
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
From what I remember, it has a function key to climb or descend level.
has to look on the menu. Something type F3 or F4.
(or F6, F7) ... I do not remember exactly which.
I used to leave open the Object Navigator to see my item rising or descending.
(to see if it was going to the right place)
has to look on the menu. Something type F3 or F4.
(or F6, F7) ... I do not remember exactly which.
I used to leave open the Object Navigator to see my item rising or descending.
(to see if it was going to the right place)
-
- Information
-
Who is online
Users browsing this forum: No registered users and 10 guests