Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

RTF TEMPLATES

Received Response
21
Views
3
Comments
Anagamkrishna
Anagamkrishna Rank 3 - Community Apprentice
in Oracle Analytics Forum

Summary

RTF TEMPLATES

Content

Hi All,

   I have wrote an procedure for po details for approved status and incomplete status and saved the xml file and need to design an single rtf template and output of pdf should be in 1st page approved Po's and 2nd page should be incomplete Po's and 3rd should repeat for Approved Po's and 4th page should be incomplete Po's. Please give me any suggestions

Answers

  • User910243567
    User910243567 Rank 6 - Analytics & AI Lead

    I guess it's doable, You need to fetch approved and incomplete PO's in two separate groups.Your RTF template will be 2 pages with 2 layouts, first page layout for approved Po's and second for incomplete.

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

    create an extra column in procedure which differentiate approved and incomplete po's and at template level we can filter approved po in 1st page and incomplete in 2nd page based on extra column by filtering at group level.

    Ex:

    1st page

    <?for-each-group:G_1;./[extra_column='approved value']?>    ---------extra column contains two values ,one is approved PO and 2nd is incomplete PO.

    <?for-each-group:G_1;./[extra_column='incomplete value']?>  .

    Thanks

  • Anagamkrishna
    Anagamkrishna Rank 3 - Community Apprentice

    Hi All,

    Hi All,

       I have wrote an procedure for po details for approved status and incomplete status and saved the xml file and need to design an single rtf template and output of pdf should be in 1st page approved Po's and 2nd page should be incomplete Po's and 3rd should repeat for Approved Po's and 4th page should be incomplete Po's. Please give me any suggestions.

    AS suggested I tried In all possiblie ways

              I guess it's doable, You need to fetch approved and incomplete PO's in two separate groups.Your RTF template will be 2 pages with 2 layouts, first page layout for approved Po's and second for incomplete.

    I tried ACCORDING TO above sceanrio but  the rtf template by creating different groups as first page for one group and another page for another group is not working so please give me some suggestions to do it.