This indicates the primary table you want to use for the report (see Browse on Data Dictionary Tables).

The primary table should be the table that contains the majority of the columns that you want to use in your report, or the table that is linked to other tables containing columns that you wish to use.

Once you have selected and assigned the primary table to a report, it cannot be changed.

If you have a SQL and C-ISAM mix system, then the primary table and the 1-many table must be Sequel.

The table base names are preceded by an abbreviation of the SYSPRO module.

Example 1 - GenMaster For the General Ledger Master Table. Example 2 - ArCustomer For the Accounts Receivable Customer Master Table.

This indicates the report code for the report.

The Report Code defaults to a system generated code but can be changed at this point.

The default report code is made up of an abbreviated Primary Table Description of 6 characters, followed by a sequence number relating to the number of times this table has been used as the Primary Table.

Example 1 - Report Code - ADMJOB-1. i.e. ADMJOB for the Admin Job Logging Table. 1 means it has not been used as a primary table before.

Example 2 - Report Code - GENMAS-2. i.e. GENMAS for the General Ledger Master Table. 2 means it has been used once before as a primary table.

If you define your own Report Codes, it is advisable to make them meaningful so that you are able to easily identify the report.

Once the report has been created the report code cannot be changed.

This indicates the title for the report.

The system allocates a default Report Title, but this can be changed. The default Report Title always starts with "Report on……….", followed by the Description for the Primary Table.

For example: Report on A/R Customer Invoice for the Accounts Receivable Invoice Table, or Report on G/L Master for the General Ledger Master Table.

Once defined, the report title can be changed using the Options section of the report attributes.

When creating a report, this defaults to the primary key of the primary table.

Depending on the selected Primary Table, other alternate keys may be available to sequence the report:

For example, the Accounts Payable Supplier table also has the option to use the Short Name. The Inventory Master table also has the option to use the Description and the Supplier Name as alternate keys on which to sequence the report.

Report Writer prints sequentially through the primary table, defaulting to the alphabetical sequence of the key fields.

The Sequencing function is used to define the reporting order, when producing a report.

Once defined, the default sequence can be changed in the Sequencing section of the report attributes.

This indicates the width of report and defaults to 132 characters, which is the number of columns used by standard SYSPRO reports.

The width is the maximum number of characters you wish to print on each line of the report. The Number of columns pertains to the width when maintaining this option.

The maximum number of characters that can be printed on each line is 300 and the maximum that can be used in an extract report is 400. Therefore, when adding a report you will not be allowed to enter more than 300 characters for the width.

Each line is validated during printing and if the line is longer than specified, it is truncated.

Once defined, the report width is maintained under the Options section, of the report attributes, however if the width is changed, the column headings are not realigned.

If you select this option (recommended), then the system inserts default headings with a similar format to all the standard SYSPRO reports.

The standard headings include:

Once defined, the report headings can be changed using the Page Headings option in the Layout section of the report attributes.

If you do not select this option, then you must define the heading columns manually during report maintenance.

This option relates to the global report update option.

If you select this option, then you can use the report to update columns in the database.

	Great care must be taken when allowing updates as important information could be overwritten.

Although you can select the option to allow updates here, this can be changed at a later stage by maintaining the Allow updates option within the Options folder (providing that the operator activity: R/W create reports that update data is not set to denied).

If you select to update a column against a detail line and you have not selected this option the report will not update the column.

User-Defined SQL Tables can be updated, subject to the following:

This is the field in the table or the user variable by which you want to sequence the report in order to define a subtotal.

If you select a calculated user variable, then the calculated value of that variable cannot consist of other calculated user variables.

To view and select fields from a table, you can use the F9 function key. The listview of theBrowse on Data Dictionary Columns program is displayed.

To view user defined variables, you enter % and then the F9 function key.

This is the field in the table or the user variable by which you want to sequence the report.

If you select a calculated user variable, then the calculated value of that variable cannot consist of other calculated user variables.

To view and select fields from a table, you can use the F9 function key. The listview of theBrowse on Data Dictionary Columns program is displayed.

To view user defined variables, you enter % and then the F9 function key.

This is the field in the table or the user variable by which you want to sequence and subtotal the report.

If you select a calculated user variable, then the calculated value of that variable cannot consist of other calculated user variables.

