CN109766338A - Self-defined report design method, electronic equipment, storage medium and system - Google Patents

Self-defined report design method, electronic equipment, storage medium and system Download PDF

Info

Publication number
CN109766338A
CN109766338A CN201811434275.0A CN201811434275A CN109766338A CN 109766338 A CN109766338 A CN 109766338A CN 201811434275 A CN201811434275 A CN 201811434275A CN 109766338 A CN109766338 A CN 109766338A
Authority
CN
China
Prior art keywords
field
report
database table
data
database
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.)
Pending
Application number
CN201811434275.0A
Other languages
Chinese (zh)
Inventor
李伦
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Hangzhou Cloud Technology Co Ltd
Original Assignee
Hangzhou Cloud Technology Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Hangzhou Cloud Technology Co Ltd filed Critical Hangzhou Cloud Technology Co Ltd
Priority to CN201811434275.0A priority Critical patent/CN109766338A/en
Publication of CN109766338A publication Critical patent/CN109766338A/en
Pending legal-status Critical Current

Links

Landscapes

  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The present invention provides self-defined report design method, including several database tables in business datum cited in report are established database relation with several reference fields;Database relation is that the field in reference field and database table has incidence relation;Using database relation, database table and reference field as reference data source, and reference data source is introduced into report setting;Reference field in reference data source is defined as to show field;It will show that field definition is inquiry field according to preset need information;It inquires to obtain the field in correspondence database table according to inquiry field and pre-set constraint condition, data corresponding with field in database table is obtained according to field;Data are filled to default report template according to default report area format, obtain target report.Self-defined report design method of the invention, can satisfy the demand of different user, and the process for making report makes according to the demand of client oneself completely.

Description

