Home Datapipelines

Drill Down with JIT

edited September 2005 in Datapipelines
I have a master-detail report setup using two JIT pipelines linked by the
MasterFieldLinks. The report prints just fine when I have the sub report
automatically expanded. But when I set the sub report to be a drill down,
nothing happens, except for a screen flicker, when I click on the drill down

Thanks All,
Branden Johnson


  • edited September 2005

    Below is an article on using the JITPipeline in a master/detail

    Once the master/detail relationship is configured properly the drill down
    should work properly.

    Tech Tip: Use Master/Detail JITPipelines

    To use Master/Detail relationship with the JITPipeline:

    1. Check out the demo dm0139 in the main demo reports app
    for an example.

    2. Make sure you have the Detail JITPipeline.MasterFieldLinks
    defined to specify the relationship. In dm0139 the detailed it
    linked to the master using the CustNo field from each pipeline.

    3. Once you have things setup like the above, then you will need
    to connect the Report.DataPipeline property to the master JITPipeline
    and the SubReport.DataPipeline property to the detail JITPipeline.

    4. In the FormCreate event set each JITPipeline.RecordCount
    property to the total number of records for each.

    You should not need to reset anything.

    6. ReportBuilder expects the data in the detail dataset
    to be in sorted order of the field links.

    In dm0139, the linked field is the CustNo, therefore
    the detail data must be order like this:

    CustNo OrderNo
    ------ -------
    1 001
    1 002
    1 003
    2 010
    2 009
    2 005

    Tech Support mailto:support@digital-metaphors.com
    Digital Metaphors http://www.digital-metaphors.com

    Nard Moseley
    Digital Metaphors Corporation

    Best regards,

    Nard Moseley
    Digital Metaphors
This discussion has been closed.