Bi Publisher - Problem with table header repeat

Oracle Business Intelligence, Oracle Warehouse Builder OWB, Oracle Discoverer, BI Publisher, XML Publisher, OLAP, Data Mining, ODI Oracle Data Integrator, etc
Post Reply
thiago.pinheiro
Rank: Programador Júnior
Rank: Programador Júnior
Posts: 16
Joined: Mon, 23 Jun 2008 11:06 am
Location: Uberlândia - MG
======================
"Quando todos pensam o mesmo,
ninguém está pensando!"
======================

Hello,

I have the following problem:
I need the report to repeat the header of a table whenever there is a page break. When I do this running from the local machine, through the BI Publisher Desktop, it works perfectly. The problem occurs when I execute the EBS report. Hence the report does not repeat the table header at each page break.
The default report output is .rtf! Even if I run with the PDF output it works. The problem is only when the output is RTF and run from EBS.
Has anyone ever had this problem? How do I know the version of XDO / BI Publisher installed on the server? How do I know if there is more recent version or update patch? Can you help me?

Thanks!
senger
Rank: Estagiário Sênior
Rank: Estagiário Sênior
Posts: 9
Joined: Fri, 16 Apr 2010 5:19 pm
Location: SC

Use in the Word table setting to repeat, but does not work, the version of Word would be the problem?
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

Well, I'm with Word 2007 and it's working properly here.

I do this:
Right click on the table, properties, line, hence has a checkbox saying:
"Repeat as header line at the beginning From each page "

I'm using XML Publisher version 5.6.3.
(to see the version, you can open a PDF document generated by XML and clicks with the right - Property of the document)
suelana
Rank: Programador Sênior
Rank: Programador Sênior
Posts: 63
Joined: Thu, 10 Aug 2006 6:07 pm
Location: Joinville-SC
Suelana BLU-JLLE

My case is less simple.

I have a balance sheet accounts and, by jumping the page, I must repeat the parent accounts without the values; The following details are printed below parent accounts.

Select all

------------------------------------------------------------------------------------------------------------------------- 
DESCRIÇÃO                                                    SALDO                     DEB                   CREDITO 
------------------------------------------------------------------------------------------------------------------------- 
1000 ADMINISTRACAO XXXS                             108.500.800,00        5555,00            2222,00 
  1001 ADMINST UYYYY SSSSSSSSSS                  104.500.800,00        3555,00            1222,00         
    1002 BBBBBBBBBBBBBBBBB                              99.500.800,00        2555,00             222,00 
      1003 Seção BLLLIII                                        8.200.800,00        1555,00             122,00 
              60000002 Detalhe 1                               8.200.800,00        1555,00             122,00 
              60000002 Detalhe 2                               8.200.800,00        1555,00             122,00 
              60000002 Detalhe 3                               8.200.800,00        1555,00             122,00 
              60000002 Detalhe 4                               8.200.800,00        1555,00             122,00 
              60000002 Detalhe 5                               8.200.800,00        1555,00             122,00
When jumping the page should only be the parent description:

Select all

------------------------------------------------------------------------------------------------------------------------- 
DESCRIÇÃO                                                    SALDO                     DEB                   CREDITO 
------------------------------------------------------------------------------------------------------------------------- 
1000 ADMINISTRACAO XXXS                     
  1001 ADMINST UYYYY SSSSSSSSSS          
    1002 BBBBBBBBBBBBBBBBB                    
      1003 Seção BLLLIII                                  
              60000002 Detalhe 6                               8.200.800,00        1555,00             122,00 
              60000002 Detalhe 7                               8.200.800,00        1555,00             122,00 
              60000002 Detalhe 8                               8.200.800,00        1555,00             122,00 
              60000002 Detalhe 9                               8.200.800,00        1555,00             122,00
The method for repeat header in the table ( As explained here), it does not work because they are on the same line and not the whole line q is repeated, only the description.

How do I only make the first column be repeated and not the values?

* Note: (XDO Data Engine Version on: 5.6.3)
suelana
Rank: Programador Sênior
Rank: Programador Sênior
Posts: 63
Joined: Thu, 10 Aug 2006 6:07 pm
Location: Joinville-SC
Suelana BLU-JLLE

*** It was not able to show the correct layout ... aqui has no formatting feature ....

But it is with a balancement. Most must have worked with a book balance.
suelana
Rank: Programador Sênior
Rank: Programador Sênior
Posts: 63
Joined: Thu, 10 Aug 2006 6:07 pm
Location: Joinville-SC
Suelana BLU-JLLE

I found in Oracle Business Intelligence Publisher Core Components Guide a guidance: "Defining Columns to Repeat Across Pages" - Page 2-99.

Use the following syntax:

Select all

<?horizontal-break-table:number?>  
Where Number is the number of columns to repeat (from the left).

But it is not working.

Can anyone tell anything about it? Any tip?
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 9 guests