Master detail

rbuser

Hello,

Is it possible to use in a detail data pipeline a field from the master data
pipeline.

I have a master pipeline with a field Date_Max and Date_Min i want to
display only those records from the detail pipeline where the field date
between these fields from the master pipeline.

regards,

rbuser

Yes, Henk.

You can set up links between pipelines or the queries/tables which they
represent.
Use the Master/Detail mechanism through Delphi's TDataset or use the
MasterPipeline and FieldLinks of the ppPipelines.
If you parameterize your detail query, you can feed the dates you want from
the master query to it.
This is how to do what you need. There are some examples to better show it.
See if you can locate them.

rbuser

We are talking about ENDUSER...... NG

I need to do this in enduser env.

Regards,

nicocizik

It is possible to link datasets using DADE in the Data tab of the Report
Designer. This can be done by simply dragging the detail field to the

corresponding field in the master DataView. A visual link will be drawn for
you when you do this.

Try running the example located in (\RBuilder\Demos\3. EndUser\1. Report
Explorer\), then navigating to the (Application\02. DataView Linking\)

folder in the Report Explorer. These reports give a good example on how to
link in an end-user environment.

--

rbuser

Sorry, but i now how to do this, i have an other problem

I have 2 query's build in the enduser env. one master query with fields
named Date_Max and Date_Min i want to display only those records from the
other query where the field date between these fields from the first query
pipeline.

I already linked the two querys with draging te fields.

Regards,

nicocizik

This type of linking is not supported by the query tools. For this type of
linking, you would need to use Delphi's query linking features. Using this
approach you can create a CustomDataView that contains any number of linked
datasets. As an example check out the \RBuilder\Demos\3. EndUser\2. Custom
Data Views\EndUser.dpr. Open MyDataVw.pas and look at the TdvOrder example
code.

--