{"id":3734,"date":"2016-07-12T03:00:28","date_gmt":"2016-07-11T19:00:28","guid":{"rendered":"http:\/\/www.finereport.com\/en\/?p=3734"},"modified":"2019-10-24T16:24:26","modified_gmt":"2019-10-24T08:24:26","slug":"cell-form","status":"publish","type":"post","link":"https:\/\/www.finereport.com\/en\/product-functions\/cell-form.html","title":{"rendered":"One of Settings to change cell value – Form"},"content":{"rendered":"

There are four settings in report designer<\/a> to change cell value: form, style form, new value attribute in condition attribute and custom display in advanced attribute of data column.We’ll study one of them: Form in our business intelligence tool<\/span><\/a>.<\/p>\n

1. Description<\/h3>\n

A cell value in report designer is divided into two parts: actual value and display value. Actual value means the actual value of cell, while display value is the value displayed after setting of form and style.<\/p>\n

There are four settings in the designer to change cell value: form, style form, new value attribute in condition attribute and custom display in advanced attribute of data column. Among these four settings, some changes display value, and some changes actual value of a cell.<\/p>\n

Description will be made to form below. For other three setting methods, refer to Style<\/span>, Condition Attribute-New Value<\/span> and Data Column Custom<\/span> display.<\/p>\n

2. Form setting<\/h3>\n

Select the cell for setting. Right click and select Form for setting. There are 4 types of forms: data dictionary, formula form, barcode and amount line, which will be described one by one below:<\/p>\n

\"\"<\/p>\n

2.1 Data dictionary<\/strong><\/p>\n

In original data, what\u2019s saved is the data of code nature. However, data presentation requires meaningful actual value. That means, corresponding data should be displayed based on a coding table. This coding table is data dictionary. Select Cell Form as Data Dictionary. Based on data source for constructing data dictionary, the data dictionary types include: database table, data query, custom and formula.<\/p>\n

For example, if there is only Client ID in the table and the corresponding Client Name is in another table, we can display the Client Name in another table through data dictionary setting.<\/p>\n

Select the cell. Right click to select menu Form > Data Dictionary<\/span> for setting, as shown below:<\/p>\n

\"\"<\/p>\n

2.2 Formula form<\/strong><\/p>\n

Some complex data dictionaries are used for switching actual value and display value.<\/p>\n

Select the cell. Right click to select menu Form > Formula Form<\/span> for setting.<\/p>\n

\"\"<\/p>\n

For detailed usage of formulas, refer to Function Usage Instructions<\/span>.<\/p>\n

2.3 Barcode<\/strong><\/p>\n

Barcode is a graphic identifier to represent a group of information like certain characters and numbers with several black bars and blanks in different widths based on certain coding rules.<\/p>\n

After setting, barcode will be displayed.<\/p>\n

Select the cell. Right click to select menu Form > Barcode<\/span> for setting.<\/p>\n

\"\"<\/p>\n

2.4 Amount line<\/strong><\/p>\n

For banking industry, amount lines are used to view amounts in figure. After setting amount lines, the report will display amount line format.<\/p>\n

Select the cell. Right click to select menu Form > Amount Line<\/span> for setting.<\/p>\n

\"\"<\/p>\n

2.5 Cancel form setting<\/strong><\/p>\n

Select the cell. Right click to select menu Form > Cancel Form Setting<\/span> to cancel related form settings.<\/p>\n

See %FR_HOME%\\WebReport\\WEB-INF\\reportlets\\doc\\Primary\\DetailReport\\Details_1.cpt<\/span> for completed templates.<\/p>\n

3. Priority<\/h3>\n\n\n\n\n\n\n\n
Action<\/td>\nChange display value or actual value of a cell<\/td>\nExecution sequence<\/td>\n<\/tr>\n
Custom display of data column<\/td>\nDisplay value<\/td>\n1<\/td>\n<\/tr>\n
Cell format<\/td>\nDisplay value<\/td>\n2<\/td>\n<\/tr>\n
Cell style<\/td>\nDisplay value<\/td>\n2<\/td>\n<\/tr>\n
Condition<\/td>\nDisplay value<\/td>\n3<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

There are four settings in report designer to change cell value: form, style form, new value attribute in condition attribute and custom display in advanced attribute of data column.We’ll study one of them: Form in our business intelligence tool. 1. Description A cell value in report designer is divided into two parts: actual value and…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[111],"tags":[117],"yst_prominent_words":[2169,2164],"_links":{"self":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/3734"}],"collection":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/comments?post=3734"}],"version-history":[{"count":9,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/3734\/revisions"}],"predecessor-version":[{"id":8544,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/3734\/revisions\/8544"}],"wp:attachment":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/media?parent=3734"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/categories?post=3734"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/tags?post=3734"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/yst_prominent_words?post=3734"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}