Subreport with no results gives error | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Subreport with no results gives error

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.
The NoRows property should fix this, you supply a suitable string / expression to be returned
Graham
]]>