Crystal Reports Export to XLSX issue

Technical Questions
Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: Export to XLSX issue

Author	Message
dan231 Newbie Joined: 03 Oct 2014 Online Status: Offline Posts: 13	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 Logged

dan231 Newbie Joined: 03 Oct 2014 Online Status: Offline Posts: 13	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 Logged

kevlray Admin Group Joined: 29 Oct 2009 Online Status: Offline Posts: 1587	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 Logged

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