master/detail

rbuser

Hi,
Don't have a problem as such, more an issue.

I have a report with several sub-reports and all the sub-reports take a ID
parameter that I pass at runtime. So in effect, all the reports show up
only records for that ID, which is fine and everything shows up correctly.

Question is, for the DBPipeline, do I need to set up the MasterDataPipeline
and MasterFieldLinks, with say ID field of the main report to that of the
sub-reports? I don't have the links at the moment, and the reports work as
the did when I do set up the links.

Cheers
Shanil.

nicocizik

Hi Shanil,

The method you are using is just a different approach to what pipeline
linking will do for you automatically. If you are satisfied with the output
of your report as it is now, I would suggest staying with the current
design. You may find in the future if your reports become larger and more
complex that linking the datapipelines rather than using parameters in your
sql generates the report much faster and is easier to set up.

--

rbuser

thanks for that.
I don't think I have much as my queries use some stored procedures that
don't output the linking field. I'd have preferred the pipline method also,
but it will mean changing a whole lot of stored procedures