Self-defined report design method, electronic equipment, storage medium and system
Technical field
The present invention relates to Report Form Design field more particularly to self-defined report design method, electronic equipment, storage medium and System.
Background technique
With current things diversification and business diversity, the understanding of different business information is come from mostly The detailed data of statistics in report.Open-and-shut data can more quickly understand oneself demand letter in report with let us Breath, saves a large amount of time.But existing user, during using report, having different query statistic data needs It asks, but current report can only provide fixed statistical mask, and not have universal applicability, and mould report generation is first Phase can not carry out design template according to the demand of user.
Summary of the invention
For overcome the deficiencies in the prior art, one of the objects of the present invention is to provide self-defined report design method, Existing user be can solve during using report, have different query statistic data requirementss, but current report is only Fixed statistical mask can be provided, and do not have universal applicability, and the initial stage of mould report generation can not be according to user's Demand carrys out the problem of design template.
The second object of the present invention is to provide a kind of electronic equipment, can solve existing user in the mistake using report Cheng Zhong has different query statistic data requirementss, but current report can only provide fixed statistical mask, and not have general Time applicability, and the problem of the initial stage of mould report generation can not carry out design template according to the demand of user.
The third object of the present invention is to provide a kind of computer readable storage medium, and can solve existing user makes During with report, different query statistic data requirementss are had, but current report can only provide fixed statistical mask, And do not have universal applicability, and the problem of the initial stage of mould report generation can not carry out design template according to the demand of user.
The fourth object of the present invention is to provide self-defined report designing system, can solve existing user and using report During table, different query statistic data requirementss are had, but current report can only provide fixed statistical mask, not Initial stage with universal applicability, and mould report generation can not carry out the problem of design template according to the demand of user.
The present invention provides the first purpose and is implemented with the following technical solutions:
Self-defined report design method characterized by comprising
Data source is defined, several database tables in business datum cited in report are established into number with several reference fields It include several fields and several data in the database table according to base relation, each field is corresponding with each data; The database relation is that the field in the reference field and the database table has incidence relation;
Data source is introduced, using the database relation, the database table and the reference field as reference data Source;
Binding shows field, and the reference field in the reference data source is defined as to show field, each described Show that the field in field and the database table has the incidence relation;
Querying condition is quoted, the displaying field definition is inquired according to preset need information by field, it is each described to look into The field ask in field and the database table has the incidence relation;
Report generation, inquires to obtain and corresponds to the database according to the inquiry field and pre-set constraint condition Field in table obtains data corresponding with the field in the database table according to the field;According to default report band Domain format fills the data to default report template, obtains target report.
It further, further include setting data constraint before the report generation, for inquiry field setting constraint item Part, the constraint condition include querying condition and query context.
Further, the binding shows that field further includes that setting shows format, shows lattice default according to displaying field Corresponding displaying format is matched in formula library.
Further, further include that data increase, increase number is carried out to the database table in the business datum according to demand According to processing.
Further, the default report area format statistics column format and statistical indicator format.
The present invention provides the second purpose and is implemented with the following technical solutions:
A kind of electronic equipment, comprising: processor;
Memory;And program, wherein described program is stored in the memory, and is configured to by processor It executes, described program includes for executing the self-defined report design method in the application.
The present invention provides the third purpose and is implemented with the following technical solutions:
A kind of computer readable storage medium, is stored thereon with computer program, and the computer program is held by processor Self-defined report design method in row the application.
The present invention provides the fourth purpose and is implemented with the following technical solutions:
Self-defined report designing system characterized by comprising
Data source modules are defined, the definition data source modules are used for several numbers in business datum cited in report Database relation is established according to Ku Biao and several reference fields, includes several fields and several data in the database table, each The field is corresponding with each data;The database relation is the field in the reference field and the database table With incidence relation;
Introduce data source modules, the introducings data source modules for by the database relation, the database table with And the reference field is as reference data source;
Binding shows field module, and the binding shows that field module is used for the reference in the reference data source Field definition is to show field, and each field shown in field and the database table has the incidence relation;
Quote querying condition module, the reference querying condition module for according to preset need information by the displaying word Section is defined as inquiry field, and the field in each inquiry field and the database table has the incidence relation;
Report generation module, for according to the inquiry field and pre-set constraint item described in report generation module Part is inquired to obtain the field corresponded in the database table, according to the field obtain in the database table with the field pair The data answered;The data are filled to default report template according to default report area format, obtain target report.
It further, further include setting data constraint module, the setting data constraint module is used to be the inquiry word Section setting constraint condition, the constraint condition includes querying condition and query context.
Further, the binding shows that field further includes that setting shows format, shows lattice default according to displaying field Corresponding displaying format is matched in formula library.
Compared with prior art, the beneficial effects of the present invention are self-defined report design methods of the invention, including will report Several database tables in business datum cited in table and several reference fields establish database relation, in the database table Including several fields and several data, each field is corresponding with each data;The database relation is described draws There is incidence relation with the field in field and the database table;By the database relation, the database table and institute Reference field is stated as reference data source, and the reference data source is introduced into the report setting;By the reference data The reference field in source is defined as showing that field, each field shown in field and the database table have institute State incidence relation;The displaying field definition is inquired into field, each inquiry field and institute according to preset need information The field stated in database table has the incidence relation;It is inquired according to the inquiry field and pre-set constraint condition It obtains corresponding to the field in the database table, number corresponding with the field in the database table is obtained according to the field According to;The data are filled to default report template according to default report area format, obtain target report.By defining data Source simultaneously introduces data source, and inquiry field can be defined according to preset need information, can be with to realize self-defined report Meets the needs of different user, the process for making report makes according to the demand of client oneself completely.
The above description is only an overview of the technical scheme of the present invention, in order to better understand the technical means of the present invention, And can be implemented in accordance with the contents of the specification, the following is a detailed description of the preferred embodiments of the present invention and the accompanying drawings. A specific embodiment of the invention is shown in detail by following embodiment and its attached drawing.
Detailed description of the invention
The drawings described herein are used to provide a further understanding of the present invention, constitutes part of this application, this hair Bright illustrative embodiments and their description are used to explain the present invention, and are not constituted improper limitations of the present invention.In the accompanying drawings:
Fig. 1 is the flow diagram of self-defined report design method of the invention.
Specific embodiment
In the following, being described further in conjunction with attached drawing and specific embodiment to the present invention, it should be noted that not Under the premise of conflicting, new implementation can be formed between various embodiments described below or between each technical characteristic in any combination Example.
As shown in Figure 1, self-defined report design method of the invention, comprising the following steps:
Data source is defined, several database tables in business datum cited in report are established into number with several reference fields It include several fields and several data in database table according to base relation, each field is corresponding with each data;Database relation is Field in reference field and database table has incidence relation;The database table in business datum in the present embodiment is preparatory The data sheet set.The field in database table in the present embodiment is associated with above-mentioned reference field generation, can be one A reference field corresponds to the field in multiple or individual data table.
Data source is introduced, using database relation, database table and reference field as reference data source;It i.e. will be above-mentioned The data of database relation and database table and reference field as setting report.
Binding shows field, and the reference field in reference data source is defined as to show field, each displaying field and number There is incidence relation according to the field in the table of library.Specially user is according to their own needs by above-mentioned part reference field or whole Reference field is dragged to the position of the displaying field of report, using above-mentioned reference field as field is shown, concretely according to not With the text in the field in the database table in the data source for showing field displaying, such as character field meeting display data library table The content of format, date field can generate corresponding date content, amount of money type can generate corresponding amount of money format etc..In this implementation Also further include that setting shows format in example, corresponding displaying format matched in default show in format library according to displaying field, Such as: age displaying is calculated in the field that the entitled age is arranged by birthday date.
Quote querying condition, according to preset need information will show field definition be inquiry field, each inquiry field and Field in database table has incidence relation.Preset need information in the present embodiment be demand inquire field type and Number, it is above-mentioned specifically: i.e. according to the type matching of the demand inquiry field to corresponding displaying field, and according to number It goes to seek the number for determining and needing to show field, to be inquiry field by the displaying field definition of corresponding number, will show field It is dragged to the position of inquiry field.
Report generation is inquired to obtain the word in correspondence database table according to inquiry field and pre-set constraint condition Section, obtains data corresponding with field in database table according to field;Data are filled to pre- according to default report area format If report template, target report is obtained.In the present embodiment, above-mentioned default report area format include statistics column definition and Statistical indicator definition, statistics column definition includes fixed dimension column definition and dynamic dimension column definition, solid-state dimension column The ranks dimension for referring to report is entirely static fixed dimension, and dynamic dimension column refers to that the ranks dimension of report can basis The report dimensional information of the query result dynamic expansion of database table, i.e. ranks dimension are not fixed and invariable, and can pass through definition Dynamic dimension and fixed dimension are realized to Report Form Design demand, to efficiently design report.Fixed dimension column definition is For the set for by the column definition in report being one group of customized column member, column member is finally presented in the fixation in report Dimension can define column member with tree structure.Statistical indicator defines the access mode of the essence report, even if definition expression Formula and condition.Finally the corresponding data of field in the database table inquired are filled according to above-mentioned default report area format In the corresponding position of corresponding column member, particular number is determined according to above-mentioned statistical indicator definition, has finally obtained mesh Mark report.In the present embodiment, further includes that data increase, according to demand the database table in business datum increase at data Reason.
The present invention provides a kind of electronic equipment, comprising: processor;
Memory;And program, wherein program is stored in memory, and is configured to be executed by processor, journey Sequence includes the self-defined report design method for executing the application.
The present invention provides a kind of computer readable storage mediums, are stored thereon with computer program, computer program quilt Processor executes the self-defined report design method of the application.
The present invention provides self-defined report designing systems, comprising: defines data source modules, defines data source modules and be used for By in business datum cited in report several database tables and several reference fields establish database relation, in database table Including several fields and several data, each field is corresponding with each data;Database relation is reference field and database table In field have incidence relation;Introduce data source modules, introduce data source modules be used for by database relation, database table with And reference field is as reference data source;Binding shows field module, and binding displaying field module is used for will be in reference data source Reference field be defined as showing that field, each field shown in field and database table have incidence relation;Reference inquiry Condition module, reference querying condition module are used to show that field definition is inquiry field, Mei Gecha according to preset need information The field ask in field and database table has incidence relation;Report generation module, report generation module are used for according to inquiry word Section and pre-set constraint condition inquire to obtain the field in correspondence database table, according to field obtain in database table with The corresponding data of field;Data are filled to default report template according to default report area format, obtain target report.This reality It applies in example, further includes setting data constraint module, setting data constraint module is used to that constraint condition, constraint to be arranged for inquiry field Condition includes querying condition and query context.Binding shows that field further includes that setting shows format, according to displaying field default It shows in format library and matches corresponding displaying format.
Self-defined report design method of the invention, including by several database tables in business datum cited in report Database relation is established with several reference fields, includes several fields and several data in database table, each field and each Data are corresponding;Database relation is that the field in reference field and database table has incidence relation;By database relation, data Library table and reference field are introduced into report setting as reference data source, and by reference data source;It will be in reference data source Reference field is defined as showing that field, each field shown in field and database table have incidence relation;According to default need Ask information that will show field definition as inquiry field, the field in each inquiry field and database table has incidence relation;Root It is investigated that inquiry field and pre-set constraint condition inquire to obtain the field in correspondence database table, data are obtained according to field Data corresponding with field in the table of library;Data are filled to default report template according to default report area format, obtain target Report.By defining data source and introducing data source, and inquiry field can be defined according to preset need information, to realize Self-defined report, can satisfy the demand of different user, the process for making report is made according to the demand of client oneself completely Make, meets the demand of different user.Report data source can be flexibly quoted, the field that can be shown with self-defined report can With the condition of self-defined inquiry.It is greatly convenient for users to use.
More than, only presently preferred embodiments of the present invention is not intended to limit the present invention in any form;All current rows The those of ordinary skill of industry can be shown in by specification attached drawing and above and swimmingly implement the present invention;But all to be familiar with sheet special The technical staff of industry without departing from the scope of the present invention, is made a little using disclosed above technology contents The equivalent variations of variation, modification and evolution is equivalent embodiment of the invention;Meanwhile all substantial technologicals according to the present invention The variation, modification and evolution etc. of any equivalent variations to the above embodiments, still fall within technical solution of the present invention Within protection scope.

