Reports with no records
Posted: Wed Oct 01, 2008 5:39 pm
We are using a filter to do a runtime selection of records that match certain user selection criteria. A minor problem we find is that, when there are no records that match the criteria, the report is coming up with some anomalies - missing headings, partial headings, a link to a static dbf table doesn^t work. What we would like is to have a nice, simple user friendly message such as "No records were found for the selected date" or some such thing, maybe by using a calculated field and looking for record count = 0. However the calculated field doesn^t work either when there are no records. So all the user sees is this very confusing result with no data and a corrupted looking report template.____Is there any way to produce some sort of user friendly message simply stating that no records match the selection criteria.____thanks__