We are publishing Crystal reports XI Reports to InfoView in Business Objects XI R2. When we export these reports to Excel format using Shceduling options, the Column Values are not displayed properly and cells are merged giving the report a dirty look.
However, if we export the data using Excel (Data Only) format, the look comes clean, as required. However the Group header information is lost.
Is there any way to export the report in Clean way as in data Only format and yet publish other relevant information too.
Please reply ASAP as this is a very urgent requirement.
Thanks a lot.