"Data Entry" Doc in this DirectoryThere are 181 docs under this directory.Create a Doc in this Directory
JS Display image according to the item hovered by mouse
Author:ayuan0625      Create Time:11-17 17:19      Tag:      Edit:23 Times    |   View:472 Times

Summary:I. Overview1.1 ProblemWhen in data entry, sometimes user hopes that when item is hovered in the drop-[Full Text:]

JS Get the Values of Certain Cells in Rows with Checked Box
Author:ayuan0625      Create Time:11-17 17:16      Tag:      Edit:18 Times    |   View:914 Times

Summary:I. Overview1.1 RequirementHow to get the values of certain cells in rows with checked checkboxes in a[Full Text:]

JS Click Radio Button Pop Up a Dialog Box to Enter Value
Author:ayuan0625      Create Time:11-17 17:11      Tag:      Edit:15 Times    |   View:1139 Times

Summary:I. Overview1.1 RequirementIn making a report template similar to a questionnaire, there may be a coup[Full Text:]

JS Set Values for Expanded Cells
Author:ayuan0625      Create Time:11-17 17:09      Tag:      Edit:15 Times    |   View:841 Times

Summary:I. Overview1.1 RequirementUsually, we use setCellValue("cell", null, value) to se[Full Text:]

JS Assign Values to Report Widgets
Author:ayuan0625      Create Time:11-17 17:08      Tag:      Edit:14 Times    |   View:443 Times

Summary:I. Overview1.1 RequirementWhen the value of a certain widget has been edited, dynamically assign valu[Full Text:]

JS Confirm Before Delete Row
Author:ayuan0625      Create Time:11-10 14:47      Tag:      Edit:22 Times    |   View:653 Times

Summary:I. Overview1.1 RequirementWhen users perform row-based data entry, FineReport will provide users with[Full Text:]

JS Get the Row Number of Cell Currently being Edited
Author:ayuan0625      Create Time:11-17 17:14      Tag:      Edit:14 Times    |   View:567 Times

Summary:I. Overview1.1 RequirementShow the row number on the top when editing any cell in the row.1.2 Solutio[Full Text:]

JS Hide sheet page
Author:ayuan0625      Create Time:02-15 14:18      Tag:      Edit:10 Times    |   View:662 Times

Summary:I. Overview1.1 ProblemIn view of the fact that there are many sheet pages to be reported, some sheet[Full Text:]

JS Set report/toolbar to be unavailable
Author:ayuan0625      Create Time:02-21 09:26      Tag:      Edit:30 Times    |   View:369 Times

Summary:I. Overview1.1 ProblemIn our report development, in many cases it is necessary to set the report body[Full Text:]

JS Get all values of extended widget
Author:ayuan0625      Create Time:08-04 09:07      Tag:      Edit:13 Times    |   View:417 Times

Summary:I. Overview1.1 ProblemWhen a data entry report is displayed, the reporting widget is extended. A[Full Text:]

JS Hide Columns or Rows by Clicking a Button
Author:ayuan0625      Create Time:02-24 13:40      Tag:      Edit:19 Times    |   View:922 Times

Summary:I. Overview1.1 RequirementWhen performing data entry, how to hide certain rows and columns by using a[Full Text:]

JS Text Control Displays Style After Editing
Author:ayuan0625      Create Time:02-27 12:56      Tag:      Edit:12 Times    |   View:421 Times

Summary:I. Overview1.1 Problem descriptionThe use of conditional formatting allows cells or text widgets to d[Full Text:]

JS realizes dynamic display/hiding of rows
Author:ayuan0625      Create Time:02-26 13:28      Tag:      Edit:10 Times    |   View:340 Times

Summary:I. Overview1.1 RequirementIn making a filling report, how to make optional items invisible when[Full Text:]

JS Dynamically Display Current Time
Author:ayuan0625      Create Time:07-05 09:22      Tag:      Edit:26 Times    |   View:767 Times

Summary:I. Overview1.1 RequirementThe report only display static current time by inputting formula. How to di[Full Text:]

JS Initial Button Color,Change Color After Clicking
Author:ayuan0625      Create Time:02-24 10:46      Tag:      Edit:19 Times    |   View:529 Times

Summary:I. Overview1.1 RequirementWidget CSS and Button CSS can be used to change the CSS style of a certain[Full Text:]

