Here's how I do it:
1. You can use Windows Scheduler if you have a password
specified for your
user login. However, I use this free program which is
easier to use:
http://www.americansys.com/ezscheduler.htm
2. In notepad, create a text file called
MyReportName.RRS where
"MyReportName" is the name of the .RRW file.
3. In the RRS file, enter the following text, replacing
the file names as
desired:
RI_REPORT=X:\MyPath\MyReportName.RRW
RI_PRINTER=CSV
RI_OUTFILE=X:\MyOutputPath\MyReportName.CSV
RI_STATUS=T
The above example outputs to CSV. There is no XLS
format, but Excel reads
CSV files.
To output a report to a worksheet or Xbase file, specify
W or X,
respectively, as the RI_PRINTER value and specify the
file name as the
RI_OUTFILE value. If you do not specify a file
extension, R&R appends .WKS
to worksheet files and .DBF to Xbase files.
FYI, The P value in RI_PRINTER specifies that the report
be sent to the
printer saved with the report or specified as the
RI_WPTR value, even if the
report's saved destination is a file.
You can find the documentation for thee and other
runtime options in the R&R
online help file rrwrun.hlp under the topic named
"Parameters for Modifying
Report Characteristics" (or rswdev.hlp depending on
which version of R&R you
have).
4. In EZScheduler add a task and for the name of the
program to run, enter a
pathname for the RRS file as in the following example,
including the quotes:
"X:\MyPath\MyReportName.RRS"
Hope that helps,
Rob
rob@plan-be.com
|
