Oracle Transactional Business Intelligence

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

Decimals not appearing on excel export when run through agent

31
Views
2
Comments

Summary

Decimals not appearing on excel export when run through agent

Content

I have some reports that I have created a scheduling agent to automatically run and email to some colleagues.  When these reports are run through BI Publisher and exported to excel manually, the decimals are shown.  When the agent runs the report the decimals are cut off.  Is there special formatting that I need to put in when letting the scheduling agent run the report that will export the decimals to excel?

Thanks,
Ruthie

Comments

  • Nirmal-64675
    Nirmal-64675 Rank 2 - Community Beginner

    Hi Ruth,

    Your BIPublisher report is build using RTF or XPT layout?

    Thanks

    Nirmal

  • Ruthie
    Ruthie Rank 3 - Community Apprentice

    Found my answer, I had to change the data format on my currency field to use a custom format.

    Thanks,

    Ruthie