Solved

Export Data from Crystal Report XI R2 to Excel Using InfoView Interface.

Posted on 2006-10-26
4
696 Views
Last Modified: 2011-09-20
Hi,

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.

Regards
Deepakshi
0
Comment
Question by:deepakshi
4 Comments
 
LVL 17

Accepted Solution

by:
MIKE earned 250 total points
ID: 17814488
This is a know issue with Export to Excel. The process is quite complex.

The main issue in trying to export to excel is to go into the REPORT CREATION with exporting to excel as the main goal. You'll need a CLEAN REPORT with minimal sorts, spaces and any other print formatting that will not export correctly.

You can try the following:

-Make you've set the correct exporting criteria.

-Remove all group headers/footers/subtotals..etc.
-Keep your reporting data in the basic BLOCK format that Excel is expecting.

Hope it helps.

MikeV
0
 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 250 total points
ID: 17815577
Here is an article that explains Mike's comments in more detail

http://support.businessobjects.com/communityCS/TechnicalPapers/cr10_export_excel.pdf.asp

mlmcc
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

861 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now