Default message if report returns no rows that match criteria

j2associates

December 17, 2019 20:51

None

Hello all,

If a given Jet Report returns zero rows because nothing matches the criteria, is there anyway to display some kind of a message notifying the user of the same? Maybe something like 'No matching records found.', or some such.

Date Votes

1 comment

0

Harry Lewis December 17, 2019 21:14

You could copy your NL(Rows) function, change it to an NL(Count), and then embed it in an Excel IF() function.

Like this:

Comment actions Permalink

Please sign in to leave a comment.