Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    Mohammad Alhindawi
    Limit number of lines per page
    Topic posted March 24, 2019 by Mohammad AlhindawiRed Ribbon: 250+ Points, tagged BI Publisher, Fusion Financial reporting, Fusion Procurement reporting, Fusion Project reporting, Fusion Supply Chain Management reporting, OBI Answers, OBIEE Answers, OTBI, Public Sector, Reports, Sample Reports, Tip 
    98 Views, 2 Comments
    Title:
    Limit number of lines per page
    Summary:
    I have an invoice where I want to limit the number of lines that appears per page
    Content:

    Is there an IF statement that could limit the number of lines that appear per page?

    Version:
    Oracle Fusion

    Comment

     

    • Pasupathi Reddy

      Hi,

      Use below code in your invoice lines restriction.For example  If you want to restrict per page 10 lines then give mod 11 .

      <?if: position() mod 11= 0?>
      <?split-by-page-break:?>
      <?end if?>

      If its not work let me know feel free to reach out to me my contact number 91-9916246397

       

      Thanks

      Pasupathi

    • Amar

      https://myoracleappsworld.wordpress.com/2014/06/19/limiting-lines-per-page-and-fixed-length-table-in-xmlbi-publisher-reports/