To select the entities to be used in a Crystal Reports report, prior to the layout design stage, you need to either select the Layout manager context-sensitive menu option or button in one of the following tabs or dialog boxes:
Select report in the CDM,
Work with a batch program (BPM) in the Object manager,
Reports of the Object manager,
List of Reports in the 4GL Editor.
Important: Once the Crystal Reports® application has been started, you will still be able to access this dialog box (it remains active), in order to regenerate the necessary interface files if you wish to add new fields to the report. To do so, you just need to check the boxes in front of the fields you wish to add, and to generate the files again from the contex-sensitive menu. However, the left-hand tree view will be dimmed and unavailable. It will be updated when Crystal Reports® is closed.
Back into Crystal Reports®, remember to choose the Verify database option from the Database menu, in order to apply the modifications to the report.
Tree views
Fields used in the report
Tree view of the entities used in the report, with for each entity, the list of properties placed in the report.
The names of the various subreports (including the main report) containing a given property will be shown for each property.
At the bottom of the tree, you will find the list of the work variables that were placed on the report.
Fields not used in the report
Tree view of the entities attached to the current application area that have not yet been used in the report.
At the bottom of the tree, you will find the list of the program's work variables.
When the tree is expanded, the properties and work variables are preceded by a check box that shows their status:
Box checked |
The field will be generated in a "ttx" file. |
Box checked/grey background |
The field is placed on the report and will be automatically generated. You cannot deselect it here. |
Box unchecked |
The field will undergo no action. |
Check boxes
Display all of the repository's logical entities
Checked |
The tree view of unused fields displays all logical entities of the Adelia repository, irrespective of their attachment to the current application area. |
Unchecked |
The tree view displays only those logical entities attached to the current application area. |
By default: unchecked.
Context-sensitive menus
Entities used in the report
Apply edit codes
Applies a format to each layout field, as dictated by the corresponding property's edit code.
Properties placed in the report
Use management rules
Lets you display or modify the exclusion status of the property's management rules.
Apply edit code
Applies a format to the selected layout field, as dictated by the corresponding property's edit code.
Rename field
Renames the layout field related to the property.
Restore original name
Restores the original name of the layout field related to the property.
Note: When a layout field is renamed, the name in the tree view is as follows: RenamedName[OriginalName].
In the Crystal Reports layout of the report, renamed fields are displayed with their original names. Indeed, the report is based on the entity's description file; should the name of a field be changed in this file, the field would be removed from the report.
Buttons
Designer (validation)
Used to access the Crystal Reports Designer for Visual Adelia.
This is when the "ttx" files will be generated.
Cancel
Closes the dialog box.
Keyboard shortcut: Esc.