I want to export the Crystal report XI to Microsoft Excel Format using the option provided by CRViewer.

I am using the Web Control provided by Business Objects. The report when exported to Excel distort the data. The NULL values in any column are replace by the value in the column right to it.

For eg:

The correct data is:

Name Contact Phone Address
ABC Mr. Bhasin 1836583 ABC Corporation
XYZ Mr. Mehta <NULL> Okhla Phase II
M/S Creative Mr. Gupta 946272 Nehru Place

Exported Data displayed is:

Name Contact Phone Address
ABC Mr. Bhasin 1836583 ABC Corporation
XYZ Mr. Mehta Okhla Phase II
M/S Creative Mr. Gupta 946272 Nehru Place

Please can anyone help?