FineReport

https://help.fanruan.com/finereport-en11.0/
Admin
FineReport is an enterprise-level web reporting tool that enables users to create complex reports...
Tokens:9,421
Snippets:187
Trust Score:9.6
Update:6 months ago
Show doc for...
Tokens:
Raw
### Accessing Server Deployment Wizard

Source: https://help.fanruan.com/finereport-en11.0/doc-view-2772.html

If the project fails to start, the system automatically navigates to the Server Deployment Wizard page. This URL is used for local deployment.

```text
http://localhost:8080/webroot/decision
```

--------------------------------

### Copying tools.jar to Project

Source: https://help.fanruan.com/finereport-en11.0/doc-view-2772.html

To resolve the 'Project missing tools.jar' error, copy the tools.jar file from your %JAVA_HOME%/lib directory to the project's WEB-INF/lib folder.

```text
%JAVA_HOME%/lib
```

```text
project name/WEB_INF/lib
```

--------------------------------

### FineReport Exception Reference

Source: https://help.fanruan.com/finereport-en11.0/doc-view-1062.html

A comprehensive list of error codes and their corresponding descriptions for the FineReport platform.

```APIDOC
## FineReport Exception Codes

### Description
This table provides a reference for error codes returned by the FineReport platform when operations fail.

### Error Codes
| Category | Error Code | Description |
| :--- | :--- | :--- |
| Decision-making platform | 21300001 | Server time-out |
| Upload file | 21300002 | Failed to upload the file, the file is too large |
| Upload file | 21300003 | Failed to upload the file, binary header verification failed |
| No permission | 21300004 | Does not have permission |
| Repeated naming | 21300005 | Repeated naming |
| User | 21300006 | User unavailable |
| User | 21300007 | User name password error |
| User | 21300008 | Import tree dataset did not empty the original data |
| User | 21300009 | Import encryption mode changed, original data not cleared |
| User | 21300010 | Ordinary users do not support this operation |
| User | 21300011 | The old password is the same as the new password |
| Login | 21300014 | Login information not available |
| Login | 21300015 | Special characters prohibited |
| Login | 21300016 | Access record does not exist |
| Login | 21300018 | Login authentication information parsing error |
| Login | 21300019 | Login device mismatch |
| Cluster configuration | 21300020 | Platform database not migrated |
| Cluster configuration | 21300021 | Status server connection failed |
| Cluster configuration | 21300022 | File server connection failed |
| Backup restore | 21300023 | Backup file does not exist |
| Update and upgrade | 21300024 | The platform started by designer does not support upgrading jar package |
| User | 21300025 | Authentication mode change did not kick out the user |
| User | 21300026 | Platform users remove users not kicked out |
| Directory | 21300027 | Unable to move to target location |
| User | 21300028 | Switch user dataset did not kick out user |
| User | 21300029 | Old password error |
| User | 21300030 | You have no right to use the mobile terminal, please contact the administrator |
| Cluster configuration | 21300031 | Bash configuration failed |
| Cluster configuration | 21300032 | Spider cluster service failed to start |
| Cluster configuration | 21300033 | Operating system mismatch |
| Data connection | 21300034 | The data connection is being edited by a user |
| Data connection | 21300035 | The data connection has been deleted |
| Directory | 21300036 | Directory node does not exist |
| Business package | 21300037 | Service package line filter already exists |
| Resource migration | 21300038 | The content of the uploaded migration file is empty |
| Resource migration | 21300039 | Failed to import BI template |
| Resource migration | 21300040 | Import node type conflicts with existing type |
| Task schedule | 21300041 | FTP upload error |
| Data connection | 21300042 | The data connection type is not adapted |
| Burying point | 21300043 | Event track collection trigger limit |
| Task schedule | 21300044 | The task schedule result file does not exist |
| Task schedule | 21300045 | Task schedule object type not recognized |
| User | 21300050 | Synchronization ID conflict (name corresponds to multiple IDS) |
| User | 21300051 | Synchronization name conflict (one ID, multiple user names) |
| User | 21300052 | Synchronization ID conflicts with existing platform ID |
| User | 21300053 | Synchronization ID is empty |
| User | 21300054 | Tree department is marked as a number, the checked ID is inconsistent with the tree mark |
| User | 21300055 | One mark corresponds to multiple departments |
| User | 21300056 | A tag has multiple parent tags |
| User | 21300057 | Department cannot find the corresponding parent department |
| User | 21300058 | Multiple department marks in a department |
| User | 21300059 | Dead loop in department tree |
| Watermark security | 21300060 | Setting watermark density value out of limit |
| User | 21300061 | Role name setting out of range |
| Backup restore | 21300062 | Backup restore file read/write failure |
| Dataset | 21300070 | Data memory alert |
| Dataset | 21300071 | Dataset does not exist |
| Plugin | 21310096 | The key format of the configuration item is incorrect |
| Plugin | 21310097 | The key of the configuration item is empty |
| Plugin | 21310098 | Configuration item value verification failed |
| Plugin | 21310099 | Configuration item cannot be found |
```

