You use this program to create the Report Writer data dictionary from the standard SYSPRO data dictionary.
The SYSPRO Report Writer data dictionary defines the data structures that can be used by the Report Writer. It contains details of all the tables, columns and the logical links, keys and comments between them.
Custom form table information for SQL databases can be imported into the Report Writer data dictionary using the Custom Form Design program.
An easy-to-use Wizard guides you through the process of setting up your Report Writer data dictionary. The wizard displays a number of screens, some of which provide you with information; others which require that you make certain selections.
Field | Description | ||||
---|---|---|---|---|---|
<Back | Display the previous screen. | ||||
Next> | Display the next screen. | ||||
Cancel | Exit from the Wizard, without saving any selections you made. | ||||
Select the modules you wish to have installed in the Report Data Dictionary | |||||
Available modules |
All the modules listed in this list box may be added into the data dictionary. Once a module is added into the data dictionary, it is then removed from the available modules list box and is displayed under the contents of the data dictionary list box. This list is empty if all modules have previously been imported into the data dictionary. |
||||
Add |
This allows you to individually select a module to import into your data dictionary and add the highlighted module in the Available modules list box to the Contents of data dictionary list box. |
||||
Add All |
This allows you to add all available modules for importation into your data dictionary by adding all the Available modules to the Contents of data dictionary list box. |
||||
Remove |
This enables you to deselect individual modules from the import by highlighting a module in the Contents of data dictionary list box and moving it back to the Available modules list box. A warning is displayed, informing you that any existing reports that use tables from these modules cannot be edited or printed. You can either cancel the Remove or continue. This function is only available if one or more columns have already been imported into the data dictionary. |
||||
Remove All |
This enables you to deselect all modules from the import by removing all modules in the Contents of data dictionary list box and transferring them back to the Available modules list box. A warning is displayed, informing you that any existing reports that use tables from these modules cannot be edited or printed. You can either cancel the Remove or continue.
This function is only available if one or more columns have already been imported into the data dictionary. |
||||
Contents of data dictionary |
All the modules listed in this list box are available in the data dictionary and can be imported. Once a module is removed from the data dictionary, it is removed from the contents of the data dictionary list box and is displayed under the available modules list box. This list is empty if you have not imported any modules into your data dictionary. |
||||
Update Single Module |
This function is enabled when a module is highlighted under the Contents of data dictionary list box. Select this to update only the selected module with the latest Standard SYSPRO Data Dictionary Contents. |
||||
Before creating the new columns against each table, you can elect to remove any existing columns (for those tables) to be imported | Your selections determine which fields must be removed or remain within the data dictionary, before the actual import takes place. | ||||
I do not want any columns to be removed |
Select this to update existing columns and import new columns to the tables. No existing columns are deleted. This is the default selection. |
||||
I only want standard SYSPRO columns to be removed |
Select this to remove the standard SYSPRO columns, but keep any user defined columns. The user-defined columns are ignored, but all the SYSPRO standard columns are deleted before being rebuilt. |
||||
I want to remove all existing columns |
Select this to remove all existing columns from the tables and replace them with only the standard SYSPRO columns. All the columns are deleted, including any user-defined columns, before being rebuilt. |
||||
I want all imported tables to be set to Read only |
Select this to prohibit operators from creating reports that change your data in any way, as access to the Data Dictionary is set to Read Only. Once the files have been imported, the status can be changed as required using the Browse on Data Dictionary Tables program. |
||||
Finish | This function imports the selected Data Dictionary by transferring the contents of selected tables from the standard SYSPRO data dictionary to the Report Writer data dictionary. The data type against each field is also transferred to each column in the Report Writer data dictionary. |
This Import must be run before you can use the Report Writer. This is so that the report writer data dictionary can be created from the standard data dictionary.
The Report Writer module uses its own data dictionary and not the standard data dictionary. Once you have created the report writer data dictionary, you can amend this dictionary as required. You should never amend the standard data dictionary.
See also Custom Form Design - Notes and warnings.