CN109766529B - Report generation method and equipment - Google Patents
Report generation method and equipment Download PDFInfo
- Publication number
- CN109766529B CN109766529B CN201811467736.4A CN201811467736A CN109766529B CN 109766529 B CN109766529 B CN 109766529B CN 201811467736 A CN201811467736 A CN 201811467736A CN 109766529 B CN109766529 B CN 109766529B
- Authority
- CN
- China
- Prior art keywords
- sheet
- template
- style
- report
- requirement
- 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.)
- Active
Links
Images
Abstract
The embodiment of the invention discloses a method and equipment for generating a report, relates to the field of data processing, and can simplify the production process of the report, reduce the production cost of the report and meet the requirements of customization and diversification of the report. The method comprises the following steps: the server receives an operation table sent by the terminal; the server analyzes the intermediate table, generates a calculation formula of the cells of the demand table, and determines a screening condition for the content of the source data table in the demand table according to the source data table; obtaining a calculation relation of a demand table generated by a source data table according to a calculation formula and a screening condition; analyzing the style sheet to generate style configuration information of the requirement sheet, wherein the style configuration information comprises a format and a display style of the requirement sheet, and the style sheet is used for determining a static style of the requirement sheet; and generating a report template according to the calculation relation of the demand sheet and the style configuration information of the demand sheet.
Description
Technical Field
The embodiment of the invention relates to the field of data processing, in particular to a report generation method and equipment.
Background
At present, in order to meet the diversified requirements of users, and the data relationship between more complex reports may appear. In addition, the generation process of the report necessarily comprises the steps of obtaining data from a database and customizing the calculation relationship of the cell data. When the current electronic report is generated, developers need to know user requirements and then use a professional report generation tool to complete the generation of the report through configuration and coding. For example, report tools such as FineReport and run-dry report all use report design tools like EXCEL operation interface to implement the configuration of report style and data in the form of what you see is what you get in the graphical interface.
Therefore, in the existing solution, it is necessary to complete the configuration of the data source and the encoding of the SQL query statement in the report design tool, and to complete the compilation of the calculation relationship according to the self-defined configuration method and relationship definition of the report designer, so that the configuration is cumbersome, the learning cost of the report tool is still high, and professional developers still need to perform operations to complete the development of the report requirement.
In addition, from the generation of report requirements of the user to the actual normal inquiry and report generation of the user, the following procedures need to be practiced: the user puts forward report requirements-development-test-online use. And in the process of later use, the method still comprises the following steps: finding a problem in use-user feedback-modification-testing-continuing the complex process of use after update. The above processes often include a lot of communication and understanding between the user and the developer, and the practical requirements of electronic report customization and diversification cannot be met in time.
Disclosure of Invention
The embodiment of the invention provides a report generation method and equipment, which can simplify the report production process, reduce the report production cost and meet the requirements of report customization and diversification.
In a first aspect, a method for generating a report is provided, where a server receives an operation table sent by a terminal, where the operation table includes: the system comprises a style sheet, a middle sheet and a requirement sheet, wherein the operation sheet is in an excel format; the server analyzes the intermediate table, generates a calculation formula of the cells of the demand table, and determines a screening condition for the content of the source data table in the demand table according to the source data table; the server obtains a calculation relation of generating the demand table by the source data table according to the calculation formula and the screening condition; the server analyzes the style sheet and generates style configuration information of the requirement sheet, wherein the style configuration information comprises a format and a display style of the requirement sheet, and the style sheet is used for determining a static style of the requirement sheet; and the server generates a report template according to the calculation relation of the demand sheet and the style configuration information of the demand sheet.
In summary, users cannot freely customize the reports required by themselves in the prior art, not only the learning process of a certain time is required for the query language of the database, but also the calculation formulas for screening and representing the relationship between data in the table are often complicated, and all formulas in the final requirement table cannot be generated by providing functions through excel from the data source table at one time. Therefore, the concept of an intermediate table and a style sheet in an excel format is introduced in the embodiment of the invention. The user can autonomously divide the complex screening and calculating process into a plurality of calculating steps which are easy to realize, and the calculation is carried out in the intermediate table to obtain an intermediate result, so that the configuration process of the final requirement table is simplified; in addition, the user can set the static style of the report form by editing the style sheet autonomously; finally, a report template can be generated according to the calculation relation of the demand table obtained by analyzing the intermediate table and the style configuration information of the demand table obtained by analyzing the intermediate table, and when a user inquires the report, the user can directly inquire the data content in the data source table according to the template of the target report to fill the data content so as to generate the target report. Therefore, the report making process can be simplified, the report making cost is reduced, and the requirements of customization and diversification of the report are met.
In a second aspect, a server is provided, which includes: the data export module is used for receiving an operation table sent by a terminal, wherein the operation table comprises: the system comprises a style sheet, a middle sheet and a requirement sheet, wherein the operation sheet is in an excel format; the data analysis module is used for analyzing the intermediate table received by the data export module, generating a calculation formula of the cells of the demand table and determining the screening conditions of the contents of the source data table in the demand table according to the source data table; the data link module is used for obtaining the calculation relation of the source data table for generating the demand table according to the calculation formula obtained by the data analysis module and the screening condition; the style analysis module is used for analyzing the style sheet received by the data export module and generating style configuration information of the requirement sheet, wherein the style configuration information comprises the format and the display style of the requirement sheet, and the style sheet is used for determining the static style of the requirement sheet; and the template generating module is used for generating a report template according to the calculation relationship of the requirement table generated by the data linking module and the style configuration information of the requirement table generated by the style analyzing module.
In a third aspect, a terminal is provided, including: the receiving module is used for exporting the operation table template and the source data table from the server; the editing module is used for editing the operation table template according to an editing instruction input by a user and then generating an operation table, wherein the operation table template comprises a style table template, an intermediate table template and a requirement table template, the user inputs the editing instruction to the terminal according to a source data table displayed by the terminal, and the editing instruction controls filling of the style table template to generate a style table, controls filling of the intermediate table template to generate an intermediate table and controls filling of screening conditions in a generation requirement table of the requirement table template; a sending module that sends the operation table to the server, wherein the operation table includes: the device comprises a style sheet, an intermediate sheet and a requirement sheet, wherein the style sheet is used for determining the static style of the requirement sheet, and the intermediate sheet is used for determining the calculation formula of the cell of the requirement sheet.
In a fourth aspect, a server is provided, which includes a communication interface, a processor, a memory, and a bus; the memory is used for storing computer execution instructions, the processor is connected with the memory through the bus, and when the server runs, the processor executes the computer execution instructions stored in the memory so as to enable the server to execute the report generation method.
In a fifth aspect, a terminal is provided, which includes a communication interface, a processor, a memory, and a bus; the memory is used for storing computer execution instructions, the processor is connected with the memory through the bus, and when the terminal runs, the processor executes the computer execution instructions stored in the memory, so that the terminal executes the report generation method.
In a sixth aspect, a computer storage medium is provided, which includes instructions that, when executed on a computer, cause the computer to perform the method for generating a report as described above.
In a seventh aspect, a computer program product is provided, which includes instruction codes for executing the report generation method.
It should be understood that any one of the server, the terminal, the computer storage medium, or the computer program product provided above is used for executing the method corresponding to the first aspect provided above, and therefore, the beneficial effects that can be achieved by the server, the terminal, the computer storage medium, or the computer program product may refer to the beneficial effects of the method according to the first aspect and the corresponding solutions in the following detailed description, and are not repeated herein.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings needed to be used in the description of the embodiments or the prior art will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art that other drawings can be obtained according to these drawings without creative efforts.
Fig. 1 is a schematic diagram of a network system according to an embodiment of the present invention;
fig. 2 is a schematic flow chart of a report generation method according to an embodiment of the present invention;
fig. 3 is a schematic structural diagram of a server according to an embodiment of the present invention;
fig. 4 is a schematic structural diagram of a server according to another embodiment of the present invention;
fig. 5 is a schematic structural diagram of a terminal according to an embodiment of the present invention;
fig. 6 is a schematic structural diagram of a terminal according to another embodiment of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
The embodiment of the present invention is applied to a network system, which includes a terminal 11 and a server 12 as shown in fig. 1, wherein the terminal may be a mobile phone or other user equipment, such as a PAD, a palm computer, a PC, a vehicle-mounted terminal, etc.; in addition, the network system is used in a B/S architecture (Browser/Server, Browser/Server architecture), or a C/S architecture; the browser is installed on the terminal 11 in a B/S architecture scene; the terminal 11 may be a Client in a C/S architecture (Client/Server architecture).
Referring specifically to the flow shown in fig. 2, the embodiment of the present invention includes the following steps:
101. the server receives an operation table sent by the terminal, wherein the operation table comprises: the system comprises a style sheet, a middle sheet and a requirement sheet, wherein the operation sheet is in an excel format.
The server supports a data export function, before step 101, the server exports an operation table template and a source data table to the terminal, the terminal edits the operation table template according to an editing instruction input by a user to generate an operation table, the operation table template comprises a style sheet template, a middle sheet template and a requirement sheet template, and the user inputs the editing instruction to the terminal according to the source data table displayed by the terminal. Illustratively, the editing instructions control the filling of the stylesheet template into the stylesheet, control the filling of the intermediate table template into the intermediate table, and control the filling of the filter conditions in the generation requirement table of the requirement table template. The style sheet is used for determining the static style of the requirement sheet, and the intermediate sheet is used for determining the calculation formula of the cell of the requirement sheet.
Specifically, the operation table may include a plurality of worksheets, which are the style sheet, the middle sheet, and the requirement sheet according to types; of course, the data source table can also be called an operation table, and in the excel workbook file, the distinction is carried out according to the name of the worksheet. The following descriptions of the various tables are as follows:
the data source table comprises the list heads and data information of the tables in the database selected by the user; the worksheets (data source tables) of the data source type can be divided into a plurality of worksheet export displays according to a plurality of database tables selected by a user. In addition, in each column of the data source table, only part of data is required to be exported for reference calculation, and all data rows do not need to be extracted and displayed.
The style sheet specifies the static style of the requirement sheet, and comprises configuration information such as a sheet header, a column header group, a plurality of rows for combination, a plurality of columns for combination, fixed row and column number, color and size of cells and the like.
The intermediate table is used for editing and displaying the intermediate calculation result of the complex calculation process in the requirement table.
The requirement table is a report table which is customized by the end user. The requirement table comprises a report static table head, a row head content and all cell data calculation formulas. The row and column style of cells in the requirements sheet needs to be consistent with the configuration of the style sheet. The demand table also includes the arrangement of the filtering conditions (or query conditions), and the fixed area cells are set in the demand table (EXCEL table format) as the query conditions. The query condition can be realized by an EXCEL table drop-down list and an input control; the formulas in the intermediate table and the requirement table can refer to the cells; these cells as query conditions correspond to each query condition filled in by the user when the user performs the relevant operation of condition query at the terminal.
In order to achieve the above requirements, the server needs to be configured with an analysis function for the operation table, which specifically includes:
102. and the server analyzes the intermediate table, generates a calculation formula of the cells of the demand table, and determines the screening conditions of the contents of the data source table in the demand table according to the data source table.
In order to realize the resolution of the intermediate table, the intermediate table needs to be a simple table, namely, the intermediate table only contains static contents, and the data in the rest tables are all references. There may be several intermediate tables, and the formula content in the intermediate tables may refer to the data source table and other intermediate tables, and may not be referred to circularly.
The main function of step 102 is to convert the contents of the data source table referred in the intermediate table and the requirement table, and the calculation formula (e.g., excel formula) for processing and calculating the contents of the data source table into the corresponding screening conditions and the associated relationship related to the data summarization calculation. On one hand, the screening conditions in the intermediate table are analyzed to generate a relation expression of a data range selection algorithm; and on the other hand, analyzing the excel formula to obtain a corresponding data calculation algorithm relation. When the analysis has errors, the data analysis module provides detailed error prompts to guide the user to modify the imported operation table, such as an intermediate table or a requirement table.
103. And the server obtains the calculation relation of the requirement table generated by the data source table according to the calculation formula and the screening condition.
The functions mainly performed in step 103 are to link the processes of generating data of the intermediate table by computing the data of the data source table and generating data of the demand table by computing the data of the intermediate table based on the result output in step 102, and determine the computation relationship from the content of the data source table to each cell in the demand table by computing.
In addition, the result generated by the data link is the correlation calculation relationship of the cell results of the generated requirement table calculated from the data source table. Since the calculation relationship is generated by means of calculation assistance of the intermediate table, unnecessary repetition of the algorithm is inevitably generated as a result, and the algorithm is a zigzag and complex calculation process. Therefore, in step 103, the method further comprises optimizing the screening conditions and the calculation formula. For example: and analyzing the correlation degree of the calculation relation between the data source table and the result, simplifying the calculation relation obtained by formula linking between tables, and generating final query and calculation codes, thereby improving the efficiency of generating the demand table.
104. The server analyzes the style sheet and generates style configuration information of the requirement sheet, wherein the style configuration information comprises the format and the display style of the requirement sheet, and the style sheet is used for determining the static style of the requirement sheet.
Since the style sheet specifies the static style of the requirement sheet, the parsing is mainly performed on the style label of the cell in the imported style sheet in this step. And determining the size, color, character and style information of the required report displayed in the terminal. In addition, the style sheet and the requirement sheet can be analyzed to check whether the form formats of the style sheet and the requirement sheet correspond to each other, otherwise, detailed error prompt is carried out when the operation sheet is imported.
105. And the server generates a report template according to the calculation relation of the demand sheet and the style configuration information of the demand sheet.
Finally, the embodiment of the application also provides a report query and display function, and specifically comprises the following steps:
106. and the server receives a report inquiry request sent by the terminal equipment, wherein the report inquiry request contains the identifier of the target report.
107. And the server determines a template of the target report according to the identifier of the target report and determines the queried data content in a source data table of the database.
108. And the server combines the template of the target report form and the data content into the target report form and feeds the target report form back to the terminal.
Based on the network system, the report presentation does not depend on a specific client, and no matter in a browser or a customized computer client, the report presentation process can call corresponding interfaces according to different clients, finally present a result table for use, and provide functions of exporting, downloading, printing and the like.
In summary, users cannot freely customize the reports required by themselves in the prior art, not only the learning process of a certain time is required for the query language of the database, but also the calculation formulas for screening and representing the relationship between data in the table are often complicated, and all formulas in the final requirement table cannot be generated by providing functions through excel from the data source table at one time. Therefore, the concept of the intermediate table and the style sheet in the excel format is introduced in the embodiment of the invention. The user can autonomously divide the complex screening and calculating process into a plurality of calculating steps which are easy to realize, and the calculation is carried out in the intermediate table to obtain an intermediate result, so that the configuration process of the final requirement table is simplified; in addition, a user can set the static style of the report form by editing the style sheet independently; finally, a report template can be generated according to the calculation relation of the demand table obtained by analyzing the intermediate table and the style configuration information of the demand table obtained by analyzing the intermediate table, and when a user inquires the report, the user can directly inquire the data content in the data source table according to the template of the target report to fill the data content so as to generate the target report. Therefore, the report making process can be simplified, the report making cost is reduced, and the requirements of customization and diversification of the report are met.
Referring to fig. 3, a server includes:
a data deriving module 31, configured to receive an operation table sent by a terminal, where the operation table includes: the system comprises a style sheet, a middle sheet and a requirement sheet, wherein the operation sheet is in an excel format;
a data parsing module 32, configured to parse the intermediate table received by the data deriving module 31, generate a calculation formula of a cell of the requirement table, and determine, according to a source data table, a screening condition for contents of the source data table in the requirement table;
the data link module 33 is configured to obtain a calculation relationship of the requirement table generated by the source data table according to the calculation formula obtained by the data analysis module 32 and the screening condition;
a style parsing module 34, configured to parse the style sheet received by the data export module 31, and generate style configuration information of the requirement sheet, where the style configuration information includes a format and a display style of the requirement sheet, and the style sheet is used to determine a static style of the requirement sheet;
the template generating module 35 is configured to generate a template of a report according to the calculation relationship of the requirement table generated by the data linking module 33 and the style configuration information of the requirement table generated by the style analyzing module 34.
In an exemplary scheme, the report display module 36 is configured to receive a report query request sent by a terminal, where the report query request includes an identifier of a target report; determining a template of the target report according to the identifier of the target report, and determining the queried data content in a source data table of a database; and combining the template of the target report form and the data content into a target report form, and feeding back the target report form to the terminal.
In an exemplary scheme, the data export module 31 is further configured to export an operation table template and a source data table to a terminal, so that the terminal edits the operation table template according to an editing instruction input by a user to generate the operation table, where the operation table template includes a style sheet template, an intermediate sheet template and a requirement sheet template, and the user inputs the editing instruction to the terminal according to the source data table displayed by the terminal; and the editing instruction controls filling of the style sheet template to generate a style sheet, controls filling of the intermediate sheet template to generate an intermediate sheet and controls filling of screening conditions in a generation requirement sheet of the requirement sheet template.
In an exemplary aspect, the method further comprises: and a query optimization module 37, configured to optimize the screening condition and the calculation formula obtained by the data analysis module 32.
All relevant contents of each step related to the above method embodiment may be referred to the functional description of the corresponding functional module, and the function thereof is not described herein again.
In the case of an integrated module, the server comprises: the device comprises a storage unit, a processing unit and an interface unit. The processing unit is used for performing control management on the actions of the server, for example, the processing unit is used for supporting the server to execute the processes 102, 107 and 108 in fig. 2; the interface unit is used for the server to execute the processes 101, 106 and 108 in the figure 2; and a storage unit for storing the program codes and data of the server.
For example, the processing unit is a processor, the storage unit is a memory, and the interface unit is a communication interface. The server shown in fig. 4 includes a communication interface 401, a processor 402, a memory 403, and a bus 404, where the communication interface 401 and the processor 402 are connected to the memory 403 through the bus 404.
The Memory 403 may be a Read-Only Memory (ROM) or other type of static storage device that can store static information and instructions, a Random Access Memory (RAM) or other type of dynamic storage device that can store information and instructions, an Electrically Erasable Programmable Read-Only Memory (EEPROM), a Compact Disc Read-Only Memory (CD-ROM) or other optical Disc storage, optical Disc storage (including Compact Disc, laser Disc, optical Disc, digital versatile Disc, blu-ray Disc, etc.), magnetic disk storage media or other magnetic storage devices, or any other medium that can be used to carry or store desired program code in the form of instructions or data structures and that can be accessed by a computer, but is not limited to these. The memory may be self-contained and coupled to the processor via a bus. The memory may also be integral to the processor.
The memory 403 is used for storing application program codes for executing the scheme of the present application, and is controlled by the processor 402 to execute, for example, support the server to execute the processes 102, 107, and 108 in fig. 2. The communication interface 401 is used to support the server to execute the processes 101, 106, 108 in fig. 2. The processor 402 is configured to execute application program code stored in the memory 403 to implement the methods described in the embodiments of the present application.
Referring to fig. 5, an embodiment of the present invention provides a terminal, including:
a receiving module 51, configured to derive an operation table template and a source data table from a server;
the editing module 52 is configured to edit the operation table template received by the receiving module 51 according to an editing instruction input by a user, and then generate an operation table, where the operation table template includes a style sheet template, an intermediate sheet template, and a requirement sheet template, and the user inputs the editing instruction to a terminal according to a source data sheet displayed by the terminal, where the editing instruction controls filling of the style sheet template to generate a style sheet, controls filling of the intermediate sheet template to generate an intermediate sheet, and controls filling of a filter condition in a requirement sheet generated by the requirement sheet template;
a sending module 53, configured to send the operation table generated by the editing module 52 to the server, where the operation table includes: the device comprises a style sheet, an intermediate sheet and a requirement sheet, wherein the style sheet is used for determining the static style of the requirement sheet, and the intermediate sheet is used for determining the calculation formula of the cell of the requirement sheet.
All relevant contents of each step related to the above method embodiment may be referred to the functional description of the corresponding functional module, and the function thereof is not described herein again.
In case of using an integrated module, the terminal comprises: the device comprises a storage unit, a processing unit and an interface unit. The processing unit is configured to control and manage the actions of the terminal, for example, the processing unit is configured to support the terminal to execute the process 107 in fig. 2; the interface unit is used for supporting information interaction between the terminal and other devices, for example, performing steps 101, 106, and 108. And a storage unit for storing program codes and data of the terminal.
For example, the processing unit is a processor, the storage unit is a memory, and the interface unit is a communication interface. The terminal shown in fig. 6 includes a communication interface 601, a processor 602, a memory 603, and a bus 604, where the communication interface 601 and the processor 602 are connected to the memory 603 through the bus 604.
The memory 603 is used for storing application program codes for executing the scheme of the present application, and is controlled by the processor 602 to execute, for example, step 107 in fig. 2. The communication interface 601 is used for information interaction with other devices, for example, to support the terminal to execute steps 101, 106, and 108. The processor 602 is configured to execute the application program code stored in the memory 603, thereby implementing the methods described in the embodiments of the present application.
In addition, a computing storage medium (or media) is also provided, which includes instructions that when executed perform the method operations performed by the network side device or the terminal in the above embodiments. Additionally, a computer program product is also provided, comprising the above-described computing storage medium (or media).
All relevant contents of each step related to the above method embodiment may be referred to the functional description of the corresponding functional module, and the function thereof is not described herein again.
It should be understood that, in the various embodiments of the present invention, the sequence numbers of the above-mentioned processes do not imply an order of execution, and the order of execution of the processes should be determined by their functions and internal logics, and should not limit the implementation processes of the embodiments of the present invention in any way.
Those of ordinary skill in the art will appreciate that the various illustrative elements and algorithm steps described in connection with the embodiments disclosed herein may be implemented as electronic hardware or combinations of computer software and electronic hardware. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the implementation. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present invention.
It is clear to those skilled in the art that, for convenience and brevity of description, the specific working processes of the above-described systems, apparatuses and units may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again.
In the several embodiments provided in the present application, it should be understood that the disclosed system, apparatus, and method may be implemented in other ways. For example, the above-described device embodiments are merely illustrative, and for example, the division of the units is only one logical functional division, and other divisions may be realized in practice, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may be in an electrical, mechanical or other form.
The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional units in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit.
The functions, if implemented in the form of software functional units and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: a U disk, a removable hard disk, a read-only memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and other various media capable of storing program codes.
The above description is only for the specific embodiments of the present invention, but the scope of the present invention is not limited thereto, and any person skilled in the art can easily conceive of the changes or substitutions within the technical scope of the present invention, and all the changes or substitutions should be covered within the scope of the present invention. Therefore, the protection scope of the present invention shall be subject to the protection scope of the appended claims.
Claims (13)
1. A method for generating a report is characterized in that,
the method comprises the steps that a server receives an operation table sent by a terminal, wherein the operation table comprises: the system comprises a style sheet, a middle sheet and a requirement sheet, wherein the operation sheet is in an excell format;
the server analyzes the intermediate table, generates a calculation formula of the cells of the demand table, and determines a screening condition for the content of the source data table in the demand table according to the source data table;
the server obtains a calculation relation of the source data table for generating the demand table according to the calculation formula and the screening condition;
the server analyzes the style sheet and generates style configuration information of the requirement sheet, wherein the style configuration information comprises a format and a display style of the requirement sheet, and the style sheet is used for determining a static style of the requirement sheet;
and the server generates a report template according to the calculation relation of the demand sheet and the style configuration information of the demand sheet.
2. A report generation method according to claim 1, characterized in that said method further comprises:
the server receives a report inquiry request sent by terminal equipment, wherein the report inquiry request contains an identifier of a target report;
the server determines a template of a target report according to the identification of the target report, and determines the queried data content in a source data table of a database;
and the server combines the template of the target report form and the data content into a target report form and feeds the target report form back to the terminal.
3. The report generation method according to claim 1, wherein before the server receives the operation table transmitted from the terminal, the method further comprises:
the server exports an operation table template and a source data table to a terminal, so that the terminal edits the operation table template according to an editing instruction input by a user and generates the operation table, wherein the operation table template comprises a style sheet template, an intermediate sheet template and a requirement sheet template, and the user inputs the editing instruction to the terminal according to the source data table displayed by the terminal; and the editing instruction controls filling of the style sheet template to generate a style sheet, controls filling of the intermediate sheet template to generate an intermediate sheet and controls filling of screening conditions in a generation requirement sheet of the requirement sheet template.
4. A report generation method according to claim 1, wherein before the server obtains the calculation relationship of the demand table generated by the source data table according to the calculation formula and the screening condition, the method further comprises:
and the server optimizes the screening conditions and the calculation formula.
5. A server, comprising:
the data export module is used for receiving an operation table sent by a terminal, wherein the operation table comprises: the system comprises a style sheet, a middle sheet and a requirement sheet, wherein the operation sheet is in an excell format;
the data analysis module is used for analyzing the intermediate table received by the data export module, generating a calculation formula of the cells of the demand table and determining the screening condition of the content of the source data table in the demand table according to the source data table;
the data link module is used for obtaining the calculation relation of the source data table for generating the demand table according to the calculation formula obtained by the data analysis module and the screening condition;
the style analysis module is used for analyzing the style sheet received by the data export module and generating style configuration information of the requirement sheet, wherein the style configuration information comprises the format and the display style of the requirement sheet, and the style sheet is used for determining the static style of the requirement sheet;
and the template generating module is used for generating a report template according to the calculation relationship of the requirement table generated by the data linking module and the style configuration information of the requirement table generated by the style analyzing module.
6. The server according to claim 5, wherein the report presentation module is configured to receive a report query request sent by a terminal device, wherein the report query request includes an identifier of a target report; determining a template of the target report according to the identifier of the target report, and determining the queried data content in a source data table of a database; and combining the template of the target report form and the data content into a target report form, and feeding back the target report form to the terminal.
7. The server according to claim 5, wherein the data export module is further configured to export an operation table template and a source data table to a terminal, so that the terminal edits the operation table template according to an editing instruction input by a user to generate the operation table, wherein the operation table template includes a style sheet template, an intermediate sheet template and a requirement sheet template, and the user inputs the editing instruction to the terminal according to the source data table displayed by the terminal; and the editing instruction controls filling of the style sheet template to generate a style sheet, controls filling of the intermediate sheet template to generate an intermediate sheet and controls filling of screening conditions in a generation requirement sheet of the requirement sheet template.
8. The server of claim 5, further comprising: and the query optimization module is used for optimizing the screening conditions and the calculation formula obtained by the data analysis module.
9. A terminal, comprising:
the receiving module is used for exporting the operation table template and the source data table from the server;
the editing module is used for editing the operation table template according to an editing instruction input by a user and then generating an operation table, wherein the operation table template comprises a style table template, an intermediate table template and a requirement table template, the user inputs the editing instruction to the terminal according to a source data table displayed by the terminal, and the editing instruction controls filling of the style table template to generate a style table, controls filling of the intermediate table template to generate an intermediate table and controls filling of screening conditions in a generation requirement table of the requirement table template;
a sending module, configured to send the operation table to the server, where the operation table includes: the system comprises a style sheet, an intermediate sheet and a requirement sheet, wherein the style sheet is used for determining the static style of the requirement sheet, and the intermediate sheet is used for determining the calculation formula of the cell of the requirement sheet.
10. A server, comprising a communication interface, a processor, a memory, a bus; the memory is used for storing computer execution instructions, the processor is connected with the memory through the bus, and when the server runs, the processor executes the computer execution instructions stored by the memory so as to enable the server to execute the report generation method according to any one of claims 1-4.
11. A terminal comprising a communication interface, a processor, a memory, a bus; the memory is used for storing computer execution instructions, the processor is connected with the memory through the bus, and when the terminal runs, the processor executes the computer execution instructions stored in the memory so as to enable the terminal to execute the report generation method according to any one of claims 1-4.
12. A computer storage medium comprising instructions that, when executed on a computer, cause the computer to perform a method of generating a report according to any of claims 1-4.
13. A computer program product, characterized in that it comprises instruction code for executing the method of generation of a report according to any of claims 1-4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811467736.4A CN109766529B (en) | 2018-12-03 | 2018-12-03 | Report generation method and equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811467736.4A CN109766529B (en) | 2018-12-03 | 2018-12-03 | Report generation method and equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109766529A CN109766529A (en) | 2019-05-17 |
| CN109766529B true CN109766529B (en) | 2022-09-27 |
Family
ID=66450872
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811467736.4A Active CN109766529B (en) | 2018-12-03 | 2018-12-03 | Report generation method and equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109766529B (en) |
Families Citing this family (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110347992A (en) * | 2019-07-10 | 2019-10-18 | 成都函夏科技有限公司 | Data analysing method and system based on electronic report forms |
| CN111126019B (en) * | 2019-11-28 | 2024-01-05 | 泰康保险集团股份有限公司 | Report generation method and device based on mode customization and electronic equipment |
| CN111124570A (en) * | 2019-12-06 | 2020-05-08 | 深圳市元征科技股份有限公司 | Method for generating automobile diagnosis report and related equipment |
| CN111881192B (en) * | 2020-08-03 | 2024-01-30 | 浪潮云信息技术股份公司 | Method, system, electronic equipment and storage medium for generating visual configuration report |
| CN112036142A (en) * | 2020-09-02 | 2020-12-04 | 中国银行股份有限公司 | Real-time report generation method and system based on data configuration |
| CN112258907B (en) * | 2020-11-19 | 2022-06-14 | 唐山学院 | Display device is used in colleges and universities EXECL financial management teaching |
| CN113486269B (en) * | 2021-05-25 | 2024-01-30 | 厦门海迈科技股份有限公司 | WEB-based electronic form data processing method, computing device and storage medium |
| CN113743060B (en) * | 2021-08-30 | 2023-05-26 | 建信金融科技有限责任公司 | Customizable report generation method, device, computer equipment and storage medium |
Family Cites Families (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2015011581A (en) * | 2013-06-28 | 2015-01-19 | キヤノンマーケティングジャパン株式会社 | Information processing device, information processing method, and program |
| CN104376068B (en) * | 2014-11-07 | 2018-04-03 | 北京思特奇信息技术股份有限公司 | A kind of data exhibiting system and method based on dynamic statement template |
| CN106599120A (en) * | 2016-12-01 | 2017-04-26 | 中国联合网络通信集团有限公司 | Stream processing framework-based data processing method and apparatus |
| CN107092625B (en) * | 2016-12-28 | 2020-10-09 | 北京星选科技有限公司 | Data configuration method, data processing method and device |
-
2018
- 2018-12-03 CN CN201811467736.4A patent/CN109766529B/en active Active
Also Published As
| Publication number | Publication date |
|---|---|
| CN109766529A (en) | 2019-05-17 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109766529B (en) | Report generation method and equipment | |
| CN101122899B (en) | Report generation method and device | |
| CN103077185A (en) | Object-based user-defined information-expanding method | |
| CN111126019B (en) | Report generation method and device based on mode customization and electronic equipment | |
| CN113760359A (en) | Data processing method, device, equipment and computer readable storage medium | |
| CN111309313A (en) | Method for quickly generating HTML (hypertext markup language) and storing form data | |
| CN112464632B (en) | Dynamic storage and conversion method for table style under excel report | |
| CN111782117B (en) | Interface display method and device, storage medium and electronic device | |
| CN114036425A (en) | Page access method, client, server and system | |
| CN113505580A (en) | Method and device for analyzing table file | |
| CN111367976A (en) | Method and device for exporting EXCEL file data based on JAVA reflection mechanism | |
| CN109710250A (en) | It is a kind of for constructing the visualization engine system and method for user interface | |
| CN110198327B (en) | Data transmission method and related equipment | |
| CN114357943A (en) | Universal efficient Excel reading processing method, tool, medium and equipment | |
| CN113590593A (en) | Method and device for generating data table information, storage medium and electronic device | |
| CN116821103B (en) | Data processing method, device, equipment and computer readable storage medium | |
| CN106933552B (en) | Data processing method and front-end code generating device | |
| CN109739504B (en) | Method for automatically generating H5 service handling page according to background configuration | |
| CN115543324B (en) | Method, device, equipment and medium for generating interactive interface | |
| CN115934716A (en) | Method for importing Excel table data into database based on metadata definition and implementation | |
| US20220284371A1 (en) | Method, device and medium for a business function page | |
| CN114996268A (en) | User-defined report generation method and user-defined report generation device | |
| CN114064601B (en) | Storage process conversion method, device, equipment and storage medium | |
| CN111176624B (en) | Method and device for generating stream type calculation index | |
| CN112199335A (en) | Generation method and generation system of operation log |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |