Joined: 24 Dec 2017
Location: United States
Online Status: Offline
Posts: 6
Topic: How to merge columns when exporting to excel Posted: 04 Feb 2018 at 6:50am
In my crystal report, I have a header and below that header, I've three columns. I want to merge the header across three columns shown as below.
| Main Heading |
|col1|col2|col3|
But when I export crystal report to excel, Main heading appears in one cell over the first column shown as below.
|Main Heading|
| col1 |col2|col3|
In crystal I'm using guidelines and ruler and have no gap between my fields, but it's not helping.
I'm new to crystal. Any help will be greatly appreciated. Thanks in advance!
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Posted: 05 Feb 2018 at 4:25am
Exporting to Excel is difficult at best trying to get the columns the way you want. As far at merging a header across three columns. I am not sure if that is possible with regular crystal reports. There may be a third party solution.
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Posted: 08 Feb 2018 at 6:59am
This is definitely not possible with Crystal. A good place to look for 3rd party tools that might help you with this is http://kenhamady.com/productlinks/default.html
Joined: 24 Dec 2017
Location: United States
Online Status: Offline
Posts: 6
Posted: 09 Feb 2018 at 9:38am
Thank you everyone for the answers. It helped!
I finally decided to export to pdf.
The only way it works in excel is when I export it to "Excel (97-2003)" not in "Excel wokrbook data-only".
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
IP Logged
