CN112783582A - Report generation method and device, electronic equipment and storage medium - Google Patents

Report generation method and device, electronic equipment and storage medium Download PDF

Info

Publication number
CN112783582A
CN112783582A CN202110185067.7A CN202110185067A CN112783582A CN 112783582 A CN112783582 A CN 112783582A CN 202110185067 A CN202110185067 A CN 202110185067A CN 112783582 A CN112783582 A CN 112783582A
Authority
CN
China
Prior art keywords
row
configuration
item
configuration information
logic
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.)
Withdrawn
Application number
CN202110185067.7A
Other languages
Chinese (zh)
Inventor
毛芝琼
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Shenzhen Lexin Software Technology Co Ltd
Original Assignee
Shenzhen Lexin Software Technology Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Shenzhen Lexin Software Technology Co Ltd filed Critical Shenzhen Lexin Software Technology Co Ltd
Priority to CN202110185067.7A priority Critical patent/CN112783582A/en
Publication of CN112783582A publication Critical patent/CN112783582A/en
Withdrawn legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F9/00Arrangements for program control, e.g. control units
    • G06F9/06Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
    • G06F9/44Arrangements for executing specific programs
    • G06F9/448Execution paradigms, e.g. implementations of programming paradigms

Landscapes

  • Engineering & Computer Science (AREA)
  • Software Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • User Interface Of Digital Computer (AREA)

Abstract

The embodiment of the invention discloses a report generation method and device, electronic equipment and a storage medium. The method comprises the following steps: receiving a creation instruction input by a user for creating a target report; responding to the creating instruction, and displaying at least one row configuration interface, wherein the row configuration interface is used for displaying at least one row configuration item of the target report; receiving row configuration information input by a user based on at least one row configuration item, and determining column configuration information according to the row configuration information; and generating the target report based on the row configuration information and the column configuration information. The technical scheme of the embodiment of the invention realizes the improvement of the flexibility of report generation and the improvement of the efficiency of report generation, thereby meeting the requirements of various report generation.

Description

