How to merge columns when exporting to excel
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22537
Printed Date: 02 May 2024 at 6:32pm
Topic: How to merge columns when exporting to excel
Posted By: mh9876
Subject: How to merge columns when exporting to excel
Date 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!
|
Replies:
Posted By: kevlray
Date 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.
|
Posted By: hilfy
Date 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
-Dell
-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics
|
Posted By: mh9876
Date 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".
|
|