FR fills in how to enter data as quickly as possible

Specify the data column, and then customize the sequence to self-add, use the import function, support excel import, and establish a data warehouse with a large amount of data, which can reduce resource consumption.

Personally, I think that when fr enters data, the amount of data will be very slow, because of the general function, so the efficiency is not very good, I generally develop the entry function by myself, as for the shortcut keys you said or something, the tool is not provided, and the function needs to be developed. View the original post

Recommended professional data reporting tools - spreadjsspreadjsThe built-in reporting components include text boxes, drop-down menus, buttons, shapes, hyperlinks, area templates, tree maps, sparklines, lists, **, general charts, rich text, barcodes, labels, annotations, etc. It can be used to design more complex report layouts and paper-like templates, and can provide a similar reporting experience across different platforms and system architectures.

SpreadJS provides a highly similar filling interface and experience to excel, you can directly fill in the data in the device, or you can use the excel document importer as the original form template to quickly create a variety of template types such as single-page grid reports, multi-sheet page reports, row forms, regional reports, etc., which not only retains the data processing capabilities of excel, but also transmits the template data to the server for effective management and storage.

With the help of SpreadJS's open API and a variety of reporting components, you can easily realize functions such as data validity verification, data summary viewing, template design, template delivery, two-way data binding, filling authority control, data linkage, version management, etc., greatly simplifying the development of the reporting system.

In addition, I proposed it last time, *** quick scanning entry, is the best choice, but who knows if the official website is willing to develop it View the original post

finereport data entry is also filling. Start by designing the report template on the designer, and add a dataset if you need to display data.

Then add a control to the cell that needs to enter data, bind the cell to the database field, and finally view it in the way of filling in the pre-staring nuclear booth cover, double-click the cell to enter the state, and you can enter the data. There are related ** tutorials on the finereport forum, and the explanation is very detailed.

Yes, this kind of web page filling and entry can be automatically achieved by you using the script software "Invincible Clicking Dog".

Invincible Clickdog can automatically fill in the content of the web page and enter, automatically run clicks, and simulate various scripted actions.

Use shortcut scripts. I can send it to you if you need it.

Creating a manual report is broadly divided into four steps.

Report design: As with normal report design, if you do not need to display data, you can not add a dataset.

Add Control: Add control to the cell where you want to enter modified data, select the control type, and set the control properties.

Set filling attributes: bind cells to database fields to control the matching of data entered on the web and database fields one by one.

Fill in the entry: Open the template in the way of filling in the preview, enter the data on the web side, and submit the data to the warehouse.

In the traditional sense, we call it an ordinary report, which solves the problem of data presentation, that is, the data is taken out of the database, and then displayed in various formats, and the displayed results can be exported, printed, etc.

Basic information systems such as CRM, ERP, OA will contain some pages for business personnel or users to add, modify, delete and other operations on the database. Such a page is called a report.

The difference between the report and the ordinary report is whether the data can be entered, the ordinary report can only browse, summarize the data but not enter the data, and the report can not only browse the data, but also enter the data.

The process of making and filling in the report is as follows:

For specific details, you can see the finereport help document, which has detailed answers, I hope mine can help you.

Automatic collection, automatic filling, and batch repetitive work are all handed over to the Xiaobang software robot to do the work.

In some jobs, you need to collect and store record information first.

In general, the most commonly used storage methods are excel or text files, and sensitive information is stored in clear text in files, which has certain security problems. In addition, the target software often cannot directly import the first data, and there is no direct interface with other software, so it is necessary to open the first and the system and enter them one by one, and the process is cumbersome and repetitive.

Using the collection function of the help software robot, you can easily and quickly obtain the desired data, and you can also use the data encryption function to make the collected data encrypted and stored, and non-specific programs can not be analyzed, so as to protect the security of data files.

At the same time, the automatic entry function of the Xiaobang software robot can restore the data to plaintext through the decryption of the data set by the Xiaobang, and replace the manual entry one by one, and the manual only needs to supervise and audit the checks, thereby reducing the labor intensity of personnel.

