SQR Dialog Box
Dialog Box Options – Windows Report Name – Click the files button, you will be prompted to select an SQR report from any of your directories or drives. If you prefer to enter in the name, be sure to specify the whole path as follows: c:\psoft90fn\pt84912\sqr\test1.sqr
Username enter username to run the report under
Password enter the password for the username entered above
Database enter the specific database identified you want to
execute the report against.
Report Arguments:
-A causes the output to be appended to an existing output file of the
same name. If the file does not exist a new one will be created. This is
useful when you want to run the same report more than once but only want to
create a single file.
Note: The -A flag has some restrictions, it
only works with .LIS files and not .SPF files, it only applies to reports
using -PRINTER:LP, it is ignore for all other printer types and output
formats. In a non-Window environments, it can only be used with SQR and SQRP,
it does not work with SQRWP.
-BURST:{xx} specifies the type of bursting to be used.
-BURST:T generates the Table of Contents file only. -BURST:S generates the report output
according to the symbolic Table of Contents entries set in the program with the
TOC-ENTRY command's "level" argument. In -BURST:S[{1}],{1} is the level at which
to burst upon. The setting -BURST:S is equivalent to -BURST:S1 -BURST:P generates the
report output by report page numbers, in-BURST:P[{1},{s}[,{s}]...}],{1} is the number of
logical report pages that each .HTM file will contain and {s} is the page
selection:{n},{n}-{m},-{m}, or {n}-. The setting -BURST:P is equivalent to
-BURST:P0,1- when using -PRINTER:HT or -BURST:P1 when using -PRINTER:EH.
Note: -BURST:P and -BURST:S requires -PRINTER:EH, -PRINTER:HT or -PRINTER:EP.
The Page range selection feature of -BURST:P requires -PRINTER:HT, -BURST:T
requires -PRINTER:HT
-C (Windows) specifies that the Cancel dialog box appears
while the program is running so you can easily terminate the program execution.
-CB (Windows, Callable SQR) forces the communication box to
be used.
-DEBUG[xxx] causes lines preceded by #DEBUG
to be compiled. Without this flag, these lines will be ignored. See #DEBUG for
more information
-DNT:{xx} specifies the default behavior for numeric variables.
The value forxx can be eitherINTEGER, FLOAT DECIMAL or
V30. To specify a precision for DECIMAL,
append it with a colon delimiter (:)- for example, -DNT:DECIMAL:20.
See the DEFAULT argument for DECLARE-VARIABLE
for a detailed explanation. The DEFAULT argument in the
DECLARE-VARIABLE command will takeprecedence, if used.
-E[file} causes error messages to be directed to the named
file, or to the default file program.err. If no error occurs, no file is
created.
-EH_APPLETS:dir specifies the directory location of the Enhanced HTML applets.
The default directory for these applets is IMAGES.
Note: This flag is only applicable when the -PRINTER:EH flag
is specified.
-EH_BQD generates a {report}.bqd file from the report data.
Also associates a BQD icon with {report}.bqd in the navigation bar.
Note: This flag is only applicable when the -PRINTER:EH or
-PRINTER:EP flag is specified. -EH_BQD:file
associates the BQD icon with the specified file
Note: This flag is only applicable when the -PRINTER:EH or
-PRINTER:EP flag is specified.
-EH_BROWSER:xx specifies the target browser. When set to ALL,
SQR auto-senses which browser is being used, invokes a browser-specific file,
generates HTML designed for that browser. When set to BASIC, SQR generates
HTML suitable for all browsers. When set to IE, SQR generates HTML designed
for Internet Explorer. When set to NETSCAPE, SQR generates HTML designed for
Netscape.
Note: This flag is only applicable when the -PRINTER:EH
flag is specified.
-EH_CSV generates a {report}.csv file from the report data.
Note: This flag is only applicable when the -PRINTER:EH
or -PRINTER:EP flag is specified.
-EH_CSV:file associates the CSV icon with the specified file.
Note: This flag is only applicable when the -PRINTER:EH or -PRINTER:EP flag is
specified.
-EH_CSVONLY creates a CSV file but does not create a HTML file.
-EH_FULLHTML:xx specifies the level of the generated Enhanced
HTML code. This can be 30, 32 or 40.
Note: This flag is only applicable when the -PRINTER:EH flag is specified.
Note: For upward compatibility a value of TRUE is equivalent to 40 and FALSE is
30.
-EH_Icons:dir specifies the directory where the HTML should look
for the referenced icons.
-EH_IMAGES:dir specifies the directory path for the .GIF files
used by the Navigation Bar.
-EH_KEEP copy not move the files when used in conjunction with EH_ZIP.
-EH_LANGUAGE:xx sets the language used for the HTML navigation bar.
You can specify English, French, German, Portugese or Spanish.
-EH_PDF associates a PDF icon with {report}.pdf in the
navigation bar.
-EH_Scale: sets the scaling factor from 50 to 200.
-EH_XML:file associates the XML icon with the specified file.
-EH_ZIP[:file] moves the generated files to the specified file or
{report}.zip if {file} is not specified.
-F[file | directory] overrides the default output file name, program.lis.
The default action places the program.lis in the same directory as the program.sqr file.
To use the current directory, specify -F with the new name. If the new name does not
specify a directory, the file will be created in the current directory. The output
file is not created until data is actually printed on the page. If no data is
printed, no output file is created.
-Idir_list specifies the list of directories that SQR will search
when processing the #INCLUDE directive if the include file does not exist in the
current directory and no path was specified for the file. The directory names must
be separated by either commas (,), or semicolons (;). Always append the directory
character to the end of each directory name.
Note: Make sure you include the directory character (backslash) at
the end of the path. If you do not include the backslash, you will receive the following
error: SQR 4713 Cannot open the #INCLUDE file
-KEEP creates .SPF file output in addition to .LIS files, for each
report that your program generates.
-LL{s | d}{c | i} LOAD-LOOKUP: s =SQR,d =DB,
c = case-sensitive,i =case-insensitive.
-Mfile defines a startup file containing sizes to be assigned to
various internal parameters in extra small or large or complex reports.
-NOLIS prevents the creation of .LIS files. Instead .SPF files
are generated.
-O[file] directs log messages to the specified file or to program.log
if no file is specified. By default, the file sqr.log is used in the current working
directory.
-PRINTER:xx Causes printer type xx to be used when creating output
files:
xx Printer Type Example
EH Enhanced HTML-PRINTER:EH
EP Enhanced HTML
and PDF -PRINTER:EP
HP HP LaserJet -PRINTER:HP
HT HTML -PRINTER:HT
LP Line Printer-PRINTER:LP
PD PDF -PRINTER:PD
PS PostScript -PRINTER:PS
WP Windows -PRINTER:WP
Types LP, HP and PS produce files with the .LIS extension. Types
EH and HT produce .htm file output. Type HT produces
version 2.0 HTML files with the report content inside of PRE tags. Type EH
produces reports in which content is fully formated with version 3.0 or 3.2 HTML tags.
On Windows systems, type WP sends the output to the default Windows
printer. To specify a non-default Windows printer, enter -PRINTER:WP:{Printer Name}.
The {Printer Name} is the name assigned to your printer. For example, to send output
to a Windows printer named NewPrinter, you would use Printer:WP:NewPrinter.
If you have spaces in your printer name, enclose the entire argument in double quotes.
Type PD produces a PDF 1.1 compliant file. When -PRINTER:PD
is used, PRINT-DIRECT, PRINT ...Code, and Print with CODE-PRINTER commands aree
processed but ignored. If you also want to create an .SPF file, use -KEEP.
-RS saves the program in a run-time file. The program is scanned and
checked for correct syntax. Queries are validated. Then, the executable version is
saved in a file with the name program.sqt. Note that ASK variables are not prompted
for after compilation.
-RT uses the run-time file saved with the -RS flag.
All syntax and query checking is skipped and processing begins immediately. Note that
ASK variables are not prompted for after compilation.
-S requests that the status of all cursors be displayed at the end
of the report run. Status includes the text of each SQL statement, number of times
each was compiled and executed, and the total number of rows selected. This information
can be used for debugging SQL statements and enhancing performance and tuning.
-Tnn specifies that you want to test your report for nn pages.
All ORDER BY clauses in SELECT statements are ignored to save time during
testing. If the program is producing more than one report, SQR stops after the
specified number of pages defined for the first report have been output.
-TB (Windows/DB2) -TB trims trailing blanks
from database character columns.
-TZ (Windows/DB2) -TZ trims trailing zeros from
the decimal portion of numeric columns.
-XC (Callable SQR) suppresses the database commit when the report
has finished running.
-XCB (Windows) do not use the communication box. Requests for
input will be made in Windows dialog boxes.
-XI do not allow use interaction during a program run. If an ASK
or INPUT command requires user input then produce an error and exit.
-XL prevents SQR from logging on to the database. Programs run
in this mode cannot contain any SQL statements. -XL lets you run SQR without
accessing the database. You must still supply at least an empty slash (/) on
the command line as a placeholder for the connectivity information
-XLFF prevents SQR from generating a trailing form feed after
the last page has been executed.
-XMB (Windows) disables the error message display so that a
program can be run without interruption by error message boxes. Error messages
will only be sent to an .err file.
-XNAV prevents SQR from creating the 'Navigation Bar' in .HTM files
generated with the -PRINTER:HT. This will occur when only a single .HTM file is
produced. Multiple .HTM files generated from a single report will always contain
the 'Navigation Bar'.
-XTB preserves the trailing blanks in an .LIS file at the end
of a line.
-XTOC prevents SQR from generating the Table Of Contents for
the report. This flag is ignored when either -PRINTER:EH, -PRINTER:HT or
-PRINTER:EP is also specified.
-ZIF sets the full path name of the SQR initialization file,
SQR.INI
-ZIV invokes the SPF Viewer after generating program.spf file.
This flag implicitly invokes the -KEEP flag to create program.spf. In case of
multiple output files, only the first report file will be passed to the Viewer.
-ZMF{file} specifies the full path of the SQR error message file,
sqrerr.dat
-ZRF{file} sets the full path name of an alternate registry.properties
file. The registry.properties file lists data sources that SQR Server can access.
The information in the registry.properties file makes it possible for SQR Server
to access SAP R/3.
Parameters
pars - report parameters for ASK and INPUT commands
@file - file containing report parameters, one per line.
0 responses so far ↓
There are no comments yet...Kick things off by filling out the form below.