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

Problem with jitpipeline and subreport

edited September 2008 in Datapipelines
Hi,

I have a coded report with 2 pipelines, one master, one detail, linked
on 3 fileds.

The report itself has 3 groups, on de 3 link fields.
The subreport is in the footer of the 3rd group.

The data is loaded in lists, one for the master, one for the detail.

Everything goes fine on my report except when one of my master record
doens't have any data in the detail report.

The Subreport of the last record to have data shows everything for all
the other not yet printed records, with then get printed without
subreport.

It's like the link between the master and detail pipeline was not
working. I'm expecting an empty subreport when there are no data...

The GetFieldValue function returns a "null" variant when no detail
data is found...is this goed?

Chantal

Comments

  • edited September 2008
    The main reports demo includes an example of a master/detail JITPipeline
    report.


    No that is not correct. The detail data must be ordered by the linking
    field(s). Your JITPipeline GetFieldValue event-handler code should return
    the value of the data corresponding to JITPipeline.RecordIndex.

    For the detail Datapipeline, you need to set SkipWhenNoRecords to False, to
    include the master records that do not have corresponding detail, otherwise
    by default the master records will not appear in the report.



    --
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited September 2008
    My master pipeline and detail pipeline are sorted on the same 3 link
    fields.
    SkipWhenNoRecord is already set to False.
    I've look al the examples of master/detail with sub report and I don't
    see what wrong with my report.

    It's works goed for 10 pages, then flushes all the data of the detail
    set onder one master record and then goes further with the rest of the
    report and an empty detail pipeline...

    When the master and detail are linked on specific fields, I assume the
    link fields are checked when the subreport has to be printed and that
    nothing get printed when no data matches the masters link field
    values? This is not somethine I have to manually check?

    My detail pipeline simply returns the value of the table for position
    DetailPipeline.RecordIndex...

    I canno't seam to find why it works 95% of the time and sometimes
    not...

    Chantal

    On Tue, 30 Sep 2008 10:21:15 -0500, "Nard Moseley \(Digital
  • edited October 2008
    It works now, but I don't really understand why.

    My first link field was "Company Name". A string field.
    The data of both the master and detail pipelines are sorted on company
    name, and my first report group is company name.
    I worked when I selected only one company, but not when I selected
    more than one.

    I switched this to "Company ID", an integer, sorted everything on the
    new field, linked on it, group on it...now it works al the time...

    There is no rule against linking on string field is there?


    Chantal

    On Tue, 30 Sep 2008 10:21:15 -0500, "Nard Moseley \(Digital
This discussion has been closed.