Posted 17 November 2017, 4:50 pm EST
Using AR 11 in a ,NET project. Some of our section reports are not exporting all their data values when exporting to Excel format. It seems to be more or less random. As some values from Group and Grand totals do export…but others consistently show as ‘0’ in the Excel spreadsheet.
Is there any known issue as to why this may be happening?
The export code is standard for all of these reports:
Dim sXLSfile As String = sOutPath & "\" & cleanTitle & ".xls"
sXLSfile = UniqueFileName(sXLSfile)
rptToRun.Run(True)
Dim xlsExport1 As New GrapeCity.ActiveReports.Export.Excel.Section.XlsExport
xlsExport1.Export(rptToRun.Document, sXLSfile)
Process.Start(sXLSfile)