CN101140562A - Method for realizing user-defined report forms - Google Patents
Method for realizing user-defined report forms Download PDFInfo
- Publication number
- CN101140562A CN101140562A CNA2007100798115A CN200710079811A CN101140562A CN 101140562 A CN101140562 A CN 101140562A CN A2007100798115 A CNA2007100798115 A CN A2007100798115A CN 200710079811 A CN200710079811 A CN 200710079811A CN 101140562 A CN101140562 A CN 101140562A
- Authority
- CN
- China
- Prior art keywords
- self
- user
- implementation method
- cell
- database
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Abstract
The invention discloses a self-defined statement fulfilling method, which comprises: Step S102, define a serial basic data list according to users' demands, and save the information of the basic data list into a database or a configuration file; and Step S104, utilize a background application service program to calculate results indexes corresponding with the basic data. Utilization of the invention can create specific format statements according to users' demands, and save the corresponding configuration information into a database or a configuration file, so as to effectively overcome inflexibility and not easy expansibility due to statements in fixed formats; meanwhile, the invention can reduce difficulties in development and maintenance for statements.
Description
Technical field
The present invention relates to computer realm, and more particularly, relate to a kind of implementation method of User Defined form.
Background technology
In field of computer technology, it is that form with form presents that a large amount of information datas is arranged.Because multiple user has various demand, so the form of form also is diversified.Generally, in a reporting system, at certain specific function, the statement form that all users use all is the same.When the user who uses this function form more for a long time, it is very dumb that the set form of form will seem, and lack extendability, thereby can't satisfy all users' individual demand.And, in the development and Design process of form, must define the statement form that can satisfy most of user's request.Simultaneously, when the demand of certain customers changed, revising statement form can influence other user, has so just increased the difficulty of the exploitation and the maintenance of whole reporting system.
At present, also do not have to propose to solve the technical scheme that report form is fixed, can not be satisfied various user's requests.
Summary of the invention
Consider the problems referred to above and make the present invention that for this reason, fundamental purpose of the present invention is to provide a kind of implementation method of self-defined report.
This method may further comprise the steps: first step, define a series of master data row according to user's request, and the information that master data is listed as is kept in database or the configuration file; And second step, calculate and master data row results indexes corresponding by the background application service routine.
And this method further comprises: third step, and when the user was provided with statement form, system read the information of master data row from database or configuration file; And the 4th step, statement form and the relative report messages that sets is kept in the database.
Wherein, in third step, the user is provided with the Data Source of the row of each cell correspondence in the gauge outfit of form, the Data Source of row be following any: master data row and calculated column.Wherein, by being performed mathematical calculations, the master data row generate calculated column.
And, in third step,,, then be provided with or revise the computing formula of its calculated column if the Data Source of cell is a calculated column according to the cell results indexes corresponding; If the Data Source of cell is not a calculated column, then in the background application service routine, increase or revise the calculation procedure of correspondence.
And, in third step, the display properties of each cell in the gauge outfit of user's modification form.
In addition, in the 4th step, report messages comprise following one of at least: the data attribute and the display properties of user identity, function point numbering, form cell.
And this method further comprises: the 5th step, when starting form, system reads the report messages that the active user is provided with from database, generates the form of specified format.
By technique scheme of the present invention, can generate the form of specific format according to user's needs, and corresponding customization information is saved in database or the configuration file, thereby overcome effectively set form that form brought was dumb, be difficult for extendability, the difficulty that has reduced the form exploitation simultaneously and safeguarded.
Description of drawings
Accompanying drawing described herein is used to provide further understanding of the present invention, constitutes the application's a part, and illustrative examples of the present invention and explanation thereof are used to explain the present invention, do not constitute improper qualification of the present invention.In the accompanying drawings:
Fig. 1 is the process flow diagram according to the User Defined form implementation method of the embodiment of the invention;
Fig. 2 is the process flow diagram according to user's form masterplate customization procedure of the embodiment of the invention;
Fig. 3 is the process flow diagram according to the process of user's form customization of the embodiment of the invention; And
Fig. 4 is the process flow diagram according to the use of the User Defined form of the embodiment of the invention.
Embodiment
Method embodiment
A kind of implementation method of self-defined report is provided in the present embodiment.
As shown in Figure 1, this method may further comprise the steps: step S102, define a series of master data row according to user's request, and the information that master data is listed as is kept in database or the configuration file; Step S104 calculates and master data row results indexes corresponding by the background application service routine.
Preferably, as shown in Figure 1, this method further may further comprise the steps (certainly, do not having under the situation of following processing, also can well implement the present invention): step S106, when the user was provided with statement form, system read the information of master data row from database or configuration file; Step S108 is kept at statement form and the relative report messages that sets in the database; And step S110, when starting form, system reads the report messages that the active user is provided with from database, generates the form of specified format.
Wherein, in step S106, the user is provided with the Data Source of the row of each cell correspondence in the gauge outfit of form, the Data Source of row be following any: master data row and calculated column.Wherein, generate calculated column by master data row are performed mathematical calculations computings such as (for example) addition subtraction multiplication and divisions.
And, in step S106,,, then be provided with or revise the computing formula of its calculated column if the Data Source of cell is a calculated column according to the cell results indexes corresponding; If the Data Source of cell is not a calculated column, then in the background application service routine, increase or revise the calculation procedure of correspondence.
And in step S106, the user can revise the display properties of each cell in the gauge outfit of form.
In addition, in step S108, report messages comprise following one of at least: the data attribute (Data Source, computing formula etc.) and the display properties (title, position, size etc.) of user identity, function point numbering, form cell.
With reference to the implementation method of the described self-defined report of Fig. 1, implementation procedure, form customization procedure and the form use to report form template is described respectively based on before.
As shown in Figure 2, the customization procedure of report form template may further comprise the steps:
Step S202 collects all user's requests, and these demands are carried out analysis-by-synthesis and arrangement;
Step S204 according to user's demand, increases or revises basic data rows, in proper order as the form masterplate, and the information of these data rows is kept in database or the configuration file;
Step S206 judges result's sign of data column unit lattice correspondence, if the Data Source of cell is not a calculated column, then increases or revise the calculation procedure of correspondence in the background application service routine; If the Data Source of cell is a calculated column, then be provided with or revise its computing formula; And
Step S208 when user's request changes, comes back to step S204.
As shown in Figure 3, the customization procedure of form may further comprise the steps:
Step S302, the user logins reporting system, opens the form of appointed function point, if do not have before this user the form of this form is provided with, what then show will be a blank form, otherwise show it is the form that has been provided with;
Step S304 increases in existing form, deletes row or column, and the row, column number of gauge outfit is set;
Step S306 is provided with the Data Source (master data row or calculated column) of its respective column to each cell of gauge outfit;
Step S308, the form of each cell of gauge outfit is carried out perfect, wherein, can revise the title, width of cell, highly, display properties such as merging; And
Step S310, set statement form is saved in the database, every information that record is corresponding in the data-base recording table comprises user identity, function point numbering, the display properties (title, position, size etc.) of gauge outfit cell and the data attribute (Data Source, computing formula etc.) of cell respective column.
As shown in Figure 4, the use of form may further comprise the steps:
Step S402, the user logins reporting system, opens the form of appointed function point;
Step S404, system reads from database and active user and the corresponding accounting logging of current function point, according to record described cell display properties (title, position, size etc.), generate and show the gauge outfit part of form, the data attribute of cell respective column (Data Source, computing formula etc.) is kept in the internal memory;
Step S406 is provided with the querying condition (as the time etc.) of form, and inquiry obtaining in the database by background program result that calculate, every elementary data item correspondence; And
Step S408 according to the data attribute of each row of the form of storing in the internal memory, shows directly that with the corresponding result data of master data row the data of calculated column then obtain according to the corresponding calculated formula, and are presented on the interface.
By above description, be appreciated that can obtain following advantage by means of technical scheme of the present invention:
(1) dirigibility is strong: at the same function in the same reporting system, different users can comprise the corresponding Data Source of each row of gauge outfit, the display properties of each cell etc. by self needing the report customization form;
(2) the form customization procedure is simple: statement form can be kept in the database, and the user only need customize once format and get final product, and later in login system and when using appointed function point, will transfer the statement form information of this customization automatically from database and shows; And
(3) reporting system is easy to maintenance: when customer requirements is revised the report data source, only need to revise the information of master data row in database or the configuration file, and in background application, correspondingly increase and decrease the computation process that master data is listed as, redefine statement form by the user then.
In sum, the application of the invention, can generate the form of specific format according to user's needs, and corresponding customization information is saved in database or the configuration file, thereby overcome effectively set form that form brought was dumb, be difficult for extendability, reduced the difficulty of form exploitation, maintenance simultaneously.
The above is the preferred embodiments of the present invention only, is not limited to the present invention, and for a person skilled in the art, the present invention can have various changes and variation.Within the spirit and principles in the present invention all, any modification of being done, be equal to replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (9)
1. the implementation method of a self-defined report is characterized in that, comprising:
First step defines a series of master data row according to user's request, and the information that described master data is listed as is kept in database or the configuration file; And
Second step is calculated and described master data row results indexes corresponding by the background application service routine.
2. self-defined report implementation method according to claim 1 is characterized in that, further comprises:
Third step, when the user was provided with statement form, system read the information of described master data row from described database or configuration file; And
The 4th step is kept at described statement form and the relative report messages that sets in the database.
3. self-defined report implementation method according to claim 2 is characterized in that, in described third step, described user is provided with the Data Source of the row of each cell correspondence in the gauge outfit of described form.
4. self-defined report implementation method according to claim 3 is characterized in that, the Data Source of described row be following any: described master data row and calculated column.
5. self-defined report implementation method according to claim 4 is characterized in that, generates described calculated column by described master data row are performed mathematical calculations.
6. self-defined report implementation method according to claim 3, it is characterized in that, in described third step, according to the described index as a result of described cell correspondence, if the Data Source of described cell is described calculated column, then be provided with or revise the computing formula of its described calculated column; If the Data Source of described cell is not described calculated column, then in described background application service routine, increase or revise the calculation procedure of correspondence.
7. self-defined report implementation method according to claim 2 is characterized in that, in described third step, and the display properties of each cell in the gauge outfit of the described form of described user's modification.
8. self-defined report implementation method according to claim 2 is characterized in that, in described the 4th step, described report messages comprise following one of at least: the data attribute and the display properties of user identity, function point numbering, form cell.
9. self-defined report implementation method according to claim 8 is characterized in that, further comprises:
The 5th step, when starting form, system reads the described report messages that the active user is provided with from described database, generates the form of specified format.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2007100798115A CN101140562A (en) | 2007-02-14 | 2007-02-14 | Method for realizing user-defined report forms |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2007100798115A CN101140562A (en) | 2007-02-14 | 2007-02-14 | Method for realizing user-defined report forms |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101140562A true CN101140562A (en) | 2008-03-12 |
Family
ID=39192517
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNA2007100798115A Pending CN101140562A (en) | 2007-02-14 | 2007-02-14 | Method for realizing user-defined report forms |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101140562A (en) |
Cited By (17)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101777079A (en) * | 2010-03-11 | 2010-07-14 | 浙江鸿程计算机系统有限公司 | System structural frame for fast generating electronic report forms and realization method thereof |
| CN102184099A (en) * | 2011-04-15 | 2011-09-14 | 北京高森明晨信息科技有限公司 | Method, device and system used for configuring and generating application software report forms |
| CN102306119A (en) * | 2011-06-30 | 2012-01-04 | 北京新媒传信科技有限公司 | System for capturing global exception and method |
| CN102779040A (en) * | 2012-06-21 | 2012-11-14 | 东莞市微模式软件有限公司 | Method and device for generating user-defined form |
| CN102855229A (en) * | 2011-06-30 | 2013-01-02 | 镇江雅迅软件有限责任公司 | Self-defined statistical report form generating system based on EXCEL form |
| CN103400008A (en) * | 2013-08-02 | 2013-11-20 | 浙江和仁科技有限公司 | Realization technology of temperature chart control software in electronic medical record system |
| CN103678413A (en) * | 2012-09-25 | 2014-03-26 | 金蝶软件（中国）有限公司 | Method and device for displaying dynamic column of report |
| WO2015003572A1 (en) * | 2013-07-12 | 2015-01-15 | Tencent Technology (Shenzhen) Company Limited | Method and server for processing report data |
| CN104331405A (en) * | 2013-07-22 | 2015-02-04 | 腾讯科技（深圳）有限公司 | Method and device for processing a data report |
| CN105573972A (en) * | 2014-10-10 | 2016-05-11 | 北大方正集团有限公司 | Report check formula generation method and apparatus |
| CN105787019A (en) * | 2016-02-24 | 2016-07-20 | 浪潮通用软件有限公司 | Method for modifying and saving table cell information in reporting system |
| CN105808540A (en) * | 2014-12-29 | 2016-07-27 | 金蝶软件（中国）有限公司 | Configuration data storage method and system |
| WO2016180228A1 (en) * | 2015-10-12 | 2016-11-17 | 中兴通讯股份有限公司 | Data processing method and device |
| CN106934021A (en) * | 2017-03-10 | 2017-07-07 | 深圳市科脉技术股份有限公司 | The processing method and system of modularized encapsulation form |
| CN110046337A (en) * | 2019-04-22 | 2019-07-23 | 厦门商集网络科技有限责任公司 | A kind of financial data acquisition method and its system |
| CN111383404A (en) * | 2020-03-06 | 2020-07-07 | 浙江智科炬新科技有限公司 | Preferential activity settlement system and method based on POS machine |
| CN112464279A (en) * | 2020-11-26 | 2021-03-09 | 北京宏景世纪软件股份有限公司 | Method and system for realizing form design based on service drive |
-
2007
- 2007-02-14 CN CNA2007100798115A patent/CN101140562A/en active Pending
Cited By (23)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101777079B (en) * | 2010-03-11 | 2011-11-09 | 浙江鸿程计算机系统有限公司 | Realization method for fast generating electronic report forms |
| CN101777079A (en) * | 2010-03-11 | 2010-07-14 | 浙江鸿程计算机系统有限公司 | System structural frame for fast generating electronic report forms and realization method thereof |
| CN102184099A (en) * | 2011-04-15 | 2011-09-14 | 北京高森明晨信息科技有限公司 | Method, device and system used for configuring and generating application software report forms |
| CN102855229A (en) * | 2011-06-30 | 2013-01-02 | 镇江雅迅软件有限责任公司 | Self-defined statistical report form generating system based on EXCEL form |
| CN102306119A (en) * | 2011-06-30 | 2012-01-04 | 北京新媒传信科技有限公司 | System for capturing global exception and method |
| CN102779040B (en) * | 2012-06-21 | 2015-11-18 | 东莞市微模式软件有限公司 | A kind of method and apparatus generating customizing form |
| CN102779040A (en) * | 2012-06-21 | 2012-11-14 | 东莞市微模式软件有限公司 | Method and device for generating user-defined form |
| CN103678413B (en) * | 2012-09-25 | 2017-07-28 | 金蝶软件（中国）有限公司 | The methods of exhibiting and device of dynamic column of report |
| CN103678413A (en) * | 2012-09-25 | 2014-03-26 | 金蝶软件（中国）有限公司 | Method and device for displaying dynamic column of report |
| WO2015003572A1 (en) * | 2013-07-12 | 2015-01-15 | Tencent Technology (Shenzhen) Company Limited | Method and server for processing report data |
| CN104331405A (en) * | 2013-07-22 | 2015-02-04 | 腾讯科技（深圳）有限公司 | Method and device for processing a data report |
| CN104331405B (en) * | 2013-07-22 | 2020-01-10 | 腾讯科技（深圳）有限公司 | Data report processing method and device |
| CN103400008A (en) * | 2013-08-02 | 2013-11-20 | 浙江和仁科技有限公司 | Realization technology of temperature chart control software in electronic medical record system |
| CN105573972A (en) * | 2014-10-10 | 2016-05-11 | 北大方正集团有限公司 | Report check formula generation method and apparatus |
| CN105573972B (en) * | 2014-10-10 | 2018-07-31 | 北大方正集团有限公司 | The generation method and device of report check formula |
| CN105808540A (en) * | 2014-12-29 | 2016-07-27 | 金蝶软件（中国）有限公司 | Configuration data storage method and system |
| WO2016180228A1 (en) * | 2015-10-12 | 2016-11-17 | 中兴通讯股份有限公司 | Data processing method and device |
| CN105787019A (en) * | 2016-02-24 | 2016-07-20 | 浪潮通用软件有限公司 | Method for modifying and saving table cell information in reporting system |
| CN106934021A (en) * | 2017-03-10 | 2017-07-07 | 深圳市科脉技术股份有限公司 | The processing method and system of modularized encapsulation form |
| CN110046337A (en) * | 2019-04-22 | 2019-07-23 | 厦门商集网络科技有限责任公司 | A kind of financial data acquisition method and its system |
| CN110046337B (en) * | 2019-04-22 | 2022-10-25 | 厦门商集网络科技有限责任公司 | Financial data acquisition method and system |
| CN111383404A (en) * | 2020-03-06 | 2020-07-07 | 浙江智科炬新科技有限公司 | Preferential activity settlement system and method based on POS machine |
| CN112464279A (en) * | 2020-11-26 | 2021-03-09 | 北京宏景世纪软件股份有限公司 | Method and system for realizing form design based on service drive |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101140562A (en) | Method for realizing user-defined report forms | |
| CN101308490B (en) | Dynamic report generation method and platform | |
| US6651055B1 (en) | OLAP query generation engine | |
| CN106372044B (en) | A method of based on the typing dimension XBRL report of report generation | |
| CN102789491B (en) | A kind of configurable data subscription and delivery system and method thereof | |
| CN102508850A (en) | Form data processing device and form data processing method | |
| CN101739452A (en) | Data exchange interface and realizing method thereof | |
| CN104063361A (en) | Report design method and system | |
| CN109408043A (en) | A kind of program creating method and device | |
| CN105335822B (en) | Big data analysis-oriented unified data model modeling method for smart power grid | |
| CN112464632B (en) | Dynamic storage and conversion method for table style under excel report | |
| CN116468010A (en) | Report generation method, device, terminal and storage medium | |
| CN104951565A (en) | XML configuration maintenance method and system based on memory database | |
| CN107122961A (en) | Excel nested report data processing methods based on SAP system | |
| CN114444478A (en) | Voucher visualization method and device, electronic equipment and storage medium | |
| CN102866985B (en) | For data formatter and the method for on-line analysing processing system | |
| CN111401023B (en) | Report generation method, report generation device, server and storage medium | |
| CN108984156A (en) | A kind of software auto generating method and system for exempting from code development based on template | |
| CN202433952U (en) | General network reporting system | |
| CN104636805A (en) | Report data management server, report data management program, and report data management device | |
| CN110704635B (en) | Method and device for converting triplet data in knowledge graph | |
| CN107562949A (en) | The method for realizing consolidated accounts Excel template write into Databasce | |
| CN106408235A (en) | Method for realizing material unit composite metering in supply chain system | |
| CN115794804A (en) | Engineering internal control data visualization processing system and method based on big data technology | |
| US9128908B2 (en) | Converting reports between disparate report formats |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Open date: 20080312 |