User input report criteria

[Kukuberra]

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

[LiveOak]

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

[Kukuberra]

Thanks! That looks like it should do it. I was thinking too complicated and trying to use the IFEmpty calculation

Kuku

[Kukuberra]

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

[msagris]

Hi Kuku,

Try replacing the "Set Field" step with:

Insert Text[select,Date,"="]

It worked for me!

Mart

[Kukuberra]

Thanks for all the help, today I got it to work. I redid it from scratch and had no problems. There might have been typos or something before! Thanks for the help eveyone!

Kuku