13. Building Applications : The Create a Frame or Procedure Frame : Creating Report Frames
 
Share this page                  
Creating Report Frames
The next option on the Edit an Application frame's Create a Frame or Procedure pop-up is REPORT. Defining Report frames is similar to defining USER frames.
Select REPORT from the Create a Frame or Procedure frame. Specify the name in the Create a Report frame and select OK. The Edit a REPORT Frame Definition frame appears, as in the following figure.
In creating a report frame, you enter the Ingres Reports interface. To learn more about this interface, see the Using Character-based Querying and Reporting Tools.
The fields on this frame contain the information needed to produce reports from the Report interface.
Frame Name
Specifies the name of the report frame
Short Remark
Specifies a brief description of report frame
RBF Report? (y/n)
Determines whether the report is a Report-Writer or RBF report
Report Name
Specifies the name of an existing report you plan to use as is or edit for use in this frame. Or, if you are creating a new report, enter the name here. If you are using Report-Writer, this name appears in the Report-Writer specification file for the report.
Report Source File
Specifies the name of the report specification file for a Report-Writer report. File names specified here require an extension of .rw. RBF reports do not have a report specification file.
Report Parameters Form
Specifies the name of a form on which the user can enter values at run time for any variables used in the report. Variable values entered on this form are passed as parameters to the Report-Writer at run time.
To create or edit a form, specify the form name in this field, and choose the FormEdit operation.
When you create a parameter form, the names of the fields on the form must match the variable names in the report specification file. For example, if year is a variable used in the where clause of a query "...where pop. year = $year" then the variable form must include the field year.
The Report-Writer prompts the application user for needed values if they are not passed. It is strongly recommended that all variables used in a report be on the report frame's form. See Using Character-based Querying and Reporting Tools for more information on variables.
Output File
Specifies the report's output type: file, print, or display (the default).
To store the report in a file, enter the filename to receive the report.
To send the report to the printer, type printer.
To display the report on your screen, type terminal. This is the default; if you leave this field blank, the report is directed to your terminal screen.
You can also save output in a file by using the .output command in your report specification file. However, any file name you enter on the Edit a REPORT Frame Definition frame overrides a file name given in the .output command.
Command Line Flags
Specifies the report parameters you want the application to use when running the report. Running a report from an application is like specifying the report command with the -r parameter at the operating system:
report dbname -r reportname
You can specify additional parameters for the report command in the Command Line Flags field. For example, specify -uusername to run the report as another user, or -lpagewidth to set the maximum page width. You cannot specify a parameter, such as -m or -i that conflicts with the -r parameter. For information on using parameters with the report command, see the Character-based Querying and Reporting Tools User Guide.
The following menu operations are similar to those in the Edit a USER frame:
NewEdit
Edits or creates a different frame or procedure. Prompts the user for the type of object to define.
Go
Runs the report frame
Edit
Runs the report editor you specified for the report in the RBF Report? (y/n): field.
If you answered yes, RBF is the editor.
If you answered no, you use the system editor.
Compile
Calls sreport to compile the source code for the Report-Writer report. This option is not necessary for RBF reports.
FormEdit
Runs VIFRED to create or edit a form for the current frame. Not active unless you specify a form.
LongRemark
Displays or edits more information about the selected frame on the LongRemark pop-up
Print
Prints a description for the frame
ListChoices, Cancel, Help, End
Perform standard operations