Page 1 of 1

Master/Detail report

Posted: Thu Oct 25, 2018 6:13 am
by zdeveloper
master/detail report use query or filter for request detail data?
can i prepare all data for report by stored procs and use them in report without any additional query to server?

Re: Master/Detail report

Posted: Thu Oct 25, 2018 5:29 pm
by Sergey Tkachenko
Normally, master/detail report are implemented using nested SQL statements. All ReportEditor demos work in this way.

But this is not the only possible solution.
For example, a master/detail relationship may be created using properties of datasets (see "4 - Master-detail predefined" demos for FireDAC or IBX). You can implement your report in a similar way, using OnProcessRecord event. This event occurs before processing each record. When a new record of the master table is processed, you can apply a filter to the detail table.