SQL Server Performance Forum – Threads Archive
Subreport with no results gives errorI 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?
The NoRows property should fix this, you supply a suitable string / expression to be returned