Number Widget-FineReport Help Document

Last update：October 26, 2023

Overview

Version

Report Server Version	App Version	Functional Change
11.0	/	/
11.0.21	11.0.85	Added the Allow One-Click Clearance function on the Mobile Terminal tab page.

Application Scenario

Data Entry Widget

You can enter numbers (including integers, negative numbers, and decimals) and data through the number widget in data entry reports.

Parameter Widget

You can enter numbers (including integers, negative numbers, and decimals) and query parameters on the parameter panel through the number widget.

Adding Methods

Data Entry Widget

Select a cell, click Widget Setting on the right attribute panel, and choose Number Widget from the drop-down menu of Select Widget.

Parameter Application

Drag the Number Widget from the widget toolbar on the parameter panel into the parameter panel.

Widget Introduction

Attribute

Data Entry Widget

The following figure shows the Attribute tab page of the Number Widget.

The following table introduces the settings of each attribute in detail.

Note:

You can set the default value by adding a value in a cell when you use the Number Widget in the data entry.

Classification	Settings	Introduction
Basic	Widget Name	Displays the name (empty by default) of the widget. It is manually entered and usually used in conjunction with parameters. For example, you can pass the widget value to the corresponding parameter after the widget is obtained through the widget name.
	Available	Determines whether the widget is available. Checked (default setting): The widget is editable in the data entry. Unchecked: The widget is grayed out and not editable.
	Visible	Determines whether the widget is visible. Checked (default setting): The widget is displayed on the data entry page. Unchecked: The widget is not displayed on the data entry page.
Advanced	Watermark	Displays light gray watermark texts in the widget during the data entry. You can manually enter the needed prompt information in Watermark (empty by default). The watermark disappears after you click the widget editing area.
Validation	Allow Null	Determines whether the widget can be empty. Checked (default setting): The widget can be empty. Unchecked: A prompt appears in the data entry validation and submission.
	Error Tip	Appears when Allow Null is unchecked, allowing you to customize the prompt message. The default message is: "Can not be null."
	Allow Decimal	Determines whether the entered value can be decimals. Checked (default setting): The entered value can be decimals. Unchecked: The entered value cannot be decimals.
	Decimal Place	Appears when Allow Decimal is checked. You can customize the maximum decimal places (default value as 16).
	Allow Negative Number	Determines whether the entered value can be negative numbers. Checked (default setting): The entered value can be negative numbers. Unchecked: The entered value cannot be negative numbers.
	Need Maximum Value	Allows you to customize the allowed maximum value. Checked: A prompt pops up during the data entry validation and submission if the entered value exceeds the limit: "Value larger than specified maximum value." Unchecked (default setting): The entered value is not limited by the maximum value. Note: If there are four or more 9999/0000 after the decimal point, the system defaults to perform carry or round-off. For example, if you enter “12.99999”, the system defaults to carry as “13”.
	Need Minimum Value	Allows you to customize the allowed minimum value. Checked: A prompt pops up during the data entry validation and submission if the entered value exceeds the limit: "Value smaller than specified minimum value." Unchecked (default setting): The entered value is not limited by the minimum value. Note: If there are four or more 9999/0000 after the decimal point, the system defaults to perform carry or round-off. For example, if you enter “12.99999”, the system defaults to carry as “13”.
	Error Tip	This setting item appears after Need Maximum Value or Need Minimum Value is checked. You can customize error prompts like “Exceed the setting range.” If no error tip is set, the entered value not meeting the condition is underlined with a red wavy line.

Parameter Widget

The following figure shows the Attribute tab page of the Number Widget.

The following table introduces the settings of each attribute in detail.

