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

Suppressing detail band if sub-report has no records

edited September 2001 in General
I am looking for some guidance in trying to suppress the detail band of a
report if a sub-report in that band returns no records.

There are three pipelines in the report, the main one and two others - each
of which is used to populate sub-reports placed on the detail line of the
main report. I want to supress the main report detail line if one of these
sub-reports returns no records (the other sub-report always returns
records).

I have tried various approaches, but nothing seems to work. I don't seem to
be able to find any property of the sub-report object in the detail band,
that allows me to determine whether or not it returns data, so that I can
supress the detail band.

This is an end-user report, with access to RAP, but no access to the
application code, so the related sample dealing with this issue through
Delphi unfortunately won't help.

At the moment I am achieving the result I need by having a seperate
sub-select in my main pipeline which tests for ny data returned by the query
used in the subselect, but this is obviously very inefficent as it means
that the sub-select query is in effect being executed twice for every row in
the main pipeline.

Suggestions for a better solution would be much appreciated.

Justin Willey

Comments

This discussion has been closed.