Report Running for Cougar Mtn Software

For Cougar Mountain Software Support's
Professional Version (V2012, V2011, V2010, V2009, V12-V6)

Energizing your decisions ~ Call 714-228-5444 for more information

Below are the major techniques for running an CMS/R&R report outside of CMS program

Create a normal Windows ShortCut to the appropriate RRW file. If R&R has been loaded on this PC, this will bring the report to the screen in edit mode. To run it click on the print, preview or export icon. Since this has been run outside of CMS, it hasn't gotten the normal file locations and other parameters. To effective, the masterfile and relationships have to manually changed to a specific company's files. It maybe necessary to add RRparameters to replace things like date range, etc. In my opinion, this technique is best used to make it easy for someone to be able to edit a document like an OE invoice.
The second technique is to use the RRWRUN.exe command in a batch file like

c:\cmswin\rrwrun.exe c:\cmswin\laser\Your_Report.rrw

As in technique #1, you need to change the data paths to your client's data path and add RRparmeters for any questions/ranges that are needed. So if you open an existing report, change the master table and relationships to your clients files, add RRparameters to replace the options that CMSRUNIN.dbf passes to the report, save it as Your_Report.rrw and then launch it with the command above, you've got it.
Technique four, is the same as technique 2 except you build the equivalent of CMSRUNIN.dbf to pass the parameters to the report

c:\cmswin\rrwrun.exe c:\cmswin\laser\Your_Report.rrw c:\cmswin\Your_Report_Runin.dbf
Technique five, is also similar but you build everything in your own version of CMSRUNIN.dbf and a row number

c:\cmswin\rrwrun.exe c:\cmswin\Your_Report_Runin.dbf 1

The number 1 is the instruction to run the report on line 1 in Your_Report_Runin.dbf
The fifth technique is to use the RRWICON.exe to create an icon to run the report. This gives you the ability to modify the output destination, manually modify the Query options (but not in a user-friendly way for a "normal" end-user), and a few other things. As in technique #1, you need to change the data paths to your client's path and add RRparmeters for any questions/ranges that are needed.
The sixth technique is to the use the RAPIDRUN.exe.   To use this program you need to set up a batch file like:

C:\Program Files\RRVer10\RapidRun\RapidRun.exe" "C:\My Documents\Rapid
Runner Sets\Daily.set" /run

The Rapidrun program is the most powerful of these techniques including the following features:

- Change the file locations and names from the DMO data set to a company's data set
- Change Report Destination
- Change Parameters
- Consolidate Multiple files into one report (eg. Sales History from 2 different company codes)
- Schedule reports to run automatically
- The set commands are simple text files that can be easily copied, renamed and edited with Notepad

The downside is that you must determine the link key names for the Masterfile and Related file from CMS's version of the reports or from the Stucture files.

So in summary, Technique #2 and #6  are the easiest to use.    Technique #4 as the most promise for working with lots of reports.

Naturally, there are additional abilities and features that I didn't cover.   There are PDF files on the R&R CD that covers each of these techniques in much more detail.

George Schaefer
george@CMStotheMax.com