To view and select fields from a table, you can use the F9 function key. The listview of theBrowse on Data Dictionary Columns program is displayed.

To view user defined variables, you enter % and then the F9 function key.

You use this field to enter the number of blank lines you want to skip after the subtotal.

This option is not available if you selected the page skip option.

For the beginning of the first condition, this defaults to If and cannot not be changed.

Select And to combine conditions using AND logic. Select Or to combine conditions using OR logic.

When applying AND logic, the combined condition is true if both simple conditions are true. When applying OR logic, the combined condition is true if either of the simple conditions are true.

You use this to enter a field from a table, a user defined variable or a system variable to use in the condition.

To view and select fields from a table, you use the F9 function key. The listview of theBrowse on Data Dictionary Columns program is displayed.

To view user defined variables, you enter % and then the F9 function key.

To view system variables, you enter $ and then use the F9 function key. The listview of the System Variables program is displayed.

You use this field to enter a valid condition that must be used to compare the fields.

If the fields are numeric, then they are compared algebraically. If the fields are alphanumeric, then they are compared alphabetically. If the fields are dates, then they are compared chronologically.

The following conditions are available:

The N and M conditions can only be used with alphanumeric variables. These conditions enable you to compare a field or variable with a string.

For example, if you want to find all stock codes that have the word "Bicycle" in their description, you could define a condition: If Description M *Bicycle*

The valid wildcards are identical to that used in the rest of SYSPRO when pattern matching is used. You can use * to represent zero or more characters and ? to represent any single character. (Refer to Wildcards).

Similarly, if you wanted to find stock codes that do not have the word "Bicycle" in their description, you would define a condition: If Description N "Bicycle"

You use this to enter a field from a table, a user defined variable, a system variable, a string or a constant to use in the condition.

To view and select fields from a table, you use the F9 function key. The listview of theBrowse on Data Dictionary Columns program is displayed.

To view user defined variables, you enter % and then use the F9 function key.

To view system variables, you enter $ and then use the F9 function key. The listview of the System Variables program is displayed.

A string must be entered between quotation marks (either single or double quotes) and can be up to 35 characters long.

Constants are numeric.

The maximum size of a numeric field is 15 digits before the decimal and a maximum of 6 digits after the decimal (15.6). This number can be positive or negative.

You use this field to enter the user variable or string with which you want to initialize the primary table variable.

Strings must be entered between quotation marks. These can be either single or double quotes.

To view user defined variables, you enter % and then press the F9 function key.

You use this to enter the field from the primary file that you want to initialize with the value of the variable or string entered at the previous field.

To view and select fields from the primary file, you use the F9 function key. The listview of theBrowse on Data Dictionary Columns program is displayed.

The Stop Logic element can be used to define the condition(s) on which to stop the report.

A maximum of three stop conditions can be defined.

You use this to enter a field from a table, a user defined variable or a system variable to use in the condition.

To view and select fields from a table, you use the F9 function key. The listview of theBrowse on Data Dictionary Columns program is displayed.

To view user defined variables, you enter % and then press the F9 function key.

To view system variables, you enter $ and then use the F9 function key. The listview of the System Variables program is displayed.

You use this field to enter a valid condition that must be used to compare the fields.

If the fields are numeric, then they are compared algebraically. If the fields are alphanumeric, then they are compared alphabetically. If the fields are dates, then they are compared chronologically.

The following conditions are available:

The N and M conditions can only be used with alphanumeric variables. These conditions enable you to compare a field or variable with a string.

For example, if you want to find all stock codes that have the word "Bicycle" in their description, you could define a condition: If Description M *Bicycle*

The valid wildcards are identical to that used in the rest of SYSPRO when pattern matching is used. You can use * to represent zero or more characters and ? to represent any single character. (Refer to Wildcards).

Similarly, if you wanted to find stock codes that do not have the word "Bicycle" in their description, you would define a condition: If Description N "Bicycle"

You use this to enter a field from a table, a user defined variable, a system variable, a string or a constant to use in the condition.

To view and select fields from a table, you use the F9 function key. The listview of theBrowse on Data Dictionary Columns program is displayed.

To view user defined variables, you enter % and then use the F9 function key.

To view system variables, you enter $ and then use the F9 function key. The listview of the System Variables program is displayed.

A string must be entered between quotation marks (either single or double quotes) and can be up to 35 characters long.

