Crystal reports - Excel export

Hi,

A Crystal report contains text type column of a length of 200 characters. Only the first n characters can be displayed on the report, but when the result is exported to Excel, the full length text (200 chars) is needed. Whatever we try, the text is trimmed during the export. Any suggestions?

Thanks.

Csaba
cslokiAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
mlmccConnect With a Mentor Commented:
First why the limit on the report?  That may be the reason for the limit in Excel.

This will help
http://support.businessobjects.com/communityCS/TechnicalPapers/scr_exportexcel.pdf.asp

How are you exporting to Excel?

mlmcc

0
 
Kurt ReinhardtConnect With a Mentor Sr. Business Intelligence Consultant/ArchitectCommented:
How is your report formatted?  Is it a columnar report (rows and columns), or something else?

Generally speaking, exporting to Exel required additional formatting at design time.  Since I don't know how your report is formatted, you could try to embed field in a text field and then export that to excel.  That was a workaround for memo field exports:

http://support.businessobjects.com/library/kbase/articles/c2004511.asp

~Kurt
0
 
cslokiAuthor Commented:
This is a simple tabular report (columns and rows), no sub-reports, totals etc.
The problem is that a large number of columns (including long description fields) must be displayed but only the first few characters of these fields can fit on the report. However, when exporting it to Excel, the whole content of all the fields must be transferred. I want to see first 10 chars in the Crystal but 200 chars in the Excel. Can it be done, or "what I see in Crystal is what I will see in Excel"?
Your comments are really valuable, anyway. Thanks.
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
mlmccCommented:
That may be very true.  Crystal tries to export to Excel exactly like the report shows (WYSIWYG).  It was for this reason that I wrote my own export to Excel routine but I don't think it will work from the CR viewer.

If you have CR9 or later there is an Excel export of data only which might do what you desire.

mlmcc
0
 
mlmccCommented:
Either my comments or rhinok's comment should have helped

recommend split rhinok and mlmcc
0
 
cslokiAuthor Commented:
Thanks for your comments, they were a valuable help for us. The question can be closed.

Csaba

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.