I have built an SSRS 2008 report that has a subreport. The subreport returns zero or one record. I want to hide the subreport if the number of rows in the subreport is zero. How do I accomplish that?
Apparently this is a very common SSRS problem and I could find several postings on the internet on the exact same problem. Non of of the solutions worked for me. I want to set the visibility of the subreport to an expression that will evaluate to true only if the count of records in the subreport is more than zero.
Since the the subreport cell is in the outer report, all parameters, report fields etc. in the expression builder are from the the outer report. That prevents me from checking the count of records in the subreport.
I'd like to do this without double querying the data the inner report queries.