Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

BI Publisher two pager RTF Template

Received Response
31
Views
2
Comments
Muhammad Jahanzaib
Muhammad Jahanzaib Rank 4 - Community Specialist
in Oracle Analytics Cloud and Server

Summary

BI Publisher two pager RTF Template

Content

Hi,

I am trying to create two pager RTF template (Job Appointment Letter), with data model having 1 field named Employee Name (having 5 records).

I want to print Employee Name on first page and a paragraph (Terms and Condition) on second page.

I tried it by adding Text field on First page and text on second page but when I run the report, 5 pages printed with 5 employee names and 1 page with Terms and Conditions.

Please help.

JB

Answers

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    Hi,

    Please attach XML and RTF, otherwise it is difficult to provide a solution.

    Edit: I'll give you a general idea/code.

    ----------------------------------------------------------------------------

    <?for-each-group:G_EMPLOYEE;./ EMP_NUM?>

    <?EMP_NUM?>

    <?EMP_NAME?>

    (Insert a MS word page break here)

    (Insert Terms and Conditions here)

    <?split-by-page-break:?>

    <?end for-each?>

    ----------------------------------------------------------------------------

    So basically you group by employee, and then add employee details then a MS word page break, then your text and finally splitting the page for each employee.

  • Muhammad Jahanzaib
    Muhammad Jahanzaib Rank 4 - Community Specialist

    Thanks a lot Sherry George; even your "general idea" helps. :-)