SectionReport, GrandTotal blank if last row is Null

SectionReport, GrandTotal blank if last row is Null

Posted by: softcomlimited on 20 August 2019, 9:22 pm EST

• 

  softcomlimited

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 20 August 2019, 9:22 pm EST

  Hello,
  
  On my RPX, in the ReportFooter , the GrandTotal Sum is blank if the last row is Null. See the 3 snapshots in the attached docx. I have tried setting CountNullValues = True on both the detail and reportfooter textboxes with no change.
  
  The data has both zeros and NULLs. We would like to keep the NULL values to distinguish from zeros.
  
  I am setting the DataFields in the Script
  
  First time I’ve noticed this behaviour.
  
  Thanks
  
  BrianBlank GrandTotals.zip

• 

  esha.dhir

  

  • Post Options:
  • Link
    Copy

  Posted 21 August 2019, 1:42 am EST

  Hello Brian,

  Thank you for the files but I could not observe the issue with your report because of the absence of data.
  
  Meanwhile, I created a report and the data such that NULL value exists for the last row’s cell. However, the issue could not be replicated and the GrandTotal was displayed well even with the last row having a NULL value. This has been shown in the screenshot in the attached folder. The folder also has the report and the related data attached for your reference. Please use the same and modify your report accordingly. In case it does not help, share your dummy data so that I can use the same and observe the issue with your report. This will help me assist you further.
  
  If you wish to share the data privately, you can create a SupportOne ticket: https://supportone.componentone.com.

  Regards,
  
  EshaFiles.zip

• 

  softcomlimited

  • Post Options:
  • Link
    Copy

  Posted 21 August 2019, 1:31 pm EST

  Thanks, I will put together demodata.
  
  Regards
  
  Brian

• 

  softcomlimited

  • Post Options:
  • Link
    Copy

  Posted 21 August 2019, 2:43 pm EST

  Ms Dhir,
  
  I attached the demo. Connection string in Line:14,
  
  To see the effect change the number of rows selected in Line:18
  
  select Top 8 * from _dump1
  
  select Top 5 * from _dump1

  I’m assuming the problem is something stupidly simple that I am just not seeing. I had tried changing CountNullValue also.

  Regards
  
  Brianrpt06ScheduleDummy.zip

• 

  esha.dhir

  

  • Post Options:
  • Link
    Copy

  Posted 22 August 2019, 8:00 am EST

  Hello Brian,

  I am working on this and will get back to you soon.

  Regards.

• 

  softcomlimited

  • Post Options:
  • Link
    Copy

  Posted 22 August 2019, 3:04 pm EST

  Ok, thank you.

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 22 August 2019, 11:43 pm EST

  Hello Brian,

  Could you please try after setting the “SummaryRunning” property to “All”. Please refer to the attached modified report.

  Thanks.
  
  rpt06ScheduleDummy_Modfied.zip

• 

  softcomlimited

  • Post Options:
  • Link
    Copy

  Posted 23 August 2019, 10:24 pm EST

  Mr Mohitg,
  
  I’m sorry my reply did not get posted yesterday. Yes! that was the problem.
  
  Thank you so very much both of you.
  
  Regards
  
  Brian