Problem while modifying Total No of Pages in RTF Template — Oracle Analytics

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

Problem while modifying Total No of Pages in RTF Template

Received Response
406
Views
9
Comments
Saheli Biswas
Saheli Biswas Rank 3 - Community Apprentice
in Oracle Analytics Cloud and Server

Summary

Problem while modifying Total No of Pages in RTF Template

Content

Hello,

I am using Page 1 of 1 syntax for Displaying Page No in RTF template. I am using section break "<?for-each-group@section:G_ORDERS[./CS_1!=0];./ORDER_NUMBER?>" for resetting page number for each section. This is working fine. But, the problem is that I have 3 "Terms and Condition" pages in my RTF template making it total of 4 pages. Although the "Terms and Condition" pages starts after " <?end for-each-group?>", in the report output, it is calculating the Number of pages including the 3 "Terms and Condition" pages. So, if the section completes within 1 page, it is still displaying "Page 1 of 4" as the page number instead of "Page 1 of 1", if the section contains 2 pages, it is displaying "Page 1 of 5"/"Page 2 of 5" as the page number instead of "Page 1 of 2"/"Page 2 of 2". I have tried to modify the page number with  {={NUMPAGES}-3}, but it is not working.

Can you please help me to sort this out.

Thanks

Saheli

Message was edited by: 3359851 RTF attached.

Answers

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

    could you please upload the rtf and sample xml

  • Saheli Biswas
    Saheli Biswas Rank 3 - Community Apprentice

    RTF uploaded. Please check.

  • Youssef_B_82
    Youssef_B_82 Rank 5 - Community Champion

    Hi Saheli,

    Have you tried using MS Word native pagination options?

    Try setting your headers and footer option to "Different First Page"

    and then add "Page Number" on the first and second page.

    Once it's done, right click on the page number of the second page (where your terms and conditions starts) and choose "Format Page Number"

    Select the "Start at:" radio button and set it to 1

    Hope this is helpful.

    Regards,

    Youssef

  • Saheli Biswas
    Saheli Biswas Rank 3 - Community Apprentice

    Sample XML also Uploaded..

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

    Sorry I missed one step

    After first page please insert "Page Layout > Breaks > Next Page " and then the first Page in the terms and condition add <?initial-page-number:1?> as shown below

    imageimage

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

    Hi,

    If I understand correctly, you don't want to consider you last three page(Terms and condition) as a part of page numbering.

    Please add below code at the beaning of terms and condition page. This will reset your page number and these three page will not be part of your actual report output

    <?initial-page-number:1?>

  • Venkat Thota - BIP
    Venkat Thota - BIP Rank 7 - Analytics Coach

    Try

    place immediate after end of @section group

    1) <?if:position()=last()?>   paste 3 pages you want to display <?end if?>

    2) <?start@last-page:body?>

    <?end body?>

    Thanks

  • Saheli Biswas
    Saheli Biswas Rank 3 - Community Apprentice

    Thanks Brajesh, your solution is working. In my RTF, section break was already there, so just typing

    in first page of "Terms and Conditions" is working for me. Thanks a lot. Saheli

  • Saheli Biswas
    Saheli Biswas Rank 3 - Community Apprentice

    Hi Youssef, thanks. I tried your solution. But. somehow it was not working. Thanks Saheli