Report generation method and device, electronic equipment and storage medium
Technical Field
The embodiment of the invention relates to the technical field of information, in particular to a report generation method and device, electronic equipment and a storage medium.
Background
Reports are forms, charts, etc. used to dynamically display data. The report may be formulated as: "report is a diverse format + dynamic data". The report tool is used for helping a user to display input data of the user, and more times, the data is displayed in a mode desired by the user.
At present, most report generation methods provide business personnel with data and report templates required by report making through developers, and the business personnel fill the data into the report templates.
However, when the report is generated by manually generating the data, the labor cost is high, and the report generation is not flexible, so that the report generation efficiency is low.
Disclosure of Invention
The embodiment of the invention provides a report generation method and device, electronic equipment and a storage medium, which are used for improving the flexibility of report generation and improving the efficiency of report generation so as to meet the requirements of various report generation.
In a first aspect, an embodiment of the present invention provides a report generating method, where the method includes:
receiving a creation instruction input by a user for creating a target report;
responding to the creating instruction, and displaying at least one row configuration interface, wherein the row configuration interface is used for displaying at least one row configuration item of the target report;
receiving row configuration information input by a user based on at least one row configuration item, and determining column configuration information according to the row configuration information;
and generating the target report based on the row configuration information and the column configuration information.
In a second aspect, an embodiment of the present invention further provides a report generating apparatus, where the apparatus includes:
the system comprises a creation instruction receiving module, a report form creating module and a report form creating module, wherein the creation instruction receiving module is used for receiving a creation instruction which is input by a user and used for creating a target report form;
the row configuration item display module is used for responding to the creating instruction and displaying at least one row configuration interface, wherein the row configuration interface is used for displaying at least one row configuration item of the target report;
the column configuration information determining module is used for receiving row configuration information input by a user based on at least one row configuration item and determining column configuration information according to the row configuration information;
and the target report generation module is used for generating the target report based on the row configuration information and the column configuration information.
In a third aspect, an embodiment of the present invention further provides an electronic device, where the electronic device includes:
one or more processors;
a storage device, configured to store one or more programs, which when executed by the processor, enable the processor to implement the report generation method provided in any embodiment of the present invention.
In a fourth aspect, an embodiment of the present invention further provides a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the report generating method provided in any embodiment of the present invention.
According to the technical scheme of the embodiment of the invention, the creation instruction for creating the target report form is received by the user input. And in response to the creating instruction, displaying at least one row configuration interface, wherein the row configuration interface is used for displaying at least one row configuration item of the target report. Receiving row configuration information input by a user based on at least one row configuration item, and determining column configuration information according to the row configuration information. According to the embodiment of the invention, the row configuration information and the column configuration information are configured through the row configuration items in the row configuration interface, so that the advantage of processing is that a user can configure the rows and the columns of the target report according to the requirement of the user. The target report is generated based on the row configuration information and the column configuration information, the problems that labor cost is high and report generation is inflexible when data is generated into the report in a manual mode are solved, flexibility of report generation is improved, efficiency of report generation is improved, and therefore the effect of various report generation requirements is met.
Drawings
In order to more clearly illustrate the technical solutions of the exemplary embodiments of the present invention, a brief description is given below of the drawings used in describing the embodiments. It should be clear that the described figures are only views of some of the embodiments of the invention to be described, not all, and that for a person skilled in the art, other figures can be derived from these figures without inventive effort.
Fig. 1 is a schematic flow chart of a report generation method according to an embodiment of the present invention;
FIG. 2 is a flowchart illustrating a report generating method according to a second embodiment of the present invention;
fig. 3 is a schematic flow chart of a report generating method according to a third embodiment of the present invention;
fig. 4 is a schematic flow chart of a report generating method according to a fourth embodiment of the present invention;
fig. 5 is a schematic diagram of a row configuration interface according to a fifth embodiment of the present invention;
fig. 6 is a schematic diagram of a row configuration interface according to a fifth embodiment of the present invention;
fig. 7 is a schematic diagram of a row configuration interface according to a fifth embodiment of the present invention;
FIG. 8 is a schematic diagram of a row configuration interface according to a fifth embodiment of the present invention;
FIG. 9 is a schematic diagram of a row configuration interface according to a fifth embodiment of the present invention;
fig. 10 is a schematic diagram of a report generation apparatus module according to a sixth embodiment of the present invention;
fig. 11 is a schematic structural diagram of an electronic device according to a seventh embodiment of the present invention.
Detailed Description
The present invention will be described in further detail with reference to the accompanying drawings and examples. It is to be understood that the specific embodiments described herein are merely illustrative of the invention and are not limiting of the invention. It should be further noted that, for the convenience of description, only some of the structures related to the present invention are shown in the drawings, not all of the structures.
Example one
Fig. 1 is a flowchart illustrating a report generating method according to an embodiment of the present invention, where the present embodiment is applicable to a situation where a target report is generated by inputting configuration information through a row configuration item in a row configuration interface, the method may be executed by a report generating apparatus, the report generating apparatus may be implemented in a software and/or hardware manner, and the report generating apparatus may be integrated in an electronic device such as a computer or a server.
As shown in fig. 1, the method of the present embodiment includes:
and S110, receiving a creation instruction for creating the target report input by the user.
The target report can be understood as a report to be generated, such as a financial report. The form of the target report includes a table consisting of rows and columns. The create instruction may be understood as an instruction for initiating the creation of the target report. Optionally, the creation instruction is generated when a user input is received for triggering a triggering operation for creating the target report. Specifically, the creating instruction may be generated when a triggering operation for triggering creation of the target report, which is preset by a user in a preset area, is received. Wherein the trigger operation can be generated by triggering a physical key or a virtual key.
Illustratively, a creation instruction for creating a target report, which is input by a user, is received, and may be a creation instruction generated by triggering a creation identifier, which is preset by the user, for creating the target report; and receiving a creation command and the like generated by the user based on the creation command for creating the target report and input by the input device. The creation command for creating the target report, which is input by the input device, may be, for example, a creation command preset by a user, which is input by a physical input device (e.g., a mouse, a handwriting device, and/or a keyboard) or a touch device (e.g., a virtual keyboard, and/or a handwriting area), and the like, in a setting input box. It is understood that the specific expression form of the creation command may be set according to actual requirements, and is not limited specifically herein, and may be, for example, words and/or numbers.
In this embodiment, there are various ways to generate the creation instruction, and as an optional implementation manner of the embodiment of the present invention, the way to generate the creation instruction may be to generate the creation instruction when it is detected that the user clicks or double-clicks the application program for creating the target report. As another optional implementation manner of the embodiment of the present invention, the manner of generating the creation instruction may be that the creation instruction is generated when it is detected that the user inputs the correct user name and password in the application program.
Specifically, according to the function of the application program, the application program used for creating the target report is determined. The operation of an application program for creating a target report is triggered by a preset user. And determining whether the user triggers the application program for creating the target report or not according to the preset operation that the user triggers the application program for creating the target report. When detecting that the user triggers the application program for creating the target report, generating a creating instruction for creating the target report. An instruction receiving module of the report generation system receives a creation instruction for creating a target report to create the target report.
S120, responding to the creating instruction, and displaying at least one row configuration interface, wherein the row configuration interface is used for displaying at least one row configuration item of the target report.
Wherein, the line configuration interface can be understood as an interface for configuring the target report. The number of the line configuration interfaces may be one, two or more. When a plurality of row configuration interfaces exist, the logical relationship between the row configuration interfaces can be preset to configure the target report. The elements displayed by the line configuration interface can comprise line configuration items, configuration item names corresponding to the line configuration items, and jump controls between the line configuration interfaces. The row configuration item may be used to configure cell information in the target report. The number of row configuration items may be one, two, or more than two. The relationship of the row configuration interface to the row configuration items may be: a row configuration interface may present one or more row configuration items.
Specifically, the display logic of the row configuration interface is preset. And when a creating instruction is received, determining the displayed row configuration interface according to the preset display logic of the row configuration interface. And displaying the corresponding row configuration items in the row configuration interface according to the displayed row configuration interface so that the user configures the target report based on the row configuration items on the row configuration interface.
S130, receiving row configuration information input by a user based on at least one row configuration item, and determining column configuration information according to the row configuration information.
The row configuration information may be configuration information input in the row configuration item, and may also be understood as specific content to be configured in the target report. One row configuration item may configure one row configuration information. The input mode of the row configuration information may be a keyboard input mode, a mouse click mode, and the like. The column configuration information may be understood as logic configuration information of a column corresponding to the row configuration information. The configuration mode of configuring the column configuration information may be to configure the column configuration information through a row configuration interface.
Specifically, column configuration information corresponding to the row configuration information is preset. And receiving row configuration information input in row configuration items displayed on a row configuration interface by a user, and determining the row configuration information of the target report when detecting that the row configuration information corresponding to the row configuration items is configured. And determining a row configuration interface corresponding to the column configuration information according to the column configuration information corresponding to the preset row configuration information. And displaying the row configuration interface corresponding to the column configuration information according to the row configuration interface corresponding to the column configuration information. And receiving column configuration information input by a user when detecting that the row configuration information in the row configuration item in the row configuration interface corresponding to the column configuration information is input.
S140, generating the target report based on the row configuration information and the column configuration information.
Specifically, when it is detected that the configuration of the column configuration information is completed, or when it is detected that a control for generating the target report is triggered, or when an instruction for generating the target report is received, the target report is generated according to the configuration information of the row configuration information and the column configuration information.
According to the technical scheme of the embodiment of the invention, the creation instruction for creating the target report form is received by the user input. And in response to the creating instruction, displaying at least one row configuration interface, wherein the row configuration interface is used for displaying at least one row configuration item of the target report. Receiving row configuration information input by a user based on at least one row configuration item, and determining column configuration information according to the row configuration information. According to the embodiment of the invention, the row configuration information and the column configuration information are configured through the row configuration items in the row configuration interface, so that the advantage of processing is that a user can configure the rows and the columns of the target report according to the requirement of the user. The target report is generated based on the row configuration information and the column configuration information, the problems that labor cost is high and report generation is inflexible when data is generated into the report in a manual mode are solved, flexibility of report generation is improved, efficiency of report generation is improved, and therefore the effect of various report generation requirements is met.
Example two
Fig. 2 is a schematic flow chart of a report generating method provided in the second embodiment of the present invention, where on the basis of various optional technical solutions in the second embodiment of the present invention, optionally, the displaying at least one line configuration interface in response to the creation instruction includes: in response to the creating instruction, presenting a row name configuration interface, wherein the row name configuration interface comprises at least one row name configuration item; receiving the row name of the target report form input by the user based on the row name configuration item; when a new-built instruction input by the user based on a row name configuration interface is received, displaying a row item configuration interface corresponding to the row name, wherein the row item configuration interface is used for displaying at least one type of row item configuration items of the target report, and the row item configuration items are determined according to the row name; the receiving of the row configuration information input by the user based on at least one row configuration item comprises: and receiving row configuration information input by a user based on at least one row item configuration item.
The technical terms that are the same as or corresponding to the above embodiments are not repeated herein.
As shown in fig. 2, the method of the embodiment may specifically include:
s210, receiving a creation instruction for creating the target report input by the user.
S220, responding to the creating instruction, and displaying a line name configuration interface, wherein the line name configuration interface comprises at least one line name configuration item.
The line name configuration interface can be used for showing an interface for configuring the name of the target report. The interface elements of the line name configuration interface can include an input box of a line name, an interface control of line name configuration, a text box corresponding to a line name title, and a control corresponding to a preset storage path of the target report. The row name configuration item may be used to configure a report name for the target report. The input mode of the row name configuration item can be that the report name of the target report is input in a row name input box on the row name configuration interface.
Specifically, the corresponding relationship between the instruction and the interface is preset. And when a creation instruction is received, displaying a line name configuration interface according to a preset corresponding relation between the instruction and the interface. And determining the interface layout of the row name configuration interface based on the preset interface layout, and displaying the row name configuration interface containing the row name configuration item so that the user inputs the report name of the target report in the row name configuration item of the row name configuration interface.
S230, receiving the row name of the target report, which is input by the user based on the row name configuration item.
Wherein, the line name of the target report can be understood as the report name of the target report, such as XX report.
Specifically, when it is detected that the input of the row name of the target report by the row name configuration item in the row name configuration interface is completed, or when it is detected that the user triggers the control for receiving the row name of the target report, or when an instruction for receiving the row name of the target report is received, the report name of the target report input by the user is received.
S240, when a new-built instruction input by the user based on the line name configuration interface is received, displaying a line item configuration interface corresponding to the line name, wherein the line item configuration interface is used for displaying at least one type of line item configuration items of the target report, and the line item configuration items are determined according to the line name.
Wherein, the new command can be understood as a command for creating a target report file. In this embodiment, there may be a variety of ways to generate a new instruction, and as an optional implementation manner of the embodiment of the present invention, the way to generate the new instruction may be to generate the new instruction when it is detected that a user triggers a control for creating a new target report file. As another optional implementation manner in the embodiment of the present invention, the manner of generating the new instruction may be that the new instruction is generated when it is detected that the report name of the target report is input completely. As a further optional implementation manner in the embodiment of the present invention, the new creation instruction is generated when it is detected that a preset new creation key of the keyboard is triggered, for example, the new creation instruction is generated when it is detected that an Enter key is triggered.
In the embodiment of the invention, the line name of the target report can correspond to the report type of the target report. Further, each report type may correspond to a row item configuration item of a row name configuration interface. In other words, the row configuration interface to be presented may be determined based on the row name entered by the user.
The row item configuration interface can be understood as an interface for configuring the row information and the column information of the target report. The line item configuration items may be used to configure information of the target report. The row item configuration interface may present one, two, or more than two types of row item configuration items.
Specifically, the corresponding relationship between the instruction and the display interface is preset. When detecting that a user triggers a control for newly building a target report file, or when detecting that the report name input of the target report is completed, or when detecting that a preset new building key of a keyboard is triggered, generating a new building instruction. When the new command is received by the line name configuration interface, displaying a line item configuration interface corresponding to the line name according to a preset corresponding relationship between the command and the display interface, namely, displaying the line item configuration interface corresponding to the report name of the target report, so as to display the line item configuration item on the line item configuration interface corresponding to the report name of the target report, so that the line item configuration item on the line item configuration interface is used for configuring the information of the line and the column of the target report.
S250, receiving row configuration information input by a user based on at least one row item configuration item, and determining column configuration information according to the row configuration information.
S260, generating the target report based on the row configuration information and the column configuration information.
According to the technical scheme of the embodiment, the line name configuration interface is displayed by responding to the creation instruction, wherein the line name configuration interface comprises at least one line name configuration item. And receiving the row name of the target report input by the user based on the row name configuration item. When a new-built instruction input by a user based on the row name configuration interface is received, the row item configuration interface corresponding to the row name is displayed, wherein the row item configuration interface is used for displaying at least one type of row item configuration items of the target report, and the row item configuration items are determined according to the row name, so that the report generation efficiency is improved, and the report information configuration flexibility is improved.
EXAMPLE III
Fig. 3 is a schematic flow chart of a report generating method according to a third embodiment of the present invention, where on the basis of the foregoing embodiment, optionally, the row configuration information includes at least one row configuration category and at least one row configuration logic; the determining column configuration information according to the row configuration information includes: and determining column configuration information according to the at least one row configuration category and the row configuration logic corresponding to the row configuration category.
The technical terms that are the same as or corresponding to the above embodiments are not repeated herein.
As shown in fig. 3, the method of the present embodiment may specifically include:
s310, receiving a creation instruction for creating the target report input by the user.
Wherein the target report may include a tax report.
Specifically, the operation of an application program for creating the tax statement is triggered by a preset user. And determining whether the user triggers the application program for creating the target report form tax statement or not according to the preset operation that the user triggers the application program for creating the tax statement. And when detecting that the user triggers the application program for creating the tax statement, generating a creating instruction for creating the tax statement. An instruction receiving module of the report generation system receives a creation instruction for creating the tax report so as to create the tax report.
S320, responding to the creating instruction, and displaying a line name configuration interface, wherein the line name configuration interface comprises at least one line name configuration item.
S330, receiving the row name of the target report form input by the user based on the row name configuration item.
S340, when a new-built instruction input by the user based on the row name configuration interface is received, displaying a row item configuration interface corresponding to the row name, wherein the row item configuration interface is used for displaying at least one type of row item configuration items of the target report, and the row item configuration items are determined according to the row name.
S350, receiving row configuration information input by a user based on at least one row item configuration item, wherein the row configuration information comprises at least one row configuration category and at least one row configuration logic.
The row configuration information may be understood as row configuration content input by the row configuration item, and may be row information of the tax statement. The row configuration category may be understood as a kind of row configuration information. The row configuration category may be used to set the names of the cells in the tax statement and the attributes corresponding to the cell names, where the number of the attributes corresponding to the cell names may be one, two, or more than two. The row configuration logic may be understood as the configuration logic of any cell in the tax statement. The kind of row configuration logic may be one or more. In this embodiment, the row configuration logic includes account allocation and/or calculation. The relationship between the row configuration category and the row configuration logic may be a one-to-one correspondence.
Specifically, when the tax statement file is completely built, or when a tax statement file new building instruction is received, the line configuration information input by the user based on the line item configuration item is received, that is, the line configuration category and the line configuration logic input by the user based on the line item configuration item are received.
S360, determining column configuration information according to the at least one row configuration category and the row configuration logic corresponding to the row configuration category.
The column configuration information can be understood as information of each column of cells in the tax statement.
Specifically, a row item configuration interface corresponding to the row configuration logic is preset. And when detecting that the control corresponding to the row configuration logic corresponding to the row configuration category in the row item configuration interface is triggered, displaying the row item configuration interface corresponding to the row configuration logic corresponding to the row configuration category. When the input of the configuration information in the configuration items of the row item configuration interface is detected to be completed, that is, when the input of the column configuration information corresponding to the row configuration category is detected to be completed, the column configuration information with completed configuration is received.
Taking the target report as a result table as an example, the row configuration categories are subject 1, subject 2, and total result, and correspondingly, the column configuration logic corresponding to subject 1 is account allocation, that is, the result corresponding to subject 1 and the column configuration logic corresponding to subject 2 are account allocation, that is, the result corresponding to subject 2 and the column configuration logic corresponding to total result are calculation, that is, the sum of the results obtained by adding subject 1 and subject 2.
S370, generating the target report based on the row configuration information and the column configuration information.
According to the technical scheme of the embodiment, the row configuration information input by the user based on the at least one row item configuration item is received, and the row configuration information comprises at least one row configuration category and at least one row configuration logic. Column configuration information is determined according to at least one row configuration category and row configuration logic corresponding to the row configuration category, and the effect of improving flexible configuration of columns of the report is achieved.
Example four
Fig. 4 is a schematic flow chart of a report generating method according to a fourth embodiment of the present invention, where on the basis of the foregoing embodiment, optionally, the determining column configuration information according to the at least one row configuration category and the row configuration logic corresponding to the row configuration category includes: receiving a triggering operation of the user for carrying out logic configuration on a row configuration category, and displaying a row logic configuration interface corresponding to the row configuration logic, wherein the row logic configuration interface comprises at least one row logic configuration item; receiving row logic configuration information input by the user based on the row logic configuration item, and determining column configuration information based on the row logic configuration information.
The technical terms that are the same as or corresponding to the above embodiments are not repeated herein.
As shown in fig. 4, the method of this embodiment may specifically include:
s410, receiving a creation instruction for creating the target report input by the user.
Wherein the target report comprises a tax report.
S420, responding to the creating instruction, and displaying a line name configuration interface, wherein the line name configuration interface comprises at least one line name configuration item.
S430, receiving the row name of the target report form input by the user based on the row name configuration item.
S440, when a new-built instruction input by the user based on the row name configuration interface is received, displaying a row item configuration interface corresponding to the row name, wherein the row item configuration interface is used for displaying at least one type of row item configuration items of the target report, and the row item configuration items are determined according to the row name.
S450, receiving row configuration information input by a user based on at least one row item configuration item, wherein the row configuration information comprises at least one row configuration category and at least one row configuration logic.
And S460, receiving a trigger operation of the user for carrying out logic configuration on the row configuration category, and displaying a row logic configuration interface corresponding to the row configuration logic, wherein the row logic configuration interface comprises at least one row logic configuration item.
The trigger operation may include the following trigger operations: single click or double click of mouse and keyboard key. The row logic configuration item may be used to input an attribute corresponding to a column of the tax statement, e.g., the attribute corresponding to the column of the tax statement may be a data range of the column of the tax statement. The number of the row logic configuration items of the logic configuration corresponding to one row configuration category can be one, two or more.
Specifically, a trigger operation for a user to perform logic configuration on the row configuration category is preset. And generating a logic configuration instruction when detecting that a preset trigger operation is triggered. And when a logic configuration instruction is received, displaying a row configuration interface corresponding to the configuration logic so that a user configures the column information of the tax statement based on the logic configuration item of the row configuration interface.
S470, receiving row logic configuration information input by the user based on the row logic configuration item, and determining column configuration information based on the row logic configuration information.
Wherein, the row logic configuration information can be column logic configuration information of the tax statement. The kinds of the configuration information of the row logic may be one kind, two kinds, or more than two kinds. The configuration information of the row logic may include a range of data to configure each column of the tax statement and a calculation between at least two columns to configure the tax statement, where the calculation between at least two columns of the tax statement may be any combination of addition, subtraction, multiplication, and division.
Specifically, when it is detected that the user inputs row logic configuration information based on a logic configuration item of the row configuration interface, or when it is detected that the user triggers a control corresponding to the completion of the configuration of the row logic configuration information, a row logic configuration information configuration instruction is generated. And when a row logic configuration information configuration instruction is received, determining the row logic configuration information input by the user based on the row logic configuration item. When the row logic configuration information configuration is completed, that is, the column configuration information configuration is completed.
Optionally, the determining column configuration information based on the row logic configuration information includes: determining configuration data of the row configuration item based on the row logic configuration information, and determining column configuration information based on the configuration data.
The source of the configuration data may be data stored in data tables in the database, where the number of the data tables is not limited. The configuration data may be data in one data table or data in a plurality of data tables. It should be noted that, in this embodiment, a data source of the configuration data is not limited as long as the configuration data that needs to be acquired.
Specifically, when a row logic configuration information configuration instruction is received, the row logic configuration information input by the user based on the row logic configuration item is determined. And determining column configuration information according to configuration data in the row logic configuration information.
On this basis, optionally, the determining the configuration data of the row configuration item based on the row logic configuration information includes: responding to the received triggering operation for configuring the row configuration item input by the user, and displaying a data configuration interface, wherein the data configuration interface is used for displaying at least one data configuration item; and receiving configuration data corresponding to the row logic configuration information input by the user based on at least one data configuration item, and configuring the row logic configuration item of the row logic configuration interface based on the configuration data.
The data configuration interface can comprise data configuration items and interface controls. Wherein, the data configuration items can be one, two or more than two. Interface controls may include a determine control, a cancel control, a clear control, and a help control, among others. The data configuration item may configure the data range of each column of the tax statement.
Specifically, a trigger operation for configuring a row configuration item is preset, and when it is detected that the trigger operation for configuring the row configuration item is triggered, the received trigger operation for configuring the row configuration item is input by a user. And displaying a data configuration interface according to the triggering operation input by the user and used for configuring the row configuration item. And when the data configuration item input of the data configuration interface is detected to be completed, generating an instruction for receiving configuration data. And when an instruction for receiving the data configuration item is received, receiving configuration data which is input by a user based on the data configuration item and corresponds to the row logic configuration information, and configuring the row logic configuration item of the row logic configuration interface according to the configuration data, so as to configure the column configuration information of the target report.
S480, generating the target report based on the row configuration information and the column configuration information.
According to the technical scheme of the embodiment, a row logic configuration interface corresponding to row configuration logic is displayed by receiving a trigger operation of a user for carrying out logic configuration on a row configuration category, wherein the row logic configuration interface comprises at least one row logic configuration item. And receiving row logic configuration information input by a user based on the row logic configuration item, and determining column configuration information based on the row logic configuration information, so that the effect of flexible configuration of the column configuration information of the target report is achieved.
EXAMPLE five
The fifth embodiment of the invention provides a preferable example of the report generation method. In this embodiment, taking the tax statement as an example, when the user triggers the application program of the tax statement, a row configuration interface is displayed, for example, a report creation interface (shown in fig. 5) is displayed, and the report creation interface may include a row configuration item of a report name, a new button control, a clear button control, and a search button control. The user may enter a report name, such as a tax statement, in the row configuration item of the report name. When the user clicks the new control button, a row item configuration interface is displayed, for example, a general ledger report relationship maintenance interface (shown in fig. 6), and row item configuration items in the interface include a report number, a report name, a configuration item of a project major class, and a configuration item of a project minor class.
The configuration items of the project major category may be used to configure the types of the tax statistical reports, and it should be noted that the types of the reports may be national tax, local tax, and total. The configuration items of the project subclass can be report line information configuration items in a report type based on the configuration items of the project subclass.
Taking the row configuration information in the row item configuration items in the project major category as the national tax as an example, the row configuration information in the configuration items in the project minor category comprises: the serial number is A1, the name is tax-receivable sales, and the type is allocated to the account; the serial number is A2, the name is value-added tax, and the type is account allocation; serial number A3, name value added tax rate, type calculation, etc.
When the serial number is A1, the name is tax-receivable sales, and the type is account allocation, for example, in the general ledger sheet relationship maintenance interface, the configuration information with the serial number of A1, the name is tax-receivable sales, and the type is account allocation is selected, and the account allocation button control is clicked. Upon detecting that the account assignment button control is triggered, an account assignment-relationship maintenance interface (as shown in FIG. 7) is presented.
Based on the account allocation-relationship maintenance interface, selecting the row configuration item as a symbol, taking the symbol as "+", for example, when "+" is selected, displaying the account information configuration interface (as shown in fig. 8), and inputting information such as the lower limit and the upper limit of the classification item, the company, the cost center, the subject and the like into the row configuration item in the account information configuration interface. And when a determination button in the account information configuration interface is triggered, displaying configuration completion row configuration information in the account allocation-relation maintenance interface.
When the serial number is A3, the name is the value-added tax rate, and the type is used as an example for calculation, the configuration information with the serial number of A3, the name is the value-added tax rate, and the type is used as calculation is selected in the general ledger sheet relation maintenance interface, and a calculation button control is clicked. Upon detecting that the calculate button control is triggered, a calculate-relationship maintenance interface (as shown in FIG. 9) is presented.
And maintaining the configuration information of the row number, the calculation symbol corresponding to the row number, the lower limit of the serial number and the upper limit of the serial number in the row logic configuration item in the interface based on the calculation-relation. When the configuration information configuration in the calculation-relationship maintenance interface is completed, the configuration information configuration in the column logic configuration item of the tax statistical report form is completed.
When the configuration of the row configuration information and the column configuration information is completed, a generation instruction for generating the tax statement may be triggered to generate the tax statistical statement based on the row configuration information and the column configuration information.
According to the technical scheme, the row information and the column information of the report are configured, so that the tax report is generated, the flexibility of report generation is improved, the efficiency of report generation is improved, and the effect of meeting the requirements of various report generation is achieved.
EXAMPLE six
Fig. 10 is a schematic diagram of a module of a report generating apparatus according to a sixth embodiment of the present invention, where the present invention provides a report generating apparatus, including:
a creating instruction receiving module 510, configured to receive a creating instruction input by a user for creating a target report.
A row configuration item presentation module 520, configured to present at least one row configuration interface in response to the creation instruction, where the row configuration interface is configured to present at least one row configuration item of the target report.
A column configuration information determining module 530, configured to receive row configuration information input by a user based on at least one row configuration item, and determine column configuration information according to the row configuration information.
A target report generating module 540, configured to generate the target report based on the row configuration information and the column configuration information.
According to the technical scheme of the embodiment of the invention, the creation instruction input by a user for creating the target report is received through the creation instruction receiving module. And responding to the creating instruction through a row configuration item showing module, and showing at least one row configuration interface, wherein the row configuration interface is used for showing at least one row configuration item of the target report. Receiving row configuration information input by a user based on at least one row configuration item through a column configuration information determination module, and determining column configuration information according to the row configuration information. According to the embodiment of the invention, the row configuration information and the column configuration information are configured through the row configuration items in the row configuration interface, so that the advantage of processing is that a user can configure the rows and the columns of the target report according to the requirement of the user. The target report is generated by the target report generation module based on the row configuration information and the column configuration information, so that the problems of high labor cost and inflexible report generation when data is generated into a report in a manual mode are solved, the flexibility of report generation is improved, the efficiency of report generation is improved, and the effect of meeting the requirements of various report generation is met.
Optionally, the line configuration item presentation module 520 is configured to present a line name configuration interface in response to the creation instruction, where the name configuration interface includes at least one line name configuration item; receiving the row name of the target report form input by the user based on the row name configuration item; when a new-built instruction input by the user based on a row name configuration interface is received, displaying a row item configuration interface corresponding to the row name, wherein the row item configuration interface is used for displaying at least one type of row item configuration items of the target report, and the row item configuration items are determined according to the row name; the receiving of the row configuration information input by the user based on at least one row configuration item comprises: and receiving row configuration information input by a user based on at least one row item configuration item.
Optionally, the row configuration information includes at least one row configuration category and at least one row configuration logic, and the column configuration information determining module 530 is configured to determine column configuration information according to the row configuration information, and includes: and determining column configuration information according to the at least one row configuration category and the row configuration logic corresponding to the row configuration category.
Optionally, the column configuration information determining module 530 is configured to receive a trigger operation of the user for performing logic configuration on a row configuration category, and display a row logic configuration interface corresponding to the row configuration logic, where the row logic configuration interface includes at least one row logic configuration item; receiving row logic configuration information input by the user based on the row logic configuration item, and determining column configuration information based on the row logic configuration information.
Optionally, the column configuration information determining module 530 is configured to determine configuration data of the row configuration item based on the row logic configuration information, and determine column configuration information based on the configuration data.
Optionally, the column configuration information determining module 530 is configured to display a data configuration interface in response to the received user input triggering operation for configuring the row configuration item, where the data configuration interface is configured to display at least one data configuration item; and receiving configuration data corresponding to the row logic configuration information input by the user based on at least one data configuration item, and configuring the row logic configuration item of the row logic configuration interface based on the configuration data.
Optionally, the target statement includes a tax statement, and the line configuration logic includes account allocation and/or calculation.
The device can execute the report generation method provided by any embodiment of the invention, and has the corresponding functional modules and beneficial effects of executing the report generation method.
It should be noted that, the units and modules included in the apparatus are merely divided according to functional logic, but are not limited to the above division as long as the corresponding functions can be implemented; in addition, specific names of the functional units are only for convenience of distinguishing from each other, and are not used for limiting the protection scope of the embodiment of the invention.
EXAMPLE seven
Fig. 11 is a schematic structural diagram of an electronic device according to a seventh embodiment of the present invention. FIG. 11 illustrates a block diagram of an exemplary electronic device 12 suitable for use in implementing any of the embodiments of the present invention. The electronic device 12 shown in fig. 11 is only an example, and should not bring any limitation to the functions and the scope of use of the embodiment of the present invention. The device 12 is typically an electronic device that undertakes the processing of configuration information.
As shown in fig. 11, electronic device 12 is embodied in the form of a general purpose computing device. The components of electronic device 12 may include, but are not limited to: one or more processors or processing units 16, a memory 28, and a bus 18 that couples the various components (including the memory 28 and the processing unit 16).
Bus 18 represents one or more of any of several types of bus structures, including a memory bus or memory controller, a peripheral bus, an accelerated graphics port, and a processor or local bus using any of a variety of bus architectures. By way of example, such architectures include, but are not limited to, an Industry Standard Architecture (ISA) bus, a Micro Channel Architecture (MCA) bus, an enhanced ISA bus, a Video Electronics Standards Association (VESA) local bus, and a Peripheral Component Interconnect (PCI) bus.
Electronic device 12 typically includes a variety of computer-readable media. Such media may be any available media that is accessible by electronic device 12 and includes both volatile and nonvolatile media, removable and non-removable media.
Memory 28 may include computer device readable media in the form of volatile Memory, such as Random Access Memory (RAM) 30 and/or cache Memory 32. The electronic device 12 may further include other removable/non-removable, volatile/nonvolatile computer storage media. By way of example only, storage system 34 may be used to read from and write to non-removable, nonvolatile magnetic media (not shown in FIG. 11, and commonly referred to as a "hard drive"). Although not shown in FIG. 11, a magnetic disk drive for reading from and writing to a removable, nonvolatile magnetic disk (e.g., a "floppy disk") and an optical disk drive for reading from or writing to a removable, nonvolatile optical disk (e.g., a Compact disk-Read Only Memory (CD-ROM), a Digital Video disk (DVD-ROM), or other optical media) may be provided. In these cases, each drive may be connected to bus 18 by one or more data media interfaces. Memory 28 may include at least one program product 40, with program product 40 having a set of program modules 42 configured to carry out the functions of embodiments of the invention. Program product 40 may be stored, for example, in memory 28, and such program modules 42 include, but are not limited to, one or more application programs, other program modules, and program data, each of which examples or some combination may comprise an implementation of a network environment. Program modules 42 generally carry out the functions and/or methodologies of the described embodiments of the invention.
Electronic device 12 may also communicate with one or more external devices 14 (e.g., keyboard, mouse, camera, etc., and display), one or more devices that enable a user to interact with electronic device 12, and/or any devices (e.g., network card, modem, etc.) that enable electronic device 12 to communicate with one or more other computing devices. Such communication may be through an input/output (I/O) interface 22. Also, the electronic device 12 may communicate with one or more networks (e.g., a Local Area Network (LAN), Wide Area Network (WAN), and/or a public Network such as the internet) via the Network adapter 20. As shown, the network adapter 20 communicates with other modules of the electronic device 12 via the bus 18. It should be understood that although not shown in the figures, other hardware and/or software modules may be used in conjunction with electronic device 12, including but not limited to: microcode, device drivers, Redundant processing units, external disk drive Arrays, disk array (RAID) devices, tape drives, and data backup storage devices, to name a few.
The processor 16 executes various functional applications and data processing by running programs stored in the memory 28, for example, implementing the report generation method provided by the above-described embodiment of the present invention.
Of course, those skilled in the art can understand that the processor can also implement the technical solution of the report generation method provided in any embodiment of the present invention.
Example eight
The eighth embodiment of the present invention further provides a storage medium containing computer-executable instructions, which are used for executing the report generation method when executed by a computer processor.
The method comprises the following steps:
receiving a creation instruction input by a user for creating a target report;
responding to the creating instruction, and displaying at least one row configuration interface, wherein the row configuration interface is used for displaying at least one row configuration item of the target report;
receiving row configuration information input by a user based on at least one row configuration item, and determining column configuration information according to the row configuration information;
and generating the target report based on the row configuration information and the column configuration information.
Computer storage media for embodiments of the invention may employ any combination of one or more computer-readable media. The computer readable medium may be a computer readable signal medium or a computer readable storage medium. A computer readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples (a non-exhaustive list) of the computer readable storage medium would include the following: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the context of this document, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device.
A computer readable signal medium may include a propagated data signal with computer readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device.
Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.
Computer program code for carrying out operations for embodiments of the present invention may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, Smalltalk, C + + or the like and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any type of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or the connection may be made to an external computer (for example, through the Internet using an Internet service provider).
It is to be noted that the foregoing is only illustrative of the preferred embodiments of the present invention and the technical principles employed. It will be understood by those skilled in the art that the present invention is not limited to the particular embodiments described herein, but is capable of various obvious changes, rearrangements and substitutions as will now become apparent to those skilled in the art without departing from the scope of the invention. Therefore, although the present invention has been described in greater detail by the above embodiments, the present invention is not limited to the above embodiments, and may include other equivalent embodiments without departing from the spirit of the present invention, and the scope of the present invention is determined by the scope of the appended claims.

