CN103064689A - Implementation method and system for dynamically generating report pages - Google Patents
Implementation method and system for dynamically generating report pages Download PDFInfo
- Publication number
- CN103064689A CN103064689A CN2013100010808A CN201310001080A CN103064689A CN 103064689 A CN103064689 A CN 103064689A CN 2013100010808 A CN2013100010808 A CN 2013100010808A CN 201310001080 A CN201310001080 A CN 201310001080A CN 103064689 A CN103064689 A CN 103064689A
- Authority
- CN
- China
- Prior art keywords
- report
- data
- query
- generating
- style
- 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
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses implementation method and system for dynamically generating report pages. The method includes: setting a functional frame of a dynamic report as required; establishing a data model of the dynamic report based on the functional frame; generating a report query page according to report configuration data, and selecting a report display form according to query conditions; querying the report data; selecting the form containing header and index data according to the query conditions; and generating a two-dimensional table of report display result according to the user-selected form, filling with report result data, and generating a final report form. Same data can be displayed through similar report forms by the method and system, so that report number is decreased and management is facilitated. The data are displayed according to the customized report form in the query stage. Therefore, the requirement for counting same data of similar table forms at different levels is met, the number of reports is decreased greatly, and the reports are easy to manage, maintain nd use.
Description
Technical field
The present invention relates to information processing and display technique field, specifically, relate to a kind of implementation method and system of the Dynamic Generating Report page.
Background technology
A large amount of report capabilities are provided in the products such as sector application and internet, have two class problems for the part form:
The data of report form statistics are constant, but the as required usually to some extent change of the pattern of form.
Identical data are because the granularity of statistics is different, but the table sample is identical.The form development scheme of a form of one of traditional fixedly report style table sample causes the form quantity huge not manageability that becomes.
Propose to realize that for above two problems a cover by dynamic table sample generating report forms framework, can make the user in the inquiry phase, the table sample generating report forms that User is selected.
A kind of report form generation method and the platform that provide in the prior art, come organising data, extract the data binding of data model definition, based on data collection model and the transformation rule configuration of structure of report with a kind of data set model according to the service feature definition, and by report generation engine automatic report generation example, form a kind of method of generating report forms.Come the organising data item by the derived relation between the data item and expansion relation, and when data binding, specify the data item attribute that need to be tied in the report form template by path expression.Contingent variation when generating defines to structure of report, and structure of report is adjusted according to the Structural Transformation rule by the report generation engine, only need by adding new Structural Transformation rule, namely can be data and increase new exhibition method, need not recompile, improved the extensibility of system, like this, the user can adopt different ways of presentation according to the feature of different pieces of information, and the ability to express of form increases.
In addition, also have in the prior art a kind of custom dynamic report system be by custom dynamic report by data Layer, operation layer, definition layer and represent the layer consist of, the implementation procedure of custom dynamic report is: according to form requirement definition report form type; According to report form type definition XML configuration file; Obtain profile information by operation layer analyzing XML configuration file, it is the EXCEL template file that while loading in Installed System Memory represents layer, to form common form; According to profile information, obtain raw data and be processed into report data from data Layer; With report data with represent the layer be after the EXCEL template file is combined, generating report forms in Installed System Memory; According to profile information the form that generates is disposed to get form.The present invention can make the enforcement of reporting system and maintenance cost significantly reduce, and can satisfy changeable form demand by simple configuration, makes simply, has certain practicality.
Such as existing ripe form product on above-mentioned two kinds of form implementations of the prior art and the market or be integrated in report frame in projects, all be to represent form by fixing report style mode, there is no the solution of Dynamic Generating Report pattern feasible on the realistic meaning.
Summary of the invention
The invention provides a kind of implementation method of the Dynamic Generating Report page, can pass through dynamic table sample generating report forms framework, make the user in the inquiry phase, but the table sample generating report forms that User is selected.
The invention provides a kind of implementation method of the Dynamic Generating Report page, comprising:
The functional framework of dynamic statement is set according to demand, and this functional framework has form Back ground Information, form dimension, report data query engine, report query page generation engine, report generation engine;
Make up the data model of described dynamic statement based on described functional framework;
According to form configuration data generating report forms query page, and according to the user input query condition, select to represent report style;
Report data inquiry: according to the querying condition that obtains, comprise gauge outfit and achievement data to select pattern;
Report generation: according to the user selection pattern, the relevant dimension table data generating report forms of inquiry represents result's bivariate table, and fills the form result data, generates final report style.
The present invention also provides a kind of system that realizes the Dynamic Generating Report page, comprising:
Form Back ground Information module is used for arranging and preserving the form Back ground Information, comprises report name, data query table, and querying condition and Query Result;
The report data enquiry module is used for according to form predefine query aim tables of data, the user input query condition, and user selection form dimension dynamically generates SQL statement, generates key-value pair mapping (enum) data collection according to the user selection dimension;
Report query page generation module is used for according to form configuration data generating report forms query page, and according to the user input query condition, selects to represent report style;
The report generation module is used for representing report style according to user selection and generates whole report style, and uses the Query Result that comprises dimensional information, fills each cell of generating report forms pattern.
In sum, technical scheme provided by the invention arranges the functional framework of dynamic statement according to demand; Make up the data model of corresponding dynamic statement based on functional framework; According to form configuration data generating report forms query page, select to represent report style; Report data inquiry: according to querying condition, comprise gauge outfit and achievement data to select pattern; The relevant dimension table data generating report forms of inquiry represents result's bivariate table, and fills the form result data, generates final report style.According to the present invention, can realize that the table sample that identical data communication device is crossed roughly the same represents, reduce the convenient management of form quantity.Can design a cover Making Dynamic Report Forms framework according to the present invention, at development phase design dynamic table sample, carry out data exhibiting in inquiry phase by User Defined generating report forms pattern.So both satisfied the requirement of similar table sample different stage statistics identical data, can significantly reduce form quantity again simultaneously, thereby so that form is easy to management, safeguarded and use.
Description of drawings
Fig. 1 is the implementation method process flow diagram of the Dynamic Generating Report page provided by the invention;
The functional framework synoptic diagram of the dynamic statement that provides in the specific embodiments of the present invention is provided Fig. 2;
The data model figure of the dynamic statement that provides in the specific embodiments of the present invention is provided Fig. 3;
Fig. 4 is the overall flow figure of dynamic statement displaying interface in the embodiment of the invention;
Fig. 5 is that generating report forms provided by the invention represents as a result bivariate table;
Fig. 6 is generated final report style figure by filling the form result data in the embodiment of the invention;
A kind of system architecture synoptic diagram of realizing the Dynamic Generating Report page of Fig. 7 for providing in the embodiment of the invention;
Fig. 8 is the query page figure of dynamic statement in the embodiment of the invention;
Fig. 9 is the interface synoptic diagram of selecting in the embodiment of the invention to represent behind the pattern.
Terminological interpretation:
Form: the chart and figure that dynamically shows statistics.
Literal form: the form that uses the mode demonstrating data of literal and numerical value.
Pictorial statement: the form that uses the patterned way demonstrating data.
Report heading: be used for the cell data that definition represents row or represents the row content title in the literal form.
Data field: the cell zone that is used for representing report data in the form.
Dimension: one group of data acquisition of enumerating that contains the particular service implication.
Embodiment
In view of the form that provides in the prior art exists defective and deficiency, use form to experience in order to strengthen the user, control simultaneously form quantity and make things convenient for keeper's Report Server Management to safeguard, design and develop a cover dynamic statement framework, be implemented in the user when the inquiry form, Query Result table sample defined by the user.The invention provides a kind of implementation method of the Dynamic Generating Report page, can pass through dynamic table sample generating report forms framework, make the user in the inquiry phase, but the table sample generating report forms that User is selected.
Dynamically pattern report frame core mainly solves two problems: the automatic generation of table sample and the filling of data.The generation of table sample generates a bivariate table by taking in the upper left corner as initial point according to carrying out the data expansion with user selection transverse dimensions and vertical dimension data.When generating bivariate table, the data coordinates of each cell has just been determined (X, Y)=(row dimension value, row dimension value).In the data query result, comprise this two parts dimension data, carry out the data stuffing of corresponding dimension behind the generation bivariate table framework, last generating report forms.
With reference to Fig. 1, the implementation method of a kind of Dynamic Generating Report page provided by the invention comprises:
S01 arranges the functional framework of dynamic statement according to demand;
This functional framework has form Back ground Information, form dimension, report data query engine, report query page generation engine, report generation engine;
S02 makes up the data model of described dynamic statement based on described functional framework;
This data model specifically comprises:
Entity form Back ground Information table, statistical report form querying condition table, statistical report form gauge outfit information table, report form statistics indication information table, dimensional information definition list and report query page style sheet.
S03 according to form configuration data generating report forms query page, and according to the user input query condition, selects to represent report style;
S04, report data inquiry: according to the querying condition that obtains, comprise gauge outfit and achievement data to select pattern;
S05, report generation: according to the user selection pattern, the relevant dimension table data generating report forms of inquiry represents result's bivariate table, and fills the form result data, generates final report style.
The query page of generating report forms described in the step S03 specifically comprises:
In page generative process, the configure base data-mapping is converted to the html element element, and carries out interface element according to user's definition of order and put, and generate corresponding verification rule according to querying condition configuration data type; For drop-down data frame, the relevant dimension table of inquiry carries out initialization to candidate's conditional value.
The query steps of report data described in the step S04 specifically comprises:
When report query, according to form predefine query aim tables of data, user input query condition, the dynamic generating structured query language of user selection form dimension (SQL, Structured Query Language) statement generates key-value pair mapping (enum) data collection according to the user selection dimension.
The step of report generation described in the step S05 comprises: specifically carry out report style and generate, represent report style according to user selection and generate whole report style; And the report data filling, use the Query Result that comprises dimensional information, fill each cell of generating report forms pattern.
More specifically, the inquiry of report data described in the step S04 specifically comprises:
According to the querying condition of input, demonstrating data, report heading generates SQL statement;
According to the SQL statement that generates, data query return results data set;
Generate key-value pair mapping (enum) data collection according to Query Result data set and option table header.
More specifically, the step of report generation specifically comprises described in the step S05:
According to the user selection pattern, the relevant dimension table data generating report forms of inquiry represents result's bivariate table;
According to key-value pair mapping (enum) data collection and bivariate table data coordinates, fill the form result data, generate final report style.
The method further comprises:
S06 after generating final report style, becomes the data stream of predetermined format to flow to browser data-switching.
For making principle of the present invention, characteristic and advantage clearer, describe the present invention below in conjunction with specific embodiment.
The implementation method of a kind of Dynamic Generating Report page provided by the invention mainly comprises two parts: construction of data model and maintenance and displaying interface.
Construction of data model and maintenance, specific as follows:
The functional framework of dynamic statement is set at first, according to demand;
Figure 2 shows that the functional framework synoptic diagram of dynamic statement provided by the invention, with reference to Fig. 2, the functional module that has comprises:
Form Back ground Information module:
Be used for the form Back ground Information is set, comprise report name, the data query table; Form comprises querying condition and alternative report heading.
Form dimension definition module:
Be used for defining all dimensional information that report frame uses.
The report data enquiry module:
When report query, according to form predefine query aim tables of data, the user input query condition, user selection form dimension dynamically generates SQL statement, generates the mapping (enum) data collection according to the user selection dimension.
Report query page generation module:
According to report definition information, the querying condition that comprises and candidate's report heading generated query condition page.
The report generation module:
Mainly be divided into two parts function: report style generates and report data is filled.Report style generates, and represents report style according to user selection and generates whole report style; Report data is filled, and uses the Query Result that comprises dimensional information, fills each cell of generating report forms pattern.
Secondly, make up the data model of described dynamic statement based on described functional framework;
As shown in Figure 3, the data model of whole dynamic statement comprises entity form Back ground Information table, statistical report form querying condition table, statistical report form gauge outfit information table, report form statistics indication information table, dimensional information definition list and report query page style sheet, functions is described as follows:
Form Back ground Information table: definition report name, data query table, the Back ground Information of demonstration title etc.
Statistical report form querying condition table: the definition form comprises querying condition information, comprises the display Name of querying condition, interface element display type, data type and put in order etc.A form comprises the multiple queries condition.Each querying condition can corresponding dimension, and the dimension table corresponding data is as candidate's querying condition candidate data.
Statistical report form gauge outfit information table: definition form gauge outfit information to be selected.Every corresponding dimensional information of gauge outfit information when being used for the generating report forms pattern, is carried out the data expansion.Every corresponding a plurality of statistics gauge outfit data of form.
Report form statistics indication information table: the index of definition report query form, i.e. concrete business datum in the form.Such as sales volume, sales volume all is a statistical indicator.
Report query page style sheet: be used for preserving the designated user report style.For dynamic statement pattern commonly used, the user can be stored as the default style, and acquiescence loads when using form, is user-friendly to.
Dimensional information definition list: be used for defining all dimension datas that use of report frame.Dimension is one group of data acquisition of enumerating that contains the particular service implication, and the form of expression is tables of data in operation system, and such as department information, personal information, product type all are dimensions.In this table, safeguard and supply with querying condition, be used for the data expansion during generating report forms pattern.
The displaying interface flow process:
Dynamic statement displaying interface overall flow comprises as shown in Figure 4:
The report query page generates: according to form configuration data generating report forms query page, and according to the user input query condition, select to represent report style;
Report data inquiry: according to the querying condition that obtains, comprise gauge outfit and achievement data to select pattern; Specifically comprise:
When report query, according to form predefine query aim tables of data, the user input query condition, user selection form dimension dynamically generates SQL statement, generates key-value pair mapping (enum) data collection according to the user selection dimension.
Report generation: according to the user selection pattern, the relevant dimension table data generating report forms of inquiry represents result's bivariate table;
According to the set of key-value pair mapping (enum) data and bivariate table data coordinates, fill the form result data, generate final report style.
Further comprise:
After generating final report style, become the data stream (such as html stream) of predetermined format to flow to browser data-switching.
The concrete operations flow process of displaying interface is as follows:
1), the user enters report frame.Report frame is according to form coded query report query conditions and the gauge outfit Information generation report query page to be selected.In page generative process, finish the configure base data to the mapping generation of html element element, and carry out interface element according to user's definition of order and put, generate corresponding verification rule JavaScript according to querying condition configuration data type simultaneously.For drop-down data frame, the relevant dimension table of inquiry carries out initialization to candidate's conditional value.
2), the user input query condition, select to represent report style.
3), click inquire button, execution inquiry.
4), the report data query engine obtains foreground input form coded query report query tables of data title, and according to obtaining the querying condition data, selected pattern to comprise gauge outfit and achievement data, generates SQL statement.The SQL statement create-rule meets the SQL grammer.
5), according to generating SQL statement, data query, return results collection.
6), generate key-value pair mapping (enum) data collection according to Query Result data set and option table header, with every query note generation key-value pair data.
The Map create-rule is as follows:
Map
=Collection(KEY=tabulation head value 1: tabulation head value 2: ... a tabulation N: row gauge outfit value 1: row gauge outfit value 2: row gauge outfit value N ... statistical indicator 1, VALUE=Query Result numerical value)
7), according to the user selection pattern, the relevant dimension table data generating report forms of inquiry represents as a result bivariate table; As shown in Figure 5.
Whole form form is to be initial point with the upper left corner, carries out horizontal and vertical data extending.With the capable gauge outfit of user selection and the gauge outfit data of a tabulation whole tables of data of data expansion generation.
8), according to Map data and bivariate table data coordinates, fill the form result data, generate final report style, as shown in Figure 6.
Wherein, the padding data algorithm in the specific embodiments is as follows:
Every item number certificate that the data field represents is a cell, and each cell can identify by row gauge outfit and tabulation head the position of each cell for coordinate figure.The coordinate of each cell: (X, Y)=(a tabulation data combination, the combination of row gauge outfit data).Thereby set up the key-value pair mapping relations that show data with cell according to this coordinate defining relation, wherein key is the character string that row gauge outfit, a tabulation data and statistical indicator form, and is worth to be the report display real data.
Form is as follows:
Map=Collection(KEY=tabulation head value 1: tabulation head value 2: ... a tabulation N: row gauge outfit value 1: row gauge outfit value 2: row gauge outfit value N ... statistical indicator 1, VALUE=Query Result numerical value)
The MAP data that inquiry is returned according to step 6, and above rule is carried out the data stuffing of data field.And the gauge outfit adjacent data represented merging.
9), html stream exports browser to, represents final form.
As shown in Figure 7, the present invention also provides a kind of system 700 that realizes the Dynamic Generating Report page, comprising:
Form Back ground Information module 71 is used for arranging and preserving the form Back ground Information, comprises report name, data query table, and querying condition and Query Result;
Report data enquiry module 72 is used for according to form predefine query aim tables of data, the user input query condition, and user selection form dimension dynamically generates SQL statement, generates the Map data set according to the user selection dimension;
Report query page generation module 73 is used for according to form configuration data generating report forms query page, and according to the user input query condition, selects to represent report style;
Concrete application example
The below is take the fruit and vegetable form as example descriptive statement generative process:
The 1st step: fruit and vegetable is sold statistics forecast of sales and inputs as customer demand, and it is as follows to take out dimensional information according to the table sample:
Economize: Hebei, Jiangsu.
The city: Shijiazhuang, Baoding, Langfang are under the jurisdiction of Hebei; Nanjing, Suzhou, Nantong, Zhenjiang are under the jurisdiction of Jiangsu.
Statistics kind: fruit, vegetables.
The statistics subclass: banana, apple, pear are under the jurisdiction of fruit; Celery, wild cabbage are under the jurisdiction of vegetables.
Provide functional configuration querying condition basic data according to dynamic statement, the click function point enters query page, and the result as shown in Figure 8;
The user fills in querying condition, select to represent behind the pattern the interface as shown in Figure 9;
The 2nd step: according to the pattern of user selection: definition province, city are the row gauge outfit, and statistics kind and statistics subclass are the tabulation head.Definition is as a result shown in the table 1.
Table 1
| KEY | VALUE | KEY | VALUE |
| Fruit: banana: Hebei: Shijiazhuang | 999.9 | Vegetables: celery: Hebei: Shijiazhuang | 999.9 |
| Fruit: banana: Hebei: Baoding | 999.9 | Vegetables: celery: Hebei: Baoding | 999.9 |
| Fruit: banana: Hebei: Langfang | 999.9 | Vegetables: celery: Hebei: Langfang | 999.9 |
| Fruit: banana: Jiangsu: Nanjing | 999.9 | Vegetables: celery: Jiangsu: Nanjing | 999.9 |
| Fruit: banana: Jiangsu: Suzhou | 999.9 | Vegetables: celery: Jiangsu: Suzhou | 999.9 |
| Fruit: banana: Jiangsu: Nantong | 999.9 | Vegetables: celery: Jiangsu: Nantong | 999.9 |
| Fruit: banana: Jiangsu: Zhenjiang | 999.9 | Vegetables: celery: Jiangsu: Zhenjiang | 999.9 |
| Fruit: apple: Hebei: Shijiazhuang | 999.9 | Vegetables: wild cabbage: Hebei: Shijiazhuang | 999.9 |
| Fruit: apple: Hebei: Baoding | 999.9 | Vegetables: wild cabbage: Hebei: Baoding | 999.9 |
| Fruit: apple: Hebei: Langfang | 999.9 | Vegetables: wild cabbage: Hebei: Langfang | 999.9 |
| Fruit: apple: Jiangsu: Nanjing | 999.9 | Vegetables: wild cabbage: Jiangsu: Nanjing | 999.9 |
| Fruit: apple: Jiangsu: Suzhou | 999.9 | Vegetables: wild cabbage: Jiangsu: Suzhou | 999.9 |
| Fruit: apple: Jiangsu: Nantong | 999.9 | Vegetables: wild cabbage: Jiangsu: Nantong | 999.9 |
| Fruit: apple: Jiangsu: Zhenjiang | 999.9 | Vegetables: wild cabbage: Jiangsu: Zhenjiang | 999.9 |
| Fruit: pear: Hebei: Shijiazhuang | 999.9 | Fruit: pear: Jiangsu: Nanjing | 999.9 |
| Fruit: pear: Hebei: Baoding | 999.9 | Fruit: pear: Jiangsu: Suzhou | 999.9 |
| Fruit: pear: Hebei: Langfang | 999.9 | Fruit: pear: Jiangsu: Nantong | 999.9 |
| Fruit: pear: Jiangsu: Zhenjiang | 999.9 | ? | ? |
The 3rd step: generate SQL statement according to the input inquiry condition and carry out inquiry, generate the MAP data.The result is as shown in table 2.
Table 2
The 4th step: the capable gauge outfit according to definition is expanded, and it is as shown in table 3 to generate gauge outfit data and corresponding form dimension KEY Value Data result.
Table 3
Then its adjacent data are merged, represent and beautify, generate form shown in the table 4.
Table 4
The 5th step: fill according to the data that Query Result generates, generate final demonstrating data, as shown in table 5.
Table 5
The core value of dynamic statement just is the user, selects the pattern that represents of form before inquiry, rather than fixed pattern when designing and developing.Top example has just illustrated a kind of possibility that represents.According to the capable gauge outfit of user selection and the different of head of tabulating, the report style of generation is also different, but use is same form.
The equally explanation as an example of the fruit and vegetable form example of the below, select pattern and the relation that represents the result:
Example 1:
The user selection pattern:
The report form showing pattern:
| The statistics kind | Hebei | Jiangsu |
| Vegetables | 2000 | 3000 |
| Fruit | 3000 | 2000 |
Example 2:
The user selection pattern:
The report form showing pattern:
Although the present invention with preferred embodiment openly as above; but it is not to limit the present invention; any those skilled in the art without departing from the spirit and scope of the present invention; can make possible change and modification, so protection scope of the present invention should be as the criterion with the scope that claim of the present invention was defined.
Claims (9)
1. the implementation method of a Dynamic Generating Report page is characterized in that, comprising:
The functional framework of dynamic statement is set according to demand, and this functional framework has form Back ground Information, form dimension, report data query engine, report query page generation engine, report generation engine;
Make up the data model of described dynamic statement based on described functional framework;
According to form configuration data generating report forms query page, and according to the user input query condition, select to represent report style;
Report data inquiry: according to the querying condition that obtains, comprise gauge outfit and achievement data to select pattern;
Report generation: according to the user selection pattern, the relevant dimension table data generating report forms of inquiry represents result's bivariate table, and fills the form result data, generates final report style.
The method of claim 1, it is characterized in that described data model specifically comprises:
Entity form Back ground Information table, statistical report form querying condition table, statistical report form gauge outfit information table, report form statistics indication information table, dimensional information definition list and report query page style sheet.
3. the method for claim 1, it is characterized in that, described report data query engine is when report query, according to form predefine query aim tables of data, the user input query condition, the dynamic generating structured query language of user selection form dimension SQL statement generates key-value pair mapping (enum) data collection according to the user selection dimension.
4. the method for claim 1 is characterized in that, described generating report forms query page specifically comprises:
In page generative process, the configure base data-mapping is converted to the html element element, and carries out interface element according to user's definition of order and put, and generate corresponding verification rule according to querying condition configuration data type; For drop-down data frame, the relevant dimension table of inquiry carries out initialization to candidate's conditional value.
5. the method for claim 1 is characterized in that, described report generation engine is specifically carried out report style and generated, and represents report style according to user selection and generates whole report style; And the report data filling, use the Query Result that comprises dimensional information, fill each cell of generating report forms pattern.
6. the method for claim 1 is characterized in that, described report data inquiry specifically comprises:
According to the querying condition of input, demonstrating data, report heading generates SQL statement;
According to the SQL statement that generates, data query return results data set;
Generate the key-value pair mapping (enum) data according to Query Result data set and option table header.
7. method as claimed in claim 6 is characterized in that, the step of described report generation specifically comprises:
According to the user selection pattern, the relevant dimension table data generating report forms of inquiry represents result's bivariate table;
According to key-value pair mapping (enum) data and bivariate table data coordinates, fill the form result data, generate final report style.
8. such as claim 1 or 7 described methods, it is characterized in that, further comprise:
After generating final report style, become the data stream of predetermined format to flow to browser data-switching.
9. a system that realizes the Dynamic Generating Report page is characterized in that, comprising:
Form Back ground Information module is used for arranging and preserving the form Back ground Information, comprises report name, data query table, and querying condition and Query Result;
The report data enquiry module is used for according to form predefine query aim tables of data, the user input query condition, and the dynamic generating structured query language of user selection form dimension SQL statement generates key-value pair mapping (enum) data collection according to the user selection dimension;
Report query page generation module is used for according to form configuration data generating report forms query page, and according to the user input query condition, selects to represent report style;
The report generation module is used for representing report style according to user selection and generates whole report style, and uses the Query Result that comprises dimensional information, fills each cell of generating report forms pattern.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310001080.8A CN103064689B (en) | 2013-01-04 | 2013-01-04 | The implementation method of a kind of Dynamic Generating Report page and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310001080.8A CN103064689B (en) | 2013-01-04 | 2013-01-04 | The implementation method of a kind of Dynamic Generating Report page and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103064689A true CN103064689A (en) | 2013-04-24 |
| CN103064689B CN103064689B (en) | 2016-06-01 |
Family
ID=48107327
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310001080.8A Active CN103064689B (en) | 2013-01-04 | 2013-01-04 | The implementation method of a kind of Dynamic Generating Report page and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103064689B (en) |
Cited By (48)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103473316A (en) * | 2013-09-11 | 2013-12-25 | 北京思特奇信息技术股份有限公司 | Data column dynamically displaying method and device |
| CN103559292A (en) * | 2013-11-07 | 2014-02-05 | 大连东方之星信息技术有限公司 | Method for dynamically establishing and displaying multiple levels of forms in customized mode |
| CN103631969A (en) * | 2013-12-20 | 2014-03-12 | 北京中电普华信息技术有限公司 | Generation method and device of report data |
| CN103631764A (en) * | 2013-12-18 | 2014-03-12 | 用友软件股份有限公司 | Report design method based on extension mechanism |
| CN103646100A (en) * | 2013-12-20 | 2014-03-19 | 北京中电普华信息技术有限公司 | Report data organization model |
| CN103745301A (en) * | 2013-12-16 | 2014-04-23 | 远光软件股份有限公司 | Statement figure acquisition setting method and device based on statement dimension |
| CN104036040A (en) * | 2014-06-30 | 2014-09-10 | 贝壳网际（北京）安全技术有限公司 | Method and device for generating report |
| CN104133826A (en) * | 2013-09-26 | 2014-11-05 | 腾讯科技（深圳）有限公司 | Method for creating data report business, relevant device and business system |
| WO2015010564A1 (en) * | 2013-07-22 | 2015-01-29 | Tencent Technology (Shenzhen) Company Limited | Data report process method and device thereof |
| CN104376068A (en) * | 2014-11-07 | 2015-02-25 | 北京思特奇信息技术股份有限公司 | Data representation system and method based on dynamic report template |
| CN104572813A (en) * | 2014-11-26 | 2015-04-29 | 国家电网公司 | Report generation method and device |
| CN104616134A (en) * | 2015-01-23 | 2015-05-13 | 北京京东尚科信息技术有限公司 | Statement analysis report pushing method and device |
| CN104866589A (en) * | 2015-05-28 | 2015-08-26 | 北京京东尚科信息技术有限公司 | Method and device for generating data report |
| CN104915378A (en) * | 2015-05-08 | 2015-09-16 | 珠海世纪鼎利通信科技股份有限公司 | Rapid statistics task generation system and method suitable for big data |
| CN105138501A (en) * | 2015-08-10 | 2015-12-09 | 北京思特奇信息技术股份有限公司 | Configurable dynamic report generating method and system |
| CN105243022A (en) * | 2015-11-10 | 2016-01-13 | 中国建设银行股份有限公司 | Method and device for analyzing performance data of host application software system |
| CN105677625A (en) * | 2014-11-21 | 2016-06-15 | 中国科学院沈阳自动化研究所 | Processing method for cooperatively filling multi-tier summarized statistical forms |
| CN105808228A (en) * | 2014-12-31 | 2016-07-27 | 青岛中科软件股份有限公司 | Generation method of dynamic configuration statement |
| CN105843945A (en) * | 2016-04-08 | 2016-08-10 | 联动优势科技有限公司 | Report generation method and system |
| CN105868310A (en) * | 2016-03-25 | 2016-08-17 | 联想(北京)有限公司 | Data processing method and device and electronic device |
| CN106372048A (en) * | 2016-08-30 | 2017-02-01 | 北京北信源软件股份有限公司 | Report generation system and report generation method |
| CN106406835A (en) * | 2015-07-30 | 2017-02-15 | 大唐软件技术股份有限公司 | Report generation method and report generation apparatus |
| CN106776773A (en) * | 2016-11-11 | 2017-05-31 | 苏州华元世纪科技发展有限公司 | A kind of Dynamic data display system and method |
| CN106844324A (en) * | 2017-02-22 | 2017-06-13 | 浪潮通用软件有限公司 | It is a kind of to change the method that column data exports as Excel forms |
| CN106933904A (en) * | 2015-12-31 | 2017-07-07 | 北京国双科技有限公司 | The filter method and device of data |
| CN107169050A (en) * | 2017-04-26 | 2017-09-15 | 燕山大学 | A kind of customized Web forms implementation method of pattern |
| CN107609109A (en) * | 2017-09-13 | 2018-01-19 | 山东浪潮云服务信息科技有限公司 | A kind of report form generation method, device and system |
| CN107832282A (en) * | 2017-11-21 | 2018-03-23 | 苏州正载信息技术有限公司 | A kind of implementation method for defining Visual Report Forms |
| CN108268525A (en) * | 2016-12-30 | 2018-07-10 | 深圳市优朋普乐传媒发展有限公司 | A kind of report implementation method and device based on Excel template |
| CN108388550A (en) * | 2017-11-14 | 2018-08-10 | 深圳市瑞艾特科技有限公司 | Full Dynamic Generating Report implementation method, system and equipment based on Stimulsoft |
| CN108446309A (en) * | 2018-02-05 | 2018-08-24 | 深圳市资本在线金融信息服务有限公司 | The application process and device of WEB intelligent report forms |
| CN108572945A (en) * | 2018-03-09 | 2018-09-25 | 吉贝克信息技术（北京）有限公司 | Create method, system, storage medium and the electronic equipment of report |
| CN108595394A (en) * | 2018-03-21 | 2018-09-28 | 上海蔚界信息科技有限公司 | A kind of rapid build scheme of text analyzing report |
| CN108664638A (en) * | 2018-05-15 | 2018-10-16 | 口碑(上海)信息技术有限公司 | Report form generation method based on index system and device |
| CN109299450A (en) * | 2018-10-31 | 2019-02-01 | 上海用天网络科技有限公司 | Dynamic statement method for exhibiting data in a kind of business management software |
| CN109344375A (en) * | 2018-08-24 | 2019-02-15 | 周宁 | A kind of report tool and method based on office software |
| CN109508352A (en) * | 2018-11-16 | 2019-03-22 | 苏州好玩友网络科技有限公司 | A kind of output method of report data, device, equipment and storage medium |
| CN109947861A (en) * | 2017-11-09 | 2019-06-28 | 北京京东尚科信息技术有限公司 | The method, apparatus and computer-readable medium of object table are generated for data warehouse |
| 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 |
| CN110674195A (en) * | 2019-09-27 | 2020-01-10 | 山东浪潮通软信息科技有限公司 | Form-based query method |
| CN111078679A (en) * | 2019-12-23 | 2020-04-28 | 用友网络科技股份有限公司 | Data report generation method and device and computer readable storage medium |
| CN111104108A (en) * | 2018-10-29 | 2020-05-05 | 大唐移动通信设备有限公司 | Display interface WPF generation method and device |
| CN111291544A (en) * | 2020-01-13 | 2020-06-16 | 中国建设银行股份有限公司 | Report generation method and device, electronic equipment and storage medium |
| CN112036118A (en) * | 2020-07-03 | 2020-12-04 | 山东浪潮通软信息科技有限公司 | Configurable dynamic data report display method and system |
| CN112905687A (en) * | 2021-03-26 | 2021-06-04 | 深圳壹账通智能科技有限公司 | Data conversion method and device, electronic equipment and storage medium |
| WO2021212386A1 (en) * | 2020-04-22 | 2021-10-28 | 深圳市欢太科技有限公司 | Method and apparatus for creating custom report form, electronic device and storage medium |
| CN114490702A (en) * | 2020-10-26 | 2022-05-13 | 陕西省烟草公司渭南市公司 | Dynamic generation method of production data coordinate graph in discrete manufacturing industry |
| CN115544130A (en) * | 2022-11-30 | 2022-12-30 | 广州天维信息技术股份有限公司 | Performance report generation method and device, storage medium and computer equipment |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101021839A (en) * | 2007-03-23 | 2007-08-22 | 北京润乾信息系统技术有限公司 | Nonlinear report generating method |
| US20070239508A1 (en) * | 2006-04-07 | 2007-10-11 | Cognos Incorporated | Report management system |
| CN102222105A (en) * | 2011-06-23 | 2011-10-19 | 公安部交通管理科学研究所 | Method for generating real-time statistical report |
-
2013
- 2013-01-04 CN CN201310001080.8A patent/CN103064689B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070239508A1 (en) * | 2006-04-07 | 2007-10-11 | Cognos Incorporated | Report management system |
| CN101021839A (en) * | 2007-03-23 | 2007-08-22 | 北京润乾信息系统技术有限公司 | Nonlinear report generating method |
| CN102222105A (en) * | 2011-06-23 | 2011-10-19 | 公安部交通管理科学研究所 | Method for generating real-time statistical report |
Cited By (72)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2015010564A1 (en) * | 2013-07-22 | 2015-01-29 | Tencent Technology (Shenzhen) Company Limited | Data report process method and device thereof |
| CN103473316A (en) * | 2013-09-11 | 2013-12-25 | 北京思特奇信息技术股份有限公司 | Data column dynamically displaying method and device |
| CN104133826A (en) * | 2013-09-26 | 2014-11-05 | 腾讯科技（深圳）有限公司 | Method for creating data report business, relevant device and business system |
| CN103559292A (en) * | 2013-11-07 | 2014-02-05 | 大连东方之星信息技术有限公司 | Method for dynamically establishing and displaying multiple levels of forms in customized mode |
| CN103745301B (en) * | 2013-12-16 | 2017-05-24 | 远光软件股份有限公司 | Statement figure acquisition setting method and device based on statement dimension |
| CN103745301A (en) * | 2013-12-16 | 2014-04-23 | 远光软件股份有限公司 | Statement figure acquisition setting method and device based on statement dimension |
| CN103631764A (en) * | 2013-12-18 | 2014-03-12 | 用友软件股份有限公司 | Report design method based on extension mechanism |
| CN103631764B (en) * | 2013-12-18 | 2016-09-14 | 用友网络科技股份有限公司 | Report design method based on extension mechanism |
| CN103631969B (en) * | 2013-12-20 | 2016-12-28 | 北京中电普华信息技术有限公司 | A kind of generation method and device of report data |
| CN103631969A (en) * | 2013-12-20 | 2014-03-12 | 北京中电普华信息技术有限公司 | Generation method and device of report data |
| CN103646100A (en) * | 2013-12-20 | 2014-03-19 | 北京中电普华信息技术有限公司 | Report data organization model |
| CN104036040B (en) * | 2014-06-30 | 2017-11-03 | 北京猎豹移动科技有限公司 | Report form generation method and device |
| CN104036040A (en) * | 2014-06-30 | 2014-09-10 | 贝壳网际（北京）安全技术有限公司 | Method and device for generating report |
| CN104376068A (en) * | 2014-11-07 | 2015-02-25 | 北京思特奇信息技术股份有限公司 | Data representation system and method based on dynamic report template |
| CN104376068B (en) * | 2014-11-07 | 2018-04-03 | 北京思特奇信息技术股份有限公司 | A kind of data exhibiting system and method based on dynamic statement template |
| CN105677625B (en) * | 2014-11-21 | 2019-03-26 | 中国科学院沈阳自动化研究所 | Processing method is made a report in the collaboration of multi-layer collect statistics report |
| CN105677625A (en) * | 2014-11-21 | 2016-06-15 | 中国科学院沈阳自动化研究所 | Processing method for cooperatively filling multi-tier summarized statistical forms |
| CN104572813B (en) * | 2014-11-26 | 2019-02-26 | 国家电网公司 | A kind of report generation method and device |
| CN104572813A (en) * | 2014-11-26 | 2015-04-29 | 国家电网公司 | Report generation method and device |
| CN105808228A (en) * | 2014-12-31 | 2016-07-27 | 青岛中科软件股份有限公司 | Generation method of dynamic configuration statement |
| CN104616134A (en) * | 2015-01-23 | 2015-05-13 | 北京京东尚科信息技术有限公司 | Statement analysis report pushing method and device |
| CN104616134B (en) * | 2015-01-23 | 2019-07-02 | 北京京东尚科信息技术有限公司 | A kind of statement analysis report method for pushing and device |
| CN104915378A (en) * | 2015-05-08 | 2015-09-16 | 珠海世纪鼎利通信科技股份有限公司 | Rapid statistics task generation system and method suitable for big data |
| CN104915378B (en) * | 2015-05-08 | 2018-11-13 | 珠海世纪鼎利科技股份有限公司 | A kind of statistics task quick-speed generation system and method suitable for big data |
| CN104866589B (en) * | 2015-05-28 | 2018-06-15 | 北京京东尚科信息技术有限公司 | The generation method and device of data sheet |
| CN104866589A (en) * | 2015-05-28 | 2015-08-26 | 北京京东尚科信息技术有限公司 | Method and device for generating data report |
| CN106406835A (en) * | 2015-07-30 | 2017-02-15 | 大唐软件技术股份有限公司 | Report generation method and report generation apparatus |
| CN105138501A (en) * | 2015-08-10 | 2015-12-09 | 北京思特奇信息技术股份有限公司 | Configurable dynamic report generating method and system |
| CN105138501B (en) * | 2015-08-10 | 2018-04-03 | 北京思特奇信息技术股份有限公司 | A kind of configurable dynamic report generation method and system |
| CN105243022B (en) * | 2015-11-10 | 2018-05-18 | 中国建设银行股份有限公司 | The performance data analysis method and device of host application software system |
| CN105243022A (en) * | 2015-11-10 | 2016-01-13 | 中国建设银行股份有限公司 | Method and device for analyzing performance data of host application software system |
| CN106933904A (en) * | 2015-12-31 | 2017-07-07 | 北京国双科技有限公司 | The filter method and device of data |
| CN106933904B (en) * | 2015-12-31 | 2019-12-03 | 北京国双科技有限公司 | The filter method and device of data |
| CN105868310B (en) * | 2016-03-25 | 2020-05-26 | 联想(北京)有限公司 | Data processing method and device and electronic equipment |
| CN105868310A (en) * | 2016-03-25 | 2016-08-17 | 联想(北京)有限公司 | Data processing method and device and electronic device |
| CN105843945A (en) * | 2016-04-08 | 2016-08-10 | 联动优势科技有限公司 | Report generation method and system |
| CN106372048A (en) * | 2016-08-30 | 2017-02-01 | 北京北信源软件股份有限公司 | Report generation system and report generation method |
| CN106776773B (en) * | 2016-11-11 | 2020-12-18 | 苏州华元世纪科技发展有限公司 | Dynamic data display system and method |
| CN106776773A (en) * | 2016-11-11 | 2017-05-31 | 苏州华元世纪科技发展有限公司 | A kind of Dynamic data display system and method |
| CN108268525A (en) * | 2016-12-30 | 2018-07-10 | 深圳市优朋普乐传媒发展有限公司 | A kind of report implementation method and device based on Excel template |
| CN106844324A (en) * | 2017-02-22 | 2017-06-13 | 浪潮通用软件有限公司 | It is a kind of to change the method that column data exports as Excel forms |
| CN106844324B (en) * | 2017-02-22 | 2020-01-10 | 浪潮通用软件有限公司 | Method for exporting variable column data into Excel format |
| CN107169050A (en) * | 2017-04-26 | 2017-09-15 | 燕山大学 | A kind of customized Web forms implementation method of pattern |
| CN107609109A (en) * | 2017-09-13 | 2018-01-19 | 山东浪潮云服务信息科技有限公司 | A kind of report form generation method, device and system |
| CN109947861A (en) * | 2017-11-09 | 2019-06-28 | 北京京东尚科信息技术有限公司 | The method, apparatus and computer-readable medium of object table are generated for data warehouse |
| CN108388550A (en) * | 2017-11-14 | 2018-08-10 | 深圳市瑞艾特科技有限公司 | Full Dynamic Generating Report implementation method, system and equipment based on Stimulsoft |
| CN107832282A (en) * | 2017-11-21 | 2018-03-23 | 苏州正载信息技术有限公司 | A kind of implementation method for defining Visual Report Forms |
| CN108446309A (en) * | 2018-02-05 | 2018-08-24 | 深圳市资本在线金融信息服务有限公司 | The application process and device of WEB intelligent report forms |
| CN108572945A (en) * | 2018-03-09 | 2018-09-25 | 吉贝克信息技术（北京）有限公司 | Create method, system, storage medium and the electronic equipment of report |
| CN108595394A (en) * | 2018-03-21 | 2018-09-28 | 上海蔚界信息科技有限公司 | A kind of rapid build scheme of text analyzing report |
| CN108664638A (en) * | 2018-05-15 | 2018-10-16 | 口碑(上海)信息技术有限公司 | Report form generation method based on index system and device |
| CN108664638B (en) * | 2018-05-15 | 2019-12-10 | 口碑(上海)信息技术有限公司 | report generation method and device based on index system |
| CN109344375A (en) * | 2018-08-24 | 2019-02-15 | 周宁 | A kind of report tool and method based on office software |
| CN111104108B (en) * | 2018-10-29 | 2021-07-23 | 大唐移动通信设备有限公司 | Display interface WPF generation method and device |
| CN111104108A (en) * | 2018-10-29 | 2020-05-05 | 大唐移动通信设备有限公司 | Display interface WPF generation method and device |
| CN109299450A (en) * | 2018-10-31 | 2019-02-01 | 上海用天网络科技有限公司 | Dynamic statement method for exhibiting data in a kind of business management software |
| CN109508352A (en) * | 2018-11-16 | 2019-03-22 | 苏州好玩友网络科技有限公司 | A kind of output method of report data, device, equipment and storage medium |
| CN109508352B (en) * | 2018-11-16 | 2019-12-27 | 苏州好玩友网络科技有限公司 | Report data output method, device, equipment and storage medium |
| CN110211646B (en) * | 2019-05-22 | 2021-04-06 | 浙江大学 | OCQL and openEHR-based dynamically configurable medical report generation method |
| 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 |
| CN110674195B (en) * | 2019-09-27 | 2023-05-02 | 浪潮通用软件有限公司 | Form-based query method |
| CN110674195A (en) * | 2019-09-27 | 2020-01-10 | 山东浪潮通软信息科技有限公司 | Form-based query method |
| CN111078679A (en) * | 2019-12-23 | 2020-04-28 | 用友网络科技股份有限公司 | Data report generation method and device and computer readable storage medium |
| CN111078679B (en) * | 2019-12-23 | 2023-06-16 | 用友网络科技股份有限公司 | Method and device for generating data report and computer readable storage medium |
| CN111291544A (en) * | 2020-01-13 | 2020-06-16 | 中国建设银行股份有限公司 | Report generation method and device, electronic equipment and storage medium |
| WO2021212386A1 (en) * | 2020-04-22 | 2021-10-28 | 深圳市欢太科技有限公司 | Method and apparatus for creating custom report form, electronic device and storage medium |
| CN112036118A (en) * | 2020-07-03 | 2020-12-04 | 山东浪潮通软信息科技有限公司 | Configurable dynamic data report display method and system |
| CN112036118B (en) * | 2020-07-03 | 2024-01-26 | 浪潮通用软件有限公司 | Configurable data report dynamic display method and system |
| CN114490702A (en) * | 2020-10-26 | 2022-05-13 | 陕西省烟草公司渭南市公司 | Dynamic generation method of production data coordinate graph in discrete manufacturing industry |
| CN114490702B (en) * | 2020-10-26 | 2024-08-20 | 陕西省烟草公司渭南市公司 | Dynamic generation method of discrete manufacturing production data coordinate graph |
| CN112905687A (en) * | 2021-03-26 | 2021-06-04 | 深圳壹账通智能科技有限公司 | Data conversion method and device, electronic equipment and storage medium |
| CN115544130A (en) * | 2022-11-30 | 2022-12-30 | 广州天维信息技术股份有限公司 | Performance report generation method and device, storage medium and computer equipment |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103064689B (en) | 2016-06-01 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103064689A (en) | Implementation method and system for dynamically generating report pages | |
| US9436672B2 (en) | Representing and manipulating hierarchical data | |
| CN113272801B (en) | Generating a data visualization from an object model of a selected data source | |
| US10354002B2 (en) | Interaction relationship building and explorer for dashboard | |
| US10579678B2 (en) | Dynamic hierarchy generation based on graph data | |
| CN110955717A (en) | Visual dynamic display method and system based on big data | |
| CN104965886B (en) | Data dimension processing method | |
| US20090119309A1 (en) | System and method for analyzing data in a report | |
| US8161374B2 (en) | Butterfly diagrams enabling multi-dimensional performance analysis | |
| US20150032708A1 (en) | Database analysis apparatus and method | |
| CN104008162A (en) | Template based one-button type thematic map automatic forming method and system | |
| CN103970527A (en) | Assistive Overlay For Report Generation | |
| CN104063361A (en) | Report design method and system | |
| CN105512265A (en) | Method and device for displaying data through figure | |
| CN102930099B (en) | A kind of actual situation mode contrast verification system | |
| CN104715003A (en) | Method and system transmitting data via data transmitting function | |
| CN104102670A (en) | Performance indicator analytical framework | |
| Kalampokis et al. | Linked open cube analytics systems: Potential and challenges | |
| CN106649232A (en) | Method for automatically converting financial data into data capable of being understood by non-financial staff | |
| CN116468010A (en) | Report generation method, device, terminal and storage medium | |
| CN105808682A (en) | Relational graph display method and apparatus | |
| CN103853809A (en) | Efficient space allocation for business objects | |
| US9298686B2 (en) | System and method for simulating discrete financial forecast calculations | |
| CN109408502A (en) | A kind of data standard processing method, device and its storage medium | |
| CN109360106A (en) | Portrait construction method, system, medium and computer system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant |