Reports with Subforms

[giacomo1]

Ok Gang...here we go!

Let me begin by saying I know there have been postings on this....I have read them, however, I cannot get it to work!

I have a report with 4 subreports based on different queries. When there is no data for the report the subreport does not display itself. I have tried using the no data event and making it visible...I have tried the HasData property....none work...for me at least. I need to have the subreport display and txtData (a currently invisible textbox) display "There is no data for this section of the report!" I need as much detail as possible! Help!!!!!!!!

Thanks,

Frustrated Giacomo

 

[Rich]

=IIf([SubReportName].[Report].[HasData]," ","There is no data to display") as the control source for a textbox

 

[giacomo1]

That did not work...any suggestions?? I appreciate the help!

Thanks

 

[Rich]

The example I gave you will display the text (There is no data to display) if the subreport has no data, you need to check the name of your subreports and of course make sure the control's visible property is set to yes, other than having some dummy data in the query, I know of no way to make the SubReport visible