Export to XLSX issue
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22704
Printed Date: 02 May 2024 at 4:59pm
Topic: Export to XLSX issue
Posted By: dan231
Subject: Export to XLSX issue
Date 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
|
Replies:
Posted By: dan231
Date 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
|
Posted By: kevlray
Date 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.
|
Posted By: dan231
Date Posted: 30 Nov 2018 at 3:19am
ok, great. I will play around with the header. Thanks!
-------------
Thanks,
Dan
|
|