Crystal Reports Excel Export

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

Topic: Excel Export

Author	Message
alex451 Newbie Joined: 06 Nov 2007 Location: United States Online Status: Offline Posts: 3	Topic: Excel Export Posted: 05 Feb 2008 at 6:44am
	I have written a very simple report that I want my users to be able to export to excel - however when they select export the data is a) merging columns together - so column 1 which contains a number in Excel appears to be spread across column a& B b) It is adding a blank additional row after each row. I am unable to sort the data because of the "merged fields"
	IP Logged

saoco77 Senior Member Joined: 26 Jun 2007 Online Status: Offline Posts: 104	Posted: 05 Feb 2008 at 9:54am
	Crystal Reports has two export to excel choices 1) Choice 1 Microsoft Excel (1997 -2000) - This option trys to maintain as much of the original report formatting as possible. Based on what you wrote I think you are choosing this option. 2) Choice 1 Microsoft Excel (1997 -2000)(Data Only) - This option allows you minimal control over formatting but the data is exported into a functional Excel spreadsheet. Once exported users may have to adjust column heights/row widths to read the content. But otherwise functionality such as sorting columns based on values is possible. Hope this helps, Sarah
	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.017 seconds.