Problems with empty 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.
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.
This discussion has been closed.
Comments
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
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.
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