How can I hide subreports if they contain no data?

I have a report which has 3 subrepor开发者_运维问答ts. In the case of no data I want to hide the report. It's giving me this error:

Error: Subreport could not be shown

How can I hide the subreports?

You are going to have to create some mechanism of knowing whether or not a subreport will successfully be shown on the main report because you aren't going to be able to "return" anything back to the main report from the subreport.

Could you create a small dataset on your main report that would query to check if data will exists for the subreport? and then you could use an expression on the subreport element (or container such as tablix or rectangle) to hide it based upon the results of the query on the main report.

Let me know if I need to clarify.

if we directly create a dataset in the main report itself then there is no question of using another report as a subreport we can directly use the fields from the data set created in the main report and assigning parameters to main dataset values. i think that will not server purpose.