FAQ

Frequently Asked Question
Subject
Report runs at workstation but not scheduled
Question

I'm using a very basic template for a report and if I run it manually it works Ok and uses the template I've defined / attached for the applicable report.
If I shedule it, it does not work and the log has the following detail.

------------------------
0:34:56 AMgr: Agent ('Process Scheduled Reports' in 'Reporting\ExportWiz2_5k.nsf') message box: Please check sheet names in your template! Sheet Database Report is an invalid or non-existent Excel Sheet supplied in Excel Options 18/07/2003 10:34:56 AMgr: Agent ('Process Scheduled Reports' in 'Reporting\ExportWiz2_5k.nsf') message box: The following errors occured: Class Report: InitialiseOutputOptionsExcel Error = Microsoft Excel: ' ~e98awz71.xlt' could not be found. Check the spelling of the file n

Reports' in 'Reporting\ExportWiz2_5k.nsf') message box: Please check sheet names in your template! Sheet Database Report is an invalid or non-existent Excel Sheet supplied in Excel Options 18/07/2003 10:39:56 AMgr: Agent ('Process Scheduled Reports' in 'Reporting\ExportWiz2_5k.nsf') message box: The following errors occured: Class Report: InitialiseOutputOptionsExcel Error = Microsoft Excel: ' ~ssvdyhl1.xlt' could not be found. Check the spelling of the file n

Answer
The server must have a system (not administrator) environmental variable called TEMP. It must be set to a valid directory. ExportWiz uses that directory for temporary files. In windows 2000 or NT 4 this is set in “Control Panel” – “System” – “Advanced” – “Environmental Variables” – “System Variables”