Insert and Delete

"Insert and Delete" Doc in this DirectoryThere are 73 docs under this directory.Create a Doc in this Directory
Data Dictionary Linkage of Data Entry Widgets
Author:ayuan0625      Create Time:11-10 14:35      Tag:      Edit:20 Times    |   View:808 Times

Summary:OverviewApplication ScenarioFor data entry templates that contain multiple widgets, after you select[Full Text:]

Auto Data Matches Based on Widget Values
Author:ayuan0625      Create Time:11-10 13:21      Tag:      Edit:27 Times    |   View:623 Times

Summary:OverviewApplication ScenarioYou may hope that corresponding data in other related cells can be automa[Full Text:]

Setting the Attribute of the Submission Button
Author:_339541      Create Time:06-25 14:10      Tag:      Edit:6 Times    |   View:291 Times

Summary:OverviewApplication ScenarioThe built-in submission button provides the attribute setting function, t[Full Text:]

Data Entry Freeze
Author:ayuan0625      Create Time:11-10 14:37      Tag:      Edit:16 Times    |   View:609 Times

Summary:OverviewVersionReport Server VersionFunctional Change11.0/Application ScenarioYou hope that the heade[Full Text:]

Excel Import Introduction
Author:ayuan0625      Create Time:11-11 11:29      Tag:      Edit:16 Times    |   View:785 Times

Summary:OverviewFunction DescriptionIn FineReport bulk data entry scenarios, you can directly import Excel da[Full Text:]

Learning Path of Data Entry
Author:_339541      Create Time:06-26 09:18      Tag:      Edit:8 Times    |   View:643 Times

Summary:OverviewThere are many functions of data entry. Beginners may not know how to learn and what to focus[Full Text:]

Display Value Conversion During Excel Import
Author:frenadmin1234      Create Time:07-03 16:47      Tag:      Edit:5 Times    |   View:249 Times

Summary:OverviewApplication ScenariosYou can import values from Excel and convert them into desired actual va[Full Text:]

Excel Import Mark
Author:frenadmin1234      Create Time:05-15 14:32      Tag:      Edit:19 Times    |   View:611 Times

Summary:OverviewVersionPlugin VersionMinimum Version Requirement for FineReportFunctional ChangeV 1.7.0V[Full Text:]

Import Excel
Author:ayuan0625      Create Time:11-11 11:14      Tag:      Edit:23 Times    |   View:1428 Times

Summary:I. OverviewThe report supports importing data from excel directly into the data entry page, as shown[Full Text:]

Use UUID to achieve a unique number
Author:ayuan0625      Create Time:07-10 16:52      Tag:      Edit:6 Times    |   View:1621 Times

Summary:I. Overview1. Problem DescriptionIf there is no specific field as the primary key when repo[Full Text:]

Clear the database table before importing into Excel
Author:ayuan0625      Create Time:03-14 08:23      Tag:      Edit:15 Times    |   View:521 Times

Summary:I. Overview1. Problem descriptionWe hope to clear the data in the original database table b[Full Text:]

Excel import multiple times
Author:ayuan0625      Create Time:01-18 16:37      Tag:      Edit:15 Times    |   View:639 Times

Summary:I. Overview1. Version updateReport versionJAR packageFunction change10.0.122020-12-28Before this vers[Full Text:]

Excel custom import
Author:ayuan0625      Create Time:11-12 21:47      Tag:      Edit:11 Times    |   View:528 Times

Summary:I. Overview1. Application scenariosThe custom import Excel row and column function is suitable f[Full Text:]

Self-growth ID of the database
Author:ayuan0625      Create Time:11-10 13:31      Tag:      Edit:28 Times    |   View:582 Times

Summary:I. Overview1. Problem descriptionDatabase self-growth ID data entry means that when data entry i[Full Text:]

JS realizes automatic generation of serial numbers and sorting
Author:ayuan0625      Create Time:11-10 13:32      Tag:      Edit:35 Times    |   View:1665 Times

