Successfully!

Error!

Insert Formulas

  • Author:ayuan0625
  • Recent Updates:FRInternational on 2021-08-03
  • I. Overview

    1) FineReport allows you to insert formulus into cells to achieve more complex and variable report effects.

    2) Compared to Excel, FineReport provides rich built-in functions.

    You will learn
    • Insert Cell

    • Formula Definition Window

    • Simple Formula Examples

    II. Steps

    There are 3 ways to insert a formula.


    1. Method 1

    In the right-hand pane, click the drop-down box and select [Insert Formula]

     


    2. Method 2

    In the upper toolbar, click Insert->Cell Element->Insert Formula.


    3. Method 3

    In the upper toolbar, click the formula icon


    4. Formula Definition Window

    1) Formulas can be constructed by constants, variables, operators and functions.

    • Constant:Number, string, etc.

    • Variable:Parameters, cells, widgets, etc.  For the use of parameters, please refer to Global Parameters and Template Parameters and Dataset Parameters.

    • Operator:Arithmatic operators, logical operators, comparison operators, etc.

    • Function:FineReport provides abundant built-in functions.

    2) When you enter a formula in the input box, other regions in the window will react accordingly to help you quickly find out the exact built-in function.


    5. The built-in functions support fuzzy search

     Double-click the result to add the function to your formula.


    6. Search for a built-in function based on function type

    The lower-right region will describe the function prototype and usage scenarios.


    7. Click the [Validity Checks] button to ensure the formula is legal


    8. Simple Formula Example (1)

    1) Create a title using a sring and a function

    • Insert a formula in B2.

    • Input: "Report of " + TODAY(). Click OK.

    2) Broaden the cell, and the cell content begins with "=", indicating that its a formula. Preview.

    3) The preview result shows the date when you make the report.


    9. Simple Formula Example (2)

    1) Create a dataset by DB query and drag table [Sales_Volume].

    2) Drag data column [Sales_Volume] to B2.

    3) Insert a formula in C2. Input: B2 - 100. Click OK.

    4) Preview. A new column of data is created next to the original data column.


    10. Simple Formula Example (3)

    1) Create a dataset by DB query and drag table [Sales_Volume].

    2) Drag data column [Sales_Volume] to B2.


    3) Insert a formula in B1. Input: SUM(B2). Change the font color of B1 to red.

    4) Preview. A summation appears above the data column.


    11. Simple Formula Example (4)

    1) Create a dataset by DB query and drag table [Sales_Volume].

    2) Drag data column [Sales_Volume] to B2.

    3) insert a formula in C2. Input: B2 > 200. Click OK and make the content in B2 and C3 align center.

    4) Preview. The comparison results appear on the right of the data column.

    Attachment List


    Theme: Designer
    Already the First
    Already the Last
    • Helpful
    • Not helpful
    • Only read

    Doc Feedback