JS Change the Background Color of the Selected Cell
Author:ayuan0625      Create Time:02-26 21:08      Tag:      Edit:13 Times    |   View:474 Times

Summary:I. Overview1.1 RequirementIn report production, sometimes in order to highlight the cell selected, it[Full Text:]

JS Button color change according to mouse hover
Author:ayuan0625      Create Time:02-10 14:56      Tag:      Edit:10 Times    |   View:374 Times

Summary:I. Overview1.1 ProblemWhen the mouse is hovering over the widget for the first time, it changes from[Full Text:]

JS Edit widget on click once
Author:ayuan0625      Create Time:04-06 08:10      Tag:      Edit:11 Times    |   View:432 Times

Summary:I. Overview1.1 ProblemWhen there are many widgets in one report, to enhance performance, sometimes we[Full Text:]

JS Mark the Modified Cells When Data Entry
Author:ayuan0625      Create Time:04-01 11:15      Tag:      Edit:14 Times    |   View:413 Times

Summary:I. Overview1.1 Problem descriptionScene description: In the Data Entry Preview, after editing the cel[Full Text:]

JS Modify a Column Value of Selected Rows at One Click
Author:ayuan0625      Create Time:03-08 23:54      Tag:      Edit:12 Times    |   View:406 Times

Summary:I. Overview1.1 RequirementIn some cases, we need to select a batch of records and then modify values[Full Text:]

JS Refresh the Parent Window after the Child Window is Close
Author:ayuan0625      Create Time:02-17 10:55      Tag:      Edit:16 Times    |   View:1527 Times

Summary:I. Overview1.1 RequirementWhen performing data entry in a particular project, we might have to jump t[Full Text:]

JS Length limit of text in widget
Author:ayuan0625      Create Time:02-26 23:22      Tag:      Edit:11 Times    |   View:343 Times

