RCheesley
Registered User.
- Local time
- Today, 12:07
- Joined
- Aug 12, 2008
- Messages
- 243
Hi all,
I've done a bit of searching but all the answers I am finding relate to a report, and not a sub report.
I've got a report set up which is working perfectly, it has several sub-reports running off their own queries and whatnot.
I've set the reports to can grow/shrink yes, which is great.
What I would like to be able to do, is if the sub reports have no data to return (for example if the record being queried has no entries in a particular table, which is quite likely) that rather than leave the heading and a blank section, it prints "No Records Found".
Is there any way to do this in VBA or some such? Note this is for a SUBREPORT linked via child/master on PatientID.
I've done a bit of searching but all the answers I am finding relate to a report, and not a sub report.
I've got a report set up which is working perfectly, it has several sub-reports running off their own queries and whatnot.
I've set the reports to can grow/shrink yes, which is great.
What I would like to be able to do, is if the sub reports have no data to return (for example if the record being queried has no entries in a particular table, which is quite likely) that rather than leave the heading and a blank section, it prints "No Records Found".
Is there any way to do this in VBA or some such? Note this is for a SUBREPORT linked via child/master on PatientID.