Constants are numeric.

The maximum size of a numeric field is 15 digits before the decimal and a maximum of 6 digits after the decimal (15.6). This number can be positive or negative.

You use this field if you want to enter more than one Stop logic condition.

Select And to combine conditions using AND logic. Select Or to combine conditions using OR logic.

When applying AND logic, the combined condition is true if both simple conditions are true. When applying OR logic, the combined condition is true if either of the simple conditions are true.

This field enables you to define your own report title, utilizing a format that is meaningful to your company. The maximum number of characters available for this report title is 40.

The system allocates a default Report Title, but this can be changed. The default Report Title always starts with "Report on……….", followed by the Description for the Primary Table.

For example: Report on A/R Customer Invoice for the Accounts Receivable Invoice Table, or Report on G/L Master for the General Ledger Master Table.

Select this to produce an extract report.

An extract report is one in which the report contents are output to a file rather than to a printer. This enables you to use the extract file to import the data into a third-party application's software (for example into a spreadsheet).

Select this to produce an XML report.

When you select this option, you can select the XML Wizard function to customize your report as an XML document using the RW XML Wizard program.

You use this function to define the default options to be used if the report must be run as an extract.

You can only access this function if the report type is defined as Extract.

Select this if you want Tabs to separate each filed in the extract file.

This format enables you to import the data from the extract file into an Excel spreadsheet.

This indicates the separator character type you want to use for separating the fields.

You will be unable to access this field if you selected User-defined extract file format at the Extract file type field.

You use this field to define a file name and path for the extract report.

If you do not specify the full path, then it defaults to the SYSPRO base directory.

The extract file is a sequential file and does not need an extension (i.e. .DAT).

Up to 250 characters can be used to define the extract file name and path.

This option is selected by default and indicates that the report detail must be extracted even when you select to create a summary report (see Report Summary).

Deselect this option if you only want to include subtotals and report totals in the extract report when you select to create a summary report.

You use this option to define the headings to be extracted for all extract file types.

The column heading method selected is not dependent on the type of extract report.

You use this field to indicate whether the negative sign must be leading or trailing.

When extracting using the separated file formats and not the "user-defined extract file format", you can specify whether the sign on numeric fields is leading or trailing.

Most 3rd party systems that use comma or other separators, require leading signs.

You use this function to customize your report as an XML document using the RW XML Wizard program.

This function is only enabled if you selected the Report type as XML.

Select this option if you want the default report messages to be displayed at the End of a Report and when a Report is Cancelled.

Deselect this option if you want to define your own report messages or blank out all the characters if no message is required.

Deselect this option if you are creating an extract file and you do not want each message to create a record in the file.

Select this option if you want the person running the report to be allowed to interrupt and (optionally) cancel the running of the report.

	If you have created a report which updates fields, you should not select the Report interrupt allowed option. This will prevent the files from being partially updated if the report is stopped before it has completed processing.

This field is only enabled if you deselected the option: Use standard messages.

You use this field to enter the wording you want printed at the end of your report. The standard default message "End of Report" is displayed but can be changed.

Clear this field if you are creating an extract file to prevent the message creating a record in the file.

This field is only enabled if you deselected the option: Use standard messages.

You use this field to enter the wording you want printed if the report is cancelled.

The standard default message "Report cancelled" is displayed but can be changed.

You use this field to indicate the overline character to be used.

The default is ‘------------------‘, this may be changed.

You use this field to indicate the underline character to be used.

The default is ‘==========‘, this may be changed.

This refers to the first line on which column headings must be printed. By default, the column headings are printed on line 4, but this can be changed.

Enter 0 in this field if you do not require column headings to be printed.

You use this field to define the number of blank lines you want between the column headings and the first line of detail for the column.

If you enter 0 in this field, then the first line of detail is printed immediately below the column heading.

You use this field to define the number of blank lines you want between the top of the page and the first line of the heading.

If you enter 0 in this field, then the first line of the page heading is printed according to your entries in the Page Heading section.

You would typically define a number of line skips before the heading if you wanted to insert a bitmap image (e.g. a logo graphic) above the heading.

Select this if you want to print headings using the standard format.

The standard default report headings are formatted in bold and all the columns are underlined.

If this option is deselected, the headings are not printed in bold and the columns are not underlined.

