Java Reporting Tools Finereport Formula Usage Summary

There are many places where the formula is FINEREPORT, the cell ( 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, Even the mouse hover hints in other properties of the cell can be written as a formula, although the edit box is very different.

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 formula 1, Value 1,if ( conditional 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 judged to be empty, use isnull ().

4.3format formula. The format formula is more flexible. format ($$$, "0.00") can convert the current cell number to two decimal places, or you can use format (" Budget value:0.00 million ") to The Budget value:12.00 million, 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 month-date 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. These documents are available (in English case).

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 the DS1 Region field,group is a grouping, so it is easy to know that select is a list,ds1.select ( salesperson ) is the list form to get the Salesperson field, you can add restrictions, such as Ds1.select ( salesperson , sales =111) is A collection of salespeople who get sales for 111.

several functions associated with datasets are colcount colname row rowcount , and so on.

8. hierarchical coordinates.

The level coordinate is the formula inside the comparison difficulty, "The playability" is very strong, the thing is more, can only remember the most commonly used several, can solve various BT 's 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.

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.

Java Reporting Tools Finereport Formula Usage Summary