REPORTER (OpenInsight Specific)
At 03 FEB 1999 12:07:45PM RUSSELL ALLEN wrote:
NEED INFO ON HOW TO RUN REPORTER FROM A MENU ITEM.
At 04 FEB 1999 09:07AM [email protected] - [url=http://www.sprezzatura.com]Sprezzatura, Inc.[/url] wrote:
From the Reporter on-line help, Starting Revelation Reporter.
Revelation Reporter can be started from the File Manager command line (choose Run from the File menu). The following table lists the run command line switches that can be invoked from the command line.
The command line switches /AP, /UN, and /PW must be entered immediately after the REPORTER.EXE. The sequence of other command line switches is not important.
For example, to launch Revelation Reporter and open a saved report from the demo application, the Run command might look like this:
C:\OINSIGHT\REPORTER.EXE /AP=DEMO /UN=DEMO /REP=1 /PV=1 /QU=1 /RP=REPORT.RPT
where:
C:\OINSIGHT\REPORTER.EXE is the full path and file name for Revelation Reporter;
/AP=DEMO connects to the OpenEngine via the DEMO application;
/UN=DEMO indicates the user name for the DEMO application;
/REP=1 loads the report from the repository;
/PV=1 runs the report in Preview mode;
/QU=1 quits after processing the report; and
/RP=REPORT.RPT is the name of the report to be loaded.
You can also create a DOS file (in this example, SELECT.TXT) that contains any number of command line switches to load from the command line. In the following example, the SELECT.TXT file is used to load selection criteria.
C:\OINSIGHT\REPORTER.EXE /AP=DEMO /UN=DEMO @SELECT.TXT
The following table describes each of the command line switches.
Command Switch Description
/RP= Loads the specified report.
/QR= Loads the specified query.
/AP= Used to connect to OpenEngine. This is a required command switch. This should be the first switch in the Run command line, after loading REPORTER.EXE.
/UN= A valid user name for the application. Used in conjunction with the /AP switch. This is a required command switch. This should be the second switch in the Run command line, after loading REPORTER.EXE.
/PW= The corresponding password for the user name. This is required if there is a password associated with the specified user name. This should be the third switch in the Run command line, after loading REPORTER.EXE.
/SEL= Loads selection criteria formula for this report. Enter the complete selection criteria statement, with any text or numeric variables enclosed in quotes, as it appears in the Formula edit box. For example, STATE=NY". For more information about selection criteria, refer to Chapter 6: Selecting Data for Your Report.
/SELTYPE= Used in conjunction with the /SEL command line switch to specify the selection criteria language.
Enter one of the following (without spaces):
reporterbasic (for Reporter BASIC)
notesmacro (for Notes Macro)
revelationbasic (for BASIC+)
/QUERY=Query Name Loads a defined query file with the selected report file. The query conditions loaded supersede those stored with the report.
@ Lets you to store multiple command line switches in an external file. Note that you can combine command line switches and an @ in the same command line. The command line switch or @ that is encountered first will be processed first by Revelation Reporter.
/ED= 1 (True)=launch in Design mode. If no value is entered with this command line switch, the default is true.
/PR= 1 (True)=bypass design and begin printing. If no value is entered with this command line switch, the default is true.
/PV= 1 (True)=bypass design and print preview. If no value is entered with this command line switch, the default is true.
/QU= 1 (True)=quit immediately after processing. If no value is entered with this command line switch, the default is true.
/REP= 1 (True)=loads the report from the repository. If no value is entered with this command line switch, the default is true.
/BA= 1 (True)=prints in Batch mode; prints without displaying the Print dialog box. If no value is entered with this command line switch, the default is true.
Note: You can also use these command line switches using the RUNWIN utility and Repository ("EXECUTE") from the execute line of the System Monitor. For more information about using the RUNWIN utility and Repository ("EXECUTE"), refer to the Programmer's Reference Manual.
Note: The /QU switch implies that print or print preview are also turned on. Most commonly this would be used in the Runtime mode of an application to force a menu selection to print a report and exit.
Note: /AP and /UN are required command line switches in order to connect to OpenInsight. /PW is required if your application has a password.