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.

Answers


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

Primefaces binding Bean with form

jsf primefaces

I'm developing an application with primefaces, I´m trying to map my form with my Bean of User but i can't, this is my code:

java optional parameters

java optional-parameters

I want to write an average method in java such that it can consume N amount of items, returning the average of them: