Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Printing report if No rows retrieved

Status
Not open for further replies.

jeannie322

Programmer
May 18, 2001
25
US
Hey is there a way to have the report print out 0, or something other than nothing when there are no rows returned from my query??
Is there something that I can set to tell it to print a value (like "no rows returned") when no rows are retrieved from the query???

Thanks in advance!
 
Have you tried a "before report" trigger to see if there are any records selected and if none then use srw.message?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top