Select this if you want to truncate user-defined column headings in the same way that standard column headings are truncated (the default column headings for fields are truncated automatically to fit the standard column width for the field).

If you do not select this option then user-defined column headings are printed as specified (i.e. They are not truncated).

In addition, if you add fields and simultaneously define the column headings, the column widths are automatically increased to allow for the headings. If, however, you add the columns first and then edit them to change the headings, you will need to select Edit from the Menu and use the Recalculate Detail Fields option to increase the column widths.

This field refers to the report width. This width is the maximum number of characters you want to print on each line of the report.

Standard SYSPRO reports use 132 columns, so when creating a report it defaults to 132 characters.

This may be changed, by selecting a different width from the pull down menu. Alternatively, you may enter the required width. e.g. 85.

The maximum number of characters that can be printed on each line is 300 and the maximum that can be used in an extract report is 400. Therefore, when adding a report you will not be allowed to enter more than 300 characters for the width.

Each line is validated during printing and if the line is longer than specified, it is truncated.

	If the width is changed after the report columns have been defined, the column headings are not realigned.

The number of lines per page, is the number of lines that will be printed before a new page is started.

Standard SYSPRO reports use 58 lines per page, so when creating a report it defaults to 58 lines.

Select this option if you want to change this default.

This filed is only enabled if you selected the option: Define lines per page against report.

You use this field to enter the number of lines you want to print on each page of the report. This will depend on the length of one page of the paper you are using to print the report.

You can select a different line from the pull down menu or alternatively enter the number you require.

The maximum number of lines that can be selected is 99.

To reduce the expenses normally associated with pre-printed stationery, as well as to simplify document alignment, SYSPRO allows a number of its documents and reports to be printed with a bitmap background.

By selecting this option you no longer need to use pre-printed stationery, however the option will only function if you are printing using a Windows Print Manager printer type.

You use this function to define the bitmap image you want to use for the report.

This function is only enabled if you selected the option: Bitmap background.

You use this field to enter the bitmap file name you want to use. The full pathname must be specified. A Browse facility is available.

A maximum of 255 characters can be used for the bitmap file name and path.

This is the bitmap scale factor in millimeters or inches.

The default is 7.5, however you can enter a maximum of 9999.99 characters (i.e. 4.2).

The bitmap scale must also be specified in either millimeters or inches. The default is inches.

The width field indicates how wide you want the bitmap image to be printed on the document and the measurement factor to use. The bitmap is scaled automatically according to the specifications entered, retaining the aspect ratio (i.e. Width to height).

Select this if you want to print leading zeros in the report.

This option is designed primarily for key fields (such as a stock code or customer) where the field can be alphanumeric or numeric.

For example Customer code 1234 will print as 000000000001234 if this option is selected.

You would typically select this option when creating a link between two files that is based on a numeric key.

If you do not select to show leading zeros, then there are spaces in the key where there should be zeros. This means that when the linked file is read, the records are not found.

Select this if you do not want to print blank lines in the detail section of the report. The default is set to suppress blank detail lines.

Trailing blank lines are always suppressed.

Select this if you do not want to print blank lines in the Subtotal, Report Total and Group Heading sections of the report. The default is set not to suppress blank lines.

Blank lines cannot be suppressed in Report Headings.

Select this if you want to print the Report Total on a separate page from any previously printed detail lines or sub-totals.

This option has no effect if a report only comprises a Report Total, or for Extract or XML type reports.

You use this option to add a text comment to the report.

A narration can typically be used to warn users, to change the font of the printer or change the stationery before they start printing the report.

The report narration uses the Generic Notepad style of notes and allows for virtually unlimited text with various formats. When printing the report notes, this text can be printed in plain text format.

Select this if you want the narration you enter to automatically be displayed when the report is executed.

The narration is displayed before any runtime prompts are displayed.

You use this function to enter the narration text using the Generic Text Editor program.

The Date Stamp function is used to insert the current system date and the operator code into the text.

Select this if you want to automatically run the Sequential to ISAM Converter program whilst executing the report.

The Sequential to ISAM Converter program creates a user-defined index file from a sequential file.

This option only creates an ISAM file. The Report Writer does not have any logic to physically create SQL tables (i.e. the table definition or the columns and their data types). The Report Writer cannot write any new rows to an existing SQL server table. It can only be used to update existing rows in a SQL table. If you select this option, you must define the index file format in the Data dictionary tables and columns (see Browse on Data Dictionary Tables and Browse on Data Dictionary Columns), before executing the report.

