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?
Master/Detail report
-
Sergey Tkachenko
- Site Admin
- Posts: 17557
- Joined: Sat Aug 27, 2005 10:28 am
- Contact:
Re: Master/Detail report
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.
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.