nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

PS Multilingual BI publisher template Page break is not working

Hariramakrishnan Arumugam

Summary

PS Multilingual BI publisher template Page break is not working

Content

Dear All,

Am going through something weird on the multi lingual BI publisher report. Am generating XML through PeopleCode. Since my PS is not multi-lingual enabled, am handling those languages in template. Given below is the skeleton of my Template design. I have all languages texts in single RTF in the following order ENG,JPN,SPN and POR.

Repeat For Each Employee data tag group by emplid

if Data exists = Y

if Language=Eng

Print English content

End-If

if Language=JPN

Print Japanese content

End-If

if Language=Spanish - SPN

Print Spanish content

End-If

if Language=Portuguese - POR

Print Portuguese content

End-If

End-if

PageBreak

End-For

XML Structure

<Root>

<Emp_Data>

<Merit>

</Merit>

<Bonus>

</Bonus>

<Data-Exists>

<Data-Exist>Y</Data-Exist>

</Data-Exists>

</Emp_Data>

</Root>

This design is perfectly working in terms of printing respective language based on the XML data. Issue am facing is whenever Japan employees data printed it is not giving page break.

I have pushed JAPAN text at the end of RTF and tested. So template had languages in following order ENG,SPN,POR and JPN. At this time Japan worked perfectly but SPANISH started having page break issue. So looks like the language that comes at second position end up having page break issue.

Any idea/guidance how to approach such issue will be greatly helpful and appreciated.

Thanks,

Hari.A

Message was edited by: 3375847

Find more posts tagged with

Accepted answers

All comments

Brajesh Shukla-95078

could u plz upload sample rtf and xml

Brajesh Shukla-95078

is this for-each or for-each@section....please make sure its for-each@section

Brajesh Shukla-95078

I have handle the same thing in rtf and faced some weird behavior sometime. Once I open the header loop before if condition that solve my problem

so my structure was

<?for-each@section:G_HEADER?>

<?if: country = 'US'?>

--US HEADER--

<?start:body?>

<for-each:G_LINE> --Line Table--<?end for-each?>

<?end body?>

--US FOOTER--

<?end if?>

<?if: country = 'JP'?>

--JP HEADER--

<?start:body?>

<for-each:G_LINE> --Line Table--<?end for-each?>

<?end body?>

--JP FOOTER--

<?end if?>

<?if: country = 'IN'?>

--IN HEADER--

<?start:body?>

<for-each:G_LINE> --Line Table--<?end for-each?>

<?end body?>

--IN FOOTER--

<?end if?>

etc.

<?end for-each?>

Venkat Thota - BIP

Please upload docs ?

Hariramakrishnan Arumugam

To be exact I am having this in my RTF as parent loop before all if conditions

<xsl:for-each-group select=".//APS/EMP_DET" group-adjacent="EMPLID">

Hariramakrishnan Arumugam

Many Thanks for the response.

I already have my RTF structure as you have mentioned. For loop is there before those if conditions.

Hariramakrishnan Arumugam

Hi All,

Further in my research, I have replaced the page break (split by page page break) with <xsl:attribute name="break-before">page</xsl:attribute>.

After this change, page break is happening perfectly. But it prints a blank page at the end of report.

Now we need to remove this extra blank (only one) page.

Thanks,

Hari.A

Venkat Thota - BIP

So you have created parameter to filter each language data ?

why don't you try next page section break in ms word (not bi publisher functionality) at the end of each if condition.

This will start new page for each language data. for this ,place your cursor where you want to start section break ,Go to page Layout tab then Breaks then next page , Thanks

Repeat For Each Employee data tag group by emplid

if Data exists = Y

if Language=Eng

Print English content

End-If

ms word next section break

if Language=JPN

Print Japanese content

End-If

ms word next section break

if Language=Spanish - SPN

Print Spanish content

End-If

ms word next section break

if Language=Portuguese - POR

Print Portuguese content

End-If

ms word next section break

End-if

PageBreak

End-For

Hariramakrishnan Arumugam

Thanks for the response. I have tried the same. But no luck. Am not getting all the employees data in PDF. Also getting many blank pages.

Yes. XML has the language tag filter data.

Hariramakrishnan Arumugam

So for did anybody implemented multi lingual template (handling multi-lingual through template design)?

Anybody else faced issues like me? Do we have any limitations in BI publisher?