We will introduce Change displayed value – form of FineReport reporting tool in this article.

1. Description

An original data table stores data of code nature. Data presentation displays meaning actual values, but codes and values tend to be stored in another table.

If there is only Client ID in the Order Table of the built-in FRDomo database and the corresponding Client Name is in the Client Table, in order to display Client ID in the Order Table as the corresponding Client Name:

FineReport Cell Attribute Table – Form > Data Dictionary can be used to address such problem.

2. Realization Steps

2.1 Open report

Open the report of %FR_HOME%\WebReport\WEB-INF\reportlets\doc\Primary\DetailReport\Details.cpt

To see only Client ID in the report to be displayed as the corresponding Client Name in the Client Table.

2.2 Set Form – Data Dictionary

Select data column cell of Client ID, right click to select Form > Data Dictionary, or directly select Form in the Cell Attribute panel at lower right corner and set the actual value of this column to the Client ID column in the Client Table, displayed as Company Name column in the Client Table.

Function of style: Displaying cells as other values or other styles without changing the actual cell values. See more Forms.

The function of data dictionary is to display the corresponding display value of each extended actual value.

2.3 Save and preview

Saved preview effect is as follows:

Click Details_1.cpt to check template effect online.

For completed templates, refer to %FR_HOME%\WebReport\WEB-INF\reportlets\doc\Primary\DetailReport\Details_1.cpt