Was this helpful?
Call Report
The statement call report calls the Report-Writer to run the report you specify. Separate items in the list with a blank or by pressing the Tab key.
brkfmt
Equivalent to the +t flag. Causes aggregates to occur over rounded values for any floating point column whose format has been specified in a .format statement as numeric F or template. The value is a blank string. Each value is rounded to the precision given in its format, based on displayed data rather than on internal database values.
Syntax:
call report(file= 'filename', brkfmt= ' ')
file
Equivalent to the -f flag. Directs the formatted report (output) to the file name specified by the value. If you do not specify a file name, the report is written to the file specified in output; if you do not specify a filename in either place, the report is displayed on the screen.
forcerep
Equivalent to the -h flag. Creates headers and footers even when the report contains no data, executing all .header and .footer sections and suppressing the detail section. The value is a blank string. Allows an .if statement in report footer to verify that no rows were found. See Character-based Querying and Rporting Tools User Guide for details.
Syntax:
call report(file = 'filename', forcerep = ' ')
formfeed
Equivalent to the +b flag. Forces form feeds at page breaks, overriding report-formatting commands. The value is a blank string.
Syntax:
call report(file = 'filename', formfeed = ' ')
mode
Equivalent to the -m flag. Specifies the mode. Values: tabular, wrap, and block. Use the mode parameter with the name parameter only; mode has no effect when used with the report parameter.
If you do not specify a style, Report-Writer creates a default report based on the width of your report. Use pagewidth to change the default.
If you do not use the mode parameter, RBF takes one of the following actions:
If it finds a report, places you in the report specification
If it finds a table or view, creates a new report specification
mxquer
Equivalent to the -q flag. Sets the maximum length of the query specified in the .query command to the specified number of characters following all substitutions for runtime parameters. Only needed for very long queries. The value is an integer.
mxwrap
Equivalent to the -w flag. Sets the specified number as the maximum number of lines within any block. The value is an integer. Default : 300.
name
Names a database table or view for the default report
param
Indicates the parameters for the report. The value is a quoted parameter string or the name of a field containing the parameter string.
Use the format pname='value' and separate the string with blanks or tabs (with no blanks around the equals sign.) Enclose nonnumeric values passed in an element in standard quotes, with the following exception.
If pname is a character report parameter, enclose value in double quotes within single quotes (' " " '). Place a backslash (\) before embedded double quotes.
nobrkfmt
Equivalent to the -t flag. Causes aggregates to occur over internal database values rather than on the displayed data for any floating point column whose format has been specified in a .format statement as numeric F or template. The value is a blank string.
Syntax:
call report(file = 'filename', nobrkfmt = ' ')
noformfeed
Equivalent to the -b flag. Suppresses form feeds, overriding report-formatting commands. The value is a blank string.
pagelength
Equivalent to the -v flag. The value is an integer. Sets the page length, overriding .pagelength commands in the report. Default: 61 lines per page if report is written to a file, and your terminal length per page if written to the terminal.
mxline
Equivalent to the -l flag. Sets the page width, overriding .pagewidth commands in the report. Defaults depend on style of report: block: 80; wrap: 100; tabular and column: no default. Needed only for reports with very long lines. The value is an integer.
printer
Equivalent to the -o flag. Specifies that the value is a printer name (overrides the default printer). Additional memory is required to print large reports.
copies
Equivalent to the -n flag. Lets you specify the number of copies to be printed. The value is an integer. Default: 1 copy.
report
Equivalent to the -r flag. Indicates that the value is a report, rather than a table or view, and displays the report. The value is a report name.
silent
Equivalent to the -s flag. Suppresses some informational messages, but not prompts. The value is a blank string.
Syntax:
call report(file = 'filename', silent = ' ')
sourcefile
Equivalent to the -i flag. Requests that the report specification be read from a source file outside the Reports Catalog. With this flag, the specified source file is not saved in the database. To save the report specification in the database, use the sreport command. You cannot use this flag in conjunction with the -m or -r flags. You can specify only one filename. Do not specify a report, table, or view on the command line.
-5
Requests report compatibility with Ingres release 5. Use with brkfmt option to ensure compatibility. Displays month of current_date in capitals if no format is specified. With -5 set, the date appears as dd-MMM-yyyy.
-6
Requests that all distinct rows be reported when the following reports are executed: SQL default reports, SQL reports that contain .data, .table, .view, or .sort statements. Without -6, duplicate rows are reported in these SQL reports. Does not apply to QUEL reports.
flags
Specifies the flags in effect. The value is a list of flags. Includes most system-level command line flags (except -u). Separate items in the list with a blank or tab.
Last modified date: 08/14/2024