CN110362591B - Report form display method and device - Google Patents

Report form display method and device Download PDF

Info

Publication number
CN110362591B
CN110362591B CN201810284150.8A CN201810284150A CN110362591B CN 110362591 B CN110362591 B CN 110362591B CN 201810284150 A CN201810284150 A CN 201810284150A CN 110362591 B CN110362591 B CN 110362591B
Authority
CN
China
Prior art keywords
query
report
sql
condition
field
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN201810284150.8A
Other languages
Chinese (zh)
Other versions
CN110362591A (en
Inventor
米玉
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Hainan Shenzhou Taiyue Software Co ltd
Original Assignee
Ultrapower Software Co ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Ultrapower Software Co ltd filed Critical Ultrapower Software Co ltd
Priority to CN201810284150.8A priority Critical patent/CN110362591B/en
Publication of CN110362591A publication Critical patent/CN110362591A/en
Application granted granted Critical
Publication of CN110362591B publication Critical patent/CN110362591B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR 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
    • G06F16/2433—Query languages
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR 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
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR 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/2453—Query optimisation
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR 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 discloses a report form showing method and device. The method comprises the following steps: receiving an inquiry request, wherein the inquiry request carries a report document number, and initializing an inquiry field set according to the report document number; dynamically spelling SQL sentences in a report database according to the query condition information selected by the user in the query field set and the report document number to obtain SQL query sentences; inquiring a corresponding result set in the report database according to the SQL inquiry statement, and processing data in the result set to obtain tree-shaped structure data with a superior-inferior relation; and performing tree representation on the tree structure data in the result set in the report. The invention can make the user only master the keyword without knowing which field of the tree list the keyword is in, thereby achieving the purpose of fast searching.

Description

Report form display method and device
Technical Field
The invention relates to the technical field of data processing, in particular to a report form showing method and device.
Background
The report forms display data in a form, a chart and the like. With the advent of computers, it is possible to generate and display reports through the functions of computer data processing and interface design, and a large amount of data processing requirements have brought forth a lot of report software, which is mainly characterized by data dynamism and format diversification, and realizes the complete separation of report data and report format, header style and data are fixed in advance, only the content of the report is dynamic data, and the user can only modify data or only modify format.
At present, query of tree list display report data is often a fixed condition during searching, and if a user only grasps a keyword without knowing which field of the tree list the keyword is in, rapid query cannot be performed.
Disclosure of Invention
The invention provides a report display method and a report display device, which are used for solving the problem that when the report data is displayed by inquiring a tree-shaped list, a user does not know which field of the tree-shaped list the inquiry keyword is in, so that the searching speed is too slow.
In order to achieve the purpose, the technical scheme of the invention is realized as follows:
in one aspect, the present invention provides a report display method, including:
receiving an inquiry request, wherein the inquiry request carries a report document number;
initializing a query field set according to the report document number;
dynamically spelling Structured Query Language (SQL) statements in a report database according to query condition information and report document numbers selected by a user in a query field set to obtain SQL query statements, wherein the SQL statements are registered in the report database, and each SQL statement corresponds to one report document number;
inquiring a corresponding result set in the report database according to the SQL inquiry statement, and processing data in the result set to obtain tree-shaped structure data with a superior-inferior relation;
and performing tree representation on the tree structure data in the result set in the report.
In another aspect, the present invention provides a report display apparatus, including:
the receiving unit is used for receiving an inquiry request, and the inquiry request carries a report document number;
the initialization unit is used for initializing the query field set according to the report document number;
the system comprises a spelling unit, a query unit and a report form database, wherein the spelling unit is used for dynamically spelling Structured Query Language (SQL) sentences in the report form database according to query condition information and report form document numbers selected by a user in a query field set to obtain SQL query sentences, the SQL sentences are registered in the report form database, and each SQL sentence corresponds to one report form document number;
the query processing unit is used for querying a corresponding result set in the report database according to the SQL query statement and processing data in the result set to obtain tree-shaped structure data with a superior-inferior relation;
and the display unit is used for performing tree display on the tree structure data in the result set in the report.
The invention has the beneficial effects that: the SQL sentences are registered in the report database, the query field set is dynamically initialized according to the report document number carried by the query request, so that a user can select the query keywords according to the requirement, the SQL query sentences are dynamically spelled according to the query keywords to query the result set, the data of the result set is processed according to the query keywords to obtain the tree-shaped structure data with the upper and lower level relations, the tree-shaped structure data is displayed in the report in a tree form, and the user only masters the keywords without knowing which field of the tree-shaped list the keywords are in, so that the aim of quickly searching is fulfilled.
Drawings
FIG. 1 is a flowchart of a report presentation method according to an embodiment of the present invention;
FIG. 2 is a schematic diagram of data showing a tree structure in a report according to an embodiment of the present invention;
fig. 3 is a block diagram of a report presentation apparatus according to an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, embodiments of the present invention will be described in detail with reference to the accompanying drawings.
Fig. 1 is a flowchart of a report presentation method according to an embodiment of the present invention, and as shown in fig. 1, the method according to the embodiment includes:
s110, receiving an inquiry request, wherein the inquiry request carries a report document number.
And S120, initializing a query field set according to the report document number.
In this embodiment, the report form number is associated with an inquiry field set, and the inquiry field set includes all inquiry field information associated with the report form number. Exemplarily, if the report is a purchase report, if the query field information corresponding to the document number of the purchase report includes the name of an article, the model of the article, the purpose of the article, and the price of the article, the query field initialized according to the document number of the purchase report collectively includes the name of the article, the model of the article, the purpose of the article, and the price of the article; if the report is a personnel statistics report, if the query field information corresponding to the document number of the personnel statistics report comprises: and the inquiry field set initialized according to the bill number of the personnel statistical report comprises the employee name, the employee gender, the employee post and the employee leave-on date.
S130, dynamically spelling a Structured Query Language (SQL) statement in a report database according to Query condition information and a report document number selected by a user in a Query field set to obtain an SQL Query statement; SQL sentences are registered in the report database, and each SQL sentence corresponds to a report document number.
The report database of the embodiment is a database supporting SQL query.
S140, inquiring a corresponding result set in the report database according to the SQL inquiry statement, and processing the data in the result set to obtain the tree-structured data with the upper and lower level relations.
S150, tree-shaped display is carried out on the tree-shaped structure data in the result set in the report.
In this embodiment, the result set data is tree-displayed by using the query keyword in the query condition information as a root node, and if the data in the result set includes tree-structured data using a as the root node, tree-structured data using B as the root node, and tree-structured data using C as the root node, the report simultaneously displays the tree-structured data using A, B, C as the root node.
In the embodiment, SQL sentences are registered in the report database, the query field set is dynamically initialized according to the report document number carried by the query request, so that a user can select query keywords according to requirements, the SQL query sentences are dynamically spelled according to the query keywords to query the result set, the data of the result set is processed according to the query keywords to obtain tree-shaped structure data with an upper-level and lower-level relation, the tree-shaped structure data is displayed in the report in a tree form, and the user only needs to master the keywords without knowing which field of the tree-shaped list the keywords are in, so that the purpose of quick search is achieved.
The report query method of the embodiment is simple and convenient to operate, accords with user habits, and is wide in application range.
In one embodiment of the invention, SQL statements are registered in the report database by the following method:
splitting a pre-written SQL statement according to a selection query Select field, a table query From field, a query condition Where field and a query grouping group field, and storing split words obtained by splitting into four corresponding excel tables, wherein the four excel tables are associated through a report document number and respectively correspond to a main table, a sub table, a relation table and a query condition table in a report database; and importing the word segmentation corresponding to each excel table into the table corresponding to the report database.
Illustratively, taking splitting an SQL statement Select column name From table name Where condition name is 'value' group name as an example, splitting the SQL statement according to a Select field, a From field, a Where field and a group name field in sequence to divide 1-column name, divide 2-table name, divide 3-condition name 'value' and divide 4-group name, importing the divide 1-column name into a main table, importing the divide 2-table name into a sub-table, importing the divide 3-condition name 'value' into a relation table, and importing the divide 4-group name into a query condition table.
In practical application, a secondary developer writes a large and complete SQL statement of a statistical report in advance, and splits the written SQL statement into corresponding excel tables, where the four excel tables are associated by a report document number and are respectively a main table (FX _ ReportConfigGroupMain), a sub table (FX _ ReportConfigColSub), a relation table (FX _ fxrelationship) and a query condition table (FX _ confregroupware) in a report database, and may use a JSTL tool to import data corresponding to each excel table into a corresponding table in the report database, complete registration of SQL statement, and then encapsulate corresponding fields into SQL query statements for data query according to generated query fields and grouping fields.
In one embodiment of the present invention, the present embodiment initializes the set of query fields by:
acquiring a query field set corresponding to a report document number according to an initialization query method getSearchConditionByMenuCode (); initializing list head information of a pre-displayed form according to a query field set, wherein a keyword query frame and a condition query frame are arranged in the pre-displayed form.
For example, a pre-display table with table name JTable may be initialized in advance for display by the user, and a keyword query box and a condition query box are displayed in a query area of the JTable table. As shown in fig. 2, a keyword query box is set in the query area of the table shown in fig. 2, and the query area shown in fig. 2 does not display a condition query box, and at this time, the condition field may be defaulted to be a full field.
Correspondingly, dynamically spelling the SQL statement in the report database includes:
generating grouping information and condition information according to a query keyword input by a user in the keyword query box and a query condition input by a user in the condition query box, extracting four object values for spelling an SQL query statement according to report form number information, calling a statement query method getSQL according to the grouping information and the condition information, and spelling the SQL query statement corresponding to the query request based on the four object values.
The embodiment may invoke a data query method queryFilterData to respond to the selection operation of the user, and generate the group information and the condition information corresponding to the query keyword and the query condition by using a group mapping table attribute groupMap.
In practical application, the report presentation method can be realized by using CORE JAVA SWING, and various queries and presentations of the report are processed by using a unified parent class. In this embodiment, database query is performed in combination with information generated by a user selecting a foreground report and a background registered SQL statement, and a queried result set is processed into tree-structured data for data display in the report.
Illustratively, a report subclass, such as the report subclass BookFileCountUI (the report subclass is a report parent class of an abstract class such as report nested class reportnestui) may be used, and four object values VO for preparing a spelled SQL statement, i.e., a main table object value reportconfiggroupmainnvo, a sub table object value ReportConfigColSubVO, a relational table object value fxconcurgroupsvo, and a query condition object value confregroupwherevo, are extracted according to a report document number, at this time, a pre-display form is initialized by using a report tool JTable for a user to display, and a column displayed at this time of the initialized pre-display form is a large complete set of all fields in a query field set.
When a user opens a report to generate a query request, the embodiment acquires and queries all queryable query condition information according to the query request carrying the report document number, and completes initialization work before displaying a list. A user can input keywords or select keywords in the keyword query box shown in fig. 2 as required, when the user clicks a query button, the reportnestui parent class calls a data query method queryFilterData to respond to the query request of the user, and group information and condition information corresponding to the query keywords and the query conditions are generated by using the group table groupMap attributes.
And the report NestedUI parent class calls an acquisition method getSQL of the report NestedUI parent class according to the generated grouping information and condition information, acquires a corresponding SQL query statement by an inquiry nesting method queryNestedData () in a report class report Impl and a concateSQL method of a nesting class NestedSql, queries a corresponding result set and returns the result set to the report NestedUI method, and then processes data in the result set to obtain tree-shaped structure data taking a query keyword as a root node.
In the data processing of the result set, the data in the result set can be packaged by using a Java toolkit Bean and returned to the pre-display table, so that the multi-condition query is completed.
In this embodiment, before encapsulating the data, the data in the result set is subjected to service aggregation, and different processing modes are adopted according to different fields. The service summary function of this embodiment needs to be determined according to the requirement, as shown in fig. 2, a field "% Completed" indicates the process of averaging data, a field "Work" indicates the process of summing data, a field "Start" indicates the minimum value in the data, and a field "Finish" indicates the maximum value in the data.
Corresponding to the method embodiment, the invention also provides a report display device embodiment. Fig. 3 is a block diagram of a report presentation apparatus according to an embodiment of the present invention, and as shown in fig. 3, the apparatus includes:
the receiving unit 31 is configured to receive an inquiry request, where the inquiry request carries a report document number;
the initialization unit 32 is used for initializing the query field set according to the report document number;
the spelling unit 33 is used for dynamically spelling SQL sentences in the report database according to the query condition information and the report bill number selected by the user in the query field set to obtain SQL query sentences, wherein the SQL sentences are registered in the report database, and each SQL sentence corresponds to one report bill number;
the query processing unit 34 is configured to query a corresponding result set in the report database according to the SQL query statement, and process data in the result set to obtain tree-like structure data having a hierarchical relationship;
and the display unit 35 is used for performing tree display on the tree structure data in the result set in the report.
Preferably, in this embodiment, the apparatus in fig. 3 further includes a registration import unit;
the registration import unit is used for splitting a pre-written SQL sentence according to a Select field, a From field, a Where field and a group field, storing the split participles into four corresponding excel tables, wherein the four excel tables are associated through a report document number and respectively correspond to a main table, a sub-table, a relation table and a query condition table in a report database; and importing the word segmentation corresponding to each excel table into the table corresponding to the report database.
In an embodiment of the present invention, the initializing unit 32 is further configured to obtain a query field set corresponding to the report document number according to an initialization query method getsearccordinationbymenucode (); initializing list head information of a pre-displayed form according to the query field set, and setting a keyword query frame and a condition query frame in the pre-displayed form.
In another embodiment of the present invention, the spelling unit 33 is further configured to generate grouping information and condition information according to the query keyword in the keyword query box and the query condition in the condition query box; extracting four object values for spelling the SQL query statement according to the report document number information; and calling a statement query method getSQL according to the grouping information and the condition information, and spelling the SQL query statement corresponding to the query request based on the four object values.
The spelling unit 33 specifically calls a data query method queryFilterData to respond to a selection operation of a user, and generates grouping information and condition information corresponding to the query condition, the query keyword, and the query value by using a grouping table groupMap attribute.
To sum up, the embodiment of the invention provides a report presentation method and a device, SQL sentences are registered in a report database, a query field set is dynamically initialized according to report document numbers carried by query requests, so that a user can select query keywords according to needs, SQL query sentences are dynamically spelled according to the query keywords to query a result set, data of the result set are processed according to the query keywords to obtain tree-shaped structure data with a hierarchical relationship, the tree-shaped structure data are presented in the report, the user only grasps the keywords without knowing which fields of the tree-shaped list the keywords are in, and the purpose of quick search is achieved.
For the convenience of clearly describing the technical solutions of the embodiments of the present invention, in the embodiments of the present invention, the words "first", "second", and the like are used to distinguish the same items or similar items with basically the same functions and actions, and those skilled in the art can understand that the words "first", "second", and the like do not limit the quantity and execution order.
While the foregoing is directed to embodiments of the present invention, other modifications and variations of the present invention may be devised by those skilled in the art in light of the above teachings. It should be understood by those skilled in the art that the foregoing detailed description is for the purpose of better explaining the present invention, and the scope of the present invention should be determined by the scope of the appended claims.

Claims (8)

1. A report presentation method is characterized by comprising the following steps:
receiving an inquiry request, wherein the inquiry request carries a report document number;
initializing a query field set according to the report document number;
dynamically spelling Structured Query Language (SQL) statements in a report database according to query condition information selected by a user in the query field set and the report bill number to obtain SQL query statements, wherein the SQL statements are registered in the report database, and each SQL statement corresponds to one report bill number;
inquiring a corresponding result set in the report database according to the SQL inquiry statement, and processing data in the result set to obtain tree-shaped structure data with a superior-inferior relation;
tree-form showing is carried out on the tree-form structure data in the result set in a report, and the tree-form showing is carried out on the result set data by taking the query keywords in the query condition information as root nodes;
wherein, SQL sentences are registered in the report database according to the following method:
splitting a pre-written SQL statement according to a selection query Select field, a table query From field, a query condition Where field and a query grouping group field, and storing split words obtained by splitting into four corresponding excel tables, wherein the four excel tables are associated through a report document number and respectively correspond to a main table, a sub table, a relation table and a query condition table in a report database;
and importing the word segmentation corresponding to each excel table into the table corresponding to the report database.
2. The method of claim 1, wherein initializing a set of query fields according to the statement document number comprises:
acquiring a query field set corresponding to the report document number according to an initialization query method getSearchConditionByMenuCode ();
initializing list head information of a pre-displayed form according to the query field set, wherein a keyword query frame and a condition query frame are arranged in the pre-displayed form.
3. The method of claim 2, wherein dynamically spelling the SQL statement in the reporting database according to the query condition information selected by the user in the query field set and the report document number comprises:
generating grouping information and condition information according to the query keywords in the keyword query box and the query conditions in the condition query box;
extracting four object values for spelling the SQL query statement according to the report document number information;
and invoking a statement query method getSQL according to the grouping information and the condition information, and spelling the SQL query statement corresponding to the query request based on the four object values.
4. The method of claim 3, wherein generating grouping information and condition information according to the query keyword in the keyword query box and the query condition in the condition query box comprises:
and calling a data query method queryFilterData to respond to the selection operation of a user, and generating grouping information and condition information corresponding to the query keyword and the query condition by utilizing the grouping table groupMap attribute.
5. A report presentation apparatus, comprising:
the receiving unit is used for receiving an inquiry request, and the inquiry request carries a report document number;
the initialization unit is used for initializing a query field set according to the report document number;
the spelling unit is used for dynamically spelling Structured Query Language (SQL) sentences in a report database according to the query condition information selected by the user in the query field set and the report bill number to obtain SQL query sentences, the SQL sentences are registered in the report database, and each SQL sentence corresponds to one report bill number;
the query processing unit is used for querying a corresponding result set in the report database according to the SQL query statement and processing data in the result set to obtain tree-shaped structure data with a superior-inferior relation;
the display unit is used for performing tree-shaped display on the tree-shaped structure data in the result set in a report, and performing tree-shaped display on the result set data by taking the query keywords in the query condition information as root nodes;
wherein the device further comprises a registration import unit;
the system comprises a register import unit, a report database and a database, wherein the register import unit is used for splitting a pre-written SQL sentence according to a selection query Select field, a table query From field, a query condition Where field and a query group field, and storing split participles into four corresponding excel tables which are associated through a report document number and respectively correspond to a main table, a sub-table, a relation table and a query condition table in the report database; and importing the word segmentation corresponding to each excel table into the table corresponding to the report database.
6. The apparatus of claim 5,
the initialization unit is used for acquiring a query field set corresponding to the report document number according to an initialization query method getSearchConditionByMenuCode (); initializing list head information of a pre-displayed form according to the query field set, wherein a keyword query frame and a condition query frame are arranged in the pre-displayed form.
7. The apparatus of claim 6,
the spelling unit is used for generating grouping information and condition information according to the query keywords in the keyword query box and the query conditions in the condition query box; extracting four object values for spelling the SQL query statement according to the report document number information; and invoking a statement query method getSQL according to the grouping information and the condition information, and spelling the SQL query statement corresponding to the query request based on the four object values.
8. The apparatus of claim 7,
the spelling unit is also used for calling a data query method queryFilterData to respond to the selection operation of a user and generating grouping information and condition information corresponding to the query keyword and the query condition by utilizing the grouping table groupMap attribute.
CN201810284150.8A 2018-04-02 2018-04-02 Report form display method and device Active CN110362591B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201810284150.8A CN110362591B (en) 2018-04-02 2018-04-02 Report form display method and device

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201810284150.8A CN110362591B (en) 2018-04-02 2018-04-02 Report form display method and device

Publications (2)

Publication Number Publication Date
CN110362591A CN110362591A (en) 2019-10-22
CN110362591B true CN110362591B (en) 2022-02-22

Family

ID=68213447

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201810284150.8A Active CN110362591B (en) 2018-04-02 2018-04-02 Report form display method and device

Country Status (1)

Country Link
CN (1) CN110362591B (en)

Families Citing this family (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111143359A (en) * 2019-12-18 2020-05-12 口碑(上海)信息技术有限公司 Query statement generation method and device
CN112685475A (en) * 2020-12-30 2021-04-20 平安普惠企业管理有限公司 Report query method and device, computer equipment and storage medium
CN112860728A (en) * 2021-02-19 2021-05-28 深圳市极致科技股份有限公司 Method and device for adding display columns to data query table based on user environment
CN114141322A (en) * 2021-12-14 2022-03-04 浙江太美医疗科技股份有限公司 Method and device for configuring clinical test analysis report and computer equipment

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2002117060A (en) * 2000-10-11 2002-04-19 Fujitsu Ltd Automatic generating method for database query statement, and data table structure
CN101697122A (en) * 2009-10-16 2010-04-21 深圳市科陆电子科技股份有限公司 Method for generating report query conditions through predefined components
CN104239368A (en) * 2013-06-21 2014-12-24 苏州精易会信息技术有限公司 Form data inquiring method based on setting
CN104714974A (en) * 2013-12-17 2015-06-17 航天信息股份有限公司 Method and device for parsing and reprocessing query statement
CN105138501A (en) * 2015-08-10 2015-12-09 北京思特奇信息技术股份有限公司 Configurable dynamic report generating method and system

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2002117060A (en) * 2000-10-11 2002-04-19 Fujitsu Ltd Automatic generating method for database query statement, and data table structure
CN101697122A (en) * 2009-10-16 2010-04-21 深圳市科陆电子科技股份有限公司 Method for generating report query conditions through predefined components
CN104239368A (en) * 2013-06-21 2014-12-24 苏州精易会信息技术有限公司 Form data inquiring method based on setting
CN104714974A (en) * 2013-12-17 2015-06-17 航天信息股份有限公司 Method and device for parsing and reprocessing query statement
CN105138501A (en) * 2015-08-10 2015-12-09 北京思特奇信息技术股份有限公司 Configurable dynamic report generating method and system

Also Published As

Publication number Publication date
CN110362591A (en) 2019-10-22

Similar Documents

Publication Publication Date Title
US11755575B2 (en) Processing database queries using format conversion
US20230325410A1 (en) Data analysis engine
CN110362591B (en) Report form display method and device
CN110633292B (en) Query method, device, medium, equipment and system for heterogeneous database
US8463739B2 (en) Systems and methods for generating multi-population statistical measures using middleware
CN106372194B (en) Method and system for presenting search results
US20040158567A1 (en) Constraint driven schema association
CN109213776B (en) Report form display method and device
CN105550241A (en) Multidimensional database query method and apparatus
US20170357693A1 (en) Overlay Visualizations Utilizing Data Layer
US9824128B1 (en) System for performing single query searches of heterogeneous and dispersed databases
CN102810094A (en) Report generation method and device
US20080215554A1 (en) Data Plotting Extension for Structured Query Language
CN113553341A (en) Multidimensional data analysis method, multidimensional data analysis device, multidimensional data analysis equipment and computer readable storage medium
US20130166531A1 (en) Data browser for group-by data access
CN113918605A (en) Data query method, device, equipment and computer storage medium
JPH09218878A (en) Information presenting device
US8781997B2 (en) Reusing reporting components in customized cubes
CN110019433B (en) Report query method and device
CN112527918A (en) Data processing method and device
CN111143356A (en) Report retrieval method and device
US8793272B2 (en) Query transformation
EP2690563A1 (en) Method and device for reporting on data of documents generated from templates
US9798449B2 (en) Fuzzy search and highlighting of existing data visualization
CN108460092B (en) Automatic generation method and system for sql query statement containing database built-in function

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

Address after: Room 818, 8 / F, 34 Haidian Street, Haidian District, Beijing 100080

Applicant after: ULTRAPOWER SOFTWARE Co.,Ltd.

Address before: 100089 Beijing city Haidian District wanquanzhuang Road No. 28 Wanliu new building 6 storey block A Room 601

Applicant before: ULTRAPOWER SOFTWARE Co.,Ltd.

CB02 Change of applicant information
GR01 Patent grant
GR01 Patent grant
TR01 Transfer of patent right

Effective date of registration: 20230116

Address after: 572000 No. 201-13-22, second floor, building 5, yabulun Industrial Park, yazhouwan science and Technology City, Yazhou District, Sanya City, Hainan Province

Patentee after: Hainan Shenzhou Taiyue Software Co.,Ltd.

Address before: 100080 room 818, 8 / F, 34 Haidian Street, Haidian District, Beijing

Patentee before: ULTRAPOWER SOFTWARE Co.,Ltd.

TR01 Transfer of patent right