![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
The following table presents the tasks required to generate a report. The number of tasks involved varies if your report is based on more than one data table. Except for Task C, the procedure is the same for single or multiple data tables.1
This task indicates which data tables you require for your report. You can access the Select Source Tabless screen by selecting its option on the main Report Generator screen.
How to Enter ValuesEnter values directly in the top portion of the screen or select them from the scrollable display in the bottom portion of the screen.Displaying Tables for SelectionWhen the Select Source Tables screen first appears, it contains a scrollable listing of tables based upon your default UNIT. You can modify this listing to display a subset of these tables or a different set of tables. Use the following as a guide to help you find the tables you are looking for:
The UNIT that you require Tables with UNIT field. The approximate names of the tables that you require NAME like field. type in a partial name along with the asterisk (*), oruse question mark (?) wildcard characters. Both the UNIT and approximate name Tables with UNIT field and NAME like field Type in the values as described above.Type an alphanumeric character in the line command field of each table that you want to select. Use the sequential order 0-9, A-Z. The tables are then listed in the Table field based on this order.To remove a table name from the list, position your cursor on the table name and press PF23. If you remove a table, all references to that table in the rest of the report are also deleted.
• One or more table names can be entered into a Table field. Enter each table name on its own row in the Table field.
• If you are using multiple tables, the first one selected becomes the outer table within which subsequent FORALLS are nested.
• If you are using multiple tables, enter the table names so that you can use the data from the multiple tables (relating data). Refer to Task C, Relate the data of two or more tables for more information about relating tables.
• If a table is parameterized, you can also enter the parameter name and value (thus bypassing the Specify Parameters screen). Refer to Task B, Specify parameter values for more information.
• The PRM table must be included before the source parameterized table in the list of tables in the Select Tables screen. If the PRM table does not exist, contact your TIBCO Object Service Broker administrator.Task B Specify parameter valuesThis task is used to indicate (to the report formatter) which instance of a parameterized table to use in the report.Parameter values are required only for parameterized tables. There are three different places to specify the parameter values required for parameterized tables. Depending on your requirements, you can use the:
Know the parameter value Type the value in the Parm Value field, next to the appropriate parameter name. Refer to Task A, Identify the source data tables for an illustration of this screen. Do not know the parameter value and you are not going to relate parameter values to field values Specify Parameters. Type the value in the Parm Value field, next to the appropriate parameter name and select the value from the displayed list. Refer to Guidelines for Specifying Parameter Values for more information. Are going to relate parameter values to field values Refer to Task C, Relate the data of two or more tables for more information.
• A PRM table for the parameterized table is required to select parameter values. If the PRM table does not exist and you require one, contact your TIBCO Object Service Broker administrator.
• A PRM table is not required if you are entering the parameter values directly into the Select Tables screen or Relate Tables screen.
• A default value of null ('') appears in the Parm Value field of the Select Tables screen if a table has a location parameter and a value is not assigned to it.TIBCO Object Service Broker Managing Data for more information on location parameters.When the Specify Parameters screen first appears, it contains a scrollable listing of parameter values for the first parameter name listed on the Select Tables screen. The following table describes how to display additional parameter values:
Position your cursor on the parameter name and press Enter.Specify Parameter Values Screen
Selecting Parameter ValuesTo select a parameter value, type an alphanumeric character in the line command field of the required value.Complete this task if you are using data from more than one table. You must draw a link between the tables by associating individual elements from the tables to one another. You use the Relate Source Tables screen to associate the data.Relate Source Tables Screen
Enter the values directly into the appropriate fields or select them from the scrollable display in the bottom portion of the screen.When the Relate Tables screen first appears, the bottom portion of the screen contains two columns listing the fields or parameters of the first two tables selected in the Select Tables screen. The columns contain the following information:
• The RELATE column contains the table name and the fields of the second table entered in the Select Tables screen.
• The TO column contains the table name and the fields of the first table entered in the Select Tables screen.Displaying Additional Table and Field Values
Sequential listing of additional tables. Position your cursor on the table name and press Enter.Type a pair of identical alphanumeric characters in the line command fields of the fields or parameters you want to relate and press Enter. For example, to relate the DEPTNO field of the EMPLOYEE table to the DEPTNO field of the DEPARTMENT table, type the number 1 next to DEPTNO of both tables. Repeat this operation until all required links are made.
• A field of a table can be associated with only one other field or parameter. The semantic type must be compatible.
• Each table must be associated with at least one table preceding it in the list of the Table field in the Select Tables screen.
• The PRM table must be included before the source parameterized table in the list of tables in the Select Tables screen. If the PRM table does not exist, contact your TIBCO Object Service Broker administrator.
• Assignments to parameter values in the Specify Parameters screen are overridden if the parameter is associated with a field of another table.Task D Specify selection criteriaThis optional task is used to specify the selection of data when you want to report on a specific range of data. Use the Specify Selection Criteria screen to specify the selection of data.Specify Selection Criteria Screen
You can enter values directly into the appropriate screen or select them from the display in the bottom portion of the screen.When the Selection Criteria screen first appears, it contains a list of the fields of the first table entered in the Table field of the Select Tables screen. Press Enter to display the rest of the tables in sequence.
4.
• Recall previous selections by pressing PF9. This re-enters your selection values in the line command fields of the previously selected fields.The following illustrates two types of data selection: Numeric Field Value and Character Data Selection.Numeric Field Value SelectionThe following example shows how to select data that is specific only to the manager number 79912 or the manager number 80002:Character Data SelectionThe following example shows how to select data that is specific to the departments managed by JOHN DUBINSKY:Specify Print/Control Fields Screen
To display across the report (if the report is defined as an across report). To display a summary of the data (if the report is defined as a summary or across report).
These field types are required for a summary or across report only. For more information on summary reports, refer to Chapter 5, Creating Across Reports.
When the Print/Control Fields screen first appears, it contains a listing of the fields of the first table entered in the Table field of the Select Tables screen. Press Enter to display the fields in the rest of the tables in sequence.
1. To create a report that summarizes data, type Y in the SUMMARY only field. For more information on summary reports, refer to Chapter 5, Creating Across Reports.
• Sort-by fields are sorted in ascending order by default. To sort in descending order, specify D in the A/D field.
• Across-by fields cannot be sort-by fields.
• Recall previous selections by pressing PF9. This re-enters your selection values in the line command fields of the previously selected fields.Using this task you can perform mathematical computations within your report either at break time or within a summary report (using the functions supplied by the Report Generator). Use the Select Report Functions screen to identify the mathematical functions that you want to use.Select Report Functions Screen
• The name of a break field is entered into each break-by section; you cannot modify the value in this screen.Up to three break-by fields appear at a time in each break-by section. To view additional fields press Enter.
• The function TOT appears beside each numeric print field; you can delete or modify this as required.Each selected function is associated with a print field within a break. The values are printed at the end of the break. A function associated with a print field in the final break prints a grand total for that field at the end of the report.When the Report Functions screen first appears, it contains a list of the fields of the first table entered in the Table field of the Select Tables screen. Press Enter to display the fields in the rest of the tables in sequence.
1. Customize/Execute Report Screen
You can make changes to the appearance of your report before it is executed. Use the numbered lines in the Line# field to customize the title of your report. You can use up to 132 spaces across two lines numbered the same for each title line of your report. You can add up to two complete lines of text.The following report functions are provided in the first title line. These can be moved or deleted as required:
The date the report is executed, using the default date format for your session. The time the report is executed, using the default time format for your session. The TIBCO Object Service Broker name under which your report is saved. Use the Label field to customize the field titles that appear for your print fields and break/summary functions. The new text must be within single quotes, for example, ‘Department’.You can use the Display Mask field to define the display format for numeric and date fields. An example of a display mask is a dollar sign ($) proceeding and a comma (,) separating numbers. You can also add a debit and credit mask, to be used in conjunction with the other masks.To add a display mask, type in valid display mask values in the Display Mask field on the appropriate line for the field. For valid display mask values, refer to TIBCO Object Service Broker Defining Screens and Menus and the $PIC tool in TIBCO Object Service Broker Shareable Tools. Use the following fields to change or add display masks to your numeric fields.
COMMA field. The default monetary symbol for your session and commas as numeric delimiters MONEY field. D/C field andCOMMA field, orMONEY field.
3. A representational example of the mask appears in the Display Mask field.To rename the report, change the name of the report to a valid TIBCO Object Service Broker name in the Report field. When you save the report it is saved under this new name.Task H Execute the reportThe following table lists the functions you can perform using the Customize/Execute Report screen:
Limit the number of occurrences to be printed on the report The number of occurrences with record limit field. Destination Screen field. Destination Printer field. File field. Save Report field. The name to save it under Send the report to a DDname or variable DDname/Variable field. Save the report and send it to its destination Save Report field.
Enter the fully qualified name of a pre-allocated data set with a minimum record length of 132. If the data set is partitioned, enter the member name in parentheses.
When you type Y in the and send it to Screen field and press Enter, the report appears on your screen. The following illustrates an example of a displayed report:
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |