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

Detecting if subreport is empty

edited June 2001 in General
I have a report that contains two subreports (master/detail relationship).
How would I go about hiding certain labels, regions, and/or shapes on the
report if one of the subreports is empty (contains no records)?

Comments

  • edited June 2001
    Use the NoDataBehaviors property of the report. For a subreport, try
    setting this property to BlankReport.


    Cheers,

    Jim Bennett
    Digital Metaphors


  • edited June 2001
    Thanks Jim...

    I had the NoDataBehaviors property of the subreports set to BlankPage, but
    changed them to BlankReport. However, that was pretty much working ok as the
    subreport was not not showing at all if there was no data. The problem is
    that I want the MASTER report to show or not show certain items (not
    contained in the subreport's area) based on whether or not the subreport had
    data. Do you understand what I mean?

  • edited June 2001
    Set SkipWhenNoRecords to true on the detail datapipeline. This is in the
    help file for the datapipeline.

    When linking in DADE, double mouse-click over the link to bring up the link
    dialog. An option should exists for this functionality.


    Cheers,

    Jim Bennett
    Digital Metaphors


This discussion has been closed.