Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: format is off when export to excel Post Reply Post New Topic
Author Message
koo9
Newbie
Newbie
Avatar

Joined: 22 Apr 2009
Location: Canada
Online Status: Offline
Posts: 11
Quote koo9 Replybullet Topic: format is off when export to excel
     Posted: 26 Jun 2009 at 7:18am

quick question, the report looks fine in HTML and PDF format, but when export to excel, the rows in the sub report starting on the new page is pushed to the right from the group column headers. if the repeat group on new page is check, then the format is fine but it doesn't look rght since the repeating groups confuse the user on the excel report. shouldn't crystal report be smart enough to know it's an excel doc and there is no such thing as a page break and keep all the groups together?

for HTML report, it looks like
 
Group 1
           data | data | data
----------------------------------new page
Group 1
           data | data | data
 
but when export to excel, it looks like
 
Group 1
         data | data | data
                   data | data | data
 
is there any option or workaround for this?
 
thanks
 
Kevin
 
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Quote lockwelle Replybullet Posted: 26 Jun 2009 at 1:19pm
I agree, but, Crystal makes all sorts of mistakes in Excel.  In the export to excel, selecting constant column width, and making it smallish, will help keep the alignment but results in lots of columns. 
 
Putting in page breaks is not necessarily a bad thing, as the report breaks and there might be identifying information in the header/footer.  Also, just because you lump all the groups together, doesn't mean that the end user is going to all time.  We have a client that needs the headers as he has over 5 companies and 90 divisions and the only place that this information is displayed is in the header...if you just want a data dump, why are you using Crystal ;)
 
The constant columns is the best hint I can give...you would think that Crystal could keep the data aligned in the same column if it is from the same field on the report....but no, it can't.
 
IP IP Logged
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