how to display a string as a note

[unknownly]

Hi All,


My users are asking to display a note like
"No data is Returned" when there is no records for the given input from the database.

Right now my report returns empty. But I still show them the paratmeter input values using a subreport.

How can I do this. Is it possible to trigger a string to be displayed in the report. when no records are returned from the database.

Any ideas are greatly appreciated.

Thanks in advance,

Sweetie

 

[unknownly]

using CR ver 8

 

[lbass]

You can create a text box with the message "No Data is Returned" and then go to format text->suppress->x+2 and enter:

Not isnull({table.ID})

//where {table.ID} is a field that appears in every record.

-LB

 

[MJRBIM]

1.) Insert a Text Box of "NO RECORDS FOUND" in the Report Footer.

2.) Use the Section Expert to Suppress the Report Footer section based on the formula -

Count ({Table.Field}) <> 0

**you'll need to insert a {Table.Field} from your report data into the formula.

 

[unknownly]

Thank you for response.

I have tried both the ideas.
and
Not isnull({table.ID}) worked fine



Thanks,

Sweetie

 

[synapsevampire]

The only problem with the isnull method is that you might eventually have a valid null in the field used to test (I was burned this way), whereas the count will never return 0 if there are rows.

-k