Sub Report Question

S

Swarfmaker

I have a main report with 2 subreports , "subrptInternalTraining" and
"subrptExternalTraining"
This works just as expected. However, sometimes there is a blank sub report
as no training has been undertaken. In such a case I would like a label to
appear saying "No Training".
I've tried the following with no luck.

If IsNull(subrptInternalTraining) then
Me!Label8.visible = True
Else
Me!Label8.visible = False
EndIf

Any Ideas?

Iain
 
D

Duane Hookom

Use a text box with a control source like:
=IIf(subrptInternalTraining.Report.HasData,Null,"No records in Internal
Training")
 
S

Swarfmaker

Thanks Duane, works a treat!!

Iain
Duane Hookom said:
Use a text box with a control source like:
=IIf(subrptInternalTraining.Report.HasData,Null,"No records in Internal
Training")
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Suppress hard page-break if no data? 4
Using Subreports to create a Main Report 7
Suppression of name in a list 10
control on form from report 2
Sub report expands even though Can Grow is no 3
Show Label & Text Box in Report based on Checkbox 3
Variable Length SubReports 3
Problem with Report code 7

Top