Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Crystal reports - Excel export

Posted on 2004-09-30
10
Medium Priority
?
544 Views
Last Modified: 2008-01-09
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
0
Comment
Question by:csloki
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
10 Comments
 
LVL 101

Accepted Solution

by:
mlmcc earned 100 total points
ID: 12189784
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
 
LVL 26

Assisted Solution

by:Kurt Reinhardt
Kurt Reinhardt earned 100 total points
ID: 12194549
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
 

Author Comment

by:csloki
ID: 12197778
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
Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

 
LVL 101

Expert Comment

by:mlmcc
ID: 12205961
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
 
LVL 101

Expert Comment

by:mlmcc
ID: 12429980
Either my comments or rhinok's comment should have helped

recommend split rhinok and mlmcc
0
 

Author Comment

by:csloki
ID: 12430647
Thanks for your comments, they were a valuable help for us. The question can be closed.

Csaba

0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
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 …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

604 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