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