Error message if no records found

[crimsntyd]

Hi,
I'd like to know how to display a message (either using VB or code inside the CR) telling the user that no records matched their parameter criteria when the report is finished searching and displaying. I've used the printingstatus.numberofrecordread function, but it only works when there are actually no records at all in the database for the parameter. I need something for when there are records in the database, but (for example) not in the date range specified. Any ideas?

 

[lbass]

You could create a formula in CR that you place in the report header:

if isnull({table.ID}) then
"No records matched your parameter selection."

You must choose a recurring field--one that would appear in each record of the report.

-LB

 

[crimsntyd]

I might try that. I also found that printingstatus.numberofrecordselected works well, too. Thanks.