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??

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?