Modify the properties of system-supplied report parameters as necessary.
|
Datastream 7i includes a bonus function that enables you to generate reports from the File menu. For example, you can generate a report equivalent to the Print work order cards report (WRJOBF) from the Work orders form (WMJOBS) by selecting either File | Print report or File | Print all reports from the File menu. |
Reports include Options that enable you to specify criteria regarding the report output, e.g., include custom fields, print attachments, etc. When you generate a report using one of the File menu bonus functions, Datastream 7i generates the report and does not invoke the report function to enable you to specify output Options. Therefore, Datastream 7i generates bonus function reports based on the default settings of the output Options for the corresponding report function set on the Functions form (BMFUNC).
Follow these steps to modify report parameters.
Open the Functions form (BMFUNC).
Query for the report function for which to modify default report parameters.
Click the Report parameters tab. Datastream 7i displays the Report parameters page.
Default—Click to select a parameter default value.
When the parameter represents a date, the default value is the difference between the system date and the parameter date in days. If the parameter is "Date to" and you specify 10 as the default value, Datastream 7i adds 10 days to the current system date. Datastream 7i displays the calculated date in the "Date to" selection criteria of the front-end screen.
Choose one of the following options for providing the list of values:
Select a function to provide the list of values for the parameter—Click , for LOV function, and then select a function code.
Select an SQL Statement to provide the list of values for the parameter—Click , for SQL statement, and then select a statement.
For example, to reduce the entries in the list of values for a predefined parameter, define a new query to filter the data. Use the Select statement definition form (BMQUER) to define the SQL statement.
|
If you define both an LOV function and an SQL statement, the LOV function takes precedence. |
Data type—Enter the data type of the parameter, e.g., character, data, numeric, etc.
System entity—Enter the code of the entity that corresponds to the report parameter.
Type—Enter the code of the type entity that corresponds to the report parameter.
Mandatory—Select to make the parameter mandatory.
Uppercase—Select to enforce uppercase characters for the parameter.
Remember—Select to carry over a remembered value (from a preceding screen) as a default value.
Choose File | Save from the menu bar. Datastream 7i saves the information to the database.