Crystal Reports subreport printing on next line when exporting to

Report Design

Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: subreport printing on next line when exporting to

Author	Message
nitrotech Groupie Joined: 30 Jan 2013 Location: United States Online Status: Offline Posts: 42	Topic: subreport printing on next line when exporting to Posted: 31 Jan 2013 at 4:57am
	I have a subreport setup on the last column of my report the totals keep printing on the first row of the next line when I export to Excel The report looks fine in crystal but not in excel How do I keep it in the right Column?
	IP Logged


hilfy Admin Group Joined: 20 Nov 2006 Online Status: Offline Posts: 3702	Posted: 31 Jan 2013 at 11:41am
	You are probably running into one of the (many) issues with the Excel export from Crystal. I don't guarantee this will work, but you could try this: 1. In the subreport, suppress every section except the one that your data is in. 2. In the main report, line up the top of the subreport to the top of the field next to it. 3. Make the subreport the same height as the field next to it. Try the export again. If this doesn't work, there's no way to get around the issue. -Dell
	Proviti, Data & Analytics Practice www.protiviti.com/US-en/data-management-advanced-analytics
	IP Logged

nitrotech Groupie Joined: 30 Jan 2013 Location: United States Online Status: Offline Posts: 42	Posted: 04 Feb 2013 at 11:32am
	The work around I found which is a pain is to export report to a tab dilimiter file open in excel when opening in excel it imports the right way using the defaults then saved the file in an excel format. Not the best solution but it worked
	IP Logged

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