Page 1 of 1
Posted: Thu Oct 25, 2018 6:13 am
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
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.