Decimals not appearing on excel export when run through agent

Ruthie

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

Nirmal-64675

Hi Ruth,

Your BIPublisher report is build using RTF or XPT layout?

Thanks

Nirmal

Ruthie

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

Thanks,

Ruthie