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

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
component???

Thanks All,
Branden Johnson

Comments

  • edited September 2005

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

    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
    http://www.digital-metaphors.com



    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.