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?