Section Report export to Excel shows 0's in Group Footers

Section Report export to Excel shows 0's in Group Footers

Posted by: raleigh on 17 November 2017, 7:50 am EST

• 

  raleigh

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 17 November 2017, 7:50 am 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)
  
  

• 

  raleigh

  • Post Options:
  • Link
    Copy

  Posted 17 November 2017, 8:50 am EST

  Interesting: each of the report fields that display dollars uses the same .OtputFormat: $#,##0.00;($#,##0.00)

  But it appears that only the fields that are in the summed groupings of the report will get set = 0 when Exporting to Excel. Even though, in many instances, the summed value has the same number of digits as the detail values.

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 20 November 2017, 8:17 pm EST

  Hello,

  I am unable to reproduce the issue at our end. Please refer the attached report and exported file . Also,
  
  Could you please attach your report file for me to run and reproduce the issue. Can you please specify the exact version of AR that you’re facing the issue with?

  Thanks,
  
  Mohit
  
  ExcelExport.zip

• 

  raleigh

  • Post Options:
  • Link
    Copy

  Posted 21 November 2017, 6:05 am EST

  Using version: 11.1.9726.0
  
  in the form you sent–>i do not see the .OutputFormat property set to the value i mentioned. What i find is that i must clear that property value for the report field’s value to display in Excel…but only for some report fields.
  
  I attached a report that is typical of the reports in which we experience this issue.rptPmtDetail.Designer.zip

  Thank you.

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 21 November 2017, 5:46 pm EST

  Hello,

  We are unable to reproduce the issue at our end using build 11.1.9726.0 with OutputFormat:“$#,##0.00;($#,##0.00)”.

  Also, attached report in above report has lot of unknown variables. Please share the report without any unknown variable so that we can replicate the issue at our end.
  
  This will be very helpful for us.

  Thanks,
  
  Mohit

• 

  raleigh

  • Post Options:
  • Link
    Copy

  Posted 22 November 2017, 1:33 am EST

  i am able to reproduce the issue very easily in the report i sent. just delete, or comment out, all the code and export directly to Excel.

  i can also see why this is happening. those fields are in summary sections and each field has its Summary properties set…even though the values in the fields are set in program code in their respective Format event. i am able to work around this now that i know why it was happening.

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 22 November 2017, 4:43 pm EST

  Hello,

  We commented out all code in your attached report and found that Group and Grand totals is shown as “0” even at preview time. There could be a problem in report design. When we set " Summary" properties of report item then its value depends on the Report/Group data. Could you please recheck it one more time at your end or share the report with us without any unknown variables.

  Thanks,
  
  Mohit