two pipeline for report template

rbuser

could i have two or more pipeline on the report template ?
i have one pipeline , plReports , to retrieve the report template from the
interbase .The code shown as below:

var
ppReport : TppReport;
begin
ppReport := TppReport.Create(Self);
SetDatabaseSetting(ppReport1);
ppReport.Template.DatabaseSettings.DataPipeline := plReports;
ppReport.Template.DatabaseSettings.NameField := 'rp_report_name';
ppReport.Template.DatabaseSettings.TemplateField := 'rp_report';
ppReport.Template.DatabaseSettings.Name := Name;
ppReport.Template.LoadFromDatabase;
ppViewer1.Report := ppReport;
ppViewer1.RegenerateReport;
end;

i need to insert some criteria statement, before i load the report template
to the ppViewer1. could i have one or more pipeline to relate report
template , so that i could set the where clause or other query condition for
simple report or master-detail report ? how to do it?

TIA

digitalmetaphors

Yes, you can connect the report up to a different data pipeline to get its
data than the one which was used to load the template. You'll connect the
master data pipeline to the main report. Then connect the detail data
pipeline to a subreport in the report. See the master detail section of the
developer's guide for info on creating master detail reports. The
developer's guide is a pdf located in your installation. There are also
autosearch demos in your RBuilder\Demos\Autosearch directory. These
examples show how you can set a table filter or update the where clause on a
query.


Cheers,

Jim Bennett
Digital Metaphors