Oracle Transactional Business Intelligence

Exporting to Excel & Word Wrap
Summary
I want cells with longer text to wrap automatically when I export an analysis to excel 2010.
Content
I have a built an analysis that pulls in requisition user comments. I am trying to export the information to excel with the cell width of that column fixed so it wraps the text, vs having a extremely long column. These report will be delivered using an agent and I don't want my end user to have to open and adjust the width of the cell each day when the report is delivered.
Any thought/ideas on how to solve this issue.
Thanks
Answers
-
Have you looked at a B,I publisher solution
-
You can create a BI Publisher report using RTF Template / Excel Template. You will have more control over the size of columns, text-wrapping etc.
Thanks,
Arun
-
Hi
Can you try inserting a Analysis in a dashboard and schedule it through Agent?
OR
User has to create a customized setting with macro for all formatting. Once you set it will be embedded in excel.you would just need to click one time entire format.
No need to do manual formatting..
Regardrs,
Ramesh