Master/Detail report

ReportWorkshop support and discussion (TRichView reporting add-on)
Post Reply
zdeveloper
Posts: 1
Joined: Thu Oct 25, 2018 6:09 am

Master/Detail report

Post 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?
Sergey Tkachenko
Site Admin
Posts: 17520
Joined: Sat Aug 27, 2005 10:28 am
Contact:

Re: Master/Detail report

Post 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.
Post Reply