This indicates the table name to use for the User defined index table.

The path for the sequential file is stipulated against the Extract file name under the Extract Options (see Extract options).

The path for the user-defined index file is stipulated against the Disk file name when adding a user-defined table under the Data Dictionary Table Setup (see Browse on Data Dictionary Tables).

These are the file names you use in this field.

Select this if you want to execute another report after this report has executed.

This enables you to execute a string of reports.

For example:

Assume you have three reports (say R1, R2, R3) that you want to run, one after the other.

Against report R1, you select this option and enter R2 in the Report field below. Against report R2, you select this option and enter report R3 in the Report field below.

You use this field to configure the report to request the value of X at run time.

If you select this option then you must define a run time variable to prompt the operator to enter the value of X. The following fields for this variable must be configured as follows:

You use this field to enter the value of "X." i.e. The number of items you want to print.

This field is not enabled if you selected the option: Print top X items using user variable

This indicates the user defined variable that will store the value of X.

This field is only enabled if you selected to the option: Print top X items using user variable

Select this if you want to update data files/tables when executing the report.

If you select to update a column against a detail line but you have not selected this option, then the report will not update the column.

Select this if you want to produce only a summary report when the report is executed.

If you select this option, then only Report headings, Column headings, Group headings, Subtotals and Totals are printed. Details lines are not printed.

This option is deselected by default.

	If you are creating an extract report and you do not want to include the report details in the extract file, you must deselect the option: Include details in summary extract (see Extract options).

When defining passwords against a report in Report Writer, you can specify that this must be By company or System wide.

	If you change your password definition from By company to System wide, then the company passwords are cleared, but not deleted. If you change the setting back to By company, the original company passwords are reinstated.

Select this if you want to apply the security accesses defined against the operator (Operators - Security tab) when running the report. If you select this option, then the security accesses for Warehouses, A/P Branches, A/R Branches, Banks, Job classifications and Salespersons defined against the operator are applied when the operator runs the report.

	The security only applies when the fields: Warehouse, Branch, Bank, Salesperson or JobClassification are defined in the report.

Select this if you want to define selected operators who are allowed to maintain the report.

You use the Define operator list options to define this list of operators.

Select this if you want to define selected operators who are not allowed to maintain the report.

You use the Define operator list options to define this list of operators.

This option enables you to define the list of operators who are or are not allowed to maintain the report, depending on your selection at the Report maintenance security option.

This option is not enabled if you indicated that all operators can edit the report.

	If you change the security selection (see Security selection), then all existing lists are cleared.

Select this to add the operator entered in the previous field to the list of operators who can/cannot edit the report.

Up to 20 operators can be added to the list.

Select this if you want to define selected groups who are allowed to maintain the report.

You use the Define groups options to define this list of groups.

Select this if you want to define selected groups who are not allowed to maintain the report.

You use the Define group list options to define this list of groups.

This option enables you to define the list of groups who are or are not allowed to maintain the report, depending on your selection at the Report maintenance security option.

This option is not enabled if you indicated that all groups can edit the report.

	If you change the security selection (see Security selection), then all existing lists are cleared.

Select this to add the group entered in the previous field to the list of operators who can/cannot edit the report.

Up to 20 groups can be added to the list.

Select this if you want to define selected operators who are allowed to run the report.

You use the Define operators options to define this list of operators.

Select this if you want to define selected operators who are not allowed to run the report.

You use the Define operators options to define this list of operators.

This option enables you to define the list of operators who are or are not allowed to execute the report, depending on your selection at the Report maintenance security option.

This option is not enabled if you indicated that all operators can run the report.

	If you change the security selection (see Security selection), then all existing lists are cleared.

Select this to add the operator to the list of operators who can/cannot run the report.

Up to 20 operators can be added to the list.

Normally, the operators who can maintain a report would also be given the authority to execute the report.

You use this function to copy the list of operators you defined as being able to maintain the report to the list of operators who can also run the report. This saves you from having to define the list of operators twice - once for maintaining the report and once for executing the report.

This function is not available if you selected the option: All operators can run the report.

Select this if you want to define selected groups who are allowed to run the report.

You use the Define groups options to define this list of groups.

