Commit information to DB

When printing, Sometimes users want to know which reports were printed at what time, and record it in a record table in the database to facilitate viewing of related information. Generally, after clicking print, the print event will be triggered directly. As for the unprinted situations that may occur after clicking print, these are caused by some situations such as printer equipment, etc. In this article, we will take that clicking Printand recording its print information in the library table when previewing the report as an example.

In FineReport 10.0, you can click Server>Server Configuration Manager>Pagination Preview Settings, add "After printing" event for editing, select Commit to Database, and then write back the template name and printing time information to the DB table.

1. Create a table

Create a new record information table, such as: create a new table in the FRDemoEN database and name it [get]. Enter two fields: year1 and type, both of which are "String".

2. Add "After printing" event

Click Server>Server Configuration Manager, select Pagination Preview Settings. In the right column, click to add the "After printing" event, as shown in the figure below:

After selecting Commit to Database and selecting its information record table, and click Smart Add Fields, enter the formula in year1 as above: =today() to get the current date, and enter the formula in type: =reportName to get the currently printed template.

3. Preview effect

After the above settings are completed, when clicking Print button, the date of printing the template and the template name will be recorded in the table, and the information can be viewed in the DB table.