I was facing an issue while exporting a crystal report to excel using ASP code.
The report data exports correctly but there are a few graphs and other images that are displayed as blank in the excel. There seems to be an image object there but it is completely blank.
Can someone please help me out with this as it is very urgent. Please find the code I am trying to perform this below. Please let me know if I am missing something.
Set CrystalExportOptions = Session("oRpt").ExportOptions
CrystalExportOptions.DiskFileName = sFilePath
CrystalExportOptions.FormatType = 29 'This is excel format type
CrystalExportOptions.DestinationType = CInt(1)
Set Session("oRpt") = Nothing