Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Export to XLSX issue Post Reply Post New Topic
Author Message
dan231
Newbie
Newbie


Joined: 03 Oct 2014
Online Status: Offline
Posts: 13
Quote dan231 Replybullet Topic: Export to XLSX issue
    Posted: 29 Nov 2018 at 3:09am
I am trying to get a 2-row header and all my attempts at this result in only 1 row showing for the actual export.

Any suggestions on how to get a 2nd row in the page header?
Thanks,
Dan
IP IP Logged
dan231
Newbie
Newbie


Joined: 03 Oct 2014
Online Status: Offline
Posts: 13
Quote dan231 Replybullet Posted: 29 Nov 2018 at 3:29am
ok! I am exporting now NOT as data only and I have 2 rows!

Now, I am looking to see how to get each field to be only 1 cell. I have some that cover 2 cells and when I shorten the field in Crystal, the data in Excel is cut off.
Thanks,
Dan
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 29 Nov 2018 at 11:51am
Crystal does not export to Excel very nicely.  If you want to look more like the actual report, You will have to export as Excel not data only.  But getting column sizes correctly is difficult at best. Crystal normally looks at the column headers to determine the correct size.  Thus column headers and details should be the same size and aligned vertically for best results.
IP IP Logged
dan231
Newbie
Newbie


Joined: 03 Oct 2014
Online Status: Offline
Posts: 13
Quote dan231 Replybullet Posted: 30 Nov 2018 at 3:19am
ok, great. I will play around with the header. Thanks!
Thanks,
Dan
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.