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

SubReport not Printing

edited November 2004 in Subreports
Hi All,

I have a report that I'm porting from one application to another. The
report has two subreports on the detail band. The first subreport
isn't printing but the 2nd is. The 2nd one has a ShiftRelativeTo set
to the first. I've compared all the settings I can think of between
the two applications and I can't figure out what I'm missing. Can
anyone give me some ideas about what settings would prevent a
subreport from printing?

Thanks,
Steve

Comments

  • edited November 2004
    Hi Steve,

    1. Check that the subreport is connected to a DataPipeline and that the
    DataPipeline is correctly connected to valid data in your dataset.

    2. If you are creating a Master\Detail report, be sure you are linking on
    the correct field and that your detail dataset is ordered on that field.

    3. Be sure the Subreport component is visible and set to be a Child
    Subreport.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited November 2004
    Thanks Nico,

    The DataPipelines are connected. The master pipeline is connected to
    the TppReport Object, the 2 detail pipelines are connected to the two
    sub reports which reside on the detail band. There is one group that
    is keyed on the primary key of the master table.

    The primary key for the master table is the masterfields property of
    the two detail tables. All three tables (master and both details) are
    ordered with the same field that is the masterfields property.

    Both subreports are of type pbChild.

    What else should I look for? Would it help if I sent you an RTM file?

    Steve

    On Tue, 2 Nov 2004 08:12:45 -0700, "Nico Cizik \(Digital Metaphors\)"
  • edited November 2004
    Hi Steve,

    Have you ever been able to see data from this subreport? Are you sure this
    master\detail relationship is infact returning any data? If you create a
    simple example consisting of a main report , subreport and two datapipelines
    linked in the same master/detail relationship as the one in your main app,
    are you able to see any data? As a test, try placing a static shape or
    label inside the subreport and then set its NoDataBehaivors to
    ndBlankReport. If the shape shows up without any data, this means that the
    query is returning no data.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited November 2004
    That was it! Thank you very much. I was populating the key field in
    one of the detail tables with the wrong value.

    On Tue, 2 Nov 2004 10:47:22 -0700, "Nico Cizik \(Digital Metaphors\)"
This discussion has been closed.