Print "No Records found" Report for Empty Cursor Table

[rooship]

Hello,
I am trying to print a report with "No records found" message if the cursor is empty. I searched the forum, and found a few suggestion to create a seperate report.
Is there anyway that I can use the same report to print the message "No records found" in the summary band?

Thanks for your help,
Rooshi

 

[Mike Gagnon]

A report needs at least one record to print. If you find no records that meet the criteria, create a cursor with a single record in it.

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[Mike Lewis]

Rooshi,

I answered this question is thread1252-1090129

To whom it may concern,

Please don't delete my reply in the above thread. It took me some effort to write it. If you must delete something, delete this message.

Thank you.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My sites:
Visual FoxPro (www.ml-consult.demon.co.uk)
Crystal Reports (www.ml-crystal.com)

 

[SGLong]

To expand on Mike's response, your report form will need to have a field that can be appropriated for the "Nothing to report" text.

IF RECCOUNT('myfile') = 0
   INSERT INTO myfile (sometextfield) VALUES ("Nothing To Report")
ENDIF

Steve