--------------------------------

### System Error Codes Reference

Source: https://help.fanruan.com/finereport-en11.0/doc-view-1062.html

A comprehensive list of error codes categorized by functional area including password management, verification, and login security.

```APIDOC
## System Error Codes

### Description
This reference documents the error codes returned by the system during authentication, password changes, and account management operations.

### Error Code List

#### Password Management
- **22400003**: The new password cannot be the same as the original password.
- **22400005**: The original password is incorrect.
- **22400006**: New password cannot be empty.
- **22400007**: Please enter the new password again.
- **22400008**: The new password entered twice is inconsistent.
- **22400004**: Password strength does not meet the specification.
- **22400015**: The initial password needs to be changed for the first login.
- **22400032**: The user password needs to be updated (regular update policy).
- **22400033**: The password strength of the user does not meet the strength requirement.

#### Verification Codes
- **22400009**: Email or mobile phone cannot be empty.
- **22400013**: Captcha timeout.
- **22400014**: The verification code is empty.
- **22400016**: The verification code is incorrect.
- **22400100**: Captcha verification times exceeded the limit.
- **22400101**: Captcha sent too frequently.
- **22400102**: The sending of verification code exceeds the limit of the day.

#### Login & Authentication
- **22400001**: User name cannot be empty.
- **22400002**: User does not exist.
- **22400031**: The user or IP has been locked.
- **22400035**: Slider verification required.
- **22400036**: Password wrong, slider verification required.
- **22400029**: SMS verification required.

#### System & License
- **22400037**: Data connection corresponding driver not found.
- **22400038**: Formula cannot be resolved.
- **22400040**: Number of users exceeds user attribute license limit.
- **22400043**: Too many requests, daily limit exceeded.
```

--------------------------------

### Conditional Filtering with nofilter

Source: https://help.fanruan.com/finereport-en11.0/doc-view-403.html

Use the nofilter keyword to disable filtering when a parameter is empty. This is useful for creating optional filter parameters.

```text
if(len($area)==0, nofilter, $area)
```

--------------------------------

### Filtering by Column String Extraction

Source: https://help.fanruan.com/finereport-en11.0/doc-view-403.html

Extract specific portions of column values using functions like left() to define filter criteria.

```text
left(Order ID,3)=103
```

--------------------------------

### Result Set Filtering Formulas for Column Split

Source: https://help.fanruan.com/finereport-en11.0/doc-view-2065.html

Formulas used in the Advanced tab of the data column dialog to filter data for specific columns. These formulas ensure that data is distributed across the defined number of columns.

```FineReport Formula
Cell A3: =if($__count__ <5,1,JOINARRAY(GREPARRAY(range($__count__),item % 5 == 1),","))
```

```FineReport Formula
Cell B3: =if($__count__ <5,2,JOINARRAY(GREPARRAY(range($__count__),item % 5 == 2),","))
```

```FineReport Formula
Cell C3: =if($__count__ <5,3,JOINARRAY(GREPARRAY(range($__count__),item % 5 == 3),","))
```

```FineReport Formula
Cell D3: =if($__count__ <5,4,JOINARRAY(GREPARRAY(range($__count__),item % 5 == 4),","))
```

```FineReport Formula
Cell E3: =if($__count__ <5,5,JOINARRAY(GREPARRAY(range($__count__),item % 5 == 0),","))
```
Tokens:
Raw