Drill Down with JIT

rbuser

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

nardmoseley

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