CN104714949A - Method for customizing report dynamically - Google Patents
Method for customizing report dynamically Download PDFInfo
- Publication number
- CN104714949A CN104714949A CN201310676781.1A CN201310676781A CN104714949A CN 104714949 A CN104714949 A CN 104714949A CN 201310676781 A CN201310676781 A CN 201310676781A CN 104714949 A CN104714949 A CN 104714949A
- Authority
- CN
- China
- Prior art keywords
- row
- report
- query
- display
- data
- 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
Links
Landscapes
- User Interface Of Digital Computer (AREA)
Abstract
The invention discloses a method for customizing a report dynamically. The method comprises the steps of generating an item query table, receiving query statements defined by a user, and storing the query statements in the item query table; generating a report display column setting table, receiving report type setting information set by the user, and storing the report type setting information in the report display column setting table; generating a query report, taking and analyzing the query statements from the item query table, conducting query operation in a report database, and generating the query report through obtained query data; generating a report, taking the report type setting information from the report display column setting table, generating a blank table according to the report type setting information, importing the query data in the query report into the blank table, and obtaining the report which the user wants to query. By means of the method, a user defined statement query function is achieved, so that the user can directly define the query content which the query report is based on, and the flexibility and expansibility of report development are greatly increased.
Description
Technical field
The present invention relates to database application field, in particular to a kind of method of Dynamic Customization form.
Background technology
At present, along with based on J2EE(Java2Platform Enterprise Edition, Java 2 Platform Enterprise Edition) development of application software of framework, the various functions of software simulating from strength to strength, thus provide more and more space freely played for user.User can according to the custom of oneself and the needs of self, customize in software some oneself needed for function, as approval process, output report etc.In the personalized function that these are numerous, the input function of form is most important, most widely used.
In existence conditions, although the display function of form can be found everywhere, often when Software for Design, inquire about what data, which condition be provided, be fixed up by software developer.Software user, in proposition demand stage, just clearly must propose oneself to need to show what content, how to show report data and need to set which condition, thus allow software developer design in the development phase.But, software user in use, if find that oneself also needs more query contents, or need the pattern changing original form, the wait software that so they can only the be very long next construction cycle, could again propose such requirement, and then allow software developer develop.
In sum, in Software for Design, how to realize customization report query function, with realize user to report data more deep and more fine-grained query analysis, be a primary study direction of this area researchist.
Summary of the invention
The invention provides a kind of method of Dynamic Customization form, for making form according to user-defined report display pattern.
For achieving the above object, the invention provides a kind of method of Dynamic Customization form, comprising the following steps:
Generated query repertory, receives user-defined query statement and is kept in queried for items table;
Generating report forms display column arranges table, receive user arrange report style configuration information and be kept at report display row arrange in table;
Generated query form, transfers query statement and resolves, in report database, performing query manipulation from queried for items table, by the data query generated query form got;
Generating report forms, arranges table from report display row and transfers report style configuration information, generate blank form according to report style configuration information, and the data query in inquiry form is imported blank form, obtain the form that user will inquire about.
Further, query statement is SQL statement.
Further, report style configuration information comprises the DISPLAY ORDER of the row span of each row in form, the style setting information of each row and each row.
Further, when row span is 1, the style setting information of these row comprises following at least one item: these row based on queried for items ID, the alignment thereof of the height of the title of these row, the mark whether showing these row in newly-generated form, form, width, data, data display format, the trigger function of this row correspondence and the definition of trigger function in the title of these row, newly-generated form in former form; When row span is greater than 1, the style setting information of these row comprises following at least one item: the DISPLAY ORDER of each apportion, this apportion based on trigger function corresponding to queried for items ID, the title of this apportion in the title of this apportion, newly-generated form in former form, the mark whether showing this apportion in newly-generated form, the height of form, width, the alignment thereof of data, data display format, this apportion and the definition of trigger function.
Further, the DISPLAY ORDER of row and the DISPLAY ORDER of apportion are stored in display column parameter array.
Further, display column parameter array is one-dimension array, and in display column parameter array, the value of element is the row sequence number of inquiry form.
Further, in generating report forms step, travel through each group polling data, according to the DISPLAY ORDER of the row set in display column parameter array and apportion, read the setting element in inquiry form and the relevant position placed it in blank form, and the form of setting element is set according to style setting information, wherein, the element of corresponding trigger function shows with hyperlink form.
Further, the alignment thereof of the height of form, width, data, data display format are stored in report display row with functional form and arrange in table.
Further, when the number of trigger function is multiple, separate with separator between multiple trigger function, input parameter in trigger function is the column data value of occupancy parameters or inquiry form, when input parameter is the column data value of inquiry form, quotation marks identifier is used to identify, when trigger function is resolved, the character string that trigger function forms is pressed quotation marks separate, and the character string after separating is numbered from sequence number 1, the character string being numbered odd number is directly used character string spelling, to the character string being numbered even number, judge whether it is the column data value of inquiring about form, if this character string is the column data value of inquiry form, its value by reality is carried out spelling, if this character string is not the column data value of inquiry form, it is carried out spelling by character string.
Further, queried for items table and report display row arrange table and are kept in xml file or in database.
Compared with the present invention develops with traditional form, add user and function can be set in self-defined report display of being correlated with, also can more easily self-defined report query statement, use more flexible.The form development mode of the same type with other compares, and advantage of the present invention is:
1, achieve User Defined query statement function, user can directly be defined will inquire about form based on query contents.
2, achieve User-defined report display and function is set, user can arrange the trigger function of the form row of display, the DISPLAY ORDER of form row, the height of form, width, the alignment thereof of data, data display format and this row correspondence, considerably increases dirigibility and the extendability of form exploitation.
3, due to trigger function corresponding to the data that can arrange report display and input parameter, the subsequent development work of form is alleviated greatly, farthest allow the use of form customer personalized, and simplify work, greatly reduce the workload of developer during the exploitation of follow-up form, reduce code revision amount as much as possible.
4, user-defined parameter is kept in xml file or database, ensure that the logic of foreground analysis program is short and sweet, makes calling program have good readability and ease for maintenance, and when also making to perform query manipulation, the travelling speed of system is higher.
Accompanying drawing explanation
In order to be illustrated more clearly in the embodiment of the present invention or technical scheme of the prior art, be briefly described to the accompanying drawing used required in embodiment or description of the prior art below, apparently, accompanying drawing in the following describes is only some embodiments of the present invention, for those of ordinary skill in the art, under the prerequisite not paying creative work, other accompanying drawing can also be obtained according to these accompanying drawings.
Fig. 1 is the method flow diagram of the Dynamic Customization form of one embodiment of the invention.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the present invention, be clearly and completely described the technical scheme in the embodiment of the present invention, obviously, described embodiment is only the present invention's part embodiment, instead of whole embodiments.Based on the embodiment in the present invention, those of ordinary skill in the art, not paying the every other embodiment obtained under creative work prerequisite, belong to the scope of protection of the invention.
Fig. 1 is the method flow diagram of the Dynamic Customization form of one embodiment of the invention, this embodiment is for the doubtful point information bank of the tax authority, the details of paying taxes of all enterprises in tax authority's compass of competency are comprised in doubtful point information bank, comprise invoice issuing information, information etc. of declaring dutiable goods, doubtful point information bank is used for the tax authority and carries out analysis verification, to find the enterprise with tax evasion doubtful point to the enterprise in its compass of competency.As shown in the figure, the method comprises the following steps:
S110: generated query repertory, receives user-defined query statement and is kept in queried for items table;
Pertinent definition in queried for items table is as shown in table 1:
| Title | Annotation | Default value | Data type | Force |
| CXXM_ID | Queried for items ID | Nothing | VARchar2(10) | TRUE |
| CXXM_SQL | Queried for items SQL statement | Nothing | VARchar2(3000) | TRUE |
Table 1: queried for items table pertinent definition
Wherein, query statement is SQL statement, and queried for items table contains developer's SQL query statement that some basic SQL query statements of finishing writing in advance and user oneself write according to the needs of Dynamic Customization form when developing.Developer, when developing, finishes writing the SQL query statement that some are basic, conventional in advance, can reduce the workload that user writes inquiry code voluntarily on the one hand; User can transfer these SQL query statements finished writing more convenient, more intuitively on the other hand, and the report style generated after observing the inquiry of these basic SQL statements of use.For the repeated work avoiding user to cause at subsequent development link rewriting SQL query statement, can the queried for items table of generation be kept in xml file or in database, can call easily when next time uses.
S120: generating report forms display column arranges table, receive user arrange report style configuration information and be kept at report display row arrange in table;
Repeat for avoiding user to arrange report style, the report display row of generation arrange table and can be kept in xml file or in database, can call easily when next time uses.
Wherein, to arrange the pertinent definition of table as shown in table 2 for report display row:
Table 2: report display row arrange table pertinent definition
Report style configuration information comprises the DISPLAY ORDER of the row span of each row in form, the style setting information of each row and each row, wherein, row span is point column number that each row of form comprise, when a certain row do not comprise apportion, the row span of these row is 1, when a certain row comprise apportion, the row span of these row is the number of the apportion of this row correspondence.
When row span is 1, the style setting information of these row comprises following at least one item: these row based on queried for items ID, the alignment thereof of the height of the title of these row, the mark whether showing these row in newly-generated form, form, width, data, data display format, the trigger function of this row correspondence and the definition of trigger function in the title of these row, newly-generated form in former form; When row span is greater than 1, the style setting information of these row comprises following at least one item: the DISPLAY ORDER of each apportion, this apportion based on trigger function corresponding to queried for items ID, the title of this apportion in the title of this apportion, newly-generated form in former form, the mark whether showing this apportion in newly-generated form, the height of form, width, the alignment thereof of data, data display format, this apportion and the definition of trigger function.
Wherein, " these row based on queried for items ID " and the title of these row " in the former form " be respectively this be listed in inquiry form based on the ID of row and this be listed in gauge outfit title in former form.Such as, in inquiry form, the gauge outfit of a certain row is " taxable amount ", data corresponding under this gauge outfit are the taxable amount in all enterprises this month in tax authority compass of competency, the ID of these row is " nsje ", if have row in the final form generated based on these row in inquiry form, so arrange in table at report display row, " these row based on queried for items ID " and the title of these row " in the former form " are set and are respectively " nsje " and " taxable amount ".The title of these row " in the newly-generated form " is the gauge outfit in the final form generated, this gauge outfit can be identical with the gauge outfit of row corresponding in inquiry form, also the name can getting other, as gauge outfit, is as the criterion with the implication of the data value meeting these row in final form." in newly-generated form, whether showing the mark of these row " is a Boolean, when this value is true (1), these row are presented in form, when this value is false(0) time, these row are not presented in form, when needs show these row, by performing a function operation, change the Boolean of this row correspondence into true by false, namely these row show in form, analyze this column data for user.
The DISPLAY ORDER of row and the DISPLAY ORDER of apportion are stored in display column parameter array, display column parameter array is one-dimension array, in display column parameter array, the value of element is the row sequence number of inquiry form, arranges accordingly when arranging like this in order to realize transferring in inquiry form by the value of element in reading displayed row parameter array.
The height of form, width, the alignment thereof of data, data display format are stored in report display row with functional form and arrange in table, can complete the height of corresponding form in form, width, the alignment thereof of data, the setting of data display format by transferring these functions.
The number of trigger function can be one or more, separate with separator "-" between multiple trigger function, input parameter in trigger function is the column data value of occupancy parameters or inquiry form, wherein occupancy parameters is for realizing the character of row occupy-place when comprising apportion, when occupancy parameters occurs, this apportion is shown as blank column, and the object done like this reserves this apportion on stream, to further expand the content that this apportion shows in the future; When input parameter is the column data value of inquiry form, quotation marks identifier is used to identify.When trigger function is resolved, the character string that trigger function forms is pressed quotation marks separate, and the character string after separating is numbered from sequence number 1, the character string being numbered odd number is directly used character string spelling, to the character string being numbered even number, judge whether it is the column data value of inquiring about form, if this character string is the column data value of inquiry form, its value by reality is carried out spelling, if this character string is not the column data value of inquiry form, it is carried out spelling by character string.
S130: generated query form, transfers query statement and resolves, in report database, performing query manipulation from queried for items table, by the data query generated query form got;
Report database may comprise multiple form, from queried for items table, transfer query statement respectively perform query manipulation in corresponding form, from each form, get the data query meeting respective queries condition, and all data queries got are write in same inquiry form.
S140: generating report forms, arranges table from report display row and transfers report style configuration information, generate blank form according to report style configuration information, and the data query in inquiry form is imported blank form, obtain the form that user will inquire about.
Report style configuration information contains point columns of columns in form and each row, contain the title of each row and the title of each apportion in newly-generated form simultaneously, this title and gauge outfit element, blank form is generated according to above information, how many group polling data are comprised owing to cannot predict in advance in inquiry form, also the line number of the blank form that will generate cannot namely be determined, a line numerical value can be pre-defined, when the group number of data query exceedes this journey numerical value, blank form will add line automatically, to realize the interpolation of subsequent query data.Due to the row sequence number that the value of element in display column parameter array is inquiry form, therefore the value of element can extract row corresponding to inquiry form in reading displayed row parameter array, each group polling data in traversal queries form, according to the DISPLAY ORDER of the row set in display column parameter array and apportion, read the setting element in data query and the relevant position placed it in blank form, read the row span of each row simultaneously, when row span is greater than 1, the multiple row read (" multiple " the i.e. numerical value of row span) are shown as the apportion form under same row, sequentially the setting element of extraction is arranged from left to right in blank form, and the Show Styles of each element is arranged according to the pattern defined in display column parameter array, wherein, the element of corresponding trigger function shows with hyperlink form, after each the group polling data in inquiry form are all provided with, form final form.
Wherein, in generating report forms process, need according to the display column mode of user's setting, by the element alignment in gauge outfit form, this needs the width controlling each form.Concrete way is that the total length of the form a line first user set calculates, each width arranged is set again according to the length of each row setting and the ratio of total length, run into when comprising multiple apportion in row, then set the width of each apportion by each point length ratio be listed in these row.
The pattern of generating report forms when illustrating that row span is 1 below.
| Doubtful point item ID | Inventory number |
| 1201 | 50 |
Table 3: the form generated when row span is 1
Form for generating when row span is 1 as shown in table 3, in this embodiment, user, according to its subsequent analysis needs, only need show the inventory number of doubtful point item correspondence in form, the detailed number of the inventory without the need to showing doubtful point item correspondence.At this moment, key word in SQL statement is configured, obtain the SQL statement of the inventory number of an inquiry doubtful point item ID and doubtful point item correspondence, the row span simultaneously configuring two row in form is 1, wherein, user is without the need to performing operation further to doubtful point item ID further, and also without the need to performing operation further to each inventory number, therefore the element in the form generated does not comprise hyperlink.In the form of final generation, first row shows doubtful point item ID value 1201, and secondary series shows the inventory number 50 of doubtful point item correspondence.
The pattern of generating report forms when illustrating that row span is greater than 1 below.
Table 4: the form generated when row span is greater than 1
As shown in table 4 is generating report forms when row span is greater than 1, and in this embodiment, user, according to its subsequent analysis needs, not only need show the inventory number of doubtful point item correspondence in form, also needs the detailed number of inventory showing doubtful point item correspondence.At this moment, key word in SQL statement is configured, obtain an inquiry doubtful point item ID, the SQL statement of the inventory number of doubtful point item correspondence and the detailed number of the inventory of doubtful point item correspondence, the row span simultaneously configuring first row in form is 1, the row span of secondary series is 2, wherein, user is without the need to performing operation further to doubtful point item ID further, but operation further need be performed with the details understanding each inventory number to each inventory number, and operation further need be performed to understand the details of the detailed number of each inventory to the detailed number of each inventory, therefore in the form generated, the element that the detailed number of inventory number and inventory is corresponding comprises hyperlink, click this hyperlink and namely perform corresponding trigger function.In the form of final generation, first row shows doubtful point item ID value 1201, secondary series shows the inventory information of doubtful point item correspondence, wherein first point is classified as inventory number 50, second point and is classified as inventory detailed several 1000, and wherein " 50 " and " 1000 " are shown as hyperlink form, click " 50 " and inventory query page can be jumped to, the details of 50 inventory numbers that display is corresponding, click " 1000 " and can jump to the detailed query page of inventory, the detailed number details of 1000 inventorys that display is corresponding.
The report style generated when illustrating below in trigger function and comprise occupancy parameters.。
Table 5: the form generated when trigger function comprises occupancy parameters
Sample report for generating when trigger function comprises occupancy parameters as shown in table 5, the present embodiment adopts " ＄ " to be occupancy parameters, configure at lane database the function that in a certain row, element is corresponding to be configured to: javascript:queryQc (this, " dmSwjg.swjgDm ", " ydx.ydxId ")-$, the configuration of this function comprises a trigger function " javascript:queryQc (this, " dmSwjg.swjgDm ", " ydx.ydxId ") " and an occupancy parameters " ＄ ", this trigger function is Javascript function, function is called queryQc(and inquires about inventory).The character string that trigger function forms is pressed quotation marks separate, and the character string after separating is numbered from sequence number 1, obtain:
1：javascript:queryQc(this,
2：dmSwjg.swjgDm
3：,
4：ydx.ydxId
5：)
Can find out, when the character string of trigger function composition is resolved, only may with " javascript: ... " start, so the character string being numbered odd number in such cases can be only a character string, such as " javascript:queryQc (this, ", ", " and ") ", the character string these being numbered odd number directly uses character string spelling, after character string corresponding to antithesis numerical digit judges, show that the character string that even bit is corresponding is the column data value of inquiring about form, such as " dmSwjg.swjgDm " and " ydx.ydxId ", character string corresponding for even bit is carried out spelling by the value of its reality, tax authority's code column (swjgDm) that wherein " dmSwjg.swjgDm " corresponding tax authority table (dmSwjg) is inner, the doubtful point item ID of " ydx.ydxId " corresponding doubtful point item tables of data arranges, in fact, some train values of certain row data of some tables of lane database that what even column was corresponding is exactly, in the present embodiment, the value of dmSwjg.swjgDm is 14100000000, the value of ydx.ydxId is 1201, then " javascript:queryQc (this, " dmSwjg.swjgDm ", " ydx.ydxId ")-$ " when being finally performed, this character string is replaced by " javascript:queryQc (this, 14100000000, 1201)-$ " code.Javascript:queryQc (this, 14100000000,1201) rreturn value is the inventory number of certain doubtful point item of certain tax authority, occupancy parameters " ＄ " is then shown as a mentioned null cell, and after therefore performing this trigger function, these row can be divided into two apportions, first row display javascript:queryQc (this, 14100000000,1201) value 50, the second returned is classified as a blank column.
Compared with the present invention develops with traditional form, add user and function can be set in self-defined report display of being correlated with, also can more easily self-defined report query statement, use more flexible.The form development mode of the same type with other compares, and advantage of the present invention is:
1, achieve User Defined query statement function, user can directly be defined will inquire about form based on query contents.
2, achieve User-defined report display and function is set, user can arrange the trigger function of the form row of display, the DISPLAY ORDER of form row, the height of form, width, the alignment thereof of data, data display format and this row correspondence, considerably increases dirigibility and the extendability of form exploitation.
3, due to trigger function corresponding to the data that can arrange report display and input parameter, the subsequent development work of form is alleviated greatly, farthest allow the use of form customer personalized, and simplify work, greatly reduce the workload of developer during the exploitation of follow-up form, reduce code revision amount as much as possible.
4, user-defined parameter is kept in xml file or database, ensure that the logic of foreground analysis program is short and sweet, makes calling program have good readability and ease for maintenance, and when also making to perform query manipulation, the travelling speed of system is higher.
One of ordinary skill in the art will appreciate that: accompanying drawing is the schematic diagram of an embodiment, the module in accompanying drawing or flow process might not be that enforcement the present invention is necessary.
One of ordinary skill in the art will appreciate that: the module in the device in embodiment can describe according to embodiment and be distributed in the device of embodiment, also can carry out respective change and be arranged in the one or more devices being different from the present embodiment.The module of above-described embodiment can merge into a module, also can split into multiple submodule further.
Last it is noted that above embodiment is only in order to illustrate technical scheme of the present invention, be not intended to limit; Although with reference to previous embodiment to invention has been detailed description, those of ordinary skill in the art is to be understood that: it still can be modified to the technical scheme described in previous embodiment, or carries out equivalent replacement to wherein portion of techniques feature; And these amendments or replacement, do not make the essence of appropriate technical solution depart from the spirit and scope of embodiment of the present invention technical scheme.
Claims (10)
1. a method for Dynamic Customization form, is characterized in that, comprises the following steps:
Generated query repertory, receives user-defined query statement and is kept in queried for items table;
Generating report forms display column arranges table, receive user arrange report style configuration information and be kept at report display row arrange in table;
Generated query form, transfers query statement and resolves, in report database, performing query manipulation from described queried for items table, by the data query generated query form got;
Generating report forms, arrange table from described report display row and transfer described report style configuration information, generate blank form according to described report style configuration information, and the data query in described inquiry form is imported described blank form, obtain the form that user will inquire about.
2. the method for Dynamic Customization form according to claim 1, is characterized in that, described query statement is SQL statement.
3. the method for Dynamic Customization form according to claim 1, is characterized in that, described report style configuration information comprises the DISPLAY ORDER of the row span of each row in form, the style setting information of each row and each row.
4. the method for Dynamic Customization form according to claim 3, it is characterized in that, when described row span is 1, the style setting information of these row comprises following at least one item: these row based on queried for items ID, the alignment thereof of the height of the title of these row, the mark whether showing these row in newly-generated form, form, width, data, data display format, the trigger function of this row correspondence and the definition of trigger function in the title of these row, newly-generated form in former form; When described row span is greater than 1, the style setting information of these row comprises following at least one item: the DISPLAY ORDER of each apportion, this apportion based on trigger function corresponding to queried for items ID, the title of this apportion in the title of this apportion, newly-generated form in former form, the mark whether showing this apportion in newly-generated form, the height of form, width, the alignment thereof of data, data display format, this apportion and the definition of trigger function.
5. the method for the Dynamic Customization form according to claim 3 or 4, is characterized in that, the DISPLAY ORDER of described row and the DISPLAY ORDER of described apportion are stored in display column parameter array.
6. the method for Dynamic Customization form according to claim 5, is characterized in that, described display column parameter array is one-dimension array, and in described display column parameter array, the value of element is the row sequence number of described inquiry form.
7. the method for Dynamic Customization form according to claim 5, it is characterized in that, in generating report forms step, travel through each and organize described data query, according to the DISPLAY ORDER of the row set in described display column parameter array and apportion, read the setting element in described inquiry form and the relevant position placed it in described blank form, and the form of described setting element is set according to described style setting information, wherein, the element of corresponding trigger function shows with hyperlink form.
8. the method for Dynamic Customization form according to claim 4, is characterized in that, the height of described form, width, the alignment thereof of data, data display format are stored in report display row with functional form and arrange in table.
9. the method for Dynamic Customization form according to claim 4, it is characterized in that, when the number of described trigger function is multiple, separate with separator between multiple trigger function, input parameter in described trigger function is the column data value of occupancy parameters or inquiry form, when described input parameter is the column data value of inquiry form, quotation marks identifier is used to identify, when trigger function is resolved, the character string that trigger function forms is pressed quotation marks separate, and the character string after separating is numbered from sequence number 1, the character string being numbered odd number is directly used character string spelling, to the character string being numbered even number, judge whether it is the column data value of inquiring about form, if this character string is the column data value of inquiry form, its value by reality is carried out spelling, if this character string is not the column data value of inquiry form, it is carried out spelling by character string.
10. the method for Dynamic Customization form according to claim 1, is characterized in that, described queried for items table and described report display row arrange table and are kept in xml file or in database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310676781.1A CN104714949A (en) | 2013-12-11 | 2013-12-11 | Method for customizing report dynamically |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310676781.1A CN104714949A (en) | 2013-12-11 | 2013-12-11 | Method for customizing report dynamically |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104714949A true CN104714949A (en) | 2015-06-17 |
Family
ID=53414293
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310676781.1A Pending CN104714949A (en) | 2013-12-11 | 2013-12-11 | Method for customizing report dynamically |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104714949A (en) |
Cited By (23)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104978196A (en) * | 2015-06-26 | 2015-10-14 | 深圳Tcl数字技术有限公司 | Setting function item display method and apparatus |
| CN105138501A (en) * | 2015-08-10 | 2015-12-09 | 北京思特奇信息技术股份有限公司 | Configurable dynamic report generating method and system |
| CN105740368A (en) * | 2016-01-27 | 2016-07-06 | 浪潮通信信息系统有限公司 | Method and device for generating report form |
| CN105843784A (en) * | 2016-03-18 | 2016-08-10 | 中国银行股份有限公司 | Statement generation method and device |
| CN105938476A (en) * | 2016-01-19 | 2016-09-14 | 北京匡恩网络科技有限责任公司 | Reporting system with Word as template |
| CN107908747A (en) * | 2017-11-17 | 2018-04-13 | 深圳市泉眼网络科技有限公司 | A kind of page generation method and device |
| CN108664638A (en) * | 2018-05-15 | 2018-10-16 | 口碑(上海)信息技术有限公司 | Report form generation method based on index system and device |
| CN108681589A (en) * | 2018-05-15 | 2018-10-19 | 口碑(上海)信息技术有限公司 | Structured query language instruction generation method based on index system and device |
| CN108694214A (en) * | 2017-04-12 | 2018-10-23 | 北京京东尚科信息技术有限公司 | Generation method, generating means, readable medium and the electronic equipment of data sheet |
| CN108763386A (en) * | 2018-05-19 | 2018-11-06 | 国云科技股份有限公司 | Polymorphic type report data sharing means based on NOSQL and its implementation |
| CN108846576A (en) * | 2018-06-14 | 2018-11-20 | 新奥（中国）燃气投资有限公司 | A kind of budgetary technique and budget compilation device |
| CN109165378A (en) * | 2018-08-15 | 2019-01-08 | 北京天安智慧信息技术有限公司 | Sophisticated functions Report Customization method and system |
| CN109213811A (en) * | 2017-06-30 | 2019-01-15 | 北京神州泰岳软件股份有限公司 | A kind of report form showing method and device |
| CN109471889A (en) * | 2018-09-19 | 2019-03-15 | 平安科技（深圳）有限公司 | Report accelerated method, system, computer equipment and storage medium |
| CN109522370A (en) * | 2018-10-29 | 2019-03-26 | 珠海迎迎科技有限公司 | A kind of automatic table generation method and device based on SQL |
| CN109739906A (en) * | 2018-11-21 | 2019-05-10 | 深圳市佰仟金融服务有限公司 | A kind of report form generation method and system |
| CN109800264A (en) * | 2018-12-27 | 2019-05-24 | 平安科技（深圳）有限公司 | Diversified declaration form deriving method, device and storage medium |
| CN109857998A (en) * | 2017-11-30 | 2019-06-07 | 厦门白山耘科技有限公司 | A kind of intelligence generates the method and device of EXCEL table |
| CN110728113A (en) * | 2018-06-28 | 2020-01-24 | 北京金山办公软件股份有限公司 | Information screening method and device of electronic forms and terminal equipment |
| CN111241141A (en) * | 2019-12-30 | 2020-06-05 | 航天信息(山东)科技有限公司 | Method for rapidly screening problem enterprises of vehicle purchase tax monitoring and management platform |
| CN111967931A (en) * | 2020-07-29 | 2020-11-20 | 上海悦易网络信息技术有限公司 | Method and equipment for mixed arrangement of list data elements |
| CN113127544A (en) * | 2019-12-30 | 2021-07-16 | 朱曦炽 | Data report creating method, device and medium |
| CN113821533A (en) * | 2021-09-30 | 2021-12-21 | 北京鲸鹳科技有限公司 | Data query method, device, equipment and storage medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101320365A (en) * | 2008-07-09 | 2008-12-10 | 金蝶软件（中国）有限公司 | Method and apparatus for dynamic layout of document page |
| CN101697122A (en) * | 2009-10-16 | 2010-04-21 | 深圳市科陆电子科技股份有限公司 | Method for generating report query conditions through predefined components |
| CN101697123A (en) * | 2009-10-20 | 2010-04-21 | 金蝶软件（中国）有限公司 | Method and device for modifying interface layout in ERP system and ERP system |
| US20100238183A1 (en) * | 2009-03-18 | 2010-09-23 | Sony Corporation | Information processing apparatus and information processing method |
| CN102789457A (en) * | 2011-05-17 | 2012-11-21 | 航天信息股份有限公司 | Method for dynamically customizing filter conditions |
-
2013
- 2013-12-11 CN CN201310676781.1A patent/CN104714949A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101320365A (en) * | 2008-07-09 | 2008-12-10 | 金蝶软件（中国）有限公司 | Method and apparatus for dynamic layout of document page |
| US20100238183A1 (en) * | 2009-03-18 | 2010-09-23 | Sony Corporation | Information processing apparatus and information processing method |
| CN101697122A (en) * | 2009-10-16 | 2010-04-21 | 深圳市科陆电子科技股份有限公司 | Method for generating report query conditions through predefined components |
| CN101697123A (en) * | 2009-10-20 | 2010-04-21 | 金蝶软件（中国）有限公司 | Method and device for modifying interface layout in ERP system and ERP system |
| CN102789457A (en) * | 2011-05-17 | 2012-11-21 | 航天信息股份有限公司 | Method for dynamically customizing filter conditions |
Cited By (30)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104978196A (en) * | 2015-06-26 | 2015-10-14 | 深圳Tcl数字技术有限公司 | Setting function item display method and 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 |
| CN105938476A (en) * | 2016-01-19 | 2016-09-14 | 北京匡恩网络科技有限责任公司 | Reporting system with Word as template |
| CN105740368A (en) * | 2016-01-27 | 2016-07-06 | 浪潮通信信息系统有限公司 | Method and device for generating report form |
| CN105843784A (en) * | 2016-03-18 | 2016-08-10 | 中国银行股份有限公司 | Statement generation method and device |
| CN108694214A (en) * | 2017-04-12 | 2018-10-23 | 北京京东尚科信息技术有限公司 | Generation method, generating means, readable medium and the electronic equipment of data sheet |
| CN109213811A (en) * | 2017-06-30 | 2019-01-15 | 北京神州泰岳软件股份有限公司 | A kind of report form showing method and device |
| CN107908747A (en) * | 2017-11-17 | 2018-04-13 | 深圳市泉眼网络科技有限公司 | A kind of page generation method and device |
| CN109857998A (en) * | 2017-11-30 | 2019-06-07 | 厦门白山耘科技有限公司 | A kind of intelligence generates the method and device of EXCEL table |
| CN108681589A (en) * | 2018-05-15 | 2018-10-19 | 口碑(上海)信息技术有限公司 | Structured query language instruction generation method based on index system and device |
| 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 |
| CN108763386A (en) * | 2018-05-19 | 2018-11-06 | 国云科技股份有限公司 | Polymorphic type report data sharing means based on NOSQL and its implementation |
| CN108846576A (en) * | 2018-06-14 | 2018-11-20 | 新奥（中国）燃气投资有限公司 | A kind of budgetary technique and budget compilation device |
| CN110728113A (en) * | 2018-06-28 | 2020-01-24 | 北京金山办公软件股份有限公司 | Information screening method and device of electronic forms and terminal equipment |
| CN109165378A (en) * | 2018-08-15 | 2019-01-08 | 北京天安智慧信息技术有限公司 | Sophisticated functions Report Customization method and system |
| CN109471889A (en) * | 2018-09-19 | 2019-03-15 | 平安科技（深圳）有限公司 | Report accelerated method, system, computer equipment and storage medium |
| CN109471889B (en) * | 2018-09-19 | 2023-06-02 | 平安科技（深圳）有限公司 | Report accelerating method, system, computer equipment and storage medium |
| CN109522370A (en) * | 2018-10-29 | 2019-03-26 | 珠海迎迎科技有限公司 | A kind of automatic table generation method and device based on SQL |
| CN109739906A (en) * | 2018-11-21 | 2019-05-10 | 深圳市佰仟金融服务有限公司 | A kind of report form generation method and system |
| CN109800264A (en) * | 2018-12-27 | 2019-05-24 | 平安科技（深圳）有限公司 | Diversified declaration form deriving method, device and storage medium |
| CN109800264B (en) * | 2018-12-27 | 2024-05-31 | 平安科技（深圳）有限公司 | Diversified reporting form export method, device and storage medium |
| CN111241141A (en) * | 2019-12-30 | 2020-06-05 | 航天信息(山东)科技有限公司 | Method for rapidly screening problem enterprises of vehicle purchase tax monitoring and management platform |
| CN113127544A (en) * | 2019-12-30 | 2021-07-16 | 朱曦炽 | Data report creating method, device and medium |
| CN111241141B (en) * | 2019-12-30 | 2023-11-14 | 航天信息(山东)科技有限公司 | Rapid screening method for vehicle purchase tax monitoring management platform problem enterprises |
| CN111967931A (en) * | 2020-07-29 | 2020-11-20 | 上海悦易网络信息技术有限公司 | Method and equipment for mixed arrangement of list data elements |
| CN111967931B (en) * | 2020-07-29 | 2024-01-12 | 上海万物新生环保科技集团有限公司 | Method and equipment for mixed arrangement of list data elements |
| CN113821533A (en) * | 2021-09-30 | 2021-12-21 | 北京鲸鹳科技有限公司 | Data query method, device, equipment and storage medium |
| CN113821533B (en) * | 2021-09-30 | 2023-09-08 | 北京鲸鹳科技有限公司 | Method, device, equipment and storage medium for data query |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104714949A (en) | Method for customizing report dynamically | |
| CN101308490B (en) | Dynamic report generation method and platform | |
| Dourish | No SQL: The shifting materialities of database technology | |
| US8479093B2 (en) | Metamodel-based automatic report generation | |
| CN107886439A (en) | Insurance products development approach, device, equipment and computer-readable recording medium | |
| CN110472068A (en) | Big data processing method, equipment and medium based on heterogeneous distributed knowledge mapping | |
| CN108694214A (en) | Generation method, generating means, readable medium and the electronic equipment of data sheet | |
| Powell | Microsoft Power BI cookbook: Creating business intelligence solutions of analytical data models, reports, and dashboards | |
| CN109933311A (en) | A kind of information system creation method and relevant apparatus | |
| Hoberman | Data Modeling for MongoDB: Building Well-Designed and Supportable MongoDB Databases | |
| CN106407170A (en) | Rapid generation method and system for data report | |
| US20180174243A1 (en) | Systems, methods and apparatus for enhanced navigation in preparation of an electronic tax return | |
| CN104750771A (en) | Method and system for contextual data analysis using domain information | |
| CN103186632A (en) | Method and device for customizing operation and maintenance form | |
| US20060020608A1 (en) | Cube update tool | |
| CN101622619A (en) | Be used for navigating and the method and system of the data of visual relational database and/or multi-dimensional database | |
| CN103729713A (en) | Audit result display configuration method and device | |
| CN103646049A (en) | Method and system for automatically generating data report | |
| CN101901262A (en) | Object-oriented model-based enterprise database construction and service data display method | |
| CN116468010A (en) | Report generation method, device, terminal and storage medium | |
| CN106462585A (en) | System and method for column-specific materialization scheduling | |
| CN115826940A (en) | Method for developing industrial software configuration by low code | |
| Knight et al. | Microsoft Power BI Complete Reference: Bring your data to life with the powerful features of Microsoft Power BI | |
| JP2010015458A (en) | Program correction support system, program correction support method, and program correction support program | |
| CN107766519B (en) | Method for visually configuring data structure |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20150617 |
|
| RJ01 | Rejection of invention patent application after publication |