Claims (10)

1. self-defined report design method characterized by comprising
Data source is defined, several database tables in business datum cited in report are established into database with several reference fields Relationship, includes several fields and several data in the database table, and each field is corresponding with each data;It is described Database relation is that the field in the reference field and the database table has incidence relation;
Data source is introduced, using the database relation, the database table and the reference field as reference data source;
Binding shows field, and the reference field in the reference data source is defined as to show field, each displaying Field in field and the database table has the incidence relation;
Querying condition is quoted, the displaying field definition is inquired by field, each inquiry word according to preset need information Section has the incidence relation with the field in the database table;
Report generation, inquires to obtain and corresponds in the database table according to the inquiry field and pre-set constraint condition Field, data corresponding with the field in the database table are obtained according to the field;According to default report region lattice Formula fills the data to default report template, obtains target report.
2. self-defined report design method as described in claim 1, it is characterised in that: further include setting before the report generation Data constraint is set, constraint condition is set for the inquiry field, the constraint condition includes querying condition and query context.
3. self-defined report design method as described in claim 1, it is characterised in that: the binding shows that field further includes setting Displaying format is set, corresponding displaying format is matched in default show in format library according to displaying field.
4. self-defined report design method as described in claim 1, it is characterised in that: further include that data increase, according to demand Increase data processing is carried out to the database table in the business datum.
5. self-defined report design method as described in claim 1, it is characterised in that: the default report area format statistics Column format and statistical indicator format.
6. a kind of electronic equipment, characterized by comprising: processor;
Memory;And program, wherein described program is stored in the memory, and is configured to be held by processor Row, described program include requiring method described in 1-5 any one for perform claim.
7. a kind of computer readable storage medium, is stored thereon with computer program, it is characterised in that: the computer program quilt Processor executes the method as described in claim 1-5 any one.
8. self-defined report designing system characterized by comprising
Data source modules are defined, the definition data source modules are used for several databases in business datum cited in report Table and several reference fields establish database relation, include several fields and several data in the database table, each described Field is corresponding with each data;The database relation is that the reference field has with the field in the database table Incidence relation;
Data source modules are introduced, the introducing data source modules are used for the database relation, the database table and institute Reference field is stated as reference data source;
Binding shows field module, and the binding shows that field module is used for the reference field in the reference data source It is defined as showing that field, each field shown in field and the database table have the incidence relation;
Querying condition module is quoted, the reference querying condition module is for determining the displaying field according to preset need information Justice is inquiry field, and the field in each inquiry field and the database table has the incidence relation;
Report generation module, for being looked into according to the inquiry field and pre-set constraint condition described in report generation module Inquiry obtains corresponding to the field in the database table, is obtained according to the field corresponding with the field in the database table Data;The data are filled to default report template according to default report area format, obtain target report.
9. self-defined report designing system as claimed in claim 8, it is characterised in that: it further include setting data constraint module, The setting data constraint module is used to be arranged for the inquiry field constraint condition, the constraint condition include querying condition with Query context.
10. self-defined report designing system as claimed in claim 8, it is characterised in that: the binding shows that field further includes Setting shows format, matches corresponding displaying format in default show in format library according to displaying field.
CN201811434275.0A 2018-11-28 2018-11-28 Self-defined report design method, electronic equipment, storage medium and system Pending CN109766338A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201811434275.0A CN109766338A (en) 2018-11-28 2018-11-28 Self-defined report design method, electronic equipment, storage medium and system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201811434275.0A CN109766338A (en) 2018-11-28 2018-11-28 Self-defined report design method, electronic equipment, storage medium and system