Claims (10)

1. A report generation method is characterized by comprising the following steps:
receiving a creation instruction input by a user for creating a target report;
responding to the creating instruction, and displaying at least one row configuration interface, wherein the row configuration interface is used for displaying at least one row configuration item of the target report;
receiving row configuration information input by a user based on at least one row configuration item, and determining column configuration information according to the row configuration information;
and generating the target report based on the row configuration information and the column configuration information.
2. The method of claim 1, wherein said exposing at least one row configuration interface in response to said create instruction comprises:
in response to the creating instruction, presenting a row name configuration interface, wherein the row name configuration interface comprises at least one row name configuration item;
receiving the row name of the target report form input by the user based on the row name configuration item;
when a new-built instruction input by the user based on a row name configuration interface is received, displaying a row item configuration interface corresponding to the row name, wherein the row item configuration interface is used for displaying at least one type of row item configuration items of the target report, and the row item configuration items are determined according to the row name;
the receiving of the row configuration information input by the user based on at least one row configuration item comprises:
and receiving row configuration information input by a user based on at least one row item configuration item.
3. The method of claim 2, wherein the row configuration information comprises at least one row configuration category and at least one row configuration logic;
the determining column configuration information according to the row configuration information includes:
and determining column configuration information according to the at least one row configuration category and the row configuration logic corresponding to the row configuration category.
4. The method of claim 3, wherein determining column configuration information according to the at least one row configuration category and the row configuration logic corresponding to the row configuration category comprises:
receiving a triggering operation of the user for carrying out logic configuration on a row configuration category, and displaying a row logic configuration interface corresponding to the row configuration logic, wherein the row logic configuration interface comprises at least one row logic configuration item;
receiving row logic configuration information input by the user based on the row logic configuration item, and determining column configuration information based on the row logic configuration information.
5. The method of claim 4, wherein determining column configuration information based on the row logic configuration information comprises:
determining configuration data of the row configuration item based on the row logic configuration information, and determining column configuration information based on the configuration data.
6. The method of claim 5, wherein determining the configuration data of the row configuration item based on the row logic configuration information comprises:
responding to the received triggering operation for configuring the row configuration item input by the user, and displaying a data configuration interface, wherein the data configuration interface is used for displaying at least one data configuration item;
and receiving configuration data corresponding to the row logic configuration information input by the user based on at least one data configuration item, and configuring the row logic configuration item of the row logic configuration interface based on the configuration data.
7. The method of claim 3, wherein the target statement comprises a tax statement and the line configuration logic comprises account allocation and/or calculation.
8. A report generation apparatus, comprising:
the system comprises a creation instruction receiving module, a report form creating module and a report form creating module, wherein the creation instruction receiving module is used for receiving a creation instruction which is input by a user and used for creating a target report form;
the row configuration item display module is used for responding to the creating instruction and displaying at least one row configuration interface, wherein the row configuration interface is used for displaying at least one row configuration item of the target report;
the column configuration information determining module is used for receiving row configuration information input by a user based on at least one row configuration item and determining column configuration information according to the row configuration information;
and the target report generation module is used for generating the target report based on the row configuration information and the column configuration information.
9. An electronic device, characterized in that the electronic device comprises:
one or more processors;
a storage device for storing one or more programs,
when executed by the processor, cause the processor to implement the report generating method according to any of claims 1-7.
10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the report generating method according to any one of claims 1-7.
CN202110185067.7A 2021-02-10 2021-02-10 Report generation method and device, electronic equipment and storage medium Withdrawn CN112783582A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202110185067.7A CN112783582A (en) 2021-02-10 2021-02-10 Report generation method and device, electronic equipment and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202110185067.7A CN112783582A (en) 2021-02-10 2021-02-10 Report generation method and device, electronic equipment and storage medium

