This step illustrates translating a foreign-key to a table. The purpose is to make the report more user-friendly by displaying the actual name of a contact rather than the foreign-key for the field (for example, foreign-key (Item-ID) 1 translates to CEO in the foreign file and foreign-key 6 translates to Consultant in the foreign file). Note that the Title field in the Contact section of the report (as illustrated in the very beginning of this tutorial video) displays foreign-key 6.
|
NOTE- |
A portion of this procedure is accomplished from the Pick Data Provider for .NET Database Administration program. See the Pick Data Provider for Microsoft .NET Using Guide for more information on using the Pick Data Provider for .NET Database Administration program. |
To modify the CustomerInfo report:
Open the Pick Data Provider for .NET Database Administration program.
Right-click the account that contains the file to which you are adding items, and then select the appropriate file (in this tutorial, an item is added to the CUSTOMERS file in the Demo_PickDP account).
The Dictionary Items dialog box displays.
Click New.
Enter the details for the new dictionary item (in this tutorial, the item is named V_POSITION), and then click Export.
The items in the CUSTOMERS file are exported to the Demo_PickDP account and display in the list of items in the Data tab of the SampleReports project.
Select the new item in the list, and then click the Execute current command (!) button to add a field for the item.
Modify the layout by adding the new item to the Layout form, and then select the Preview tab from the report design environment.
The updated report is compiled and displays in the Preview tab. Note that the Title field now displays the actual title name (Consultant) for the individual listed in the Contact section of the report.
