Oracle Transactional Business Intelligence

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

RTF template issue

31
Views
2
Comments

Summary

Need to remove the data of 1st page from RTF

Content

Hi All,

 

If we check the attached test.rtf and test.xml file we can see the 1st page don't have any line value and it is showing group total as zero I want to remove this data from output file. Could you please help me how to remove.

Comments

  • Arghyo Banerjee -Oracle
    Arghyo Banerjee -Oracle Rank 2 - Community Beginner

    Hi Rahul,

    Kindly use conditional statements (If) for the table which holds Country ,Group And Case Code  .

    The condition logic should be based on Total revenue Column  (Total revenue not equal to zero  or greater than zero)

    Thanks

  • Michael Remisiewicz
    Michael Remisiewicz Rank 1 - Community Starter

    Hi Arghyo.

    Would you have a sample syntax for a compound condition such as you reference below where you are checking a variable for more than one value? I have struggled to come up with a proper format for this condition and end up repeating the paragraph over and over for each value of the field where I want it to be included.

    Thanks.

    Mike