Publications (1)

Publication Number Publication Date
CN112783582A true CN112783582A (en) 2021-05-11

Family

ID=75761550

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202110185067.7A Withdrawn CN112783582A (en) 2021-02-10 2021-02-10 Report generation method and device, electronic equipment and storage medium

Country Status (1)

Country Link
CN (1) CN112783582A (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113792138A (en) * 2021-09-14 2021-12-14 广东电网有限责任公司 Report generation method and device, electronic equipment and storage medium
CN114443118A (en) * 2021-12-02 2022-05-06 北京快乐茄信息技术有限公司 Sample table modification method and device, electronic equipment and storage medium

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113792138A (en) * 2021-09-14 2021-12-14 广东电网有限责任公司 Report generation method and device, electronic equipment and storage medium
CN113792138B (en) * 2021-09-14 2024-04-30 广东电网有限责任公司 Report generation method and device, electronic equipment and storage medium
CN114443118A (en) * 2021-12-02 2022-05-06 北京快乐茄信息技术有限公司 Sample table modification method and device, electronic equipment and storage medium

Similar Documents

Publication Publication Date Title
CN109697066B (en) Method and system for realizing data sheet splicing and automatically training machine learning model
US11238099B2 (en) Method and device for obtaining answer, and computer device
CN107608747B (en) Form system construction method and device, electronic equipment and storage medium
CN110750654A (en) Knowledge graph acquisition method, device, equipment and medium
WO2020124933A1 (en) Comment information processing method and apparatus, and storage medium and electronic device
US20100121888A1 (en) Automatic designation of footnotes to fact data
CN111324609A (en) Knowledge graph construction method and device, electronic equipment and storage medium
CN112783582A (en) Report generation method and device, electronic equipment and storage medium
CN111813409A (en) Code generation method, device, equipment and storage medium of interactive interface
CN110990445A (en) Data processing method, device, equipment and medium
WO2021129074A1 (en) Method and system for processing reference of variable in program code
CN103677806A (en) Method and system for managing a system
CN112214155B (en) View information playing method, device, equipment and storage medium
JP2022077969A (en) Data processing method and apparatus, electronic device, and storage medium
CN112000911A (en) Page management method and device, electronic equipment and storage medium
CN114003843A (en) Page generation method, device, equipment and storage medium
CN112799760B (en) Form rendering method and device
CN114356322A (en) Communication mapping method, device, equipment and storage medium for equipment configuration
US20080155480A1 (en) Methods and apparatus for generating workflow steps using gestures
CN113792138B (en) Report generation method and device, electronic equipment and storage medium
JP2018112919A (en) Test input information retrieval apparatus and method
CN113806556A (en) Method, device, equipment and medium for constructing knowledge graph based on power grid data
CN114298584A (en) Method, device and storage medium for configuring calculation strategy of hospital performance index
CN114201729A (en) Method, device and equipment for selecting matrix operation mode and storage medium
CN113138760A (en) Page generation method and device, electronic equipment and 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
WW01 Invention patent application withdrawn after publication

Application publication date: 20210511

WW01 Invention patent application withdrawn after publication