Sub query per record for a data set

Sub query per record for a data set

Posted by: blagoja.blazevski on 13 November 2025, 6:48 am EST

• 

  blagoja.blazevski

  • Post Options:
  • Link
    Copy

  Posted 13 November 2025, 6:48 am EST

  I’m trying to build a report in ActiveReportsJS where a Banded List is bound to a main dataset that has grouped records.

  For each row in that Banded List (details), I need to render a Table that is bound to a different dataset, but that dataset must receive a parameter derived from the current row of the Banded List.

  The parameter must then be included inside the POST body of the dataset’s request so it can fetch the correct filtered data for that specific row.

  In short:
  
  I need per-row parameterized sub-queries inside a Banded List, but I can’t find a clean way to take a field value from the parent row and use it as a dynamic parameter in the dataset request body for the child table.

  I tried using sub-reports, but they broke my page structure, I do not know how to limit the sub-report to display the elements inside only rather than a full page.

• 

  anand.sinha

  

  • Post Options:
  • Link
    Copy

  Posted 14 November 2025, 4:42 am EST

  Hi Blagoja,

  You can achieve your requirement by placing a SubReport in your BandedList’s Detail section.
  
  Then, to the SubReport’s Control, you can specify the ‘ReportParameter’ property with the values of the row you want to pass to the SubReport.

  In your SubReport, make sure you create a parameter that has the same name that you specified for the SubReport Control’s ‘ReportParameter’ property in your parent report.
  
  Then, in your SubReport’s DataSource call, you can use this parameter to be included in the POST request body.

  To prevent your SubReport from breaking the page structure, in your SubReport, click on the ‘ContinuousSection1’ report section (in the bottom pane) and reduce its width. Ideally, set it equal to the width of the SubReport Control of your Parent Report.
  
  Also, click on the empty space in your SubReport, this will show the Report’s Properties in the properties panel. Set the ‘ConsumeWhiteSpace’ property to ‘true’, this will ensure that in the Parent report, the SubReport only grows equal to the table’s height, rest whitespaces will be consumed.

  Please find attached a sample implementing your use case for reference.

  Regards,
  
  Anand

  Sample.zip