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

Supress section printing

edited August 2003 in General
Is there a way to supress a section from printing when the section contains
no data?

I need to develop a report that will have various sections and supress the
sections that do not contain data.

I am using the report server to serve up the reports (RTM files). I would
prefer to place all coding in the report (via RAP).

Thanks,

Bill Geoghan

Comments

  • edited August 2003
    Hi Bill,

    Try setting the DataPipeline.SkipWhenNoRecords property to True. This will
    suppress the printing of any records that contain no data. This property
    can be set in code or manually using the Object Inspector while selected on
    the TppDBPipeline of your choice.

    --
    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited August 2003
    Where do I place this within RAP? Since the Report server is loading and
    producing the report, I do not have easy access to DataPipelines in the
    various sections of the report. I attempted to place the following code in
    the BeforePrint event (RAP) of the main report :

    Air.DataPipeline.SkipWhenNoRecords := true;

    The report is still generating a blank page for the Air section that
    contains no data.

    I also need a way to suppress the Outline Nodes. I seen that there is an
    OnOutlineNodeCreate event where I can accept/deny a node, but I can seem to
    determine how to know that no records exist for this given node.

    Any help would be greatly appreciated.

    Bill Geoghan




  • edited August 2003
    Hi Bill,

    This should work correctly in RAP. Be sure you are suppressing the Detail
    datapipeline. If possible, please send a small example demonstrating the
    issue in .zip format to support@digital-metaphors.com and I'll test it.

    --
    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.