Master/Detail report

A reporting tool based on TRichView
Post Reply
zdeveloper
Posts: 1
Joined: Thu Oct 25, 2018 6:09 am

Master/Detail report

Post by zdeveloper » 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?

Sergey Tkachenko
Site Admin
Posts: 14163
Joined: Sat Aug 27, 2005 10:28 am
Contact:

Re: Master/Detail report

Post by Sergey Tkachenko » 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.

Post Reply