CN110750969A - Method and device for generating report - Google Patents
Method and device for generating report Download PDFInfo
- Publication number
- CN110750969A CN110750969A CN201910930541.7A CN201910930541A CN110750969A CN 110750969 A CN110750969 A CN 110750969A CN 201910930541 A CN201910930541 A CN 201910930541A CN 110750969 A CN110750969 A CN 110750969A
- Authority
- CN
- China
- Prior art keywords
- field
- report
- dictionary
- generated
- standard
- 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
- 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/24—Querying
- G06F16/242—Query formulation
-
- 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/24—Querying
- G06F16/245—Query processing
- G06F16/2457—Query processing with adaptation to user needs
-
- 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/24—Querying
- G06F16/248—Presentation of query results
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Mathematical Physics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a method and a device for generating a report, wherein the method comprises the following steps: setting a report to be generated; determining the corresponding relation between each standard field and the basic field in the report to be generated; wherein the basic field is stored in a service database of a service platform; and executing the following steps aiming at each standard field of the report to be generated: determining a target basic field corresponding to the current standard field according to the corresponding relation; querying data corresponding to the target basic field from the service database; and writing the data corresponding to the target basic field into the current standard field. The invention provides a method and a device for generating a report, which can generate the report more conveniently.
Description
Technical Field
The invention relates to the technical field of data processing, in particular to a method and a device for generating a report.
Background
In the field of data processing, reports are often generated according to data of a database of a service platform. Because the structure of the report is different from that of the table of the database, when generating the report, research and development personnel need to compile different SQL (Structured Query Language) scripts according to different reports and different databases. For example, a hospital information service and supervision system needs each hospital to generate and report required reports. Since the tables of the databases of the service platforms of the hospitals have different structures, research and development personnel need to write corresponding SQL scripts for each hospital.
As can be seen from the above description, the report generation scheme in the prior art is complex.
Disclosure of Invention
The embodiment of the invention provides a method and a device for generating a report, which can generate the report more conveniently.
In one aspect, an embodiment of the present invention provides a method for generating a report, including:
setting a report to be generated;
determining the corresponding relation between each standard field and a basic field in the report to be generated, wherein the basic field is stored in a service database of a service platform;
and executing the following steps aiming at each standard field of the report to be generated:
determining a target basic field corresponding to the current standard field according to the corresponding relation;
querying data corresponding to the target basic field from the service database;
and writing the data corresponding to the target basic field into the current standard field.
Alternatively,
the method further comprises the following steps:
presetting a dictionary comparison page;
further comprising:
setting a standard dictionary corresponding to the report to be generated;
displaying the standard dictionary in the dictionary comparison page;
before the determining the corresponding relationship between each standard field and the basic field in the report to be generated, the method further includes:
acquiring a basic dictionary of the service database;
displaying the base dictionary in the dictionary comparison page;
the determining the corresponding relationship between each standard field and the basic field in the report to be generated includes:
and receiving an externally input basic field corresponding to each standard field determined according to the standard dictionary and the basic dictionary, and generating the corresponding relation.
Alternatively,
the querying the data corresponding to the target basic field from the service database includes:
acquiring a first SQL statement for inquiring the current standard field;
according to the target basic field, the first SQL statement is reassembled, and a second SQL statement for inquiring the target basic field is generated;
and executing the second SQL statement, and acquiring data corresponding to the target basic field from the service database.
Alternatively,
the writing the data corresponding to the target basic field into the current standard field includes:
according to the corresponding relation between the target basic field and the current standard field, reassembling the second SQL statement to generate a third SQL statement for writing data into the report to be generated;
and executing the third SQL statement, and writing the data corresponding to the target basic field acquired by the second SQL statement into the current standard field.
Alternatively,
the method further comprises the following steps:
presetting a middle database, and connecting the middle database with the service database;
the setting of the report to be generated comprises the following steps:
and establishing the report to be generated in the intermediate database.
In a second aspect, an embodiment of the present invention provides an apparatus for generating a report, including:
the report setting unit is used for setting a report to be generated;
the determining unit is used for determining the corresponding relation between each standard field in the report to be generated and a basic field, wherein the basic field is stored in a service database of a service platform;
a report generating unit, configured to execute, for each standard field of the report to be generated:
determining a target basic field corresponding to the current standard field according to the corresponding relation;
querying data corresponding to the target basic field from the service database;
and writing the data corresponding to the target basic field into the current standard field.
Alternatively,
the apparatus further comprises:
the standard dictionary setting unit is used for setting a standard dictionary corresponding to the report to be generated;
the determining unit stores a dictionary comparison page;
the determining unit is further configured to display the standard dictionary in the dictionary comparison page, obtain a basic dictionary of the service database, and display the basic dictionary in the dictionary comparison page; and
the determining unit is configured to receive an externally input basic field corresponding to each standard field determined according to the standard dictionary and the basic dictionary, and generate the corresponding relationship.
Alternatively,
the report generation unit is used for executing the following steps:
acquiring a first SQL query statement for querying the current standard field;
according to the target basic field, the first SQL query statement is reassembled, and a second SQL query statement for querying the target basic field is generated;
and executing the second SQL query statement, and acquiring data corresponding to the target basic field from the service database.
Alternatively,
the report generation unit is used for executing the following steps:
according to the corresponding relation between the target basic field and the current standard field, reassembling the second SQL statement to generate a third SQL statement for writing data into the report to be generated;
and executing the third SQL statement, and writing the data corresponding to the target basic field acquired by the second SQL statement into the current standard field.
Alternatively,
the apparatus further comprises:
the database setting unit is used for setting a middle database and connecting the middle database with the service database;
and the report setting unit is used for establishing the report to be generated in the intermediate database.
In the embodiment of the invention, the corresponding relation between each standard field and the basic field in the report to be generated is determined, when the data required by each standard field is obtained from the business database, the data under the target basic field corresponding to the standard field is obtained from the business database according to the corresponding relation, and the obtained data is written into the standard field. The method can be used for different service platforms, codes do not need to be rewritten for different service platforms, and reports can be generated more conveniently.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to these drawings without creative efforts.
FIG. 1 is a flowchart of a method for generating a report according to an embodiment of the present invention;
FIG. 2 is a flowchart of another method for generating reports according to an embodiment of the present invention;
fig. 3 is a schematic diagram of an apparatus for generating a report according to an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer and more complete, the technical solutions in the embodiments of the present invention will be described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, but not all, embodiments of the present invention, and based on the embodiments of the present invention, all other embodiments obtained by a person of ordinary skill in the art without creative efforts belong to the scope of the present invention.
As shown in fig. 1, an embodiment of the present invention provides a method for generating a report, where the method may include the following steps:
step 101: setting a report to be generated;
step 102: determining the corresponding relation between each standard field and a basic field in the report to be generated, wherein the basic field is stored in a service database of a service platform;
step 103: and executing the following steps aiming at each standard field of the report to be generated: determining a target basic field corresponding to the current standard field according to the corresponding relation; querying data corresponding to the target basic field from the service database; and writing the data corresponding to the target basic field into the current standard field.
In the embodiment of the invention, the corresponding relation between each standard field and the basic field in the report to be generated is determined, when the data required by each standard field is obtained from the business database, the data under the target basic field corresponding to the standard field is obtained from the business database according to the corresponding relation, and the obtained data is written into the standard field. The method can be used for different service platforms, codes do not need to be rewritten for different service platforms, and reports can be generated more conveniently.
In an embodiment of the invention, the method further comprises:
presetting a dictionary comparison page;
further comprising:
setting a standard dictionary corresponding to the report to be generated;
displaying the standard dictionary in the dictionary comparison page;
before the determining the corresponding relationship between each standard field and the basic field in the report to be generated, the method further includes:
acquiring a basic dictionary of the service database;
displaying the base dictionary in the dictionary comparison page;
the determining the corresponding relationship between each standard field and the basic field in the report to be generated includes:
and receiving an externally input basic field corresponding to each standard field determined according to the standard dictionary and the basic dictionary, and generating the corresponding relation.
In the embodiment of the invention, the dictionary comparison page is set, the standard dictionary and the basic dictionary are displayed in the dictionary comparison page, and the corresponding relation between the standard field and the basic field can be configured outside according to the standard dictionary and the basic field displayed in the dictionary comparison page. Specifically, the standard dictionary includes standard fields of the report to be generated and a description of data required for each standard field. The basic dictionary comprises basic fields in the business database. The user can determine the basic field corresponding to each standard field according to the standard dictionary and the basic dictionary. For example: one standard field in the standard dictionary is a1, the description for a1 is that a1 requires name information of the service platform, and one base field in the base dictionary is "name", and a1 can be associated with "name" based on the standard dictionary and the base dictionary.
In an embodiment of the present invention, the querying the data corresponding to the target basic field from the service database includes:
acquiring a first SQL statement for inquiring the current standard field;
according to the target basic field, the first SQL statement is reassembled, and a second SQL statement for inquiring the target basic field is generated;
and executing the second SQL statement, and acquiring data corresponding to the target basic field from the service database.
In the embodiment of the present invention, when data required by the current standard field needs to be queried through the first SQL statement, since the data is stored according to the basic field in the business database, the first SQL statement needs to be reassembled into the second SQL statement according to the corresponding relationship, and the second SQL statement can query data under the target basic field corresponding to the current standard field, where the data is the data required by the current standard field.
In an embodiment of the present invention, the writing the data corresponding to the target basic field into the current standard field includes:
according to the corresponding relation between the target basic field and the current standard field, reassembling the second SQL statement to generate a third SQL statement for writing data into the report to be generated;
and executing the third SQL statement, and writing the data corresponding to the target basic field acquired by the second SQL statement into the current standard field.
In the embodiment of the invention, the second SQL statement is reassembled to generate a third SQL statement, and the data under the target basic data can be accurately written into the current standard field in the report to be generated through the third SQL statement.
In an embodiment of the invention, the method further comprises:
presetting a middle database, and connecting the middle database with the service database;
the setting of the report to be generated comprises the following steps:
and establishing the report to be generated in the intermediate database.
In the embodiment of the invention, the intermediate database is connected with the business database, so that the data acquired from the business database can be written into the report to be generated in the intermediate database,
as shown in fig. 2, an embodiment of the present invention provides a method for generating a report, where the method may include the following steps:
step 201: and presetting a dictionary comparison page, presetting a middle database, and connecting the middle database with a service database of the service platform.
Step 202: and establishing a report to be generated in the intermediate database, and setting a standard dictionary corresponding to the report to be generated.
Specifically, a plurality of reports to be generated may be established in the intermediate database, and a corresponding standard dictionary may be set for each report to be generated.
For example, the report to be generated can be a report required by a hospital information service and supervision system.
Step 203: the standard dictionary is displayed in the dictionary collation page.
Step 204: and acquiring a basic dictionary of the service database, and displaying the basic dictionary in a dictionary comparison page.
The service platform may be, for example, a medical management system of each hospital.
Step 205: and receiving an externally input basic field corresponding to each standard field determined according to the standard dictionary and the basic dictionary, and generating a corresponding relation between the standard field and the basic field.
For example, the standard fields include: a1, A2 and A3. The basic field includes: "name", "age", "height". According to the standard dictionary and the basic dictionary, determining that A1 corresponds to 'name', A2 corresponds to 'age', and A3 corresponds to 'height'.
Step 206: and aiming at each standard field of the report to be generated, executing: determining a target basic field corresponding to the current standard field according to the corresponding relation; inquiring data corresponding to the target basic field from a business database; and writing the data corresponding to the target basic field into the current standard field.
For example, data needs to be written into a1, then, according to the correspondence, it is determined that a1 corresponds to "name", data corresponding to "name" is queried from the business database, and data corresponding to "name" is written into a1 of the report to be generated.
In addition, the data required by each standard field can be periodically inquired from the business database, and when the business database is updated, the corresponding data in the report to be generated is also updated in real time.
In the embodiment of the invention, the corresponding relation between the standard field in the report to be generated and the basic field of the service platform is determined, the data required by each standard field can be accurately obtained based on the corresponding relation, different corresponding relations can be configured for different service platforms, different codes do not need to be compiled for different service platforms, the code sharing can be realized, the repeated development work is reduced, and the workload is greatly reduced.
As shown in fig. 3, an embodiment of the present invention provides an apparatus for generating a report, including:
a report setting unit 301, configured to set a report to be generated;
a determining unit 302, configured to determine a corresponding relationship between each standard field in the report to be generated and a basic field, where the basic field is stored in a service database of a service platform;
a report generating unit 303, configured to execute, for each standard field of the report to be generated:
determining a target basic field corresponding to the current standard field according to the corresponding relation;
querying data corresponding to the target basic field from the service database;
and writing the data corresponding to the target basic field into the current standard field.
In an embodiment of the present invention, the apparatus further comprises:
the standard dictionary setting unit is used for setting a standard dictionary corresponding to the report to be generated;
the determining unit stores a dictionary comparison page;
the determining unit is further configured to display the standard dictionary in the dictionary comparison page, obtain a basic dictionary of the service database, and display the basic dictionary in the dictionary comparison page; and
the determining unit is configured to receive an externally input basic field corresponding to each standard field determined according to the standard dictionary and the basic dictionary, and generate the corresponding relationship.
In an embodiment of the present invention, the report generating unit is configured to execute:
acquiring a first SQL query statement for querying the current standard field;
according to the target basic field, the first SQL query statement is reassembled, and a second SQL query statement for querying the target basic field is generated;
and executing the second SQL query statement, and acquiring data corresponding to the target basic field from the service database.
In an embodiment of the present invention, the report generating unit is configured to execute:
according to the corresponding relation between the target basic field and the current standard field, reassembling the second SQL statement to generate a third SQL statement for writing data into the report to be generated;
and executing the third SQL statement, and writing the data corresponding to the target basic field acquired by the second SQL statement into the current standard field.
In an embodiment of the present invention, the apparatus further comprises:
the database setting unit is used for setting a middle database and connecting the middle database with the service database;
and the report setting unit is used for establishing the report to be generated in the intermediate database.
Because the information interaction, execution process, and other contents between the units in the device are based on the same concept as the method embodiment of the present invention, specific contents may refer to the description in the method embodiment of the present invention, and are not described herein again.
The embodiments of the invention have at least the following beneficial effects:
1. in the embodiment of the invention, the corresponding relation between each standard field and the basic field in the report to be generated is determined, when the data required by each standard field is obtained from the business database, the data under the target basic field corresponding to the standard field is obtained from the business database according to the corresponding relation, and the obtained data is written into the standard field. The method can be used for different service platforms, codes do not need to be rewritten for different service platforms, and reports can be generated more conveniently.
2. In the embodiment of the invention, the corresponding relation between the standard field in the report to be generated and the basic field of the service platform is determined, the data required by each standard field can be accurately obtained based on the corresponding relation, different corresponding relations can be configured for different service platforms, different codes do not need to be compiled for different service platforms, the code sharing can be realized, the repeated development work is reduced, and the workload is greatly reduced.
It is noted that, herein, relational terms such as first and second, and the like may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other similar elements in a process, method, article, or apparatus that comprises the element.
Those of ordinary skill in the art will understand that: all or part of the steps for realizing the method embodiments can be completed by hardware related to program instructions, the program can be stored in a computer readable storage medium, and the program executes the steps comprising the method embodiments when executed; and the aforementioned storage medium includes: various media that can store program codes, such as ROM, RAM, magnetic or optical disks.
Finally, it is to be noted that: the above description is only a preferred embodiment of the present invention, and is only used to illustrate the technical solutions of the present invention, and not to limit the protection scope of the present invention. Any modification, equivalent replacement, or improvement made within the spirit and principle of the present invention shall fall within the protection scope of the present invention.
Claims (10)
1. A method for generating a report, comprising:
setting a report to be generated;
determining the corresponding relation between each standard field and a basic field in the report to be generated, wherein the basic field is stored in a service database of a service platform;
and executing the following steps aiming at each standard field of the report to be generated:
determining a target basic field corresponding to the current standard field according to the corresponding relation;
querying data corresponding to the target basic field from the service database;
and writing the data corresponding to the target basic field into the current standard field.
2. The method of claim 1,
further comprising:
presetting a dictionary comparison page;
further comprising:
setting a standard dictionary corresponding to the report to be generated;
displaying the standard dictionary in the dictionary comparison page;
before the determining the corresponding relationship between each standard field and the basic field in the report to be generated, the method further includes:
acquiring a basic dictionary of the service database;
displaying the base dictionary in the dictionary comparison page;
the determining the corresponding relationship between each standard field and the basic field in the report to be generated includes:
and receiving an externally input basic field corresponding to each standard field determined according to the standard dictionary and the basic dictionary, and generating the corresponding relation.
3. The method of claim 1,
the querying the data corresponding to the target basic field from the service database includes:
acquiring a first Structured Query Language (SQL) statement for querying the current standard field;
according to the target basic field, the first SQL statement is reassembled, and a second SQL statement for inquiring the target basic field is generated;
and executing the second SQL statement, and acquiring data corresponding to the target basic field from the service database.
4. The method of claim 3,
the writing the data corresponding to the target basic field into the current standard field includes:
according to the corresponding relation between the target basic field and the current standard field, reassembling the second SQL statement to generate a third SQL statement for writing data into the report to be generated;
and executing the third SQL statement, and writing the data corresponding to the target basic field acquired by the second SQL statement into the current standard field.
5. The method according to any one of claims 1 to 4,
further comprising:
presetting a middle database, and connecting the middle database with the service database;
the setting of the report to be generated comprises the following steps:
and establishing the report to be generated in the intermediate database.
6. An apparatus for generating a report, comprising:
the report setting unit is used for setting a report to be generated;
the determining unit is used for determining the corresponding relation between each standard field in the report to be generated and a basic field, wherein the basic field is stored in a service database of a service platform;
a report generating unit, configured to execute, for each standard field of the report to be generated:
determining a target basic field corresponding to the current standard field according to the corresponding relation;
querying data corresponding to the target basic field from the service database;
and writing the data corresponding to the target basic field into the current standard field.
7. The apparatus of claim 6,
further comprising:
the standard dictionary setting unit is used for setting a standard dictionary corresponding to the report to be generated;
the determining unit stores a dictionary comparison page;
the determining unit is further configured to display the standard dictionary in the dictionary comparison page, obtain a basic dictionary of the service database, and display the basic dictionary in the dictionary comparison page; and
the determining unit is configured to receive an externally input basic field corresponding to each standard field determined according to the standard dictionary and the basic dictionary, and generate the corresponding relationship.
8. The apparatus of claim 6,
the report generation unit is used for executing the following steps:
acquiring a first Structured Query Language (SQL) query statement for querying the current standard field;
according to the target basic field, the first SQL query statement is reassembled, and a second SQL query statement for querying the target basic field is generated;
and executing the second SQL query statement, and acquiring data corresponding to the target basic field from the service database.
9. The apparatus of claim 8,
the report generation unit is used for executing the following steps:
according to the corresponding relation between the target basic field and the current standard field, reassembling the second SQL statement to generate a third SQL statement for writing data into the report to be generated;
and executing the third SQL statement, and writing the data corresponding to the target basic field acquired by the second SQL statement into the current standard field.
10. The apparatus according to any one of claims 6 to 9,
further comprising:
the database setting unit is used for setting a middle database and connecting the middle database with the service database;
and the report setting unit is used for establishing the report to be generated in the intermediate database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910930541.7A CN110750969B (en) | 2019-09-29 | 2019-09-29 | Report generation method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910930541.7A CN110750969B (en) | 2019-09-29 | 2019-09-29 | Report generation method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110750969A true CN110750969A (en) | 2020-02-04 |
| CN110750969B CN110750969B (en) | 2023-09-01 |
Family
ID=69277381
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910930541.7A Active CN110750969B (en) | 2019-09-29 | 2019-09-29 | Report generation method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110750969B (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111339084A (en) * | 2020-02-15 | 2020-06-26 | 河北唐宋大数据产业股份有限公司 | Data processing method and system |
| CN111708801A (en) * | 2020-05-29 | 2020-09-25 | 北京金山云网络技术有限公司 | Report generation method, device and electronic device |
| CN112256684A (en) * | 2020-10-23 | 2021-01-22 | 厦门悦讯信息科技股份有限公司 | Report generation method, terminal equipment and storage medium |
| WO2021184571A1 (en) * | 2020-03-17 | 2021-09-23 | 平安国际智慧城市科技股份有限公司 | Dynamic form generation method, apparatus, computer device, and storage medium |
Citations (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1416078A (en) * | 2001-10-30 | 2003-05-07 | 艾默生网络能源有限公司 | Data processing method of monitoring system |
| CA2465577A1 (en) * | 2003-04-29 | 2004-10-29 | Cognos Incorporated | Database report generation |
| US20080319942A1 (en) * | 2007-05-14 | 2008-12-25 | Samir Courdy | Method and system for report generation including extensible data |
| CN101673287A (en) * | 2009-10-16 | 2010-03-17 | 金蝶软件（中国）有限公司 | SQL sentence generation method and system |
| CN102567539A (en) * | 2011-12-31 | 2012-07-11 | 北京新媒传信科技有限公司 | Intelligent WEB report implementation method and intelligent WEB report implementation system |
| CN104615667A (en) * | 2015-01-13 | 2015-05-13 | 联动优势电子商务有限公司 | Basic data generation method and device and test data generation method and device |
| CN106951430A (en) * | 2016-12-28 | 2017-07-14 | 金蝶软件（中国）有限公司 | Account table querying method and device |
| CN107168940A (en) * | 2017-03-29 | 2017-09-15 | 长春市万易科技有限公司 | A kind of report generating system and method |
| US20180314745A1 (en) * | 2017-04-28 | 2018-11-01 | Splunk Inc. | Dynamically-generated files for visualization sharing |
| CN108984499A (en) * | 2018-06-01 | 2018-12-11 | 北京五八信息技术有限公司 | Method for processing report data and device, electronic equipment and readable storage medium storing program for executing |
| CN109271411A (en) * | 2018-09-28 | 2019-01-25 | 中国平安财产保险股份有限公司 | Report form generation method, device, computer equipment and storage medium |
| CN109471890A (en) * | 2018-10-16 | 2019-03-15 | 深圳壹账通智能科技有限公司 | Generation method, terminal device and the medium of report file |
| CN110211646A (en) * | 2019-05-22 | 2019-09-06 | 浙江大学 | A kind of dynamic and configurable medical treatment report form generation method based on OCQL and openEHR |
-
2019
- 2019-09-29 CN CN201910930541.7A patent/CN110750969B/en active Active
Patent Citations (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1416078A (en) * | 2001-10-30 | 2003-05-07 | 艾默生网络能源有限公司 | Data processing method of monitoring system |
| CA2465577A1 (en) * | 2003-04-29 | 2004-10-29 | Cognos Incorporated | Database report generation |
| US20080319942A1 (en) * | 2007-05-14 | 2008-12-25 | Samir Courdy | Method and system for report generation including extensible data |
| CN101673287A (en) * | 2009-10-16 | 2010-03-17 | 金蝶软件（中国）有限公司 | SQL sentence generation method and system |
| CN102567539A (en) * | 2011-12-31 | 2012-07-11 | 北京新媒传信科技有限公司 | Intelligent WEB report implementation method and intelligent WEB report implementation system |
| CN104615667A (en) * | 2015-01-13 | 2015-05-13 | 联动优势电子商务有限公司 | Basic data generation method and device and test data generation method and device |
| CN106951430A (en) * | 2016-12-28 | 2017-07-14 | 金蝶软件（中国）有限公司 | Account table querying method and device |
| CN107168940A (en) * | 2017-03-29 | 2017-09-15 | 长春市万易科技有限公司 | A kind of report generating system and method |
| US20180314745A1 (en) * | 2017-04-28 | 2018-11-01 | Splunk Inc. | Dynamically-generated files for visualization sharing |
| CN108984499A (en) * | 2018-06-01 | 2018-12-11 | 北京五八信息技术有限公司 | Method for processing report data and device, electronic equipment and readable storage medium storing program for executing |
| CN109271411A (en) * | 2018-09-28 | 2019-01-25 | 中国平安财产保险股份有限公司 | Report form generation method, device, computer equipment and storage medium |
| CN109471890A (en) * | 2018-10-16 | 2019-03-15 | 深圳壹账通智能科技有限公司 | Generation method, terminal device and the medium of report file |
| CN110211646A (en) * | 2019-05-22 | 2019-09-06 | 浙江大学 | A kind of dynamic and configurable medical treatment report form generation method based on OCQL and openEHR |
Non-Patent Citations (2)
| Title |
|---|
| P.F. TARASSENKO等: ""System for database reports generating"", 《5TH KOREA-RUSSIA INTERNATIONAL SYMPOSIUM ON SCIENCE AND TECHNOLOGY. PROCEEDINGS. KORUS 2001 (CAT. NO.01EX478)》 * |
| 柳军;韩冰;: "一种可重用报表处理平台的实现", no. 11 * |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111339084A (en) * | 2020-02-15 | 2020-06-26 | 河北唐宋大数据产业股份有限公司 | Data processing method and system |
| WO2021184571A1 (en) * | 2020-03-17 | 2021-09-23 | 平安国际智慧城市科技股份有限公司 | Dynamic form generation method, apparatus, computer device, and storage medium |
| CN111708801A (en) * | 2020-05-29 | 2020-09-25 | 北京金山云网络技术有限公司 | Report generation method, device and electronic device |
| CN112256684A (en) * | 2020-10-23 | 2021-01-22 | 厦门悦讯信息科技股份有限公司 | Report generation method, terminal equipment and storage medium |
| CN112256684B (en) * | 2020-10-23 | 2022-08-16 | 厦门悦讯信息科技股份有限公司 | Report generation method, terminal equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110750969B (en) | 2023-09-01 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10545998B2 (en) | Syntactic tagging in a domain-specific context | |
| CN110750969A (en) | Method and device for generating report | |
| US8145685B2 (en) | Object relational mapping layer | |
| US8799235B2 (en) | Data de-duplication system | |
| US7149752B2 (en) | Method for simplifying databinding in application programs | |
| CN110908997A (en) | Data blood margin construction method and device, server and readable storage medium | |
| CN110795455A (en) | Dependency relationship analysis method, electronic device, computer device and readable storage medium | |
| US20220245103A1 (en) | Maintaining a dataset based on periodic cleansing of raw source data | |
| CN110837520A (en) | Data processing method, platform and system | |
| US20070239742A1 (en) | Determining data elements in heterogeneous schema definitions for possible mapping | |
| WO2005031503A2 (en) | Sytem and method for generating data validation rules | |
| CN109710220B (en) | Relational database query method, relational database query device, relational database query equipment and storage medium | |
| CN114090760A (en) | Data processing method, electronic device and readable storage medium for form question answering | |
| CN103678396A (en) | Data backup method and device based on data models | |
| CN107451280B (en) | Data communication method and device and electronic equipment | |
| CN110147396B (en) | A method and device for generating a mapping relationship | |
| CN114020852A (en) | Knowledge graph display method and device | |
| CN109716366A (en) | System and method for automated extraction and visualization of knowledge about enterprise technology, people, and business functions | |
| CN117827902A (en) | Service data processing method, device, computer equipment and storage medium | |
| CN117390011A (en) | Report data processing method, device, computer equipment and storage medium | |
| CN115718754A (en) | Electronic accounting archive data query method and device and electronic equipment | |
| CN109344249B (en) | Information processing method, information processing device, electronic equipment and computer readable storage medium | |
| CN113792048A (en) | Form validation rule generation method and system for non-relational database | |
| CN113157890A (en) | Intelligent question and answer method and device, electronic equipment and readable storage medium | |
| US20250272297A1 (en) | Systems and methods for generating explainable features for machine learning |
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 | ||
| CB02 | Change of applicant information | ||
| CB02 | Change of applicant information |
Address after: 100176 room 801-2, 8th floor, building 3, yard 22, Ronghua Middle Road, Beijing Economic and Technological Development Zone, Daxing District, Beijing Applicant after: Wanghai Kangxin (Beijing) Technology Co.,Ltd. Address before: Room 07, zone 2, building B, No. 12, Hongda North Road, Beijing Economic and Technological Development Zone, Beijing 100176 Applicant before: Wanghai Kangxin (Beijing) Technology Co.,Ltd. |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant |