Reports With No Records

[OzzieOwl]

I am creating reports for non technical users, does anyone know how to get Crystal to flag up "No Records on Search" if the report returns nil records ?????

Thanks in Advance

Martin

 

[goranm]

Hi !

You can place a formula like this one in the Report Footer:

if isNull(Count ({id.field})) then
'No Records on Search'

/Goran

 

[BCrystal]

You can do this by inserting a text object which displays 'No Records Found'. You can then conditionally suppress this text object when the report does return records.

To display 'No Records Found' for reports with no records:

1. On the Insert menu, click 'Text Object'.

2. Type "No Records Found" in the text object, then press Enter. Move this text object so the message is in a prominent position.

3. Right-click the text object, and click 'Format Field'.

4. Go to the Common tab, and click 'X+2' beside the 'Suppress' check box. This opens the Conditional Formatting Formula Editor.

5. Type this formula:

Not(Isnull(Count({Table.Field}))) or
Count({Table.Field}) > 0

//Replace {Table.Field} with
//any database field in your report

· Check and save this formula.

· Click 'OK' to return to the report.

The next time you refresh a report that returns zero records, you will see a 'No Records Found' message.
Suppress page header on the last page
HTH
Bryan