Reports with no records

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
Whitnezglugs
Posts: 0
Joined: Tue Mar 13, 2018 1:10 am

Reports with no records

Post by Whitnezglugs » 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__

Whitnezglugs
Posts: 0
Joined: Tue Mar 13, 2018 1:10 am

==> RE: Reports with no records

Post by Whitnezglugs » Thu Oct 02, 2008 8:03 am

Thanks, but I can^t find the "Type" tab. __In the band line properties there are options for Logical Field, New Page Line, line height, but no Type tab. Am I looking in the wrong place?__We are using ver. 9 for XBase.

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Reports with no records

Post by kfleming » Thu Oct 02, 2008 9:23 am

Create a title band with a text field that says No records found that match your criteria and then set the properties of this band line to Print only when no records are found. There is a checkbox on the Type tab that lets you set this for title band lines.____Kathleen__R&R Support

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

===> RE: Reports with no records

Post by kfleming » Fri Oct 03, 2008 8:04 am

We added this feature in a later release so you would need to upgrade to make it available to you.____Kathleen__R&R Support

Post Reply