Jump to content

User input report criteria


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

Recommended Posts

I have a report that needs to be run base on information in two different fields. The two basic fields that have the data in them is a text field and a date field. I need the user to input the information in the text field and then the report takes that and finds every record that has that but has the date field empty.

Any help would be great.

Kuku

Link to comment
Share on other sites

If your question is what the script looks like to accomplish this...

Allow User Abort (off)

Set Error Capture (on)

Go to Layout ("put you layout for the user entry here")

Enter Find Mode (pause) <-- User enters text field, uncheck "restore"

Set Field (Date, "=") <-- this finds a blank date

Perform Find ()

If (Status (CurrentError = 401)

Show Message ("No records were found", "OK")

Go to Layout (original layout)

Show All

Else

Go to Layout (Report)

Page Setup (Restore)

Sort(Restore)

Print()

End If

-bd

Link to comment
Share on other sites

O.k. that didn't do it. Everything about the script works fine except for the Set Field step.

Set Field asks to specify a field as well as specify a calculation for that field. You can do either or both. I'm guessing I'm simply combining them wrong but nothing I've tried has worked.

What exactly gives you Set Field (Date, "=")

Thanks

Kuku

Link to comment
Share on other sites

This topic is 7288 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
 Share

×
×
  • Create New...

Important Information

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