Home End User
New Blog Posts: Merging Reports - Part 1 and Part 2

Master detail

edited February 2003 in End User
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,

Comments

  • edited February 2003
    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. :)

  • edited February 2003
    We are talking about ENDUSER...... NG

    I need to do this in enduser env.

    Regards,

  • edited February 2003
    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.

    --
    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited February 2003
    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,

  • edited February 2003
    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.

    --
    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.