CN101996216A - Custom report generation system - Google Patents
Custom report generation system Download PDFInfo
- Publication number
- CN101996216A CN101996216A CN2009101836486A CN200910183648A CN101996216A CN 101996216 A CN101996216 A CN 101996216A CN 2009101836486 A CN2009101836486 A CN 2009101836486A CN 200910183648 A CN200910183648 A CN 200910183648A CN 101996216 A CN101996216 A CN 101996216A
- Authority
- CN
- China
- Prior art keywords
- data
- database
- report
- user interface
- user
- 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
Abstract
The invention relates to a custom report generation system, in particular to a report customization system which belongs to the field of computer information management systems and is realized by acquiring a report structure in a database to establish a data buffering area. A database structure analysis module in the system is used for analyzing a database report structure; a data reading assembly is used for reading required data to the data buffering area from the database; a user interacts with the system through a user interaction interface to send a report generation instruction; the report generation assembly selects data generation reports from the data buffering area according to the instruction and displays the selected data generation reports though the user interaction interface. The system can be used for generating various custom management reports in the simplest way, thereby reducing the cost of customers for using corporate information management software.
Description
Technical field
The present invention relates to a kind of self-defined report generation system, especially a kind of by obtaining list structure in the database, set up the Reporting Customization system that realizes the data buffer, belong to the computer information management system field.
Background technology
Along with the continuous development of society, the IT application in enterprises degree is improving constantly, and enterprise information management software emerges in an endless stream.These management softwares provide powerful infotech support for the supvrs of enterprise, have improved company managers' work efficiency effectively.
In enterprise information management software, involve the generation of form through regular meeting at present.The mode of common employing is to carry out hard coded according to client's set demand.This kind mode can only be fit to needs for the moment, also need to import again when demand takes place to change, and has increased the cost that the client uses software, has also wasted the time.
Along with the continuous development and the renewal of IT application in enterprises technology, need develop a kind of system that can allow the self-defined generation form of client.
Summary of the invention
The objective of the invention is to: at the deficiency of above prior art existence, propose a kind of by obtaining list structure in the database, set up the Reporting Customization system that realizes the data buffer, thereby make that the client can be in the process of using enterprise information management software, self-defined and generate various managerial reports in the simplest mode according to actual needs, reduced the cost that the client uses enterprise information management software.
In order to reach above purpose, a kind of self-defined report generation system of the present invention should comprise following assembly:
The database structure analysis module--in order to the table mechanism of analytical database;
The data read assembly--mutual in order to realization and data of database;
User Interface--in order to carry out mutual interface with the user;
The data buffer--in order to deposit the data message that from database, reads out;
The report generation assembly--generate various data sheets in order to setting according to the user.
A kind of self-defined report generation system of the present invention when realizing generating self-defined report, comprises following steps:
Step 1: system analyzes the list structure of the database of form to be generated by the database structure analysis module, and the field information that obtains is shown to the user by User Interface;
Step 2: the user need to select the field information of demonstration, forms then and generates the form command request, and User Interface sends to data read assembly and report generation assembly with command request;
Step 3: the solicited message that the data read assembly is sent according to User Interface, the value of reading database respective field, and value is stored in the data buffer;
Step 4: the report generation assembly, is verified data according to the request that User Interface is sent the data of data buffer zone, generates report data then, and report data is transferred to User Interface;
Step 5: User Interface is given the user with report display.
This shows, the present invention is by obtaining list structure in the database, set up the Reporting Customization system that realizes the data buffer, thereby make that the client can be in the process of using enterprise information management software, self-defined and generate various managerial reports in the simplest mode according to actual needs, reduced the cost that the client uses enterprise information management software.
Embodiment
Embodiment one
As development platform, carry out realization of the present invention by at present more common .Net.
With AD0.Net as the data read assembly;
As development platform, is principle of design with the object-oriented by .Net, is achieved as follows several modules on platform:
The database structure analysis module--in order to the table mechanism of analytical database;
The data read assembly--mutual in order to realization and data of database;
User Interface--in order to carry out mutual interface with the user;
The data buffer--in order to deposit the data message that from database, reads out;
The report generation assembly--generate various data sheets in order to setting according to the user.
When realizing generating self-defined report, comprise following steps:
Step 1: system analyzes the list structure of the database of form to be generated by the database structure analysis module, and the field information that obtains is shown to the user by User Interface;
Step 2: the user need to select the field information of demonstration, forms then and generates the form command request, and User Interface sends to data read assembly and report generation assembly with command request;
Step 3: the solicited message that the data read assembly is sent according to User Interface, the value of reading database respective field, and value is stored in the data buffer;
Step 4: the report generation assembly, is verified data according to the request that User Interface is sent the data of data buffer zone, generates report data then, and report data is transferred to User Interface; Step 5: User Interface is given the user with report display.
In addition to the implementation, the present invention can also have other embodiments.All employings are equal to the technical scheme of replacement or equivalent transformation formation, all drop on the protection domain of requirement of the present invention.
Claims (2)
1. self-defined report generation system is characterized in that comprising following assembly:
The database structure analysis module--in order to the table mechanism of analytical database;
The data read assembly--mutual in order to realization and data of database;
User Interface--in order to carry out mutual interface with the user;
The data buffer--in order to deposit the data message that from database, reads out;
The report generation assembly--generate various data sheets in order to setting according to the user.
2. according to the described a kind of self-defined report generation system of claim 1, when realizing generating self-defined report, comprise following steps:
Step 1: system analyzes the list structure of the database of form to be generated by the database structure analysis module, and the field information that obtains is shown to the user by User Interface;
Step 2: the user need to select the field information of demonstration, forms then and generates the form command request, and User Interface sends to data read assembly and report generation assembly with command request;
Step 3: the solicited message that the data read assembly is sent according to User Interface, the value of reading database respective field, and value is stored in the data buffer;
Step 4: the report generation assembly, is verified data according to the request that User Interface is sent the data of data buffer zone, generates report data then, and report data is transferred to User Interface;
Step 5: User Interface is given the user with report display.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN2009101836486A CN101996216A (en) | 2009-08-14 | 2009-08-14 | Custom report generation system |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN2009101836486A CN101996216A (en) | 2009-08-14 | 2009-08-14 | Custom report generation system |
Publications (1)
Publication Number | Publication Date |
---|---|
CN101996216A true CN101996216A (en) | 2011-03-30 |
Family
ID=43786376
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN2009101836486A Pending CN101996216A (en) | 2009-08-14 | 2009-08-14 | Custom report generation system |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN101996216A (en) |
Cited By (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102148833A (en) * | 2011-04-18 | 2011-08-10 | 中国工商银行股份有限公司 | Method for transmitting data report, server, client and system |
CN103679309A (en) * | 2012-09-13 | 2014-03-26 | 余明阳 | Intelligent statistical analysis method for power data warehouse services |
CN103699644A (en) * | 2013-12-25 | 2014-04-02 | 深圳市盈富在线信息科技有限公司 | Information release method, information release system and user terminal |
CN103761395A (en) * | 2014-01-24 | 2014-04-30 | 福建省电力勘测设计院 | Method for generating dynamic report of virtual terminal of intelligent substation |
CN107729008A (en) * | 2017-09-28 | 2018-02-23 | 武汉创客空间信息管理有限公司 | A kind of method based on electrical form rapid build management information system |
CN109800263A (en) * | 2018-12-25 | 2019-05-24 | 安徽三马信息科技有限公司 | A kind of custom report generation system |
-
2009
- 2009-08-14 CN CN2009101836486A patent/CN101996216A/en active Pending
Cited By (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102148833A (en) * | 2011-04-18 | 2011-08-10 | 中国工商银行股份有限公司 | Method for transmitting data report, server, client and system |
CN103679309A (en) * | 2012-09-13 | 2014-03-26 | 余明阳 | Intelligent statistical analysis method for power data warehouse services |
CN103679309B (en) * | 2012-09-13 | 2017-11-03 | 国网湖北省电力公司 | A kind of electric power data warehouse business intelligence statistical analysis technique |
CN103699644A (en) * | 2013-12-25 | 2014-04-02 | 深圳市盈富在线信息科技有限公司 | Information release method, information release system and user terminal |
CN103761395A (en) * | 2014-01-24 | 2014-04-30 | 福建省电力勘测设计院 | Method for generating dynamic report of virtual terminal of intelligent substation |
CN103761395B (en) * | 2014-01-24 | 2017-04-26 | 福建省电力勘测设计院 | Method for generating dynamic report of virtual terminal of intelligent substation |
CN107729008A (en) * | 2017-09-28 | 2018-02-23 | 武汉创客空间信息管理有限公司 | A kind of method based on electrical form rapid build management information system |
CN109800263A (en) * | 2018-12-25 | 2019-05-24 | 安徽三马信息科技有限公司 | A kind of custom report generation system |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN101996216A (en) | Custom report generation system | |
US8234016B2 (en) | Power metadata transfer over power lines | |
CN104267991A (en) | Mobile application platform based on quick service packaging | |
CN101232505A (en) | Interface model of RIA laminate frame based on MVC architecture | |
Qi et al. | Knowledge management in OSS—an enterprise information system for the telecommunications industry | |
CN112446683A (en) | Contract performance information management and control system | |
Karanasios et al. | Antecedents to greening data centres: A conceptual framework and exploratory case study | |
CN103731342A (en) | Instant message based workflow management system and management method | |
Seidel et al. | Implementation of sustainable manufacturing practices in SMEs-Case study of a New Zealand furniture manufacturer | |
CN104657357A (en) | User-defined report generation system | |
CN101815082A (en) | External information integrated device and service system | |
Koschatzky et al. | The spatial multidimensionality of sectoral innovation: the case of information and communication technologies | |
Garner et al. | How can knowledge cities become smart | |
Uddin et al. | Validation of green IT framework for implementing energy efficient green data centres: A case study | |
CN101887559A (en) | Technology for recommending commodities in mobile business | |
KR20110120000A (en) | Construction management business platform based on web | |
CN101226541A (en) | System and method for implementing page | |
MacLeod | Canada’s Infrastructure of the Future | |
CN202889398U (en) | General GIS object-based bidirectional information interactive system between electrical network and user | |
Zhu et al. | Things identification support system based on IoT | |
Sawaf et al. | Concepts for next generation smart real estate | |
Li et al. | Roadmap to Carbon Neutrality-Financial Practices for Chinese Telecom Giants | |
CN101079875A (en) | A method and system for realizing multi-object event | |
Nkumbwa | Emerging next generation communication technology: Unveiling the ubiquitous society | |
Khan et al. | Smart Cities: Integrating Technologies for Digital Transformation |
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 |
Application publication date: 20110330 |