Script to Run Report Blank

[TaiChi56]

I am using FileMaker Pro 12. I wrote a script to look at a field and if the value is less or equal to .70 it will run the report. I have it set to Auto open an EXCEL spreadsheet. When the script runs I see that it finds the records but then my EXCEL spreadsheet is empty. Here is the script:

Perform Find [Restore]
Save Records as Excel["TotalAttendance.xls";Automatically open;Records being browsed]
Go to Layout[original layout]
Show All Records

In the Perform Find [Restore] I have the following coded:

Find Records	PersonnelRecords::PercentDaysAttended:[<_ .70]

That is suppose to be less than and equal to. Did not know how to show it with the keyboard.

[bcooney]

Looks like a path issue to me. Add:

Set Variable ( $path ; get(temporary path) & "TotalAttendance.xls")

Save Records as Excel ($path ; auto open, records browsed]

 

 

[TaiChi56]

Thank you. 

[bcooney]

Did it resolve the issue?

[TaiChi56]

Sorry. Yes it took care of the problem. Thank you again.