Show Text if DB date = Blank

[Bentk]

I have a report that often times is blank. I need to have it return a statement 'There are no widgets sold for this date range'. I need to supress this line when no information is returned from the DB.

 

[lbass]

Try creating a formula to place in the report header:

if isnull({table.widget}) then "No widgets sold for this date range." else ""

-LB

 

[Bentk]

Thank you. That worked like a champ!
-Bentk