Oracle Analytics Publisher

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

Categories

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

How to manage empty last page when there is not enough space to print the footer

Received Response
13
Views
2
Comments
rthampi
rthampi Rank 1 - Community Starter
in Oracle Analytics Publisher

Hello guys

Currently we are developing RTF templates to use with Oracle EBS R12 12.2 instance, to address a government requirement to show Arabic labels on all documents given out to customers (Sales Order invoices, delivery notes…)

We've already achieved a major part of it, however having a minor issue when the current page doesn't have enough space to print the footer that has all the vital details like invoice totals, terms and conditions etc. This forces a new page, having only the footer printed in the last page. Is there way we could assess whether the current page has enough room for the footer, else, insert a page break manually so that last one or two rows of data prints on a new page along with the footer information?

Thanks in advance!

Answers

  • Rajasekhar Bandaru-Oracle
    Rajasekhar Bandaru-Oracle Rank 6 - Analytics Lead

    Hi

    Please review the given help center documentation link about RTF(Define Headers and Footers).

    https://docs.oracle.com/en/cloud/saas/otbi/otbi-pub-design/define-headers-and-footers.html#GUID-2822BE14-49B7-42E9-AA52-8284D5BD8E4E

  • rthampi
    rthampi Rank 1 - Community Starter

    Hi Rajasekhar

    The documentation doesn't satisfy my query. My requirement is bit complex. We are printing the sales invoices showing the descriptions for the items, and the descriptions are not of standard length and the sales department wants to show the entire description for the item on printed document.

    Here item A could have a short description like "BELT A Size 1" while item B could be "This items uses a long description with model number and other vital information". This makes the description cell to dynamically stretch vertically and there are few instances when the report engine is forced to insert a page break because after the last item, there is not enough room left for the footer to be printed. Please check the attached image(s).

    1.png

    First page is printing all the items that were invoiced, without having room for the footer. This happens only to few invoices, however, makes the customers bit of upset. Is it possible to know the available print region before hand and if it falls beyond couple of inches, to trigger a page break?