SQL Server Performance

Subreport with no results gives error

Discussion in 'SQL Server Reporting Services' started by ronl, May 4, 2004.

  1. ronl New Member

    I have inserted a subreport into a report and it displays results fine, except when there are no results in its dataset. It then displays "Error: Subreport could not be shown" in the cell. Is there a way to eliminate this message, leaving a blank cell?
    Thanks.
  2. gpl New Member

    The NoRows property should fix this, you supply a suitable string / expression to be returned
    Graham

Share This Page