Summary:I. Overview1.1 ProblemIn our reporting process, when the text length exceeds some specific value (for[Full Text:]

JS Mouse Over Cell(Row) Style Change
Author:ayuan0625      Create Time:03-23 09:26      Tag:      Edit:15 Times    |   View:691 Times

Summary:I. Overview1.1 RequirementIn making a report, in order to highlight the cell the mouse moves over, we[Full Text:]

JS Change the Background Color of the Checkbox Selected Row
Author:ayuan0625      Create Time:02-14 09:13      Tag:      Edit:14 Times    |   View:1507 Times

Summary:I. Overview1.1 Problem descriptionScenario description: When we enter data, sometimes we need to chan[Full Text:]

JS Get the Value of the Widgets in Expanded Cells
Author:ayuan0625      Create Time:02-24 10:21      Tag:      Edit:11 Times    |   View:406 Times

Summary:I. Overview1.1 RequirementWhen conducting data entry preview, how to get the value of the widgets for[Full Text:]

JS Refresh the Parent Page After the Child Window Fills in
Author:ayuan0625      Create Time:03-01 19:48      Tag:      Edit:8 Times    |   View:718 Times

Summary:I. Overview1.1 RequirementWhen using multiple windows for data entry, you may want to make the data t[Full Text:]

JS Title text remains centered
Author:ayuan0625      Create Time:03-18 18:48      Tag:      Edit:13 Times    |   View:325 Times

Summary:I. Overview1.1 ProblemWhen making some wide reports, the width of the report far exceeds the wid[Full Text:]

JS Select All the Checkboxes
Author:ayuan0625      Create Time:10-22 18:57      Tag:      Edit:1 Times    |   View:751 Times

Summary:I. Overview1.1 RequirementWhen using our checkbox widgets, how can we click to check all, so that the[Full Text:]

JS Dynamic star rating
Author:ayuan0625      Create Time:08-07 16:02      Tag:      Edit:5 Times    |   View:316 Times

Summary:I. Overview1.1 ProblemIn the report application, we may use graphics to display the effects such as s[Full Text:]

JS Get the number in the string
Author:ayuan0625      Create Time:03-09 12:42      Tag:      Edit:6 Times    |   View:345 Times

Summary:I. Overview1.1 ProblemWhen making a report, sometimes it is necessary to directly obtain the number i[Full Text:]

JS cpt Refresh a Single Cell or Column
Author:ayuan0625      Create Time:04-28 10:50      Tag:      Edit:17 Times    |   View:608 Times

Summary:I. Overview1.1 RequirementRefresh a cell or a column of cells in real time in the data entry mode. Th[Full Text:]

JS Solves Component Value is not Refreshed on time
Author:ayuan0625      Create Time:03-10 16:49      Tag:      Edit:10 Times    |   View:363 Times

Summary:I. Overview1.1 RequirementIn making a report, button widget is often used to handle values. The curre[Full Text:]

JS Customize the Prompt Text
Author:ayuan0625      Create Time:03-02 21:58      Tag:      Edit:17 Times    |   View:413 Times

Summary:I. Overview1.1 RequirementIn FR reports, prompts indicating whether or not an operation succeeds are[Full Text:]

JS Assign a Value to a Cell by Clicking a Button
Author:ayuan0625      Create Time:02-28 11:42      Tag:      Edit:10 Times    |   View:405 Times

Summary:I. Overview1.1 RequirementHow to assign a value to a cell by clicking a button? 1.2 SolutionAdd[Full Text:]

JS Sets Widget Focus
Author:ayuan0625      Create Time:02-23 13:26      Tag:      Edit:14 Times    |   View:456 Times

Summary:I. Overview1.1 RequirementIn making a report, sometimes the Text widget is disabled by default and ca[Full Text:]

JS Insert Customized Number of Rows
Author:ayuan0625      Create Time:02-21 13:30      Tag:      Edit:9 Times    |   View:442 Times

Summary:I. Overview1.1 RequirementIn many cases, by clicking [Insert Row], only one row will be inserted. How[Full Text:]

JS Assigns Multiple Values to Text Box
Author:ayuan0625      Create Time:11-17 17:10      Tag:      Edit:14 Times    |   View:398 Times

Summary:I. Overview1.1 Problem descriptionFor the Data Entry template, it is hoped that the data of a certain[Full Text:]

JS Get or Modify the Value of a Cell which is Bound with a Widge
Author:ayuan0625      Create Time:11-17 17:07      Tag:      Edit:11 Times    |   View:562 Times

Summary:I. Overview1.1 RequirementHow to get or modify the value of a cell through JavaScript, as shown below[Full Text:]

Customized Data Entry
Author:ayuan0625      Create Time:11-02 15:19      Tag:      Edit:12 Times    |   View:1174 Times

Summary:I. OverviewThis article introduces how to automate data entry in a form to accurately fill in informa[Full Text:]

Report Text Area Widget
Author:ayuan0625      Create Time:10-30 14:00      Tag:      Edit:20 Times    |   View:582 Times

Summary:I. Overview1) In designing a form, you can insert a Text Area widget to input texts in cells.2) The T[Full Text:]

Report Drop-down Tree
Author:ayuan0625      Create Time:10-21 15:49      Tag:      Edit:1 Times    |   View:587 Times

Summary:I. Overview1) In designing a form, some options are hierarchically structured. You can insert a Drop-[Full Text:]

Report Drop-down Checkbox Widget
Author:ayuan0625      Create Time:10-21 15:40      Tag:      Edit:1 Times    |   View:410 Times

Summary:I. OverviewThe Drop-down checkbox widget enables you to concurrently check multiple options for query[Full Text:]

Report Drop-down Box Widget
Author:ayuan0625      Create Time:10-21 15:39      Tag:      Edit:1 Times    |   View:714 Times

Summary:I. OverviewThe Drop-down Box Widget gives you multiple options for query.II. Steps1. Drag the widget1[Full Text:]

Report Checkbox Group Widget
Author:ayuan0625      Create Time:10-21 15:35      Tag:      Edit:1 Times    |   View:445 Times

Summary:I. Overview1) In designing a form, you can insert a Checkbox Group widget to choose more than one dat[Full Text:]

Report Number Widget
Author:ayuan0625      Create Time:10-21 15:23      Tag:      Edit:2 Times    |   View:557 Times

Summary:I. Overview1) In designing a form, you can insert a Numbers widget, so that you can enter numbers in[Full Text:]

Report Button Widget
Author:ayuan0625      Create Time:10-21 15:25      Tag:      Edit:1 Times    |   View:805 Times

Summary:I. Overview1) In designing a report, a Button widget can be bound to JS events to trigger report even[Full Text:]

Report Text Field Widget
Author:ayuan0625      Create Time:10-21 15:21      Tag:      Edit:1 Times    |   View:780 Times

