|
Report Generator |
|
|
|
|
Report Generator |
|
|
Report Generator
|
Report Generator |
|
|
|
|
Report Generator |
|
|
In addition to the standard set of custom reports, RAM Commander provides a Report Generator for designing and printing custom reports. The report generator requires experience in RAM Commander operation. Before generating a new report, examine an existing report definition to understand the report generator’s primary principles and options.
Report definition involves two phases. The first phase is building the report by selecting which data fields to include, sort orders, column widths, and optional column headings. The report’s appearance can now be customized as described below (Report Style Setup dialog box).
Report Generator may generate reports based on the product tree structure, reliability, maintainability and FMECA data of product tree elements. It does not provide information on FTA, RBD and other modules.
To add a tree data report using the Report Generator
| 1. | Activate the Product tree view. |
| 2. | From the Reports menu, choose Report Generator; the Report Definition dialog box opens. |
| 3. | In the Report Definition selection box at the top of the Report Generator dialog box, choose Add and enter a new report name. |
| 4. | In the lower Field box, choose Add; the Add/Edit Field dialog box opens: |
| 5. | In the Add/Edit Field dialog box, select a screen name to which the field belongs from the Group list box (General/Operating/Non-operating/Maintainability/ILS/Miscellaneous/FMECA). |
| 6. | In the Field name list box, select a field. |
| 7. | In the Width field, enter a field width. If a floating-point field is selected, enter the number of decimal places. Make sure to provide enough space for your numeric values. For example, width = 10 and decimal places = 3 will give output like 12.345. However, if the number is smaller than 1e-3 and it is not possible to display the most significant part of it using 3 decimal places, this number will be displayed in engineering form like 1e-4. |
| 8. | If required, change the column name to the desired column name you wish to appear in table header of the report. |
| 9. | To define the current field as a sorting key, choose First or No to set the sorting priority. |
| 10. | Choose OK. |
| 11. | Repeat steps 3-10 to add more fields to the report. |
| 12. | Choose Generate. |
| 13. | RAM Commander displays your customized report in a window. Since RAM Commander automatically saves the report definition, it can be used during subsequent sessions. |
Report Generator supports calculated fields, where user may define a formula and report will display calculated values. In order to create calculated field, add a field with Group="CA" and Field="Formula" in the Report Generator. Then select this newly added field in the list and press Edit button. Field data dialog will appear with the formula field available.You may enter formula manually, however, it is recommended to use formula editor instead – press the "Edit Formula" button to get the formula editor:
Compose the formula by double-clicking on fields list, functions, and operators lists to insert them into the formula at current cursor position. The generated report will contain column with values calculated for each item according to the defined formula. Each report definition may contain multiple formulas.
Existing customized reports may be edited.
To edit a customized report
| 1. | From the Report Generator dialog box, select the report from the Report Definition list box. |
| 2. | Select the required field by clicking on its number under the # column. |
| 3. | Choose Edit from the lower Field box; make the required changes to parameters in the Add/Edit Field dialog box |
- or -
change the parameters from within the grid by clicking on it.
| 4. | Choose OK. |
| 5. | RAM Commander redisplays the updated Report Generator dialog box. To delete a particular field from your report, select it and choose Delete from the field group. You can change the order of the fields using the Move up and Move down buttons. |
RAM Commander automatically saves your report definitions as you create them. To delete unneeded reports, select them from the Report Definition list box and choose Delete.
You can customize the appearance of your report. From the Report Generator dialog box, choose Setup. The Report Style Setup dialog box opens.
The customizations apply to all user-defined reports, not just the one selected in the Report Definition list box.