Automatically Run Reports

[Justin Grigg]

I have a solution where I need to run reports overnight ( basic search for all entries for today, PDF them, and email) . I am currently using ical and applescript to trigger the reports, but am having issues with this solution. Any little issue will halt the applescript. I tried server side and it says that it ran the script, but it doesn't create the report.

Is anyone else having better luck with this??

[bcooney]

Unfortunately, FMS scripts cannot perform the Save as PDF. So, to set this up and walk away, you'll need a robot client that performs a script in a constant loop and pauses.

Is the requirement for a PDF absolute? If not, you could attach the records as a csv or excel file. How about a Snapshot link?