Summary:I. Overview1. Problem descriptionWhen filling in data, it is hoped that the serial number can be[Full Text:]

Insert row policy
Author:ayuan0625      Create Time:11-10 13:33      Tag:      Edit:27 Times    |   View:579 Times

Summary:I. Overview1. Learning videoThis article learning video:Insert Row Policy2. Problem descriptionF[Full Text:]

Custom insert and delete column buttons
Author:ayuan0625      Create Time:08-24 17:28      Tag:      Edit:10 Times    |   View:418 Times

Summary:I. Overview1. Problem descriptionThe default insert and delete row button type has only two opti[Full Text:]

JS realizes the second confirmation when deleting
Author:ayuan0625      Create Time:12-19 13:30      Tag:      Edit:21 Times    |   View:551 Times

Summary:I. Overview1. Problem descriptionThe default Delete Row button, clicking delete will not confirm the[Full Text:]

Print and export check button widgets
Author:ayuan0625      Create Time:12-26 17:12      Tag:      Edit:7 Times    |   View:335 Times

Summary:I. OverviewNote: This scheme is only applicable to regular report data entry preview.1. Problem&[Full Text:]

Print and export radio button group widgets
Author:ayuan0625      Create Time:05-11 15:35      Tag:      Edit:7 Times    |   View:392 Times

Summary:I. Overview1. Problem DescriptionWhen introducing Printing or exporting check boxes when data entryin[Full Text:]

Excel Import Misplacement
Author:ayuan0625      Create Time:11-11 11:25      Tag:      Edit:10 Times    |   View:438 Times

Summary:I. Overview1. Problem descriptionThe same template  Excel Export as it is, and when th[Full Text:]

Row Insertion and Deletion
Author:ayuan0625      Create Time:11-10 13:22      Tag:      Edit:26 Times    |   View:1334 Times

Summary:I. OverviewIf there is an operation of inserting and deleting records when data entry, then you need[Full Text:]

Data Entry Pagination 
Author:ayuan0625      Create Time:11-10 13:39      Tag:      Edit:27 Times    |   View:749 Times

Summary:I. Overview1. Problem descriptionWhen data entry preview, all the data are displayed on one page. If[Full Text:]

Master-Sub Data Entry Report
Author:ayuan0625      Create Time:11-10 13:27      Tag:      Edit:21 Times    |   View:566 Times

Summary:I.Overview1. Problem descriptionAs shown in the figure below, the business logic of the Master-sub ta[Full Text:]

Value processing of built-in SQL submission
Author:ayuan0625      Create Time:11-10 13:24      Tag:      Edit:16 Times    |   View:531 Times

Summary:I. Overview1. Application scenariosWhen designing the data entry template, some data can be skipped a[Full Text:]

Copy and Paste Excel data to data entry cell
Author:ayuan0625      Create Time:11-10 13:21      Tag:      Edit:13 Times    |   View:592 Times

Summary:I. Overview1. Application scenariosFinereport supports copying data from Excel to the data entry page[Full Text:]

Cross Sheet Linkage
Author:ayuan0625      Create Time:11-10 13:36      Tag:      Edit:12 Times    |   View:361 Times

Summary:I. Overview1. Application scenariosData can be transmitted between reports through parameters or hype[Full Text:]

JS realizes verification of widget value
Author:ayuan0625      Create Time:11-10 13:45      Tag:      Edit:14 Times    |   View:379 Times

Summary:I. Overview1. Application scenarioIt is hoped that after entering the value in the data entry widget,[Full Text:]

Problems and solutions when submiting multi-value in drop-down checkbox
Author:ayuan0625      Create Time:04-14 16:03      Tag:      Edit:5 Times    |   View:359 Times

Summary:I. Overview1. Problem descriptionWhen making a data entry template, it is often encountered that mult[Full Text:]