Select this if you want to define selected groups who are not allowed to run the report.

You use the Define group list options to define this list of groups.

This option enables you to define the list of groups who are or are not allowed to execute the report, depending on your selection at the Report maintenance security option.

This option is not enabled if you indicated that all groups can run the report.

	If you change the security selection (see Security selection), then all existing lists are cleared.

Select this to add the group entered in the previous field to the list of operators who can/cannot run the report.

Up to 20 groups can be added to the list.

Normally, the group of operators who can maintain a report would also be given the authority to execute the report.

You use this function to copy the list of operator groups you defined as being able to maintain the report to the list of operator groups who can also run the report. This saves you from having to define the list of operator groups twice - once for maintaining the report and once for executing the report.

This function is not available if you selected the option: All groups can run the report.

You use this field to enter the variable name.

When defining a user defined variable the first character must be a %.

This defaults to the word Variable followed by the variable name, but you can replace it with a more meaningful description.

Up to 30 characters can be entered for this description.

Select this if you want the variable to be alphanumeric.

If you set the variable as alphanumeric, you can define its contents to be a fixed string of characters or a run time prompt.

Alphanumeric variables can be up to 255 characters in length.

Select this if you want the variable to be numeric.

The maximum size of a numeric field is 15 digits before the decimal and a maximum of 6 digits after the decimal (15.6). This number can be positive or negative.

Select this if you want the variable to be a date.

You use the Date format field to define the format required for this date.

If you select the Variable usage as Calculated, you use the Date, + / - and Days fields to define the date calculation required.

This field is displayed for Alpha variable types only.

For run time variables, up to 30 characters can be defined as the length of the field that must be entered at run time.

For Fixed String variables, a maximum of 30 characters can be entered as the string.

This field is displayed for Numeric variable types only.

You use this field to enter the number of characters you require before and after the decimal.

The maximum size of a numeric field is 15 digits before the decimal and a maximum of 6 digits after the decimal (15.6). This number can be positive or negative.

If this variable is to be calculated, then all calculations are rounded to the number of decimals defined in the Edit pattern.

This field is displayed for Date variable types only.

This enables you to define the format you require for the Date variable.

This is the format in which you want the date printed on the report. This does not determine the format for the date if the variable is asked at run time. Run time date prompts are formatted according to the date format defined against the company (Company Maintenance - General tab).

Select this if you want to define the variable as a run time prompt (i.e. a run time variable).

Run time variables are variables that are requested at the time of running the report. You can define up to 10 different run time prompts as well as 10 check box prompts. This enables you to define sequences to be asked at run time (e.g. Customer, Branch, Geographic Area and Customer Class).

The values entered by the operator can be used anywhere in the report. Typical uses include the entry of a range of items to be printed (e.g. Lowest to Highest, From Date to Date), or the entry of a constant to be used in a calculation.

This option is only available for Alpha variable types.

This field enables you to define the variable as being a fixed string of characters. You enter these characters in the String field below.

This option is not available for alpha variable types.

Select this if you want the variable to be calculated.

For a Numeric variable type, you use the Define Calculation function to define the required calculation.

For a Date variable type, you use the Date, + / - and Days fields to define the date calculation required.

This field is displayed if you selected the Variable usage as Ask at Run Time.

This indicates the wording that is displayed for the prompt when the report is executed. A maximum of 30 characters can be entered.

This field is not displayed for Numeric variable types.

This field is displayed if you selected the Variable usage as Fixed String.

You use this field to enter the fixed string of characters that must be stored in the variable.

This field is not displayed for Numeric variable types.

This field is displayed if you selected set Variable usage as Ask at Run Time.

This enables you to define the default value for the run time prompt. This default can be changed at the time of running the report.

This field is not displayed for Numeric variable types.

A selection of Lowest and Highest enables you to cater for a range of values that must be selected when the report is run.

For example: You could define one variable as %From and the other as %To for a range of supplier codes. You could then set the default for the %From variable to Lowest and for the default for the %To variable to Highest. When the report is run, the operator can either enter the supplier codes required, or press enter against each prompt to accept the defaults and run the report from the Lowest to the Highest supplier code.

A selection of Lowest and Highest enables you to cater for a range of values that must be selected when the report is run.

