Supress a section

[keeno]

Hello

How can I write a formula or whatever is needed for the following:

When a section doesn't return any data i want to display a message saying: 'No Data Received Today'.

Can someone tell me how to do this

Thanks

David

 

[GretaD]

Hi

There is an option in the section expert that says supress if blank section. I guess you can use this to supress the section if it returns no data.

To display the message you maybe can create a new section below/above the section that returns no data, and add a text field here with the error message. In the section expert write the following code on the supress button "not isnull({field from the section that can be empty})" that way you only display the section when the field is null. If you don't want to add a new section you can just add the text-field to one of the other sections and write the same code on the supress button of the text-field.

hope this helps
Greta

 

[faisalsham]

try using this:

if len(tablename.field) = 0 then
"no data received today"
else
tablename.field
end if