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

RTF Lines Per Page - Different First and Others

Received Response
450
Views
2
Comments
Leon Barkley
Leon Barkley Rank 1 - Community Starter
in Oracle Analytics Cloud and Server

Summary

RTF Lines Per Page - Different First and Others

Content

Happy weekend, Community!

This is a new twist on an old favorite: I need to print a specific number of records per page to ensure that the layout is as expected. The catch is that I need fewer records on the first page, due to a block of information that is not worth repeating (though there are repeating headers and footers). I read up on how to do the basics and spent a day getting my head around it and doing initial testing. Now I am stuck with either a small number of records on the second page (though the first and 3rd pages look find) or a good deal of wasted space at the bottom of every page but the first.

The template is attached, and I can mask some customer data in sample XML if needed. Any help would be greatly appreciated!!

Answers

  • timdexter
    timdexter Rank 6 - Analytics Lead

    Hi Leon

    There is no simple way to specify the number of records on the first and then subsequent pages in any dialog..

    One solution would be to have a table on the first page that looped over a fixed number of records using the position() function to return the number of the row being processed and an XPATH expression to limit the rows|start the rows.

    for-each:ROW[position() < 21]

    Now create a second page of the template and define the table again.

    for-each:ROW[position > 20]

    That would get you 20 rows on the first page and the rest of the rows on page 2 onwards. You can of course change the 20 to something else

    Tim

  • Leon Barkley
    Leon Barkley Rank 1 - Community Starter

    Oh man, Dexter. Thanks!!

    Yours is a much less complex approach and does exactly what I need. Three things to polish it up as seen in the second attachment:

    1. Losing the page-break included in my original version caused my column headers to disappear after the second page (easily fixed - Never name it.: Repeat Table Header in all pages in BIP​).
    2. I also needed to make the entire second table conditionally display (again, normal BIP/Word stuff).
    3. I did *not* need to create the second table on the second page. It could live inline with the main body

    Take care,

    Leon