For example: You could define one variable as %From and the other as %To for a range of supplier codes. You could then set the default for the %From variable to Lowest and for the default for the %To variable to Highest. When the report is run, the operator can either enter the supplier codes required, or press enter against each prompt to accept the defaults and run the report from the Lowest to the Highest supplier code.

This option is available only for numeric variable types defined as Run time prompts.

It enables you to define the run time prompt as a check box instead of a field into which data must be entered.

If you select this option, then you can define the default for the variable as One or Zero. If you define the default for the variable as One, then the check box prompt is automatically selected. If you define the default as Zero, the check box is automatically deselected

This option is only available if you selected the Variable usage as Ask at Run Time.

You use this field to link one of the standard SYSPRO browse programs to your run time variable. This enables the operator to browse for the required data instead of having to remember the exact data required to be entered.

You use the Browse icon next to the Browse program field to view and select the SYSPRO browse program you want to attach to your variable.

For example: If you define a run time prompt as: Supplier code, you can define the browse program as IMPBSP (i.e. The standard browse program used with the Supplier Maintenance program). When the report is run, the browse button alongside the run time prompt enables the operator to browse on the list of suppliers.

It is often difficult to locate the required browse program from the list provided. A quick way to identify the correct program name is to load a program within SYSPRO that allows you to browse on the required field. Select the browse function and then press Shift+F7 to display the program name from the System Information screen.

This option is only available for numeric variables that are calculated.

Select this if you want the calculations to be performed at total as well as at detail level. This option should only be selected when calculating fields such as percentages (i.e. Fields that cannot be totalled).

You would not select this option if the variable is to be totalled as a normal numeric field.

This option is only displayed for Date variables that are defined as Calculated.

For a date column you can calculate a date by using an existing date column and adding or subtracting a number of days.

You use this field to enter either a date field from a SYSPRO table or a user defined date variable.

Select + to add a number of days to the date specified in the Date field, or - to subtract a number of days from the date specified in the Date field.

This option is only displayed for Date variables that are defined as Calculated.

You use this field to enter either a date field from a SYSPRO table, a user defined date variable or a fixed number of days (constant value), that must be added or subtracted from the date defined in the Date field.

This option is only displayed for Date variables that are defined as Calculated.

Select this if you want the variable to be calculated based on some condition.

You use the Define Condition function to define the required condition(s).

You use this option to select the point at which the calculation must be performed.

The following options are available:

Refer to Calculate Variable Example for an example.

You use this function to define the calculation required for the variable.

This function is only enabled for numeric variables with a Variable usage of Calculated.

You use this field to indicate the name of the new variable that must be created.

If the variable name already exists, the program appends a suffix of 1, 2, etc., to the name.

You use this field to indicate the variable you want to import.

All variables using the same tables in the calculation fields as in the table structure of the report are displayed for selection.

You cannot link a table to the Primary table unless the link is defined in the Data Dictionary (see Browse on Data Dictionary Linkages).

The tables displayed in this list can be selected for linking to one of the other tables in the structure. Only those tables linked in the Data Dictionary are displayed.

This column displays the type of link that exists between each available table and the table structure you are currently maintaining.

Link types are either 1-1 or 1-Many.

1-1 Links occur when there is a one to one relationship between two tables (i.e. For every row in the first table, there is only one corresponding row in the second table).

For example the relationship of the ArCustomer to the TblCurrency (Currency) table is a 1-1 link because for each customer you can only define one currency. Similarly, the relationship of the InvMaster (Inventory master) table to the InvBuyer table is a 1-1 link because for each stock item can only define one default buyer.

1-Many links occur when there is a one to many relationship between two tables (i.e. For every row in the first table there can be more than one corresponding rows in the second table).

For example the relationship of the ArCustomer table to the ArMasterSub (Sub accounts) table is a 1-Many link because one customer account can have more than one sub account attached to it. Similarly, the relationship of the InvMaster to the InvAltStock (Alternate stock) table is a 1-many link because you can define one stock item to have many alternate stock items.

This column displays the type of link that exists between the table you lined and the table structure you are currently maintaining.

Link types are either 1-1 or 1-Many.

1-1 Links occur when there is a one to one relationship between two tables (i.e. For every row in the first table, there is only one corresponding row in the second table).

1-Many links occur when there is a one to many relationship between two tables (i.e. For every row in the first table there can be more than one corresponding rows in the second table).