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

Problems with empty subreports

edited January 2004 in Subreports
Hi all,

I have a Main Report with 2 subreports.
Each one has his pipeline associated to queries.
The link Master/Detail is made at the queries level.

On the detail band of the master, I have put a region containing the data of
the master and the two subreports.
When the 2 subreports are empty (ie the SQL returns no row), the detail band
is not printed even though it contains the data of the master.
If one (or the two) subreport contains data, the detail band is showned.

I have read the other threads about this, but it does not help.

SkipWhenNoRecords is set to False in the pipelines.

When I code the OnNoData event, it is fired, but the components are not
printed.

Any idea ?

Patrice.

Comments

  • edited January 2004

    Setting SkipWhenNoRecords on the detail datapipelines should enable the
    master record to be printed.

    As a test try commenting out all event-handler code that is associated with
    the report.

    If you are not using RB 7.03, try downloading a trial version from our web
    site and perform the same test.

    If you still have an issue, try creating a simple example using the DBDemos
    data. If you can recreate the issue, then e-mail to
    support@digital-metaphors.com in zip format and we can check it out here.


    --
    Nard Moseley
    Digital Metaphors
    http://www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited January 2004
    Good news Nard,

    I discovered that the manner I grouped my data in the main report, was not
    correct.
    The underlaying DB SQL view has evolved and I forgot it. (different field in
    ORDER BY clause)
    So, the problem of the band that disapeared on the main report is now fixed.

    The second one, concerning the value '-' when a subquery returns no row is
    not yet fixed.

    I use Delphi 7 + RB 7.03 standard, registered user.

    Thanks,

    Patrice.


  • edited January 2004

    Like I said, when I try it here it works for me.

    If you still have an issue, try creating a simple example using the DBDemos
    data. If you can recreate the issue, then e-mail to
    support@digital-metaphors.com in zip format and we can check it out here.



    --
    Nard Moseley
    Digital Metaphors
    http://www.digital-metaphors.com

    Best regards,

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