Repeat row headers after Page Break

The lead developer of the FO engine send me by chance an email about a REALLY nice feature I did not know about.

Did you ever encounter a long table with merged cells, where the merged cell went on to the next page? While column headers are by default repeated on the next page, row headers are not.

Tables with group-left column and pivot tables are prime examples where this problem occurs.

I have seen reports where merged cells could go over multiple pages and you would need to back to find the row header on previous pages.

The BI Publisher RTF templates have a special tag you can added to a merged cell to repeat the contents after each page break. You just need to add the following (wordy) tag to the next merged table cell:

<xsl:attribute name="xdofo:rowspancell-repeat-nextpage" xdofo:ctx="block">true</xsl:attribute>

Example:
2nd page of report before adding the tag

Before.gif

2nd page of report after adding the tag.

After.gif

Thought you might want to know.

Klaus

Comments:

Gostaria que me envia-se os arquivos de xml, pdf, rtf, utilizados neste exemplo. Obrigado.

Posted by Carlos Rafael on April 28, 2010 at 11:00 PM MDT #

Hello, I add this tag to the template. But It did not work. Please show me the detail where u add this tag in the template. Thanks in advance

Posted by Moon on April 29, 2010 at 11:59 PM MDT #

Hello, when I add the code true in to text form field. It raised the erorr following: ConfFile: C:\Program Files\Oracle\BI Publisher\BI Publisher Desktop\Template Builder for Word\config\xdoconfig.xml Font Dir: C:\Program Files\Oracle\BI Publisher\BI Publisher Desktop\Template Builder for Word\fonts Run XDO Start Template: C:\Documents and Settings\Moonlight\Desktop\temp_work\GL049_HAN.rtf RTFProcessor setLocale: en-us FOProcessor setData: C:\Documents and Settings\Moonlight\Local Settings\Application Data\Oracle\BIPublisher\TemplateBuilderforWord\tmp\1\download_data.xml FOProcessor setLocale: en-us java.lang.OutOfMemoryError: Java heap space Please help me, Thank u so much,

Posted by Moon on April 30, 2010 at 06:37 PM MDT #

Hi Tim, I have prepared a purchase order report in xml. my problem is in footer, requirement is that footer should print only in last page (Name and Signature). To achieve this i used . every thing works fine if i have 5 to 6 lines in a po. but if i have 12 lines that fill the whole page my footer is printing in second page without any data. if i can at least print the 12th line in next page, i will solve my issue. is it possible to send you my xml and rtf to have a look?

Posted by Nathan on May 02, 2010 at 08:47 PM MDT #

There was a slight error in the code above. Some an extra " " slipped into the line of code after the "true". When I cut and paste back from the blog it did not work. I corrected the line in the article and hope that it works for you now. The feature is available in 5.6.3, 10g and 11g. However only the 11g template builder created merged table cell in the grouping for tables. The 10.1.3.4 pivot table should also use merged cells. Of course you can merge cell with manually written code in any version. In my example the 11g table wizard generates in the first cell the form fields: G V IFPeriods.YearRS With the content: <?for-each-group:ROW;./Periods.Year?><?sort:current-group()/Periods.Year;'ascending';data-type='text'?> <?variable@incontext:g3pos;position()?> <?variable@incontext:g3;current-group()?> <if@cell:$g1pos=1 and $g2pos=1 and position()=1 ?><?end if?> <?Periods.Year?> <xsl:attribute name="number-rows-spanned" xdofo:ctx="block"> <xsl:value-of select="count($g3) "/> Posted by klaus.fabian on May 03, 2010 at 09:12 AM MDT #

Could you please provide XML, RTF files so that it would be much clear and easy to implement. I am unable to repeat a row for each pagebreak.

Posted by Swathi on June 01, 2010 at 11:41 PM MDT #

Where can one find a list of possible values for the name attribute of ? Thanks

Posted by RD on June 07, 2010 at 03:03 AM MDT #

To correct my previous post: the name attribute of

Posted by RD on June 07, 2010 at 03:57 AM MDT #

it seems no one successful , so it's better to provide rtf template.

Posted by Poster on July 06, 2010 at 05:21 PM MDT #

Could you please provide us the sample RTF that uses this code

Posted by swarnalatha on August 30, 2010 at 09:11 PM MDT #

Is there any chance of having pivoting feature in oracle BI publisher,

We have a report requirement of similar to pivoting feature in excel,

Any help appreciated

Posted by guest on August 25, 2011 at 12:11 AM MDT #

Hello Every 1,

Has this been resolved? any sample template? I have a requirement to do the same. When i write the above code, it does not work,.

any help on this will be appreciated.

Regards,

Posted by guest on October 17, 2011 at 06:11 AM MDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Follow bipublisher on Twitter Find Us on Facebook BI Publisher Youtube ChannelDiscussion Forum

Join our BI Publisher community to get the most and keep updated with the latest news, How-to, Solutions! Share your feedback and let us hear your voice @bipublisher on Twitter, on our official Facebook page, and Youtube!

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today