Clear table before import Excel
Author:ayuan0625      Create Time:09-02 13:40      Tag:      Edit:6 Times    |   View:384 Times

Summary:I. Overview1. Probelm descriptionHope to clear the data in the original table before importing the Ex[Full Text:]

Submit multi-value by drop-down checkbox
Author:ayuan0625      Create Time:02-16 10:19      Tag:      Edit:16 Times    |   View:385 Times

Summary:I. Overview1. Problem descriptionThere is a drop-down checkbox in the data entry template, which sets[Full Text:]

Submit to database directly without previewing
Author:ayuan0625      Create Time:06-16 09:03      Tag:      Edit:11 Times    |   View:381 Times

Summary:I. Overview1. Problem descriptionSome templates have a large amount of data, but there is no need for[Full Text:]

JS realizes the data deleted logically
Author:ayuan0625      Create Time:03-03 15:48      Tag:      Edit:9 Times    |   View:379 Times

Summary:I. Overview1. versionDesigner version10.02. Problem descriptionUsers sometimes need to achieve data b[Full Text:]

Data Entry by authority
Author:ayuan0625      Create Time:11-10 14:30      Tag:      Edit:17 Times    |   View:630 Times

Summary:I. Overview1. VersionDesigner version10.02. Problem descriptionThe customer's group is large and[Full Text:]

Upload file to DB and download
Author:ayuan0625      Create Time:11-10 14:27      Tag:      Edit:19 Times    |   View:602 Times

Summary:I. Overview1. Application scenariosHoping that users can directly save small files in the database, a[Full Text:]

Empty data is not stored in the database
Author:ayuan0625      Create Time:11-10 14:28      Tag:      Edit:10 Times    |   View:537 Times

Summary:I. Overview1. Problem descriptionWhen adding new records, if there are empty data under certain field[Full Text:]

JS custom submit button
Author:ayuan0625      Create Time:11-10 14:24      Tag:      Edit:23 Times    |   View:585 Times

Summary:I. Overview1. Problem descriptionIf you define a custom button to implement some of your own business[Full Text:]

JS custom insert and delete row buttons
Author:ayuan0625      Create Time:11-10 14:23      Tag:      Edit:16 Times    |   View:674 Times

Summary:I. Overview1. Expected effectUse the insert and delete button, each row has a button, when the amount[Full Text:]

Data entry upload image
Author:ayuan0625      Create Time:12-01 14:58      Tag:      Edit:24 Times    |   View:611 Times

Summary:I. Overview1. Problem descriptionWhen we collect employee information, we usually need to upload phot[Full Text:]

Import Excel Match by Title
Author:ayuan0625      Create Time:11-11 11:28      Tag:      Edit:29 Times    |   View:725 Times

Summary:I. Overview1. Application scenariosWhen you import a report with indefinite rows into excel and data[Full Text:]

Import Excel matched by location
Author:ayuan0625      Create Time:11-11 11:28      Tag:      Edit:14 Times    |   View:495 Times

Summary:I. DescriptionExcel import of detailed report according to the location matching means that when impo[Full Text:]

Excel Import fixed number of line
Author:ayuan0625      Create Time:11-11 11:27      Tag:      Edit:12 Times    |   View:486 Times

Summary:I. Overview1.Expected effectWhen data entry and importing Excel data, if expansion is not set in the[Full Text:]

Row-based Data Entry Batch Deletion
Author:ayuan0625      Create Time:11-10 13:20      Tag:      Edit:36 Times    |   View:732 Times

Summary:I. Overview1. Application scenariosWhen deleting a line in data entry report, if there are many conte[Full Text:]

Multi-sheet Data Entry
Author:ayuan0625      Create Time:11-10 13:34      Tag:      Edit:27 Times    |   View:1059 Times

Summary:I. Overview1) A multi-sheet report is a combination of multiple independent reports in a form similar[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:]

通过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:]