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

JITPipeline in subreport does not create all details

edited September 2002 in Datapipelines
I have a report in RB 7.0 with some problems getting all details to be
generated in a report.

The Report is layed out as follows:

Main Report->Detail Band->SubReport1->DetailBand->SubRepor2->DetailBand

There are three JITPipelines with Master/Detail relationships defined via
the MasterDataPipeline and MasterFieldLinks properties.

The problem is this,

On SubReport2, all the detail records are not printed all of the time. I
either get all the records or only one record for the detail band. The
JITPipeline reports the correct RecordCount, but only one record is
printed.

Help!

Thanks,

Dan...

Comments

  • edited September 2002
    Is Subreport2 connected to the second detail JITPipeline? Was this report
    working in a previous version of RB? When you trace into the OnGetFieldValue
    event for these details, what does it return as the value of the key linking
    field? There is a master detail JIT pipeline demo int he installation in the
    main reports demo project which you can compare to. If everything seems
    assigned correctly, then can you send us an example to
    support@digital-metaphors.com?


    Cheers,

    Jim Bennett
    Digital Metaphors

  • edited September 2002
    Hi Jim,

    Sorry it took so long for me to reply. I created a prject that isolates the
    problem and have forward it to support@digital-metaphors.com

    Yes

    No. This is a report created new in RB7. However, I opened the report in
    RB6.03 and it gives the same erroneous behavior.

    linking
    It returns the value of the key field from the MasterDataPipeline property.

    I started with the demos and worked from there.

    Thanks,

    Dan...


  • edited September 2002
    In case anyone is following along or comes across this question in a future
    search, here is the resolution from earlier this week.

    You need to set the detail JITpipeline's RecordCount property before the
    report begins printing. Only set this property once. Please see the main
    reports demo project report #139 which creates a master detail JIT report
    for an example. You cannot set the record count individually as the report
    generates, because the report engine will traverse through the entire JIT
    pipeline dataset as one dataset. The engine will track the individual detail
    datasets for a JITpipeline automatically.


    Cheers,

    Jim Bennett
    Digital Metaphors

This discussion has been closed.