Crystal Reports exporting to Excel Issue

In a current C# application I do maintenance on, we have upgraded to Visual Studio 2008 from Visual Studio 2003. We have always used the included Crystal Reports that came with Visual Studio.

Since the upgrade we have found an issue with our reports when exporting to excel. If the column in the details section is null, then all the rest of the data in the row shifts to the left. Casuing data to be put in the incorrect columns.

I have been searching, and checking properties and have come up empty handed. If anyone can throw me a lifeline or point me in the right direction I would be very grateful.


I have found that with CR, if you know that the data will mostly be dumped to excel, I remove ALL formatting that CR may do. Is this the case with your report?

What is CR set to do in it's properties with NULL values?

Need Your Help

KornShell (ksh) code to send attachments with mailx and uuencode?

shell unix scripting solaris ksh

I need to attach a file with mailx but at the moment I am not having success.

I need a binary comparison tool for Win/Linux

linux windows binary comparison

First of all, I don't need a textual comparison so Beyond Compare doesn't do what I need.