Page Break After

Dicas e truques sobre Oracle Reports Builder - modo gráfico ou modo caractere, ascii, arquivo .PRT, etc
Post Reply
PauloRobert
Rank: Estagiário Pleno
Rank: Estagiário Pleno
Posts: 6
Joined: Fri, 18 Jul 2008 8:26 am
Location: Valinhos - SP

Page Break After it does not work when I put "yes", only work when I put "YES" on the page Break Before, but it's getting the last blank page, that is, it prints only the header. I created a simple frame at the end of reping just to break the page conditionally. My reports is 3.0.5.8.0, thank you immensely if someone helps me.
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

Dude specifies your situation better.

The page Brake After will add a page break after a particular frame, the Before will add this break before.

As for its conditional QUBRA, what is the condition ??

Esplicates your strureness so we can help in your problem.
PauloRobert
Rank: Estagiário Pleno
Rank: Estagiário Pleno
Posts: 6
Joined: Fri, 18 Jul 2008 8:26 am
Location: Valinhos - SP

Hello Sergio, Thanks for the answer.

is the following, I developed a report where the user can choose to sort, if you choose by Cost Center (DC), then every time you change CC need to break the page. I created an empty simple form at the end of the Repeating CC and set it to break the page. This is the problem. Setting YES in Before works right, but is getting the last page always blank (there is always a lost sheet). When the Yes on the after, then simply do not break on page.
What I really want is to eliminate this last blank page, where it prints only header as the report was terminated on the previous page.
Thanks.
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

Dude in theory The Page Brake After should work.

Good tries to set it on the Repeating Frame of the DC, instead of creating a new Frama só for this control.
PauloRobert
Rank: Estagiário Pleno
Rank: Estagiário Pleno
Posts: 6
Joined: Fri, 18 Jul 2008 8:26 am
Location: Valinhos - SP
Paulo Robert Ferreira
Analista de Sistemas
"O Temor de Deus é o Princípio de toda Sabedoria"

Thank you Sergio Luiz, but if I set the Page Breaker of Repeating itself, I can not put the condition of breaking that the user will select on the screen.

Select all

 
function M_4FormatTrigger return boolean is 
begin 
  If :P_Quebra = 1 And (:P_Ordenacao = 3 Or :P_Ordenacao = 4) Then 
     return (TRUE); 
  Else 
     return (FALSE); 
  End If; 
end; 
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

Good ...

Make sure the break frame is actually within the CC's repeating frame (a look at the objects menu to confirm).

Anything:
How is the vertical property Elasticity of Repeating CC's Frame ??
PauloRobert
Rank: Estagiário Pleno
Rank: Estagiário Pleno
Posts: 6
Joined: Fri, 18 Jul 2008 8:26 am
Location: Valinhos - SP
Paulo Robert Ferreira
Analista de Sistemas
"O Temor de Deus é o Princípio de toda Sabedoria"

Sergio, good morning!

Making your questions:
The frame is within the Repeating CC
vertical elasticy = variable

Thank you for everything but I ended up resolving as follows:

I created an identical copy of the reports file with another name, thus being:
BHR50011.RDF "Maximum Records per page" = 0 (this is The non-crash option)
BHR50015.RDF property "Maximum Records per page" = 1 (This is the breaking option)
in the interface trigger was like this:

Select all

 
        If :Selecao.Quebra = 0 Then 
           Run_Report('BHR50011', 'Param'); 
        Else  
           Run_Report('BHR50015', 'Param'); 
        End If; 
The frame with set PAGE BREAKE was eliminated.

Resolved!

Embrace.
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 17 guests