Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Field lengths Post Reply Post New Topic
Author Message
foxy
Groupie
Groupie
Avatar

Joined: 12 Jul 2007
Online Status: Offline
Posts: 50
Quote foxy Replybullet Topic: Field lengths
    Posted: 27 Jul 2007 at 4:35am
I have a few fields that have a lot of characters in them. I have the 'can grow' option checked in the field formatting and they are displaying fine on the preview and when published through Business Objects.
 
However, the client wants to be able to export the report to excel, when i do this, excel cuts of the last few lines of all of the large fields. The rest of the text appears when you expand the rows in excel but she cannot be expected to go through the report expanding rows as the reports are massive.
 
Is there a reason why this is happening to the fields in excel or is it just typical MS Office??!
 
Any help will be much appreciated
 
Foxy


Edited by foxy - 27 Jul 2007 at 6:02am
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 30 Jul 2007 at 2:21pm
Unfortunately, this is an issue in Excel.  The easiest way for your user to handle this will be to open the spreadsheet, press Ctrl-End and then Home to go to the bottom of the data.  Press Ctrl-A to select all data and then double-click on the bottom line of the row-header (where it gives the row number to the left of the data.)  This should expand all of the rows that need it instead of having to expand individual rows.
 
-Dell
IP IP Logged
foxy
Groupie
Groupie
Avatar

Joined: 12 Jul 2007
Online Status: Offline
Posts: 50
Quote foxy Replybullet Posted: 31 Jul 2007 at 1:00am

Yea I have tried that approach by selecting all and expanding the rows, but it seems to just resize all of the rows to the default size and still cuts off the bottom few lines of each long text field.Angry

IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.