Crystal Report Export to Excel
Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=12595
Printed Date: 02 Apr 2025 at 8:39pm
Topic: Crystal Report Export to Excel
Posted By: Kathir
Subject: Crystal Report Export to Excel
Date Posted: 13 Mar 2011 at 2:48am
|
I am new to Crystal Report, I am have a problem while exporting my .rpt
to excel. I have designed my rpt with text object in White Color and
Back color as gray, When the whole data is exported to excel, text
object which is in white color disappears, of course I can see the text
when I change the text color in excel, but my user is not convincible.
Any suggestion regarding this problem? Thanks in advance |
Replies:
Posted By: lockwelle
Date Posted: 14 Mar 2011 at 3:39am
|
you won't like it...change your text color in your report. as far as I know, you have basically no control over the export from CR to anything else. Which means, if there is a glitch in CR exporting the cell backColor, you're out of luck.
You might try exporting to PDF. If it exports there OK, maybe you can use that to convince your client that the data is there. If they don't want to go to the next step to change the color (of the cell or the text), then you probably need to change the colors of your report.
HTH
|
Posted By: Kathir
Date Posted: 14 Mar 2011 at 5:11am
|
Lockwelle, Thanks for your quick response, Yeah you are correct I have to change the text color, that's the only option think so......  |
Posted By: Kanya
Date Posted: 22 Mar 2012 at 9:02pm
| Hi ...Is there any way to wrap text while exporting to excel?? |
Posted By: lockwelle
Date Posted: 23 Mar 2012 at 3:20am
|
not that I am aware of... again, you have very little control of how CR exports the data
|