I have a series of reports that print consecutively for hours and automatically email themselves to the appropriate parties. Right now if a recordset is empty the report says "error". I can cancel the event using the OnNoData property but that halts the flow. Does anyone know of way to print the report headers and replace the detail line with a message stating something like "This report has no records"? or even replace the entire report with just a message. Stating "The xxx report contained no records?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
On No Data print report header and a message
- Thread starter dpedley
- Start date
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Question
- Question