Oracle Analytics Cloud and Server

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

Issue in printing Total on Last Page and 'Continued' on rest of the pages

Received Response
72
Views
5
Comments

Summary

Issue in printing Total on Last Page and 'Continued' on rest of the pages

Content

Hi Experts,

I have a requirement where I need to print 'Continued' on every page except Last Page. At Last page, I need to print the total. For that, I used below commands but not able to find any luck:

1. Before Calculation table I initialized page total by using '<?init-page-total:contd_footer?>' command.

2. After that I calculated the sum by using '<?add-page-total:contd_footer;'LINE_AMOUNT'?>' command.

3. After the Loop of Calculation table, I used '<xdofo:inline-total display-condition="exceptlast" name="contd_footer">Continued ...</xdofo:inline-total>' command to get the required result.

4. At last I have ended page total with '<?end-page-total:contd_footer?>' command.

Kindly provide your expert comments on the same to resolve this issue.

Regards

Subal

'

Answers

  • Subal Arora-91138
    Subal Arora-91138 Rank 3 - Community Apprentice

    Hi Experts,

    Any Suggestion on above issue.

    Regards

    Subal

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

    Could you please upload you rtf and XML file

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

    If you are printing one invoice at a time you can use last page content feature of BI Publisher

  • Subal Arora-91138
    Subal Arora-91138 Rank 3 - Community Apprentice

    Hi Brajesh,

    Please find attached XML and RTF template in Original Post..

    Regards

    Subal

  • Subal Arora-91138
    Subal Arora-91138 Rank 3 - Community Apprentice

    Hi Brajesh,

    I am doing these changes in PO Output for Communication Report as per Business requirement where separate XMLs are generated for every PO. What I believe you are saying to use below feature but I am not sure how will I use it in conditional statements as I have to write "Continue" in rest of the pages:

    <?start@last-page-first:body?> <?end body?>

    Regards

    Subal