Product Ideas

Share your suggestions and ideas. Vote on ideas you find valuable.

Provide a way to display a message if the selected report filters result in no rows being selected

We have production oriented reports that behave badly when no data is retrieved. There is never production on the weekend so we can control it with the native Jet Scheduler. But on holidays like Thanksgiving there is no data returned during the week. So we end up putting a lot of extra "@@"& on formulas just to handle this infrequent situation.


It would be great if there was an option in the NL Rows and Sheets to allow a message to be displayed when no rows are returned, maybe something like =NL("Rows","Table Name",,"Filters=",$B$3:$C$5,"No Data Message","No data displayed")

  • Gary Winey
  • Nov 25 2022
  • Attach files