CN112307729A - Online filling report generation method and terminal - Google Patents
Online filling report generation method and terminal Download PDFInfo
- Publication number
- CN112307729A CN112307729A CN202011214071.3A CN202011214071A CN112307729A CN 112307729 A CN112307729 A CN 112307729A CN 202011214071 A CN202011214071 A CN 202011214071A CN 112307729 A CN112307729 A CN 112307729A
- Authority
- CN
- China
- Prior art keywords
- filling
- report
- template
- data
- indexes
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 18
- 230000003068 static effect Effects 0.000 claims abstract description 26
- 238000004590 computer program Methods 0.000 claims description 8
- 230000009286 beneficial effect Effects 0.000 description 3
- 238000010586 diagram Methods 0.000 description 2
- 238000012550 audit Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/174—Form filling; Merging
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to a method and a terminal for generating online filled-in reports, which comprise the following steps: s1, importing a preset excel template to generate a report template, wherein the report template comprises a template main body part, an enterprise data part and a data filling part; s2, importing preset enterprise information in the enterprise data part, and setting static indexes and dynamic indexes in each filling frame of the data filling part; the static indexes are as follows: each filling in a standard algorithm in the frame; the dynamic index refers to: filling logic algorithms among the boxes; and S3, releasing the report template. When workers filling the reports fill in all the frames of the data filling part, the filling contents can be automatically checked through the static indexes and the dynamic indexes, and the checking personnel do not need to check and check each filled and submitted report one by one, so that the reasonability of the filling data submitted by the reports is improved, and the manpower is greatly saved.
Description
Technical Field
The invention relates to the field of computer software, in particular to a method and a terminal for generating an online filled report.
Background
After the staff completes the online report filling, the staff needs to manually check whether the specification and the logic of the data filled by the staff are reasonable, and particularly, the checking of the logical relationship of multiple formulas is complicated, so that a large amount of workload is brought to the staff, and the manpower is wasted.
Disclosure of Invention
Technical problem to be solved
In order to solve the above problems in the prior art, the invention provides a method and a terminal for generating an online filled report, wherein the generated report can automatically check the reasonability of data filled by a user, so that the labor is saved.
(II) technical scheme
In order to achieve the purpose, the invention adopts a technical scheme that: a method for generating online filled-in reports comprises the following steps:
s1, importing a preset excel template to generate a report template, wherein the report template comprises a template main body part, an enterprise data part and a data filling part;
s2, importing preset enterprise information in the enterprise data part, and setting static indexes and dynamic indexes in each filling frame of the data filling part;
the static indexes are as follows: each filling in a standard algorithm in the frame;
the dynamic index refers to: filling logic algorithms among the boxes;
and S3, releasing the report template.
The other technical scheme adopted by the invention is as follows: a terminal for generating a line-filled report comprises a memory, a processor and a computer program which is stored on the memory and can run on the processor, wherein the processor executes the computer program to realize the following steps:
s1, importing a preset excel template to generate a report template, wherein the report template comprises a template main body part, an enterprise data part and a data filling part;
s2, importing preset enterprise information in the enterprise data part, and setting static indexes and dynamic indexes in each filling frame of the data filling part;
the static indexes are as follows: each filling in a standard algorithm in the frame;
the dynamic index refers to: filling logic algorithms among the boxes;
and S3, releasing the report template.
(III) advantageous effects
The invention has the beneficial effects that: in the template making process, a development and report staff can self-define and select the imported excel template to generate the report template, the flexibility is high, after enterprise information is imported, the development and report staff can self-define and set static indexes and dynamic indexes in each filling frame of the data filling part, when workers filling the report fill each frame of the data filling part, filling contents can be automatically checked through the static indexes and the dynamic indexes, the checking staff do not need to check and check each filled and submitted report one by one, the rationality of the filling data submitted by the report is improved, and meanwhile, the manpower is greatly saved.
Drawings
FIG. 1 is a flow chart of a method for generating an online filled report according to the present invention;
FIG. 2 is a schematic structural diagram of a terminal for generating an online filled report according to the present invention;
FIG. 3 is a report style diagram when a preset excel template is imported to generate a report template in the report generation process;
[ description of reference ]
1. A generation terminal of the online filled report; 2. a memory; 3. a processor.
Detailed Description
For the purpose of better explaining the present invention and to facilitate understanding, the present invention will be described in detail by way of specific embodiments with reference to the accompanying drawings.
Referring to fig. 1, a method for generating an online filled report includes:
s1, importing a preset excel template to generate a report template, wherein the report template comprises a template main body part, an enterprise data part and a data filling part;
s2, importing preset enterprise information in the enterprise data part, and setting static indexes and dynamic indexes in each filling frame of the data filling part;
the static indexes are as follows: each filling in a standard algorithm in the frame;
the dynamic index refers to: filling logic algorithms among the boxes;
and S3, releasing the report template.
From the above description, the beneficial effects of the present invention are: in the template making process, a development and report staff can self-define and select the imported excel template to generate the report template, the flexibility is high, after enterprise information is imported, the development and report staff can self-define and set static indexes and dynamic indexes in each filling frame of the data filling part, when workers filling the report fill each frame of the data filling part, filling contents can be automatically checked through the static indexes and the dynamic indexes, the checking staff do not need to check and check each filled and submitted report one by one, the rationality of the filling data submitted by the report is improved, and meanwhile, the manpower is greatly saved.
Further, the S3 includes:
releasing the report template, and judging whether the same report template exists in the database or not;
if yes, sending out a prompt: repeated release cannot be performed;
if not, the issuing is successful.
From the above description, it can be known that the same report template can be prevented from being issued through the above operations, and the occurrence of data redundancy in the database can be avoided.
Referring to fig. 2, a terminal for generating a linearly filled report includes a memory, a processor, and a computer program stored in the memory and executable on the processor, where the processor executes the computer program to implement the following steps:
s1, importing a preset excel template to generate a report template, wherein the report template comprises a template main body part, an enterprise data part and a data filling part;
s2, importing preset enterprise information in the enterprise data part, and setting static indexes and dynamic indexes in each filling frame of the data filling part;
the static indexes are as follows: each filling in a standard algorithm in the frame;
the dynamic index refers to: filling logic algorithms among the boxes;
and S3, releasing the report template.
From the above description, the beneficial effects of the present invention are: in the template making process, a development and report staff can self-define and select the imported excel template to generate the report template, the flexibility is high, after enterprise information is imported, the development and report staff can self-define and set static indexes and dynamic indexes in each filling frame of the data filling part, when workers filling the report fill each frame of the data filling part, filling contents can be automatically checked through the static indexes and the dynamic indexes, the checking staff do not need to check and check each filled and submitted report one by one, the rationality of the filling data submitted by the report is improved, and meanwhile, the manpower is greatly saved.
Further, the S3 includes:
releasing the report template, and judging whether the same report template exists in the database or not;
if yes, sending out a prompt: repeated release cannot be performed;
if not, the issuing is successful.
From the above description, it can be known that the same report template can be prevented from being issued through the above operations, and the occurrence of data redundancy in the database can be avoided.
Example one
Referring to fig. 1, a method for generating an online filled report includes:
s1, importing a preset excel template to generate a report template, wherein the report template comprises a template main body part, an enterprise data part and a data filling part;
s2, importing preset enterprise information in the enterprise data part, and setting static indexes and dynamic indexes in each filling frame of the data filling part;
the static indexes are as follows: each filling in a standard algorithm in the frame;
the dynamic index refers to: filling logic algorithms among the boxes;
and S3, releasing the report template.
For more convenient understanding, as shown in fig. 3, when a preset excel template is imported to generate a report style sheet of the report template, the left part of the header of the report is an enterprise data part, the right part of the middle part of the report is a data filling part, and the rest parts are template main parts. When a static index is set in each filling frame of the data filling part, if the 'business income' part sets the field length to be within 12 bits, the data unit is element, and the data type is digital type; when a dynamic index is set in each filling frame of the data filling part, the numerical value of the filling frame ' fixed asset investment is completed in the current year ' is set to be larger than ' wherein: the value of the investment is finished in this month, and when the writing error is filled in the process of the staff report, the filling error is prompted.
Wherein the S3 includes:
releasing the report template, and judging whether the same report template exists in the database or not;
if yes, sending out a prompt: repeated release cannot be performed;
if not, the issuing is successful.
Example two
Referring to fig. 2, a terminal 1 for generating an online filled report includes a memory 2, a processor 3, and a computer program stored in the memory 2 and executable on the processor 3, where the processor 3 implements the steps in the first embodiment when executing the computer program.
In summary, according to the method and the terminal for generating the online filled report, in the template making process, the development and report staff can self-define and select the imported excel template to generate the report template, the flexibility is high, after the enterprise information is imported, the development and report staff can self-define and set the static indexes and the dynamic indexes in each filling frame of the data filling part, when the staff filling the report fills each frame of the data filling part, the filling contents can be automatically audited through the static indexes and the dynamic indexes, the auditors do not need to check and audit each filled and submitted report one by one, the rationality of the filling data submitted by the report is improved, and the manpower is greatly saved.
The above description is only an embodiment of the present invention, and not intended to limit the scope of the present invention, and all equivalent changes made by using the contents of the present specification and the drawings, or applied directly or indirectly to the related technical fields, are included in the scope of the present invention.
Claims (4)
1. A method for generating a report filled on line is characterized by comprising the following steps:
s1, importing a preset excel template to generate a report template, wherein the report template comprises a template main body part, an enterprise data part and a data filling part;
s2, importing preset enterprise information in the enterprise data part, and setting static indexes and dynamic indexes in each filling frame of the data filling part;
the static indexes are as follows: each filling in a standard algorithm in the frame;
the dynamic index refers to: filling logic algorithms among the boxes;
and S3, releasing the report template.
2. The method for generating a report of online filling according to claim 1, wherein said S3 comprises:
releasing the report template, and judging whether the same report template exists in the database or not;
if yes, sending out a prompt: repeated release cannot be performed;
if not, the issuing is successful.
3. A terminal for generating a line-filled report, comprising a memory, a processor and a computer program stored on the memory and capable of running on the processor, wherein the processor executes the computer program to realize the following steps:
s1, importing a preset excel template to generate a report template, wherein the report template comprises a template main body part, an enterprise data part and a data filling part;
s2, importing preset enterprise information in the enterprise data part, and setting static indexes and dynamic indexes in each filling frame of the data filling part;
the static indexes are as follows: each filling in a standard algorithm in the frame;
the dynamic index refers to: filling logic algorithms among the boxes;
and S3, releasing the report template.
4. The terminal for generating a report of on-line filling out as claimed in claim 3, wherein said S3 comprises:
releasing the report template, and judging whether the same report template exists in the database or not;
if yes, sending out a prompt: repeated release cannot be performed;
if not, the issuing is successful.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011214071.3A CN112307729A (en) | 2020-11-04 | 2020-11-04 | Online filling report generation method and terminal |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011214071.3A CN112307729A (en) | 2020-11-04 | 2020-11-04 | Online filling report generation method and terminal |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112307729A true CN112307729A (en) | 2021-02-02 |
Family
ID=74324745
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011214071.3A Pending CN112307729A (en) | 2020-11-04 | 2020-11-04 | Online filling report generation method and terminal |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112307729A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115204126A (en) * | 2022-09-19 | 2022-10-18 | 北京必盈特信息技术有限公司 | Data filling method and device by utilizing online Excel |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080034393A1 (en) * | 2006-08-02 | 2008-02-07 | Aaron Crayford | Distribution of content and advertisement |
| CN103646016A (en) * | 2013-12-30 | 2014-03-19 | 金蝶软件（中国）有限公司 | Implementation method of user-defined financial statement and server |
| CN103679353A (en) * | 2013-12-02 | 2014-03-26 | 北京华胜天成科技股份有限公司 | Report processing method and system |
| CN103838740A (en) * | 2012-11-21 | 2014-06-04 | 方欣科技有限公司 | Report engine method |
| CN105320690A (en) * | 2014-07-30 | 2016-02-10 | 北京中海纪元数字技术发展股份有限公司 | Metadata based rapid statistic form generation method and system |
| CN105786785A (en) * | 2016-02-29 | 2016-07-20 | 浪潮软件集团有限公司 | User-defined financial statement collection method |
| CN109165266A (en) * | 2018-09-03 | 2019-01-08 | 中国平安人寿保险股份有限公司 | List generation method, device, computer equipment and storage medium |
| CN110263307A (en) * | 2019-04-15 | 2019-09-20 | 重庆金融资产交易所有限责任公司 | Report form generation method, server and computer readable storage medium |
| CN111861378A (en) * | 2020-06-23 | 2020-10-30 | 远光软件股份有限公司 | Reimbursement guide system, method and reimbursement device |
-
2020
- 2020-11-04 CN CN202011214071.3A patent/CN112307729A/en active Pending
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080034393A1 (en) * | 2006-08-02 | 2008-02-07 | Aaron Crayford | Distribution of content and advertisement |
| CN103838740A (en) * | 2012-11-21 | 2014-06-04 | 方欣科技有限公司 | Report engine method |
| CN103679353A (en) * | 2013-12-02 | 2014-03-26 | 北京华胜天成科技股份有限公司 | Report processing method and system |
| CN103646016A (en) * | 2013-12-30 | 2014-03-19 | 金蝶软件（中国）有限公司 | Implementation method of user-defined financial statement and server |
| CN105320690A (en) * | 2014-07-30 | 2016-02-10 | 北京中海纪元数字技术发展股份有限公司 | Metadata based rapid statistic form generation method and system |
| CN105786785A (en) * | 2016-02-29 | 2016-07-20 | 浪潮软件集团有限公司 | User-defined financial statement collection method |
| CN109165266A (en) * | 2018-09-03 | 2019-01-08 | 中国平安人寿保险股份有限公司 | List generation method, device, computer equipment and storage medium |
| CN110263307A (en) * | 2019-04-15 | 2019-09-20 | 重庆金融资产交易所有限责任公司 | Report form generation method, server and computer readable storage medium |
| CN111861378A (en) * | 2020-06-23 | 2020-10-30 | 远光软件股份有限公司 | Reimbursement guide system, method and reimbursement device |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115204126A (en) * | 2022-09-19 | 2022-10-18 | 北京必盈特信息技术有限公司 | Data filling method and device by utilizing online Excel |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110163735B (en) | Tax-related data processing method and device, computer equipment and storage medium | |
| CN101876970A (en) | Method for combining reports and device thereof | |
| CN110147365A (en) | The checking method of business datum and financial data, device, equipment and medium | |
| CN112307729A (en) | Online filling report generation method and terminal | |
| CN112464632A (en) | Form style dynamic storage and conversion method under excel report | |
| CN117371412B (en) | Form-based filling method, system, equipment and storage medium | |
| CN105786785B (en) | User-defined financial statement collection method | |
| CN110889272A (en) | Data processing method, device, equipment and storage medium | |
| CN108133341A (en) | A kind of generation method and system of the material alternative condition based on ERP system | |
| CN101308518B (en) | Topology element name corresponding method for copy type synergic modeling system | |
| CN116756129A (en) | Data complement method and device, storage medium and electronic equipment | |
| CN110674114A (en) | Distributed collaborative design data version control method and device | |
| CN114881601A (en) | Multi-process route transmission method based on PLM system | |
| CN114818642A (en) | Dynamic filling method for data report | |
| CN112907013A (en) | Executor selection method based on custom circulation | |
| CN106952053A (en) | A kind of Supply chain financing method based on dynamic flow | |
| CN113051321B (en) | Data importing method, device, equipment and storage medium | |
| CN111208983B (en) | Use method of plug-in type expandable framework | |
| Byeon et al. | Editable Blockchain for Secure IoT Transactions | |
| CN111882294A (en) | Process approval method and device | |
| Xu | Institute of Logistics Science and Engineering, Shanghai Maritime University, Shanghai, 201306, China 18019723145@ 163. com Abstract. In the market competition environment of oversupply, this paper | |
| CN112084762A (en) | Report template generation method and system | |
| CN112379921A (en) | System and method for automatic generation and self-improvement of dynamic flexible process | |
| CN117217186A (en) | Report generation device and method and storage medium | |
| CN117667960A (en) | Service table updating method, device, equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20210202 |