Hi all ,
I use crystal report make a report layout, onclick in screen is ok .....But i use bult-in fuction Export Report to excel...
The excel layout format, some of words displace , do not same to screen....
And then i have button , i use to directly output excel, but the format is Worse than bult-in fuction Export , and displace and ugly,
no resize the column width.
Anyone how can i do , i already correct the crystal report more time but not ok ?

 Dim CrExportOptions As ExportOptions
                Dim CrDiskFileDestinationOptions As New  _
               DiskFileDestinationOptions()
                Dim CrFormatTypeOptions As New ExcelFormatOptions
                CrDiskFileDestinationOptions.DiskFileName = exportExcelPath
                CrExportOptions = crReport.ExportOptions
                With CrExportOptions
                    .ExportDestinationType = ExportDestinationType.DiskFile
                    .ExportFormatType = ExportFormatType.Excel
                    .DestinationOptions = CrDiskFileDestinationOptions
                    .FormatOptions = CrFormatTypeOptions
                End With
                crReport.Export()