Publications (1)

Publication Number Publication Date
CN109766338A true CN109766338A (en) 2019-05-17

Family

ID=66450210

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201811434275.0A Pending CN109766338A (en) 2018-11-28 2018-11-28 Self-defined report design method, electronic equipment, storage medium and system

Country Status (1)

Country Link
CN (1) CN109766338A (en)

Cited By (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110580334A (en) * 2019-09-11 2019-12-17 北京明略软件系统有限公司 Target table template uploading method and device, storage medium and electronic device
CN110750972A (en) * 2019-08-30 2020-02-04 中国铁道科学研究院集团有限公司电子计算技术研究所 Scheduling report information acquisition method and system
CN111104784A (en) * 2019-12-19 2020-05-05 金蝶软件(中国)有限公司 Data integration method and related device
CN111159991A (en) * 2019-12-12 2020-05-15 远光软件股份有限公司 Report modeling design device and method
CN111444293A (en) * 2020-04-17 2020-07-24 重庆市勘测院 Intelligent report generation method for multi-source heterogeneous safety monitoring data
CN111708801A (en) * 2020-05-29 2020-09-25 北京金山云网络技术有限公司 Report generation method and device and electronic equipment
CN112417232A (en) * 2020-12-01 2021-02-26 北京致远互联软件股份有限公司 Data screening subassembly based on Portal designer
CN112835881A (en) * 2021-01-28 2021-05-25 山东浪潮通软信息科技有限公司 Report generation method, system, equipment and medium
CN113255315A (en) * 2021-07-19 2021-08-13 杭州天谷信息科技有限公司 Method and system for configuring and generating evidence chain
CN113962206A (en) * 2021-10-22 2022-01-21 中电金信软件有限公司 Report generation method and device

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1416078A (en) * 2001-10-30 2003-05-07 艾默生网络能源有限公司 Data processing method of monitoring system
US20100287157A1 (en) * 2007-09-11 2010-11-11 Marc Vogel Method of interrogating a database and interrogation device
CN104063361A (en) * 2014-07-04 2014-09-24 用友软件股份有限公司 Report design method and system
CN107391739A (en) * 2017-08-07 2017-11-24 北京奇艺世纪科技有限公司 A kind of query statement generation method, device and electronic equipment

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1416078A (en) * 2001-10-30 2003-05-07 艾默生网络能源有限公司 Data processing method of monitoring system
US20100287157A1 (en) * 2007-09-11 2010-11-11 Marc Vogel Method of interrogating a database and interrogation device
CN104063361A (en) * 2014-07-04 2014-09-24 用友软件股份有限公司 Report design method and system
CN107391739A (en) * 2017-08-07 2017-11-24 北京奇艺世纪科技有限公司 A kind of query statement generation method, device and electronic equipment

Cited By (12)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110750972A (en) * 2019-08-30 2020-02-04 中国铁道科学研究院集团有限公司电子计算技术研究所 Scheduling report information acquisition method and system
CN110580334A (en) * 2019-09-11 2019-12-17 北京明略软件系统有限公司 Target table template uploading method and device, storage medium and electronic device
CN111159991A (en) * 2019-12-12 2020-05-15 远光软件股份有限公司 Report modeling design device and method
CN111159991B (en) * 2019-12-12 2023-06-27 远光软件股份有限公司 Report modeling design device and method
CN111104784A (en) * 2019-12-19 2020-05-05 金蝶软件(中国)有限公司 Data integration method and related device
CN111104784B (en) * 2019-12-19 2024-03-12 金蝶软件(中国)有限公司 Data integration method and related device
CN111444293A (en) * 2020-04-17 2020-07-24 重庆市勘测院 Intelligent report generation method for multi-source heterogeneous safety monitoring data
CN111708801A (en) * 2020-05-29 2020-09-25 北京金山云网络技术有限公司 Report generation method and device and electronic equipment
CN112417232A (en) * 2020-12-01 2021-02-26 北京致远互联软件股份有限公司 Data screening subassembly based on Portal designer
CN112835881A (en) * 2021-01-28 2021-05-25 山东浪潮通软信息科技有限公司 Report generation method, system, equipment and medium
CN113255315A (en) * 2021-07-19 2021-08-13 杭州天谷信息科技有限公司 Method and system for configuring and generating evidence chain
CN113962206A (en) * 2021-10-22 2022-01-21 中电金信软件有限公司 Report generation method and device

Similar Documents

Publication Publication Date Title
CN109766338A (en) Self-defined report design method, electronic equipment, storage medium and system
CN106407404B (en) Date storage method, data managing method and system, database, client
CN110292775B (en) Method and device for acquiring difference data
CN104462421B (en) Multi-tenant extended method based on key-value database
CN108228817A (en) Data processing method, device and system
US20100131570A1 (en) Methods and structures for utilizing reusable custom-defined nestable compound data types to permit product variations within an exisitng taxonomy
CN110032604A (en) Data storage device, transfer device and data bank access method
CN104063361A (en) Report design method and system
EP3617910A1 (en) Method and apparatus for displaying textual information
US20160026708A1 (en) Selection of data storage settings for an application
CN104951565B (en) XM (extensible messaging client) L (extensible markup language) configuration maintenance method and system based on memory database
CN108009254A (en) More indexing means and device, cloud system and computer-readable recording medium
Toomey R for data science
CN115794641A (en) Method, device and equipment for making number based on business process and storage medium
CN114155921A (en) Configuration method and device of medical form, computer equipment and storage medium
CN113934839A (en) Method, equipment and storage medium for volume grouping according to knowledge points
US8296326B1 (en) Grid-based user interface techniques for interacting with nested hierarchical data structures
US20110246455A1 (en) Data search device, data search method, and recording medium
CN110209780A (en) A kind of question template generation method, device, server and storage medium
Choi et al. Ensuring content validity of patient-reported outcomes: a shadow-test approach to their adaptive measurement
CN117390011A (en) Report data processing method, device, computer equipment and storage medium
CN111523174A (en) Automatic drawing method, system, equipment and storage medium for holes in ship drawing
CN109976719A (en) A kind of design method of management system, electronic equipment, storage medium and platform
CN109101544A (en) Heating power drawing generating method, calculates equipment and readable storage medium storing program for executing at device
CN109960553A (en) A kind of more window context rendering methods and system

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
RJ01 Rejection of invention patent application after publication

Application publication date: 20190517