Active Reports sub report not displaying data

Active Reports sub report not displaying data

Posted by: jcarlisle on 24 January 2019, 8:08 am EST

• 

  jcarlisle

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 24 January 2019, 8:08 am EST

  Hello, sorry if I’m asking a question / posing a problem that has already been addressed, but I’ve been researching this for the last couple days with little progress. I have an Active Reports 11 Section Report (code based) that has 3 sub reports in it. None of the subreports are printing the data, even though the data source which has been assigned to them has data in it. The sub reports ARE printing the report headers, etc. and my bindings (DataFields in the Design view) are set to the correct StoredProcedure output column names. Not sure what I’m doing wrong. I’ve stepped through the program and the “Parent Report” IS displaying data (Me.DataSource = DataTablePopulatedByStoredProc) however the sub reports (which also have DataSources that come from SPs) are not rendering any data. There are no errors being thrown that I can see. Any help in trouble shooting my problem would be much appreciated.

  Best,
  
  Jonathan

  P.S. I’m glad to provide an example of similar code structure to what I have if that would help. I’m just not sure what to include that might be of help in troubleshooting.

• 

  jcarlisle

  • Post Options:
  • Link
    Copy

  Posted 24 January 2019, 8:55 am EST

  Okay, I think I may be making some progress. It seems that I need to include

  Dim subReport As SubReport = CType(Detail.Controls("SubRept"), SubReport)
  

  I didn’t originally have this because the report I was using as a template / guide did not use this, then I looked at a different report and it’s being used there, so I figured I’d give it a try. Now however, my grouping in the sub reports seems to be incorrect. Will look into that next.

• 

  esha.dhir

  

  • Post Options:
  • Link
    Copy

  Posted 24 January 2019, 6:26 pm EST

  Hello Jonathan,

  Thanks for reaching out to us.
  
  I hope you have referred the documentation to help you with the grouping of data in section reports:
  
  https://help.grapecity.com/activereports/webhelp/AR13/webframe.html#GroupingDataSectionLayout.html

  In order to comment on the issue you are facing, I would need your stripped down sample (showing the issue), along with the dummy data saved as a backup file.
  
  Kindly share the same. To share these privately, you can create a SupportOne ticket: http://supportone.componentone.com

  Best Regards,
  
  Esha