Crystal Reports Export to Excel Issue

Technical Questions

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

Topic: Export to Excel Issue

Post Reply

Post New Topic

Author	Message
tmulthaupt Newbie Joined: 11 Dec 2012 Location: United States Online Status: Offline Posts: 5	Topic: Export to Excel Issue Posted: 11 Dec 2012 at 4:51am
	When I export a report to excel and the field is blank, it is exporting as a zero value. However, i need the field to export as blank?
	IP Logged


comatt1 Senior Member Joined: 19 May 2011 Online Status: Offline Posts: 337	Posted: 11 Dec 2012 at 7:34am
	Change the convert to null settings. Go to file in the toolbar, Options-> Reporting , uncheck convert database nulls to defaults and other nulls to defaults.
	IP Logged

tmulthaupt Newbie Joined: 11 Dec 2012 Location: United States Online Status: Offline Posts: 5	Posted: 11 Dec 2012 at 8:03am
	Those fields were already unchecked. The report prints properly with blank spaces (Suppress if zero). However, when i export it, there are still zeroes in the field?
	IP Logged

yggdrasil Senior Member Joined: 19 Jun 2007 Location: United Kingdom Online Status: Offline Posts: 150	Posted: 12 Dec 2012 at 2:55am
	Excel has its own way of deciding what it thinks you want to do. If possible, I would use 'totext' to convert the field to text, then it will stay as blank and where you actually have a number you can format it the way you want Excel to display
	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