This kind of software we are using, the software called "Invincible Clicking Dog" can be automatically entered and clicked in batches, because Invincible Clicking Dog has flexible and diverse script action simulation, supports office data entry, mouse click button simulation these functions.

Information is automatically entered and automatically filled in, and the results of monitoring and collection are collected with the tool "pageoperator". No scripts at all**, easy to use.

It can be solved with formulas, don't use ** to achieve slow file opening, occupy memory, and even need to be maintained, and the file structure cannot be changed.

If the current number is the 10th, the data of the 1-9th is in **? I don't know if it's in**, I can't add it up.

Yes, open the designer's server core game - > define the data Lian Tsai's opening menu, and you can add a json data connection to the year, as shown in the following figure:

If you still have questions, go to the forum for help.

How can I compare it with the maximum number of the database in real time when I submit the FR report? If the conditions are met, the number filled in will be used, and if not, the maximum number of the database will be +1. Make a dataset in fr, select id from table order by id desc and then in the cell, +1, this is the most earthy method,.

After reading everyone's reply, I feel that many people have similar needs, fr's submission is relatively simple, and it does not support dynamic comparison with database data, in this way, fields that do not allow duplication such as numbers must be solved by other methods, and I feel that what yuzhifu said is a method, and I am also testing, if I can, I can solve this problem, and the use of FR will be more extensive. View the original post

I plan to do two templates, one pure filling, one query, pure filling after the template is submitted, immediately close the browser, and trigger the opening of the query to fill in the template, the purpose is to display the new number (if it has changed), the trigger I have written, if I can, I will post ** in the back. View the original post

Two parameters need to be passed, the number and the number of milliseconds (to ensure uniqueness). After the report is successful, you can write the JSP access address in the event. View the original post

How about making a trigger? When fr inserts data, use the trigger to judge, if it does not meet the requirements, how about updating the number? View the original post

I believe that the two cores of Finesoft report products are filling (filling data into the database) and data display, and then leading to other rich functions that are expanded. At present, ERP, OA, CRM, or a variety of other business systems, their most fundamental and substantial, analysis to the deepest point, is also to fill in and data display filling: a variety of process forms data display

Printing, exporting, data report analysis, and then two years, countless projects have also validated my idea, and there is almost no enterprise system that it can't do. Logistics system, HR system, CRM, MRP system, ERP system, OA system, the addition of these systems is actually in-depth business knowledge, as long as you try to find out their roots, the business over and over again, analysis, you will find that in the end there are only two forms, reports, and then add a process engine, then after these two are sorted out, the first step to do is to lay the foundation, the underlying logic of the database is determined, and then on this basis, Then use the sail soft to realize the filling and display of an interface. Therefore, in fact, it is an all-purpose tool, a display tool with a high degree of freedom, as long as you are familiar with the business and have ideas, it can be said that with finereport.

Finally, the enterprise information tools can be done simply: information collection tools, examination systems, scoring systems, collaborative data import templates, etc.

Complex can do: OA, ERP, CRM, the company's own internal business system, etc.

FineReport belongs to FineFine, a world-leading provider of business intelligence and data analysis platforms, as well as an organizer of high-quality communication platforms in the industry.

FineReport is a reporting tool that subverts the competitive landscape of China's reports, a bit like the recent use of airplanes and automobiles to reduce the price of EMUs, the most fundamental reason is technological innovation. For Chinese reports, the core functions of column and column symmetry, multi-data source sharding, custom grouping, cross-line group operation, and zero coding are summarized, and the complex report processing logic is presented to users in the simplest way, which has a very good reputation in the IT information circle.

The performance is too poor, and the customer to grab the customer, small integrators, has been doing the first industry last year we first contact the medical project, the report was originally planned to use the sail soft, the site POC stage, there is a bug, please fr to help, the bug is corrected, the result of fr medical industry sales also went, the best this list actually fr bypassed us and the customer directly signed, really TM angry.

No more fringing.