Joined: 12 Nov 2007
Location: United States
Online Status: Offline
Posts: 93
Posted: 13 Nov 2007 at 1:10pm
Rajesh, I had similar issue while exporting to Excel. I would get blank for zero values. But when I clicked on the field, I would see that it is zero. I don't know how I can overcome this problem. In you case, I think you have to check filed length in design view so that one does not overlap others. What you see is what you get. so you have to format you report in Excel friendly way such as not leaving space between fields. Hope this helps.
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Posted: 13 Nov 2007 at 3:25pm
It's important in Excel to make a report similar to a grid to make sure that all the fields gets formatted correctly. If things aren't lined up well, then it can be tough for CR to export to Excel and make sure overlapping fields get positioned correctly.
I give a list of tips and suggestions for exporting to Excel on pages 551-555 in my book.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
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
IP Logged
