Crystal Reports Double headers in an Excel Export

Technical Questions

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

Topic: Double headers in an Excel Export

Post Reply

Post New Topic

Author	Message
carstowal Groupie Joined: 31 Jul 2008 Online Status: Offline Posts: 80	Topic: Double headers in an Excel Export Posted: 29 Jul 2009 at 6:52am
	Two rows of headers sometimes Hdr Row 1 spans two columns - MATERIAL LABOR JOB Est Act Est Act is there anyway to make this work in a Data only Export to Excel? using CR9
	IP Logged


lockwelle Moderator Joined: 21 Dec 2007 Online Status: Offline Posts: 4374	Posted: 29 Jul 2009 at 7:05am
	never used 9, but I don't think so. If you can set values on the export to Excel, then you might be able set a fix cell size and if you play long enough you can find a value that works....that is what you need to do in CR XI...you would think that Crystal would know that the it is all one piece of data and place it in a just one cell...but no, it doesn't. Sorry, I can't be of more help.
	IP Logged

hilfy Admin Group Joined: 20 Nov 2006 Online Status: Offline Posts: 3702	Posted: 29 Jul 2009 at 9:43am
	If you can use a CrossTab to show your data, then it will export cleanly. I've not found any other way to have labels like that export in the same format as the report. -Dell
	Proviti, Data & Analytics Practice www.protiviti.com/US-en/data-management-advanced-analytics
	IP Logged

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