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

Issue with AR Statement BI Publisher output

Received Response
51
Views
6
Comments
User_MNW2U
User_MNW2U Rank 3 - Community Apprentice
in Oracle Analytics Cloud and Server

Summary

Issue with AR Statement BI Publisher output

Content

Hello Gurus, one year back we moved from 11i to R12. In 11i AR statement report was customized in report builder. But post R12 this report has been moved to RDF and Output in PDF using XML publisher. There was a requirement to create report using multiple template. We are also using no of lines per page option, for this we have used code available on Metalink and google. Although we are using proven solution, still we are facing one issue for which we are not able to find any solution. We are excluding 0 amount invoices from the statement due to which logic which is being used to count number of lines, is not working correctly. On some pages 10-15 lines are getting printed and some pages on 2-3 lines are getting printed for one customers. since it is customer facing document, does look good if it prints on 3 lines on page one and 10 lines on next page for same customer.  As time lapsed this issue is becoming very critical for business, we are not able to find any solutions. Your help is this regard is very appreciated. I am attaching RTF, XML output and   PDF output for the same.

Thanks in advance.

Regards

Mayur Sarwate

Answers

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

    Hi ,

    We have similar requirement for check print. Where we need to print 30 Lines per page, if invoices are more than 30 lines then 31th line should print in second page.

    And also I can see based on number of records "Note: Beckman Coulter, Inc." and "TOTAL AMOUNT / MONTANT TOTAL CAD ::" is moving up down.

    Solution for this is

    use  Below Layout. You can see only Line table is there on the body. Adjust Header and footer space in a such a way that for body you left space for specific line e.g. 30 or 10 in your case.

    image

    <?start:body?>

    image

    <?end body?>

    image

  • User_MNW2U
    User_MNW2U Rank 3 - Community Apprentice

    Hi Brajesh, Thanks for update. Can you please save same format in RTF and attach here. it is not allowing me to download. One more question, current RTF I also added condition to exclude 0 amount transactions, in this case line number will get incremented but will not appear in the output. In this case whether number will remain same or not. Thanks & Regards Mayur

  • User_MNW2U
    User_MNW2U Rank 3 - Community Apprentice

    Hi Gurus I have added one condition to exclude 0 amount invoices to be appeared in the output. Once I removed this condition number of lines are coming correctly, but in this case, it shows 0 balance transactions as well. I do not want that 0 amount transactions should be appear in the output. How can we exclude 0 amount transaction. RTF file attached in the original post. Need solution asap. Please advice

  • User_MNW2U
    User_MNW2U Rank 3 - Community Apprentice

    Hi Brajesh, Please can you mail me on msarwate@gmail.com Thanks in advance. Regards Mayur

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

    How I can upload the file in this thread, I am not able to see any upload option?

  • Rajesh123
    Rajesh123 Rank 6 - Analytics Lead

    Hi ,

    if you get the solution can u pls share the rtf file?