Oracle Analytics Cloud and Server

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

AR Invoice Print fixed table size

Received Response
31
Views
2
Comments

Summary

AR Invoice Print fixed table size

Content

Hi,

We have a requirement to print invoices and ensure the lines box stays the specific size and does not move onto the next page. We have defined 3 DFFs for the invoice description with a maximum of 150 characters each and should be printed in the invoice print if available. I used row fillers to restrict the maximum number of rows to be printed in a single page. But line descriptions spillovers to the next line if it's too long thus the bottom of the invoice is being pushed downwards or to the next page. Is there any workaround to ensure that the table size stays the specific size for this scenario?

Thanks.

Amery

Answers

  • Rajesh123
    Rajesh123 Rank 6 - Analytics Lead

    you create another variable if line has more than 150 characters

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

    Please adjusted space start body and end body in such a way that it will always print only 30(example) invoice per page.

    If invoice is more than 30 it will go to new page and less than 30 it will insert blank line for remaining lines using code written in below tag.

    <?for-each:xdoxslt:foreach_number($_XDOCTX,1, 30-count(InvoiceNumber),1)?>.<?end for-each?>