if subreport has no data, then show label only (1 Viewer)

[krberube]

Hi all,
I have a report with an embedded subreport. When the linked field is null in the subreport ( but the info is in the main report) I want the subreport to show only a label that says "no data". So i will see the report with the summary data on the top and " no data" on the bottom.
Does this sound possible?

Thanks
Kevin

 

[krberube]

I have found some posts on this, it seems to be using the hasdata property.
Now my question is, Where is this?
Is this the same as the "on no data" event in the report properties?

whats the syntax to show a label of " no data" (label35) when there is no data?

 

[krberube]

I found this from RICH,

=IIf([yourSubReport].[Report].[HasData]," ","NONE") as the control source for your textbox

I put in my report name, subreport name and when i run it, what displays is
#Name?

Whats up with that?

 

[krberube]

ok, solved my own problem by looking alittle more.

=IIf([for service subreport].Report.HasData," ","No Service History")
works great.