How to schedule R&R to write a simple file in CSV, DBF or XLS every day automatically?  

George Schaefer GPS Financial

=======================================================================

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

Please let us know what info we can send you now and what are the areas that are of most important to your organization.
 


Please fill in below, or call us on (714) 228-5444 or fax us at (800) 531-2944...

First Name :
Last Name :
Title :
Organization :
Work Phone :
FAX :
E-mail :                                          
URL / Website:
Number of Concurrent Users:  

What info can we send you?

 

email us at sales@CougarMtnSupport.com  //  phone (714) 228-5444.

(We are not Cougar Mountain Software in Boise, we take their excellent product and make it better.   We offer software products, enhanced reports, services, training and hardware that maximize the value out of this powerful accounting program.  We have been customizing solutions for Cougar Mountain since 1990.  We are located in California.