You use this program to create a new report.
Once you have defined the report using the wizard, you can use the Browse on Reports program to make any necessary changes.
| Field | Description | ||||||
|---|---|---|---|---|---|---|---|
| <Back | Select this to display the previous screen. | ||||||
| Next> | Select this to display the next screen. | ||||||
| Cancel | Select this to exit from the Wizard, without saving any selections you have made. | ||||||
| Select the primary table to be used for this report | Select this to exit from the Wizard, without saving any selections you have made. | ||||||
| Primary table |
Indicate the table in the Data Dictionary that you want as the Primary table.
The Primary table is normally the table with the majority of columns that you want to use in your report, or the table that contains the columns you want to sequence or subtotal on your report. The Browse facility is available to select the required table. Once validated the table description is displayed beneath the table name. A maximum of 18 characters can be used for the table name. The SYSPRO table base names are prefixed by an abbreviation of the SYSPRO Module. For example: GenMaster for the General Ledger Master Table. |
||||||
| Select the columns to be printed | At least one column must be selected to print; otherwise you will not be able to continue. You may select up to a total of 100 columns to print on the detail line from either the primary table or any linked table. | ||||||
| Available columns | This list indicates all the available columns from the Primary table that you can select for printing on your report. | ||||||
| Add | This function selects the highlighted column from the Available columns list and adds them to the list of Selected columns. | ||||||
| Remove |
This function removes the highlighted column from the Selected columns list and returns it to the Available columns list. This function is enabled only once you have added at least one column to the Selected columns list. |
||||||
| Clear All |
Select this to remove all columns from the Selected columns list. This function is enabled only once you have added at least one column to the Selected columns list. |
||||||
| Selected columns |
This list indicates the columns you want to include in your report.
|
||||||
| Select the columns used to sequence the report |
This screen enables you to define the column(s) to use to sequence the report. If you do not select any columns for sequencing, then the Primary key of the Primary table is used automatically. |
||||||
| Available columns | This list contains all the columns you selected to print and can be used to sequence the report. | ||||||
| Add |
This function selects the highlighted column from the Available columns list and adds them to the Sequence list. You can add a maximum of 10 columns to the Sequence list. |
||||||
| Remove |
This function removes the highlighted column from the Sequence list and returns it to the Available columns list. This function is enabled only once you have added at least one column to the Sequence list. |
||||||
| Clear All |
Select this to remove all columns from the Sequence list. This function is enabled only once you have added at least one column to the Sequence list. |
||||||
| Sequence | This indicates the columns according to which the report must be sequenced. | ||||||
| Subtotal numeric columns |
Select this if you want to produces a report with subtotals and grand totals for the numeric fields. You can access this option only if you have selected at least one column according to which to sequence the report. |
||||||
| Do you wish to print columns from another (linked) table | You can select up to a total of 100 columns to print on the detail line from either the primary table or any linked table. | ||||||
| Print columns from the primary table only | Select this if all the information you require on your report is in the Primary Table. i.e. All the columns you want to print are defined in the primary table. | ||||||
| Include columns from another table | Select this to print information from other tables. i.e.e All the columns you want to print are not in the primary table. | ||||||
| Select from the following list of linked tables |
This option is available if you selected to include columns from another table. It enables you to select the table from which you require additional columns for your report. All tables linked to the primary table you selected are displayed for selection. |
||||||
| Select the columns to be printed |
This screen is displayed if you selected to include columns from a linked table in your report. At least one column must be selected to print; otherwise you will not be able to continue. You may select up to a total of 100 columns to print on the detail line from either the primary table or any linked table. |
||||||
| Available columns | This list indicates all the available columns from the Linked table that you can select for printing on your report. | ||||||
| Add | This function selects the highlighted column from the Available columns list and adds them to the list of Selected columns. | ||||||
| Remove |
This function removes the highlighted column from the Selected columns list and returns it to the Available columns list. This function is enabled only once you have added at least one column to the Selected columns list. |
||||||
| Clear All |
Select this to remove all columns from the Selected columns list. This function is enabled only once you have added at least one column to the Selected columns list. |
||||||
| Selected columns |
This list indicates the columns you want to include in your report.
|
||||||
| Enter the report code and the report title | |||||||
| Report |
This defaults to a system-generated Report Code which comprises of an abbreviated six character Primary Table Description, then a sequence number indicating how many times this table has been used as the Primary Table. For example: Report Code - ADMJOB-1 where ADMJOB = Admin Job Logging Table and -1 means it has not been used as a primary table before. If you define a report code, it should be in a format that is meaningful to you.
|
||||||
| Title |
This defaults to a system-generated Report Title, beginning 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. You can define your own Report Title, utilizing a format that is meaningful to your company.
|
||||||
| Security | This option enables you to,define the security you want to place against this report. | ||||||
| Anyone can edit and run this report | Select this if you want any operator to be able to run and/or edit this report. | ||||||
| Only you can edit but anyone can run this report | Select this to allow any operator to be able to run the report, but only you to have the permission to edit the report. | ||||||
| Only you can edit and run this report | Select this if you want no operator except yourself to be able to run and/or edit this report. | ||||||
| Report type | This indicates how the report must be
output.
|
||||||
| Save report and run it now | Select this to save the report and print it immediately using the Report Writer program. | ||||||
| Save report and edit it now | Select this to save the report and maintain it immediately using the Browse on Reports program. | ||||||
| Save report only | Select this to save the report only. | ||||||
| Finish | Select this to create the report and exit the Report Wizard program. | ||||||
![[Note]](images/note.png)
-
Before you can add reports, you need to use the RW Data Dictionary Import Wizard program to import the data dictionary into the Report Writer module. Please refer to Report Writer Introduction for additional information about the Report Writer module.