Introduction to the syntax of the formula edit box for the Java Report Tool Finereport

There are many places where the formula is Finereport, the cell (which is parsed as a formula at the beginning of the =), the condition display, the data dictionary, the report property value definition, the chart title, the axis definition, the header footer, and even the mouse hover hint content in the cell's other properties can be written in the formula, Although the edit box is very unlike.

Simply say your own sense of the formula to pay attention to several places:

1.if statement syntax Just contact feels strange, if (conditional, value 1, value 2), if can be nested, if (conditional equation 1, value 1,if (conditional equation 2, value 2, value 3)).

2.switch statement Also, the specific function I did not say.

3. Both single equals and double equals are OK for judging.

4. Both single and double quotation marks are used for strings.

4.1bool only true or false. With logic or && or logic or | |.

4.2 The judgment is empty words with isnull ().

4.3format formula. The format formula is more flexible. Format ($$$, "0.00") can convert the number of the current cell to two decimal places, or you can use format (12, "budget value: 0 Yuan") to turn 12 into a budget value: 120,000 yuan, this is not the same as the custom display data dictionary God Horse is similar to the wonderful AH. One thing to note is that the full-digit days of the word style is "yyyy-mm-dd", instead of "yyyy-mm-dd", the lowercase MM means minutes (minute).

5. The syntax for taking a cell in a formula is directly A1 this or B2, and the grammar across sheet values is sheet1! A1. (English case) these documents have.

6.sql function, this is the method of calling the database directly in the formula.

7. Data set formula.

A dataset formula is a way for a formula to call a dataset directly. This formula does not show (there are several scattered and dataset-related functions), I say.

For example, there is a template dataset ds1, whose field is region, salesperson, sales, you can use Ds1.group (region) to get DS1 Region field, Group is a group, so it is easy to know that select is a list, Ds1.select (salesperson) is the list form to get the Salesperson field, Restrictions can be added, such as Ds1.select (salesperson, Sales =111), which is a collection of salespeople with a sales volume of 111.

Several functions associated with datasets are ColCount colname row rowcount, and so on.

8. Hierarchical coordinates.

The level of coordinates is the formula inside the more difficult, "playable" very strong, things more, can only remember the most commonly used several, can solve a variety of BT needs. The more common one is the ranking formula =count (B3[!0]{b3 > $B 3}) +1. See for yourself. Http://www.finereporthelp.com/help/1/4/7.html

9. Filter the formula.

The filter has two condition types, one of which is the formula condition. A little bit different from this formula is that you can write directly to any field in the dataset where the current cell is located, much more flexible than the normal formula. Also take your own sales list as an example, to the Region field cell filter, formula conditions can be directly written: Sales ==111.

10. Condition properties.

Conditional attributes to say is not a formula, with a lot of feeling very natural, but just contact when the feeling is not very good understanding. Simply put. The condition Properties panel, above is the attribute, the following is the condition. When the following conditions are met, that is, when the return value is true, the above property setting is performed.

Introduction to the syntax of the formula edit box for the Java Report Tool Finereport