Print frame at the end of each report patch

Dicas e truques sobre Oracle Reports Builder - modo gráfico ou modo caractere, ascii, arquivo .PRT, etc
Post Reply
Moloukos
Rank: Programador Sênior
Rank: Programador Sênior
Posts: 54
Joined: Thu, 18 Sep 2008 10:22 pm
Location: São Paulo - SP
Moloukos Rox

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.
SergioLBJr
Rank: Oracle Guru
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

Try to set the Print Object On property for All Pages.
Moloukos
Rank: Programador Sênior
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).
SergioLBJr
Rank: Oracle Guru
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

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.
Moloukos
Rank: Programador Sênior
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?
SergioLBJr
Rank: Oracle Guru
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

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.
Moloukos
Rank: Programador Sênior
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?
SergioLBJr
Rank: Oracle Guru
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

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.
fnoriko
Rank: Estagiário Sênior
Rank: Estagiário Sênior
Posts: 9
Joined: Mon, 26 Sep 2011 11:17 am
Location: SP

Sergiolbjr, doubt!
How do you organize items in Object Navigator?
Do you have any shortcut key for this?
I need to send a frames down, in the hierarchy ...

Thanks
User avatar
dr_gori
Moderador
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

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)
fnoriko
Rank: Estagiário Sênior
Rank: Estagiário Sênior
Posts: 9
Joined: Mon, 26 Sep 2011 11:17 am
Location: SP

Dude ... I tried all the f * ....
User avatar
dr_gori
Moderador
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

Here:
is

Select all

Control [ 
or

Select all

Control ]
reports.png
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 29 guests