CN112861496A - Report generation display method and device, computer equipment and readable storage medium - Google Patents
Report generation display method and device, computer equipment and readable storage mediumDownload PDFInfo
- Publication number
- CN112861496A CN112861496ACN202110303843.9ACN202110303843ACN112861496ACN 112861496 ACN112861496 ACN 112861496ACN 202110303843 ACN202110303843 ACN 202110303843ACN 112861496 ACN112861496 ACN 112861496A
- Authority
- CN
- China
- Prior art keywords
- report
- data
- data source
- style
- target
- 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.)
- Granted
Links
Images
Classifications
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Translated fromChinese
Description
Technical Field
The present application relates to the field of big data technologies, and in particular, to a report generation display method, apparatus, computer device, and readable storage medium.
Background
In the informatization process, more and more enterprises are applied, the business data volume of various businesses is larger and larger, and the enterprise data is a huge wealth of companies. The enterprise data is generated into a business report, and the business analysis and the business control are carried out, so that the effective application of the enterprise data can be realized.
In a traditional manner, a general Enterprise has multiple business systems, such as a Customer Relationship Management (CRM) system, an Enterprise Resource Planning (ERP) system, and Office Automation (OA), each system operates in a closed and independent manner, business data is dispersed in different systems, a user needs to enter different systems to query when querying data through a web end, and application difficulty of the business data is very high, so that processing efficiency is low when generating a business report based on the business data.
Disclosure of Invention
Based on this, it is necessary to provide a report generation display method, an apparatus, a computer device and a readable storage medium, which can improve the processing efficiency of a business report at a web end, in order to solve the above technical problems.
A report generation display method comprises the following steps:
receiving a report generation request, wherein the report generation request carries a service identifier of a service corresponding to a report to be generated and a report generation requirement;
acquiring a data source corresponding to the service based on the service identifier, and configuring the acquired data source to obtain a configured data source;
converting the configured data source based on the report generation requirement to obtain a data set corresponding to the report to be generated;
acquiring an initial report form style for displaying a data set;
and determining a target report form style from the initial report form styles based on the received report form style selection instruction, and displaying the data set through the target report form style.
In one embodiment, configuring the acquired data source to obtain a configured data source includes:
determining the version type of the data source according to the acquired data source;
determining a corresponding target drive according to the version type;
and acquiring data source connection information, and configuring the data source through the target driver based on the data source connection information to obtain the configured data source.
In one embodiment, determining the corresponding target driver according to the version type includes:
determining a target drive corresponding to the data source from the alternative drive list according to the version type;
the establishment mode of the alternative driving list comprises the following steps:
acquiring a drive file corresponding to the version type of the data source;
storing the drive file into a drive management directory, and analyzing the drive file in the drive management directory based on a preset analysis mode to obtain corresponding file information;
and adding a target drive corresponding to the data source in the initial alternative drive list according to the file information to obtain an alternative drive list.
In one embodiment, converting the configured data source to obtain a data set corresponding to the report to be generated includes:
acquiring corresponding query data and configuration data based on the configured data source;
verifying the configuration data and judging whether the configuration data has injection risks or not;
when the configuration data do not have injection risks, screening variable assigned value data from the query data, and replacing the corresponding to-be-replaced variable in the configuration data based on the variable assigned value data to obtain replaced configuration data;
acquiring configuration information of a data source, and generating a data source connection example based on the configuration information;
and converting the configured data source according to the connection example and the replaced configuration data to obtain a data set corresponding to the report to be generated.
In one embodiment, the report style selection instruction carries a style identifier of the selected target report style;
displaying the data set through the target report style, comprising:
determining a data display requirement corresponding to the target report form based on the form identifier;
processing the data set according to the data display requirement to obtain the abscissa, the ordinate and the data content of the corresponding data set;
and rendering the abscissa, the ordinate and the data content.
In one embodiment, the method further includes:
acquiring service updating data;
updating the data source based on the service updating data;
based on the report generation requirement, converting the configured data source to obtain a data set corresponding to the report to be generated, including:
converting the configured updated data source based on the report generation requirement to obtain an updated data set of the report to be generated;
displaying the data set through the target report style, comprising:
and displaying the updated data set through the target report style.
In one embodiment, the method further includes:
and according to the mode of the timing task, acquiring a report displaying the data set through the target report style, generating report prompt information and sending the report prompt information to the user terminal.
A report generating display apparatus, the apparatus comprising:
the report generation request receiving module is used for receiving a report generation request, wherein the report generation request carries the service identifier of the service corresponding to the report to be generated and the report generation requirement;
the data source acquisition and configuration module is used for acquiring a data source of a corresponding service based on the service identifier, and configuring the acquired data source to obtain a configured data source;
the data source conversion module is used for converting the configured data source based on the report generation requirement to obtain a data set corresponding to the report to be generated;
the initial report form style acquisition module is used for acquiring an initial report form style for displaying the data set;
and the display module is used for determining a target report form style from the initial report form style based on the received report form style selection instruction and displaying the data set through the target report form style.
A computer device comprising a memory storing a computer program and a processor implementing the steps of the method of any of the above embodiments when the computer program is executed.
A computer-readable storage medium, on which a computer program is stored which, when being executed by a processor, carries out the steps of the method of any of the above embodiments.
According to the report generation and display method, the report generation and display device, the computer equipment and the readable storage medium, a report generation request is received, the report generation request carries a service identifier of a service corresponding to a report to be generated and a report generation requirement, a data source corresponding to the service is obtained based on the service identifier, the obtained data source is configured to obtain a configured data source, then the configured data source is converted based on the report generation requirement to obtain a data set of the report to be generated, further, an initial report style for displaying the data set is determined, and the data set is displayed according to a target report style determined by a selection instruction based on a received selection instruction of the target report style in the initial report style. Therefore, according to the acquired service identification and the report generation requirement, the data source corresponding to the service can be acquired, the data source is configured, the corresponding data set is extracted, and the report is displayed according to the determined target style.
Drawings
FIG. 1 is a diagram illustrating an exemplary embodiment of a display method for generating reports;
FIG. 2 is a flowchart illustrating a report generation display method according to an embodiment;
FIG. 3 is a block diagram of a report generation display apparatus according to an embodiment;
FIG. 4 is a diagram illustrating an internal structure of a computer device according to an embodiment.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more apparent, the present application is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the present application and are not intended to limit the present application.
The report generation and display method provided by the application can be applied to the application environment shown in fig. 1. Wherein theterminal 102 communicates with theserver 104 via a network. The user can generate a report generation request through the terminal and send the report generation request to theserver 104, wherein the report generation request carries the service identifier of the service corresponding to the report to be generated and the report generation requirement. After receiving the report generation request, theserver 104 acquires a data source corresponding to the service based on the service identifier, and configures the acquired data source to obtain a configured data source. Then, theserver 104 may convert the configured data source based on the report generation requirement, so as to obtain a data set corresponding to the report to be generated. Further, theserver 104 may obtain an initial report style for displaying the data set, determine a target report style from the initial report style based on the received report style selection instruction, and display the data set by the target report style. The terminal 102 may be, but not limited to, various personal computers, notebook computers, smart phones, tablet computers, and portable wearable devices, and theserver 104 may be implemented by an independent server or a server cluster formed by a plurality of servers.
In an embodiment, as shown in fig. 2, a report generation display method is provided, which is described by taking the example that the method is applied to the server in fig. 1, and includes the following steps:
step S202, receiving a report generation request, wherein the report generation request carries a service identifier of a service corresponding to a report to be generated and a report generation requirement.
The report generation request refers to a request for generating a web-side report, and the report generation request carries a service identifier of a service corresponding to the report to be generated, such as a service name or a service ID.
In this embodiment, the business may be various businesses in the enterprise operation, such as a financial business, an attendance check business, or a workload statistics business. Those skilled in the art will appreciate that the illustration is merely for example, and in other embodiments, services may include more, and the application is not limited thereto.
The report generation requirement may include a specific report requirement, such as a monthly report, a quarterly report, or a daily report, or may further include a specific report content, such as an attendance report made only by a certain person or a certain department of the company, or a report of the absence of the employee of the company.
In this embodiment, a user may log in the web-side report generation and presentation system through a user name and a password, and then generate a report generation request by inputting or selecting a service identifier of a corresponding service, and send the report generation request to the server, so that the server performs subsequent processing.
And step S204, acquiring a data source corresponding to the service based on the service identifier, and configuring the acquired data source to obtain a configured data source.
The data source refers to original data corresponding to a service, and may include data content specific to a service, for example, attendance data corresponding to an attendance service, financial data corresponding to a financial service, and the like.
In this embodiment, the data sources may include data sources of various formats, which may include, but are not limited to mysql, oracle, sqlserver, h2, phoenix, mongodb, elastic search, presto, moonbox, cassandra, clickhouse, kylin, vertica, hana, impala, and so on.
In this embodiment, the server may perform query of the data source according to the service identifier carried in the acquired report generation request, and acquire the queried data source corresponding to the service identifier.
Further, the server may configure the obtained data source so that the obtained data source may be subsequently processed.
And step S206, converting the configured data source based on the report generation requirement to obtain a data set corresponding to the report to be generated.
The data set refers to original data used for generating a web-side business report.
In this embodiment, after the configuration of the data source is completed, the server may perform data analysis on the configured data source, and perform data conversion processing to extract data, i.e., a data set, used for generating a report from the configured data source.
Specifically, the server may process the configured data source according to the report generation requirement, so as to extract the corresponding data set.
Step S208, an initial report form style for displaying the data set is obtained.
The report style may be a style for report presentation, and may include, but is not limited to, a table, a pivot table, a tile flipper, a line graph, a bar graph, a scatter graph, a pie graph, a funnel graph, a radar graph, a morse graph, a map, a web page embedding, rich text, a fully custom configuration chart, and the like.
In this embodiment, after the server obtains the data set, the server may determine an initial report style that can be displayed on the data set according to the content of the data set, for example, for meteorological data, a more suitable initial report style may be determined to be a radar chart, and for data related to geography, the corresponding initial report style may be a map, a scatter diagram, or the like.
Step S210, based on the received report form style selection instruction, determining a target report form style from the initial report form style, and displaying the data set through the target report form style.
In this embodiment, the server may determine an initial report style for displaying the data set according to the extracted data set, and send the initial report style to the web terminal for display.
In the embodiment, the user can determine the target report style from the initial report style displayed on the web terminal through selection of the initial report style.
In the report generation and display method, a report generation request is received, the report generation request carries a service identifier of a service corresponding to a report to be generated and a report generation requirement, a data source corresponding to the service is acquired based on the service identifier, the acquired data source is configured to obtain a configured data source, the configured data source is converted based on the report generation requirement to obtain a data set of the report to be generated, further, an initial report style for displaying the data set is determined, and the data set is displayed according to a target report style determined by a selection instruction based on a received selection instruction of the target report style in the initial report style. Therefore, according to the acquired service identification and the report generation requirement, the data source corresponding to the service can be acquired, the data source is configured, the corresponding data set is extracted, and the report is displayed according to the determined target style.
In one embodiment, configuring the acquired data source to obtain a configured data source may include: determining the version type of the data source according to the acquired data source; determining a corresponding target drive according to the version type; and acquiring data source connection information, and configuring the data source through the target driver based on the data source connection information to obtain the configured data source.
In this embodiment, after the server acquires the data source, the server may parse the data source version of the acquired data source to determine the corresponding version type, for example, mysql, oracle, sqlserver, h2, phoenix, mongodb, elastic search, presto, moonbox, cassandra, clickhouse, kylin, vertica, hana, impala, and the like, as described above.
Further, the server may obtain a drive file of a corresponding version according to the obtained version type, and then establish a corresponding target drive and an alternative drive list according to the obtained drive file.
In this embodiment, the established target driver may be added to the driver candidate list and sent to the web terminal for presentation. And generating a drive selection instruction and sending the drive selection instruction to the server by selecting the target drive in the drive alternative list displayed by the web terminal by the user.
In this embodiment, after receiving the drive selection instruction, the server may obtain a pre-configured data source connection information empty table template, and send the pre-configured data source connection information empty table template to the web terminal, so as to collect data source connection information input in the data source connection information empty table template displayed by the web terminal by the user.
Further, the server may configure the data source through the target driver according to the acquired data source connection information, and complete connection configuration of the database.
In this embodiment, the data source connection information may further include tuning information, for example, the maximum connection number of the data source, the connection number of a single user, and the like.
In the above embodiment, the version type of the data source is determined according to the acquired data source, then the target driver corresponding to the data source is determined according to the version type, the connection information of the data source is further acquired, and the data source is configured through the target driver based on the connection information of the data source, so as to obtain the configured data source. Therefore, the data source of any service can be configured through the corresponding target driver, so that the configured data source can be used subsequently, and the report generation efficiency is improved.
In one embodiment, determining the corresponding target driver according to the version type may include: and determining the target drive of the corresponding data source from the alternative drive list according to the version type.
In this embodiment, the establishment manner of the alternative driving list may include: acquiring a drive file corresponding to the version type of the data source; storing the drive file into a drive management directory, and analyzing the drive file in the drive management directory based on a preset analysis mode to obtain corresponding file information; and adding a target drive corresponding to the data source in the initial alternative drive list according to the file information to obtain an alternative drive list.
In this embodiment, the server may obtain a driver file of a corresponding version according to the obtained version type, for example, for a mysql data source, the driver file corresponding to the mysql data source may be "mysql-connector-java-5.1.46. ja".
In this embodiment, after acquiring the drive file of the corresponding version, the server may copy the drive file to the fixed drive directory, for example, to the lib directory.
In this embodiment, the server may parse the drive file added to the fixed drive directory and generate file information corresponding to the drive file, such as a drive class file name and a physical address of the file.
Specifically, the server may obtain, in a file parsing manner, a drive class file name and a physical address of the file, that is, file information, included in the drive file. For example, the server may access an internal file using java's file handling class to achieve the purpose of parsing, and obtain file information of the driver file.
Further, the server may add the file information to the static object file, so as to add the target drive corresponding to the data source in the candidate drive list, for example, add the drive class file name and the physical address of the file to the static map object, to obtain the target drive added to the candidate drive list.
In one embodiment, converting the configured data source to obtain a data set corresponding to the report to be generated may include: acquiring corresponding query data and configuration data based on the configured data source; verifying the configuration data and judging whether the configuration data has injection risks or not; when the configuration data do not have injection risks, screening variable assigned value data from the query data, and replacing the corresponding to-be-replaced variable in the configuration data based on the variable assigned value data to obtain replaced configuration data; acquiring configuration information of a data source, and generating a data source connection example based on the configuration information; and converting the configured data source according to the connection example and the replaced configuration data to obtain a data set corresponding to the report to be generated.
In this embodiment, the server may obtain corresponding configuration data according to the configured data source, and send the configuration data to the web terminal. The user can input corresponding query variable parameters based on the configuration data displayed by the web terminal, generate query data and send the query data to the server.
In this embodiment, the configuration data may be an sql string, and the query data may be a variable information set.
Further, after the server acquires the query data and the configuration data, the configuration data can be checked to judge whether the configuration data has injection risks. For example, the server performs injection check on the sql string to avoid risk injection of the sql string, which may specifically be to remove an annotation statement in the sql string by using a regular expression, and then match whether the sql string includes risk operation instructions such as but not limited to create, drop, delete, insert, update, and truncate, so as to ensure that the sql statement only contains an instruction of a select-related query statement.
In this embodiment, when the server determines that the risk instruction exists in the configuration data, an error message is immediately generated and returned to the web terminal to prompt the user to modify the sql string again.
In this embodiment, after the server passes the verification, when there is no injection risk in the configuration data, the server may screen out variable assigned value data from the query data, and perform variable replacement on the configuration data according to the screened variable assigned value data.
Specifically, the variables corresponding to the variable assigned value data can be divided into a query variable and an authority variable, the query variable is a variable field, a specific value is assigned during actual query, data filtering and screening are performed on the configuration data, and the authority variable is a specific value assigned according to the user role of the current web report system login user, and data filtering and screening are performed on the configuration data. The difference between the two is that the query variable needs to be assigned or a default value is used for each query, all user values are the same, and the permission variable is that users in the same role have the same value.
In this embodiment, after obtaining the variable assigned value data, the server may replace the corresponding variable to be replaced in the configuration data to obtain the replaced configuration data, that is, assign the variable assigned value data to the configuration data, and generate the executable query script. For example, if an sql string "select from user where id $", where id $ is the value of the query variable and 1, then the sql string becomes "select from user where id? ","? "is a placeholder with a value of 1. The placeholder is used for avoiding the injection risk of the replaced value, and meanwhile, the hard analysis of the data SQL can be reduced, and the execution efficiency is improved.
Further, the server may obtain configuration information of the data source, that is, the aforementioned data source connection information, and generate a data source connection instance according to the data source connection information, so as to connect the data source.
Further, the server may perform data query on the configured data source according to the replaced configuration data, that is, the generated executable query script, and perform data conversion processing to generate a data set corresponding to the report to be generated.
In one embodiment, the report style selection instruction carries the style identification of the selected target report style.
In this embodiment, the displaying the data set through the target report style may include: determining a data display requirement corresponding to the target report form based on the form identifier; processing the data set according to the data display requirement to obtain the abscissa, the ordinate and the data content of the corresponding data set; and rendering the abscissa, the ordinate and the data content.
In this embodiment, the server may determine the selected target report form according to the report form identifier carried in the selection instruction, and obtain the data display requirement corresponding to the preset target report form.
In this embodiment, the resulting data set may include column names and specific data content. The server may process the data set according to the data display requirement corresponding to the target report style, and process the data set into data corresponding to the report style, for example, data corresponding to a form style or data corresponding to a map style.
In this embodiment, the server may process the post-data set according to the data presentation requirement, and the obtained data may include abscissa data, ordinate data, and specific data content.
Further, the server can perform data rendering on the processed abscissa, ordinate and data content, and then push the data content to the web end for displaying.
In this embodiment, corresponding to different report forms, the abscissa, the ordinate and the data content corresponding to the report forms are different, and the server may process the data set according to the corresponding data display requirement.
In the above embodiment, the data set is processed according to the corresponding data display requirement, so that the processed data can better meet the requirement of the corresponding report style, and the rendering display effect can be improved.
In one embodiment, the method may further include: acquiring service updating data; and updating the data source based on the service updating data.
In this embodiment, each service system is updated in real time, and the service is continuously added, deleted or changed. Each service system may generate service update data at preset time intervals, for example, one week or one month.
Further, the service system may send the generated service update data to the server, so that the server updates the data source according to the service update data.
In this embodiment, converting the configured data source based on the report generation requirement to obtain the data set corresponding to the report to be generated may include: and converting the configured updated data source based on the report generation requirement to obtain an updated data set of the report to be generated.
In this embodiment, the server may perform conversion processing on the updated data source based on the report generation requirement, so as to obtain an updated data set corresponding to the report to be generated.
In this embodiment, the displaying the data set through the target report style may include: and displaying the updated data set through the target report style.
Further, the server can display the updated data set according to the determined target report form style so as to realize the update display of the report form.
In this embodiment, when the data set has a great change, so that the specific data content has an order of magnitude change, for example, the previous data is "10", and the data is changed to 1000 due to the update of the data set, the server may adjust the displayed report by using the updated data set, for example, adjusting the order of magnitude relation of the ordinate, and the like.
In the embodiment, the data source is updated based on the service update data, and then the data set is updated, so that the dynamic update display of the service report can be realized, and the timeliness of the report content can be improved.
In one embodiment, the method may further include: and according to the mode of the timing task, acquiring a report displaying the data set through the target report style, generating report prompt information and sending the report prompt information to the user terminal.
In this embodiment, the server may configure a timing task, that is, obtain the report displayed by the target report rock in a timing task manner, generate corresponding report prompt information, for example, an email, and send the report prompt information to the user terminal, so as to prompt the user to view the corresponding report.
In this embodiment, the mail may be configured to be received by a specific person, or may be dynamically configured. The mail content, namely the report form, can be Excel or a picture. The timing expression can be selected from a specific type, such as a certain day, a certain month and the like, and can also be configured by directly using cron expression character strings. Meanwhile, the timing task can be executed immediately after the configuration is completed so as to verify the correctness of the configuration.
In the embodiment, the report is acquired and the report prompt information is generated and sent to the user terminal in the mode of the timed task, so that the user can acquire the report regularly, and the user can check the report in a more flexible mode.
In one embodiment, the method may further include: and uploading at least one of the report generation request, the data source, the data set and the initial report style to a block chain node for storage.
The blockchain refers to a novel application mode of computer technologies such as distributed data storage, point-to-point transmission, a consensus mechanism, an encryption algorithm and the like. A Block chain (Block chain), which is essentially a decentralized database, is a series of data blocks associated by using a cryptographic method, and each data Block contains information of a batch of network transactions, so as to verify the validity (anti-counterfeiting) of the information and generate a next Block.
Specifically, the blockchain may include a blockchain underlying platform, a platform product service layer, an application service layer, and the like.
In this embodiment, the server may upload and store one or more data of the report generation request, the data source, the data set, and the initial report style in the node of the blockchain, so as to ensure the privacy and security of the data.
In the above embodiment, at least one of the report generation request, the data source, the data set and the initial report style is uploaded to the block chain and stored in the node of the block chain, so that the privacy of the data stored in the block chain node can be guaranteed, and the security of the data can be improved.
It should be understood that, although the steps in the flowchart of fig. 2 are shown in order as indicated by the arrows, the steps are not necessarily performed in order as indicated by the arrows. The steps are not performed in the exact order shown and described, and may be performed in other orders, unless explicitly stated otherwise. Moreover, at least a portion of the steps in fig. 2 may include multiple sub-steps or multiple stages that are not necessarily performed at the same time, but may be performed at different times, and the order of performance of the sub-steps or stages is not necessarily sequential, but may be performed in turn or alternately with other steps or at least a portion of the sub-steps or stages of other steps.
In one embodiment, as shown in fig. 3, a report generation display apparatus is provided, which includes a report generationrequest receiving module 100, a data source obtaining and configuringmodule 200, a datasource converting module 300, an initial reportstyle obtaining module 400, and apresentation module 500, wherein:
the report generationrequest receiving module 100 is configured to receive a report generation request, where the report generation request carries a service identifier of a service corresponding to a report to be generated and a report generation requirement.
And the data source obtaining and configuringmodule 200 is configured to obtain a data source corresponding to the service based on the service identifier, and configure the obtained data source to obtain a configured data source.
And the datasource conversion module 300 is configured to convert the configured data source based on the report generation requirement, so as to obtain a data set corresponding to the report to be generated.
An initial reportstyle obtaining module 400, configured to obtain an initial report style for displaying the data set.
And thedisplay module 500 is configured to determine a target report style from the initial report styles based on the received report style selection instruction, and display the data set according to the target report style.
In one embodiment, the data source acquisition andconfiguration module 200 may include:
and the version type acquisition submodule is used for determining the version type of the data source according to the acquired data source.
And the target drive determining submodule is used for determining the corresponding target drive according to the version type.
And the configuration submodule is used for acquiring the data source connection information and configuring the data source through the target driver based on the data source connection information to obtain the configured data source.
In one embodiment, the target driver determining submodule is configured to determine the target driver of the corresponding data source from the candidate driver list according to the version type.
In this embodiment, the apparatus may further include:
and the alternative driving list establishing module is used for establishing an alternative driving list.
In this embodiment, the alternative driver list establishing module may include:
and the drive file acquisition submodule is used for acquiring the drive file corresponding to the version type of the data source.
And the analysis submodule is used for storing the drive file into the drive management directory and analyzing the drive file in the drive management directory based on a preset analysis mode to obtain corresponding file information.
And the alternative driving list generation submodule is used for adding a target drive corresponding to the data source in the initial alternative driving list according to the file information to obtain an alternative driving list.
In one embodiment, the datasource conversion module 300 may include:
and the obtaining sub-module is used for obtaining corresponding query data and configuration data based on the configured data source.
And the checking submodule is used for checking the configuration data and judging whether the configuration data has injection risks.
And the replacing submodule is used for screening variable assigned value data from the query data when the configuration data has no injection risk, and replacing the corresponding variable to be replaced in the configuration data based on the variable assigned value data to obtain the replaced configuration data.
And the connection instance generation sub-module is used for acquiring the configuration information of the data source and generating the data source connection instance based on the configuration information.
And the conversion submodule is used for converting the configured data source according to the connection example and the replaced configuration data to obtain a data set corresponding to the report to be generated.
In one embodiment, the report style selection instruction carries the style identification of the selected target report style.
In this embodiment, thedisplay module 500 may include:
and the data display requirement determining submodule is used for determining the data display requirement corresponding to the target report form based on the form identifier.
And the processing submodule is used for processing the data set according to the data display requirement to obtain the abscissa, the ordinate and the data content of the corresponding data set.
And the rendering submodule is used for rendering the abscissa, the ordinate and the data content.
In one embodiment, the apparatus may further include:
and the update data acquisition module is used for acquiring the service update data.
And the updating module is used for updating the data source based on the service updating data.
In this embodiment, the datasource conversion module 300 is configured to convert the configured updated data source based on the report generation requirement, so as to obtain an updated data set of the report to be generated.
In this embodiment, thepresentation module 500 is configured to present the updated data set through the target report style.
In one embodiment, the apparatus further includes:
and the report prompt sending module is used for acquiring a report displaying the data set through the target report style according to a mode of a timing task, generating report prompt information and sending the report prompt information to the user terminal.
In one embodiment, the apparatus may further include:
and the storage module is used for uploading at least one of the report generation request, the data source, the data set and the initial report style to the block chain node for storage.
For the specific definition of the report generation display device, reference may be made to the above definition of the report generation display method, which is not described herein again. All or part of the modules in the report generation and display device can be realized by software, hardware and a combination thereof. The modules can be embedded in a hardware form or independent from a processor in the computer device, and can also be stored in a memory in the computer device in a software form, so that the processor can call and execute operations corresponding to the modules.
In one embodiment, a computer device is provided, which may be a server, the internal structure of which may be as shown in fig. 4. The computer device includes a processor, a memory, a network interface, and a database connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device comprises a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program, and a database. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. The database of the computer device is used for storing data such as report generation requests, data sources, data sets, initial report styles and the like. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program is executed by a processor to implement a report generation display method.
Those skilled in the art will appreciate that the architecture shown in fig. 4 is merely a block diagram of some of the structures associated with the disclosed aspects and is not intended to limit the computing devices to which the disclosed aspects apply, as particular computing devices may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.
In one embodiment, there is provided a computer device comprising a memory storing a computer program and a processor implementing the following steps when the processor executes the computer program: receiving a report generation request, wherein the report generation request carries a service identifier of a service corresponding to a report to be generated and a report generation requirement; acquiring a data source corresponding to the service based on the service identifier, and configuring the acquired data source to obtain a configured data source; converting the configured data source based on the report generation requirement to obtain a data set corresponding to the report to be generated; acquiring an initial report form style for displaying a data set; and determining a target report form style from the initial report form styles based on the received report form style selection instruction, and displaying the data set through the target report form style.
In one embodiment, the configuring the acquired data source when the processor executes the computer program to obtain the configured data source may include: determining the version type of the data source according to the acquired data source; determining a corresponding target drive according to the version type; and acquiring data source connection information, and configuring the data source through the target driver based on the data source connection information to obtain the configured data source.
In one embodiment, the determining the corresponding target driver according to the version type when the processor executes the computer program may include: and determining the target drive of the corresponding data source from the alternative drive list according to the version type.
In this embodiment, the manner for implementing the establishment of the candidate driver list when the processor executes the computer program may include: acquiring a drive file corresponding to the version type of the data source; storing the drive file into a drive management directory, and analyzing the drive file in the drive management directory based on a preset analysis mode to obtain corresponding file information; and adding a target drive corresponding to the data source in the initial alternative drive list according to the file information to obtain an alternative drive list.
In one embodiment, the converting the configured data source to obtain the data set corresponding to the report to be generated when the processor executes the computer program may include: acquiring corresponding query data and configuration data based on the configured data source; verifying the configuration data and judging whether the configuration data has injection risks or not; when the configuration data do not have injection risks, screening variable assigned value data from the query data, and replacing the corresponding to-be-replaced variable in the configuration data based on the variable assigned value data to obtain replaced configuration data; acquiring configuration information of a data source, and generating a data source connection example based on the configuration information; and converting the configured data source according to the connection example and the replaced configuration data to obtain a data set corresponding to the report to be generated.
In one embodiment, the report style selection instruction carries the style identification of the selected target report style.
In this embodiment, when the processor executes the computer program, the displaying the data set through the target report style may include: determining a data display requirement corresponding to the target report form based on the form identifier; processing the data set according to the data display requirement to obtain the abscissa, the ordinate and the data content of the corresponding data set; and rendering the abscissa, the ordinate and the data content.
In one embodiment, the processor, when executing the computer program, may further implement the following steps: acquiring service updating data; and updating the data source based on the service updating data.
In this embodiment, when the processor executes the computer program, the converting the configured data source based on the report generation requirement to obtain the data set corresponding to the report to be generated may include: and converting the configured updated data source based on the report generation requirement to obtain an updated data set of the report to be generated.
In this embodiment, when the processor executes the computer program, the displaying the data set through the target report style may include: and displaying the updated data set through the target report style.
In one embodiment, the processor, when executing the computer program, further performs the steps of: and according to the mode of the timing task, acquiring a report displaying the data set through the target report style, generating report prompt information and sending the report prompt information to the user terminal.
In one embodiment, a computer-readable storage medium is provided, having a computer program stored thereon, which when executed by a processor, performs the steps of: receiving a report generation request, wherein the report generation request carries a service identifier of a service corresponding to a report to be generated and a report generation requirement; acquiring a data source corresponding to the service based on the service identifier, and configuring the acquired data source to obtain a configured data source; converting the configured data source based on the report generation requirement to obtain a data set corresponding to the report to be generated; acquiring an initial report form style for displaying a data set; and determining a target report form style from the initial report form styles based on the received report form style selection instruction, and displaying the data set through the target report form style.
In one embodiment, the computer program, when executed by the processor, implements configuration of the acquired data source to obtain a configured data source, and may include: determining the version type of the data source according to the acquired data source; determining a corresponding target drive according to the version type; and acquiring data source connection information, and configuring the data source through the target driver based on the data source connection information to obtain the configured data source.
In one embodiment, the computer program when executed by the processor for determining the corresponding target driver according to the version type may include: and determining the target drive of the corresponding data source from the alternative drive list according to the version type.
In this embodiment, the manner in which the computer program is executed by the processor to establish the candidate driver list may include: acquiring a drive file corresponding to the version type of the data source; storing the drive file into a drive management directory, and analyzing the drive file in the drive management directory based on a preset analysis mode to obtain corresponding file information; and adding a target drive corresponding to the data source in the initial alternative drive list according to the file information to obtain an alternative drive list.
In one embodiment, when executed by a processor, the computer program implements conversion of a configured data source to obtain a data set corresponding to a report to be generated, and may include: acquiring corresponding query data and configuration data based on the configured data source; verifying the configuration data and judging whether the configuration data has injection risks or not; when the configuration data do not have injection risks, screening variable assigned value data from the query data, and replacing the corresponding to-be-replaced variable in the configuration data based on the variable assigned value data to obtain replaced configuration data; acquiring configuration information of a data source, and generating a data source connection example based on the configuration information; and converting the configured data source according to the connection example and the replaced configuration data to obtain a data set corresponding to the report to be generated.
In one embodiment, the report style selection instruction carries the style identification of the selected target report style.
In this embodiment, when executed by a processor, the computer program implements presentation of a data set by a target report style, and may include: determining a data display requirement corresponding to the target report form based on the form identifier; processing the data set according to the data display requirement to obtain the abscissa, the ordinate and the data content of the corresponding data set; and rendering the abscissa, the ordinate and the data content.
In one embodiment, the computer program when executed by the processor may further implement the steps of: acquiring service updating data; and updating the data source based on the service updating data.
In this embodiment, when executed by the processor, the implementing, based on the report generation requirement, the converting the configured data source to obtain the data set corresponding to the report to be generated may include: and converting the configured updated data source based on the report generation requirement to obtain an updated data set of the report to be generated.
In this embodiment, when executed by a processor, the computer program implements presentation of a data set by a target report style, and may include: and displaying the updated data set through the target report style.
In one embodiment, the computer program when executed by the processor further performs the steps of: and according to the mode of the timing task, acquiring a report displaying the data set through the target report style, generating report prompt information and sending the report prompt information to the user terminal.
It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by hardware instructions of a computer program, which can be stored in a non-volatile computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. Any reference to memory, storage, database, or other medium used in the embodiments provided herein may include non-volatile and/or volatile memory, among others. Non-volatile memory can include read-only memory (ROM), Programmable ROM (PROM), Electrically Programmable ROM (EPROM), Electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), Dynamic RAM (DRAM), Synchronous DRAM (SDRAM), Double Data Rate SDRAM (DDRSDRAM), Enhanced SDRAM (ESDRAM), Synchronous Link DRAM (SLDRAM), Rambus Direct RAM (RDRAM), direct bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM).
The technical features of the above embodiments can be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the above embodiments are not described, but should be considered as the scope of the present specification as long as there is no contradiction between the combinations of the technical features.
The above-mentioned embodiments only express several embodiments of the present application, and the description thereof is more specific and detailed, but not construed as limiting the scope of the invention. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the concept of the present application, which falls within the scope of protection of the present application. Therefore, the protection scope of the present patent shall be subject to the appended claims.
Claims (10)
1. A report generation display method is characterized by comprising the following steps:
receiving a report generation request, wherein the report generation request carries a service identifier of a service corresponding to a report to be generated and a report generation requirement;
acquiring a data source of a corresponding service based on the service identifier, and configuring the acquired data source to obtain a configured data source;
converting the configured data source based on the report generation requirement to obtain a data set corresponding to the report to be generated;
acquiring an initial report form style for displaying the data set;
and determining a target report form style from the initial report form styles based on the received report form style selection instruction, and displaying the data set through the target report form style.
2. The method according to claim 1, wherein the configuring the acquired data source to obtain a configured data source comprises:
determining the version type of the data source according to the acquired data source;
determining a corresponding target drive according to the version type;
and acquiring data source connection information, and configuring the data source through the target driver based on the data source connection information to obtain the configured data source.
3. The method of claim 2, wherein determining the corresponding target driver according to the version type comprises:
determining a target drive corresponding to the data source from an alternative drive list according to the version type;
the establishment mode of the alternative driving list comprises the following steps:
acquiring a drive file corresponding to the version type of the data source;
storing the drive file into a drive management directory, and analyzing the drive file in the drive management directory based on a preset analysis mode to obtain corresponding file information;
and adding a target drive corresponding to the data source in the initial candidate drive list according to the file information to obtain the candidate drive list.
4. The method according to claim 1, wherein the converting the configured data source to obtain the data set corresponding to the report to be generated comprises:
acquiring corresponding query data and configuration data based on the configured data source;
checking the configuration data and judging whether the configuration data has injection risks or not;
when the configuration data do not have injection risks, screening variable assigned value data from the query data, and replacing corresponding variables to be replaced in the configuration data based on the variable assigned value data to obtain replaced configuration data;
acquiring configuration information of the data source, and generating a data source connection instance based on the configuration information;
and converting the configured data source according to the connection example and the replaced configuration data to obtain a data set corresponding to the report to be generated.
5. The method according to claim 1, wherein the report style selection instruction carries a style identification of the selected target report style;
the displaying the data set through the target report style comprises the following steps:
determining a data display requirement corresponding to the target report form based on the form identifier;
processing the data set according to the data display requirement to obtain the abscissa, the ordinate and the data content corresponding to the data set;
and rendering the abscissa, the ordinate and the data content.
6. The method of claim 1, further comprising:
acquiring service updating data;
updating the data source based on the service updating data;
the converting the configured data source based on the report generation requirement to obtain a data set corresponding to the report to be generated includes:
converting the configured updated data source based on the report generation requirement to obtain an updated data set of the report to be generated;
the displaying the data set through the target report style comprises the following steps:
and displaying the updated data set through the target report style.
7. The method of claim 6, further comprising:
and according to a mode of a timing task, acquiring a report displaying the data set through the target report style, generating report prompt information and sending the report prompt information to a user terminal.
8. A report generation display apparatus, comprising:
the report generation request receiving module is used for receiving a report generation request, wherein the report generation request carries a service identifier of a service corresponding to a report to be generated and a report generation requirement;
the data source acquisition and configuration module is used for acquiring a data source of a corresponding service based on the service identifier, and configuring the acquired data source to obtain a configured data source;
the data source conversion module is used for converting the configured data source based on the report generation requirement to obtain a data set corresponding to the report to be generated;
the initial report form style acquisition module is used for acquiring an initial report form style for displaying the data set;
and the display module is used for determining a target report form style from the initial report form style based on the received report form style selection instruction and displaying the data set through the target report form style.
9. A computer device comprising a memory and a processor, the memory storing a computer program, wherein the processor implements the steps of the method of any one of claims 1 to 7 when executing the computer program.
10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method of any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110303843.9ACN112861496B (en) | 2021-03-22 | 2021-03-22 | Report generation and display method, device, computer equipment and readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110303843.9ACN112861496B (en) | 2021-03-22 | 2021-03-22 | Report generation and display method, device, computer equipment and readable storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112861496Atrue CN112861496A (en) | 2021-05-28 |
| CN112861496B CN112861496B (en) | 2025-05-02 |
Family
ID=75991871
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110303843.9AActiveCN112861496B (en) | 2021-03-22 | 2021-03-22 | Report generation and display method, device, computer equipment and readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112861496B (en) |
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113591448A (en)* | 2021-08-03 | 2021-11-02 | 京东科技控股股份有限公司 | Report generation method and device and storage medium |
| CN113742342A (en)* | 2021-08-30 | 2021-12-03 | 欧电云信息科技(江苏)有限公司 | Display method, display system, electronic device and storage medium of multi-source data |
| CN114265893A (en)* | 2021-12-02 | 2022-04-01 | 北京锐安科技有限公司 | Data processing method, apparatus, electronic device and storage medium |
| CN114398226A (en)* | 2021-12-28 | 2022-04-26 | 绿盟科技集团股份有限公司 | Network asset report generation method and device |
| CN114637805A (en)* | 2022-03-24 | 2022-06-17 | 广联达科技股份有限公司 | Report generation method, device, equipment and readable storage medium |
| CN114676190A (en)* | 2022-05-27 | 2022-06-28 | 太平金融科技服务(上海)有限公司深圳分公司 | Data display method and device, computer equipment and storage medium |
| CN115098579A (en)* | 2022-08-24 | 2022-09-23 | 中关村科学城城市大脑股份有限公司 | Business data publishing method and device, electronic equipment and computer readable medium |
| CN115185967A (en)* | 2022-07-06 | 2022-10-14 | 北京字跳网络技术有限公司 | Data processing method, apparatus, electronic device and storage medium |
| CN115221849A (en)* | 2022-07-12 | 2022-10-21 | 平安科技（深圳）有限公司 | Report filling method, computer equipment and storage medium |
| CN115544130A (en)* | 2022-11-30 | 2022-12-30 | 广州天维信息技术股份有限公司 | Performance report generation method and device, storage medium and computer equipment |
| CN115809102A (en)* | 2022-12-22 | 2023-03-17 | 北京航星永志科技有限公司 | Data source configuration device, method and equipment |
| CN117688915A (en)* | 2023-11-28 | 2024-03-12 | 中国人寿保险股份有限公司江苏省分公司 | A method to automatically generate results based on data display and separation technology |
Citations (21)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108132945A (en)* | 2016-12-01 | 2018-06-08 | 百度在线网络技术（北京）有限公司 | For generating the method and apparatus of report |
| CN109816503A (en)* | 2019-01-04 | 2019-05-28 | 深圳壹账通智能科技有限公司 | Financial details data creation method, device, computer equipment and storage medium |
| WO2019174191A1 (en)* | 2018-03-15 | 2019-09-19 | 平安科技（深圳）有限公司 | Report data initialization method and apparatus, and computer device and storage medium |
| CN110266641A (en)* | 2019-05-13 | 2019-09-20 | 中国联合网络通信集团有限公司 | Information reading method and device |
| WO2019218454A1 (en)* | 2018-05-16 | 2019-11-21 | 平安科技（深圳）有限公司 | Subscription report generation method and apparatus, computer device and storage medium |
| WO2019232964A1 (en)* | 2018-06-07 | 2019-12-12 | 平安科技（深圳）有限公司 | Risk management data processing method and apparatus, computer device, and storage medium |
| CN110609715A (en)* | 2019-08-13 | 2019-12-24 | 平安国际智慧城市科技股份有限公司 | Random option page display method and device, computer equipment and storage medium |
| WO2020083059A1 (en)* | 2018-10-26 | 2020-04-30 | 阿里巴巴集团控股有限公司 | Client establishment method, apparatus and system |
| CN111400367A (en)* | 2020-02-28 | 2020-07-10 | 金蝶蝶金云计算有限公司 | Business report generation method and device, computer equipment and storage medium |
| CN111552712A (en)* | 2020-04-30 | 2020-08-18 | 中国平安财产保险股份有限公司 | Report data extraction method, device and computer equipment |
| CN111666743A (en)* | 2020-04-28 | 2020-09-15 | 平安科技（深圳）有限公司 | Report automatic generation method and device, computer equipment and storage medium |
| WO2020186809A1 (en)* | 2019-03-19 | 2020-09-24 | 深圳壹账通智能科技有限公司 | Big data platform-based hive task scheduling method and apparatus, device, and storage medium |
| CN111881192A (en)* | 2020-08-03 | 2020-11-03 | 浪潮云信息技术股份公司 | Method and system for generating visual configuration report, electronic equipment and storage medium |
| CN111966384A (en)* | 2020-10-20 | 2020-11-20 | 腾讯科技（深圳）有限公司 | System updating method, device, equipment and computer readable storage medium |
| CN112000687A (en)* | 2020-07-14 | 2020-11-27 | 金蝶医疗软件科技有限公司 | Business account table generation method and device, computer equipment and storage medium |
| CN112100219A (en)* | 2020-09-22 | 2020-12-18 | 平安养老保险股份有限公司 | Report generation method, device, equipment and medium based on database query processing |
| CN112114914A (en)* | 2020-08-03 | 2020-12-22 | 广州太平洋电脑信息咨询有限公司 | Method, device, computer equipment and storage medium for generating report |
| CN112131837A (en)* | 2020-09-22 | 2020-12-25 | 平安证券股份有限公司 | Service report configuration method, device, computer equipment and storage medium |
| CN112131843A (en)* | 2020-09-02 | 2020-12-25 | 苏宁云计算有限公司 | Business report generation method and device, computer equipment and storage medium |
| WO2021042914A1 (en)* | 2019-09-02 | 2021-03-11 | 深圳壹账通智能科技有限公司 | Test data generation method and apparatus, computer device and storage medium |
| CN112527848A (en)* | 2020-12-22 | 2021-03-19 | 苏州科达科技股份有限公司 | Multi-data-source-based report data query method, device, system and storage medium |
- 2021
- 2021-03-22CNCN202110303843.9Apatent/CN112861496B/enactiveActive
Patent Citations (21)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108132945A (en)* | 2016-12-01 | 2018-06-08 | 百度在线网络技术（北京）有限公司 | For generating the method and apparatus of report |
| WO2019174191A1 (en)* | 2018-03-15 | 2019-09-19 | 平安科技（深圳）有限公司 | Report data initialization method and apparatus, and computer device and storage medium |
| WO2019218454A1 (en)* | 2018-05-16 | 2019-11-21 | 平安科技（深圳）有限公司 | Subscription report generation method and apparatus, computer device and storage medium |
| WO2019232964A1 (en)* | 2018-06-07 | 2019-12-12 | 平安科技（深圳）有限公司 | Risk management data processing method and apparatus, computer device, and storage medium |
| WO2020083059A1 (en)* | 2018-10-26 | 2020-04-30 | 阿里巴巴集团控股有限公司 | Client establishment method, apparatus and system |
| CN109816503A (en)* | 2019-01-04 | 2019-05-28 | 深圳壹账通智能科技有限公司 | Financial details data creation method, device, computer equipment and storage medium |
| WO2020186809A1 (en)* | 2019-03-19 | 2020-09-24 | 深圳壹账通智能科技有限公司 | Big data platform-based hive task scheduling method and apparatus, device, and storage medium |
| CN110266641A (en)* | 2019-05-13 | 2019-09-20 | 中国联合网络通信集团有限公司 | Information reading method and device |
| CN110609715A (en)* | 2019-08-13 | 2019-12-24 | 平安国际智慧城市科技股份有限公司 | Random option page display method and device, computer equipment and storage medium |
| WO2021042914A1 (en)* | 2019-09-02 | 2021-03-11 | 深圳壹账通智能科技有限公司 | Test data generation method and apparatus, computer device and storage medium |
| CN111400367A (en)* | 2020-02-28 | 2020-07-10 | 金蝶蝶金云计算有限公司 | Business report generation method and device, computer equipment and storage medium |
| CN111666743A (en)* | 2020-04-28 | 2020-09-15 | 平安科技（深圳）有限公司 | Report automatic generation method and device, computer equipment and storage medium |
| CN111552712A (en)* | 2020-04-30 | 2020-08-18 | 中国平安财产保险股份有限公司 | Report data extraction method, device and computer equipment |
| CN112000687A (en)* | 2020-07-14 | 2020-11-27 | 金蝶医疗软件科技有限公司 | Business account table generation method and device, computer equipment and storage medium |
| CN111881192A (en)* | 2020-08-03 | 2020-11-03 | 浪潮云信息技术股份公司 | Method and system for generating visual configuration report, electronic equipment and storage medium |
| CN112114914A (en)* | 2020-08-03 | 2020-12-22 | 广州太平洋电脑信息咨询有限公司 | Method, device, computer equipment and storage medium for generating report |
| CN112131843A (en)* | 2020-09-02 | 2020-12-25 | 苏宁云计算有限公司 | Business report generation method and device, computer equipment and storage medium |
| CN112100219A (en)* | 2020-09-22 | 2020-12-18 | 平安养老保险股份有限公司 | Report generation method, device, equipment and medium based on database query processing |
| CN112131837A (en)* | 2020-09-22 | 2020-12-25 | 平安证券股份有限公司 | Service report configuration method, device, computer equipment and storage medium |
| CN111966384A (en)* | 2020-10-20 | 2020-11-20 | 腾讯科技（深圳）有限公司 | System updating method, device, equipment and computer readable storage medium |
| CN112527848A (en)* | 2020-12-22 | 2021-03-19 | 苏州科达科技股份有限公司 | Multi-data-source-based report data query method, device, system and storage medium |
Non-Patent Citations (3)
| Title |
|---|
| 冯亚丽，等: "基于B /S 的复杂报表动态生成系统的研究", 哈尔滨商业大学学报, vol. 28, no. 1, 29 February 2012 (2012-02-29), pages 68 - 71* |
| 艾飞，等: "面向多任务的报表管理系统运行器", 计 算 机 系 统 应 用, vol. 22, no. 12, 31 December 2013 (2013-12-31), pages 192 - 195* |
| 郭 玲: "一种Web 报表打印方法的实现", 计 算 机 系 统 应 用, vol. 21, no. 8, 31 December 2012 (2012-12-31), pages 144 - 151* |
Cited By (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113591448A (en)* | 2021-08-03 | 2021-11-02 | 京东科技控股股份有限公司 | Report generation method and device and storage medium |
| CN113742342A (en)* | 2021-08-30 | 2021-12-03 | 欧电云信息科技(江苏)有限公司 | Display method, display system, electronic device and storage medium of multi-source data |
| CN114265893A (en)* | 2021-12-02 | 2022-04-01 | 北京锐安科技有限公司 | Data processing method, apparatus, electronic device and storage medium |
| CN114398226A (en)* | 2021-12-28 | 2022-04-26 | 绿盟科技集团股份有限公司 | Network asset report generation method and device |
| CN114637805A (en)* | 2022-03-24 | 2022-06-17 | 广联达科技股份有限公司 | Report generation method, device, equipment and readable storage medium |
| CN114676190A (en)* | 2022-05-27 | 2022-06-28 | 太平金融科技服务(上海)有限公司深圳分公司 | Data display method and device, computer equipment and storage medium |
| CN115185967A (en)* | 2022-07-06 | 2022-10-14 | 北京字跳网络技术有限公司 | Data processing method, apparatus, electronic device and storage medium |
| CN115221849B (en)* | 2022-07-12 | 2023-07-18 | 平安科技（深圳）有限公司 | Report filling method, computer equipment and storage medium |
| CN115221849A (en)* | 2022-07-12 | 2022-10-21 | 平安科技（深圳）有限公司 | Report filling method, computer equipment and storage medium |
| CN115098579A (en)* | 2022-08-24 | 2022-09-23 | 中关村科学城城市大脑股份有限公司 | Business data publishing method and device, electronic equipment and computer readable medium |
| CN115544130A (en)* | 2022-11-30 | 2022-12-30 | 广州天维信息技术股份有限公司 | Performance report generation method and device, storage medium and computer equipment |
| CN115809102A (en)* | 2022-12-22 | 2023-03-17 | 北京航星永志科技有限公司 | Data source configuration device, method and equipment |
| CN117688915A (en)* | 2023-11-28 | 2024-03-12 | 中国人寿保险股份有限公司江苏省分公司 | A method to automatically generate results based on data display and separation technology |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112861496B (en) | 2025-05-02 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112861496A (en) | Report generation display method and device, computer equipment and readable storage medium | |
| CN109474578B (en) | Message checking method, device, computer equipment and storage medium | |
| US9268758B2 (en) | Method for associating third party content with online document signing | |
| CN110162524B (en) | Configuration data management method, device, computer equipment and storage medium | |
| CN111177302A (en) | Business document processing method and device, computer equipment and storage medium | |
| WO2020253401A1 (en) | File management method, apparatus, system and device, and computer-readable storage medium | |
| US9998450B2 (en) | Automatically generating certification documents | |
| CN114327374A (en) | Business process generation method, device and computer equipment | |
| CN111708971A (en) | Page configuration method, apparatus, computer device and storage medium | |
| CN113742338A (en) | Structured storage system for project acceptance forms | |
| CN113779132A (en) | Data import method and device, computer equipment and storage medium | |
| CN112286934A (en) | Database table import method, device, equipment and medium | |
| CN111949634A (en) | Method for synchronously migrating block chain data | |
| CN111143399B (en) | Data processing method, device, storage medium and computer equipment | |
| CN113449035B (en) | Data synchronization method, device, computer equipment and readable storage medium | |
| CN110598475A (en) | Block chain-based work attribute information acquisition method and device and computer equipment | |
| CN119444286A (en) | A method, device, equipment and medium for real-time data labeling | |
| CN111984631A (en) | Production data migration method, device, computer equipment and storage medium | |
| CN115396483B (en) | Interface calling method, device, computer equipment and storage medium | |
| CN111708795A (en) | Object identification generation method, object identification updating device, computer equipment and medium | |
| CN112685451B (en) | Data query processing method, device, computer equipment and storage medium | |
| CN113553344A (en) | Business data management method, system, computer equipment and storage medium | |
| US20240403475A1 (en) | System and Method for Implementing a Multi-Attestation Framework | |
| CN114004456B (en) | Data tag calculation method, device, computer equipment and storage medium | |
| CN115757458A (en) | Database file generation method and device, computer equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |