Oracle Analytics Cloud and Server

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

Conditional Printing of Text at Page Footer in RTF Template - BI Publisher

Accepted answer
2584
Views
3
Comments

Summary

Conditional Printing of Text at Page Footer in RTF Template - BI Publisher

Content

Hi,

  We have a requirement to print the Page Footer conditionally,

To be clear after the detail records we need to print a line(Static Text) at the bottom of page(only once ).

After this we need to print Terms and conditions.(Static text should not print  here).

Quick response is highly Appreciated.

-- Praveen P

Best Answer

  • Venkat Thota - BIP
    Venkat Thota - BIP Rank 7 - Analytics Coach
    Answer ✓

    Last Page Only Content

    Note: This feature is supported for PDF and PPT output only.

    BI Publisher supports the Microsoft Word functionality to specify a different page layout for the first page, odd pages, and even pages. To implement these options, simply select Page Setup from the File menu, then select the Layout tab. BI Publisher will recognize the settings you make in this dialog.

    However, Microsoft Word does not provide settings for a different last page only. This is useful for documents such as checks, invoices, or purchase orders on which you may want the content such as the check or the summary in a specific place only on the last page.

    BI Publisher provides this ability. To utilize this feature, you must:

    1. Create a section break in your template to ensure the content of the final page is separated from the rest of the report.
    2. Insert the following syntax on the final page:<?start@last-page:body?><?end body?>

    style="color:rgb(0, 0, 0);font-family:Arial, Helvetica, sans-serif;font-size:small"

    • The grayed report fields are placeholders for the XML elements.
    • The "Last Page Placeholder" field contains the syntax:<?start@last-page:body?> <?end body?>to declare the last page layout. Any content above or below this statement will appear on the last page only. The content above the statement is regarded as the header and the content below the statement is regarded as the footer.

    If your reports contains headers and footers that you want to carry over onto the last page, you must reinsert them on the last page. For more information about headers and footers see Defining Headers and Footers.

    You must insert a section break (type: next page) into the document to specify the last page layout. This example is available in the samples folder of the Oracle BI Publisher Template Builder for Word installation.

    Because the default behavior of a new section in a document is to reset the page numbering the page number on the last page will be reset. To continue the page numbering from the previous section use the following command:

    <?initial-page-number:'auto'?>

    This command will allow the continuation of the page numbering from the previous section.

    It is important to note that if the report is only one page in length, the first page layout will be used. If your report requires that a single page report should default to the last page layout (such as in a check printing implementation) then you can use the following alternate syntax for the "Last Page Placeholder" on the last page:

    <?start@last-page-first:body?> <?end body?>

    Substituting this syntax will result in the last page layout for reports that are only one page

    Link https://docs.oracle.com/cd/E21764_01/bi.1111/e13881/T421739T481157.htm

Answers

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 Rank 7 - Analytics Coach

    Could you please clear me on below points?

    1. You want to print footer only after detail records end. Means if report is printing in 3 pages then first two pages should not show any footer and in third page you want to show footer?

    2. In the same step-1 example you want to print different footer for first two pages and for third page you want different footer?

    what is your requirement 1 or 2?

  • user9128308
    user9128308 Rank 1 - Community Starter

    1. You want to print footer only after detail records end. Means if report is printing in 3 pages then first two pages should not show any footer and in third page you want to show footer?

    This one