Solved

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

Posted on 2006-10-26
4
686 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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

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…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

760 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

18 Experts available now in Live!

Get 1:1 Help Now