Summary:I. Overview1) In designing a form, sometimes you have to manually enter some information. In this cas[Full Text:]

JS Custom Button Style
Author:ayuan0625      Create Time:07-31 11:36      Tag:      Edit:14 Times    |   View:455 Times

Summary:I. OverviewIn applications, it is often necessary to modify the style of a button. In addition to mod[Full Text:]

Click the delete button to submit to the database
Author:ayuan0625      Create Time:11-10 13:30      Tag:      Edit:29 Times    |   View:312 Times

Summary:1. 概述1.1 问题描述有时候希望点击删除行按钮后,可以自动执行提交动作,无需点击工具栏提交按钮入库,效果如下图所示:1.2 实现思路给删除行按钮添加点击事件,实现点击删除行按钮后,可以延时一段时间再[Full Text:]

JS控制报表预览/填报时间,用户长久没有操作之后进行超时关闭窗口
Author:ayuan0625      Create Time:08-11 14:32      Tag:      Edit:0 Times    |   View:65 Times

Summary:1. 描述在报表集成中,有时会遇到页面打开新窗口,用户长时间不操作,导致数据重复或者提交失败;多用户并发也是服务器部署中头疼的一个问题,目前 FineReport 已经提供了相对较好的多用户 Sessi[Full Text:]

JS自定义填报控件只能填写一次
Author:ayuan0625      Create Time:08-11 13:54      Tag:      Edit:2 Times    |   View:96 Times

Summary: 1.概述对于某些特定的填报字段,比如成绩、密码之类,要求在填报的时候,只能写一次,一旦写完就不能再进行修改,这种情况怎么可以快速实现呢?2.思路既然是填写后无法再修改,那可以利用这个控件的编[Full Text:]

通过FR内置事件对用户的操作行为进行入库
Author:ayuan0625      Create Time:11-15 22:44      Tag:      Edit:11 Times    |   View:78 Times

Summary:1. 描述对于一些特殊行业,数据安全显得尤为重要,如何保证数据的安全性成为了企业需要重点注意的环节。除了加强员工保密的意识,更应该加强企业数据安全系统的建设。如果出现意外的数据泄露,也要有途径查询,防止[Full Text:]

[老]网格式报表打印成其它样式
Author:ayuan0625      Create Time:11-10 14:46      Tag:      Edit:19 Times    |   View:69 Times

Summary:1. 问题描述对于填报网格式报表,每行前面有个复选框,希望实现点击页面中设置的打印按钮可以将选中的复选框中的值按照一定的样式打印,如分栏、页面固定显示几行等格式。2. 实现思路可以定[Full Text:]

页面上脚本造成Internet
Author:ayuan0625      Create Time:11-10 14:49      Tag:      Edit:9 Times    |   View:76 Times

Summary:1. 问题描述填报模板,列数很多,包含大量编辑控件或是公式,可能会提示下图信息:各个浏览器出现如上对话框的极限值:IE:执行超过 500w 条 JavaScript 语句时会出现。FireFo[Full Text:]

[老]使用JS修改单元格样式后打印导出当前样式
Author:ayuan0625      Create Time:03-06 07:48      Tag:      Edit:6 Times    |   View:81 Times

Summary:1.概述在填报页面中,有时使用JS对页面样式进行调整,比如使用 JS 实现改变复选框选中行中指定单元格背景色,点击复选框之后改变指定单元格颜色,需要进行导出或打印报表时,发现样式并没有生效,如[Full Text:]

使用js进行及时校验
Author:ayuan0625      Create Time:11-10 13:46      Tag:      Edit:14 Times    |   View:101 Times

Summary:1. 问题描述在实现填报时,有时需要在编辑完数据后跟其他具体某个格子对比,进行及时校验。2. 解决方案使用 JS 脚本进行校验。3. 示例3.1 模板设计表样设计如下:设置 B2 单元格的控件[Full Text:]

多sheet填报分页
Author:ayuan0625      Create Time:11-10 13:38      Tag:      Edit:13 Times    |   View:98 Times

Summary:1. 版本报表服务器版本10.02. 概述上一节介绍了单 sheet 下的填报分页的制作过程以及使用方式,那么在有多个 sheet 的情况下,填报分页的范围不是整个报表,而是每个 sheet,即每个 s[Full Text:]