No Records Found Type Message

[tmozer]

When a user enters a Parameter that results in no records (a blank report), how can I create a formula that prints a helpful and/or informative message?

 

[lbass]

Create a text box with the required message and place it in the report header and then go to format->text->common->suppress->x+2 and enter:

not isnull({table.field})

You could use any recurring field in the formula (one that is populated whenever the report is run). For this to work you must not have the following checked in file->report options: "Suppress Printing if No Records."

-LB

 

[synapsevampire]

I would suggest doing this as a normal action to always show users what they had selected. I do so in every report.

If you have a range parameter, then use the appropriate formula.

For example with a date you might use:

minimum({?DateParm}) & " thru "& manimum({?DateParm})

If you post specifics you'll get specific solutions.

-k