S
selesti
I've read through several threads on here, thescripts.com, and Allen
Browne's site and although I've seen several related situations I still
can't quite seem to get this to work.
I have a report that spits out a single job's detail (the job number is
a parameter in the query the report runs off of), and it has several
subreports that may or may not have data in them, depending on the job.
not appear on the report. This is good. However, I am trying to turn
visible a hidden label behind the subreport if there is no data, and so
far it's not working.
I first tried on the subreports "On No Data" adding this event
procedure:
Reports!PreJCAnalysis!Lab_NoUnion.Visible = True
I tested the procedure syntax and it works, but for some reason isn't
working when I run the report.
I then tried to put the code in the Report_Open of my main report,
using
If Me!PreCrewSub.Report.HasData = False Then
!Reports!PreJCAnalysis!Lab_NoUnion.Visible = True
Else
!Reports!PreJCAnalysis!Lab_NoUnion.Visible = False
End If
Even with several variations, I keep getting Run-time error #2455 - You
entered an expression that has an invalid reference to the property
Form/Report.
Pointing to the first line. I feel like I'm missing something obvious
- any help would be greatly appreciated, thanks.
Browne's site and although I've seen several related situations I still
can't quite seem to get this to work.
I have a report that spits out a single job's detail (the job number is
a parameter in the query the report runs off of), and it has several
subreports that may or may not have data in them, depending on the job.
data (based off of a query that finds nothing) then it completely doesFrom what I've read and experimented, if the subreport doesn't have
not appear on the report. This is good. However, I am trying to turn
visible a hidden label behind the subreport if there is no data, and so
far it's not working.
I first tried on the subreports "On No Data" adding this event
procedure:
Reports!PreJCAnalysis!Lab_NoUnion.Visible = True
I tested the procedure syntax and it works, but for some reason isn't
working when I run the report.
I then tried to put the code in the Report_Open of my main report,
using
If Me!PreCrewSub.Report.HasData = False Then
!Reports!PreJCAnalysis!Lab_NoUnion.Visible = True
Else
!Reports!PreJCAnalysis!Lab_NoUnion.Visible = False
End If
Even with several variations, I keep getting Run-time error #2455 - You
entered an expression that has an invalid reference to the property
Form/Report.
Pointing to the first line. I feel like I'm missing something obvious
- any help would be greatly appreciated, thanks.