Classification	Settings	Introduction
Basic	Widget Name	Displays the name (default value as numberEditor#) of the widget. It is manually entered and usually used in conjunction with parameters. For example, you can pass the widget value to the corresponding parameter after the widget is obtained through the widget name.
	Available	Determines whether the widget is available. Checked (default setting): The widget is editable in the data entry. Unchecked: The widget is grayed out and not editable.
	Visible	Determines whether the widget is visible. Checked (default setting): The widget is displayed on the data entry page. Unchecked: The widget is not displayed on the data entry page.
Advanced	Label Name	Allows you to use the label name to achieve the label function on mobile terminals, because the widget label attribute is supported and the Label Name attribute of general widgets can be recognized on mobile terminals. The Label Widget on the parameter panel is not supported on mobile terminals.
	Widget Value	Displays the default value (empty by default) during the widget initialization. Double-Precision, Field, and Formula are supported. Double-Precision: includes datatype data with higher accuracy. Number with at most 15 digits (like 12.35) is supported. Field: includes dataset fields, such as the Sales_Volume field of the dataset ds1. Datasets include template datasets and server datasets. Formula: includes formulas supported by the designer, such as the following formula through which the value of the cell A1 can be obtained.
	Watermark	Displays light gray watermark texts in the widget during the data entry. You can manually enter the needed prompt information in Watermark (empty by default). The watermark disappears after you click the widget editing area.
	Font Size	Includes the size of the font (default value as 12) entered in the text box. Note: This function is not supported on mobile terminals.
Validation	Allow Null	Determines whether the widget can be empty. Checked (default setting): The widget can be empty. Unchecked: A prompt appears in the data entry validation and submission.
	Error Tip	Appears when Allow Null is unchecked, allowing you to customize the prompt message. The default message is: "Can not be null."
	Allow Decimal	Determines whether the entered value can be decimals. Checked (default setting): The entered value can be decimals. Unchecked: The entered value cannot be decimals.
	Decimal Place	Appears when Allow Decimal is checked. You can customize the maximum decimal places (default value as 16).
	Allow Negative Number	Determines whether the entered value can be negative numbers. Checked (default setting): The entered value can be negative numbers. Unchecked: The entered value cannot be negative numbers.
	Need Maximum Value	Allows you to customize the allowed maximum value. Checked: A prompt pops up during the data entry validation and submission if the entered value exceeds the limit: "Value larger than specified maximum value." Unchecked (default setting): The entered value is not limited by the maximum value. Note: If there are four or more 9999/0000 after the decimal point, the system defaults to perform carry or round-off. For example, if you enter “12.99999”, the system defaults to carry as “13”.
	Need Minimum Value	Allows you to customize the allowed minimum value. Checked: A prompt pops up during the data entry validation and submission if the entered value exceeds the limit: "Value smaller than specified minimum value." Unchecked (default setting): The entered value is not limited by the minimum value. Note: If there are four or more 9999/0000 after the decimal point, the system defaults to perform carry or round-off. For example, if you enter “12.99999”, the system defaults to carry as “13”.
	Error Tip	Appears after Need Maximum Value or Need Minimum Value is checked. You can customize error prompts like “Exceed the setting range.” If no error tip is set, the entered value not meeting the condition is underlined with a red wavy line.
Coords & Size	Widget Location	Includes the widget location (changed based on the horizontal and vertical coordinates) on the parameter panel. The coordinate is automatically displayed based on the widget location.
Coords & Size	Widget Size	Includes the widget size. You can resize the widget by changing the Width and Height values. You can also hover your cursor to the widget boundary and drag the boundary until the widget reaches the desired width and height.

Event

You can add events for the widget on the Event tab page to achieve certain effects. The Number Widget supports four types of events — After Initialization, Before Editing, After Editing, and After Exiting Edit.

Select an event and add the event content. The event response methods supported by the Number Widget include JavaScript, Summit to Database, Send Email, Export Event, and Mobile Pop-up.

Select a corresponding event response method.

Mobile Terminal

The Allow One-Click Clearance function is supported on the Mobile Terminal tab page.

Advanced:

Allow One-Click Clearance: allows you to delete the entered content with one click.

Application Example

The following table introduces how to apply the number widget.

Application Scenario

Actual Effect

Scenario:

Set a validation code through the number widget to prevent malicious data entry and junk data. The data entry can be submitted only when the validation code is correct.