Formula to check for no returned records?

[mbeech]

In CR 10, instead of receiving an "empty" report when there are no records returned, I would like to know if there is a formula I could write that will print something on the report (e.g. "No Sales for Month") even when there are no returned records for a report.

 

[lbass]

Please see thread767-1160632.

-LB

 

[synapsevampire]

This is often accomplished by creating a seperate Report Header, which is conditionally suppressed based on whatever criteria works for determinging that no rows were returned. Be careful about using recordnumber as you may find it shows 1 when there are none with some databases.

You might check for a field that could never be null, as with LB's example in the referenced thread.

You can also have Crystal not display the report at all when no rows are returned by selecting the File->Report Options->Suppress Printing if No Records Selected.

-k

 

[mbeech]

Thank you for the response. My scheduling software requires that a report instance (with at lease one record) be created before it will replace the old report instance. Is there a crystal formula that will return one record for a report, even though no records from the database have been selected due to the parameter? Will recordnumber work?