Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 8191 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

How do I script a report that is blank after finding 0 record in a query. My current output layout has a header but the preview is blank after the find. I would like to still print a page that reports no records in the find.

Posted

If (Status (CurrentFoundCount) = 0)

. New Record

. Set Field (SomeField, "No records found.")

. Print etc. etc.

. Delete Record

. Show All Records

End If

Posted

Another option:

If Status (CurrentFoundCount) = 0

Go to Layout "No Records Found Layout"

Else

Go to Layout "Actual Report Print Layout"

End If

Print...

Go to Layout (Original)

...where the layout you go to is a duplicate of the report you'd normally print, only with the "No records found" message hard-coded into the page. This will prevent mess-ups with auto-entered serial numbers, etc. when creating/deleting the faux record, if this is an issue for you.

This topic is 8191 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.