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

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

Praveper

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

Find more posts tagged with

Accepted answers

Venkat Thota - BIP

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:

Create a section break in your template to ensure the content of the final page is separated from the rest of the report.
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

All comments

Venkat Thota - BIP

Last Page Only Content

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

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

Create a section break in your template to ensure the content of the final page is separated from the rest of the report.
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.

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

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

<?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

Brajesh Shukla-95078

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

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