“How can I link DADE pipelines manually? Sometimes I need to manually edit the SQL or need to bypass generation of the magic sql
For the linked data traversal to work properly, make sure the detail query selects all records required for the entire report and Order By the linking field(s).
The following examples uses the Report.BeforeOpenDataPipelines event to define a master/detail link.
Delphi code sample:
procedure TForm1.ppReport1BeforeOpenDataPipelines(Sender: TObject);
lMasterPipeline := ppReport1.DataPipeline;
lDetailPipeline := ppSubreport1.DataPipeline;
lDetailPipeline.AddLink(lMasterPipeline, 'CustNo', 'CustNo');