How to find out if a subreport has data

I have a report and a subreport.
I have a toggle on the report that I want to show/hide based on whether
or not the subreport has data.
Does anyone know how to do this?
Thanks in advance!
ShaneImplement the following way:
Say u have subreport 'Report1' and main report 'Report'
1) Apply visibility condition in the subreport 'Report1'
2) Now use that subreport 'Report1' in ur main report 'Report'.
Regards,
SaraS|||Thanks Sara. I'm wondering how to set the visibility condition.|||shane.eckel@.seattlesoftware.com wrote:
> Thanks Sara. I'm wondering how to set the visibility condition.
I haven't tested it myself, but you should be able to set the NoRows
property in the cell (i.e. textboxN) holding the subreport to "NODATA"
and then set the visibility expression to
=(textboxN.Value="NODATA")|||Thanks for your reply, however, the problem I'm having is with
indicating whether or not the subreport has data. The visibility issue
is secondary. Does anyone have a specific way of determining if a
subreport has data?
Thank you in advance.|||SleepLab did answer your question from the way you initially asked it and
also mentioned how to tell if you have no data. The subreport is based on a
dataset, right? So set the NoRows property on the dataset the subreport is
tied to ... when the query is run it will trigger whatever you put in NoRows
to occur. Unless I am missing something I still think the NoRows property on
the subreport is your answer.
"shane.eckel@.seattlesoftware.com" wrote:
> Thanks for your reply, however, the problem I'm having is with
> indicating whether or not the subreport has data. The visibility issue
> is secondary. Does anyone have a specific way of determining if a
> subreport has data?
> Thank you in advance.
>