CN102722533A - Method and system for displaying and filling report - Google Patents
Method and system for displaying and filling report Download PDFInfo
- Publication number
- CN102722533A CN102722533A CN2012101567617A CN201210156761A CN102722533A CN 102722533 A CN102722533 A CN 102722533A CN 2012101567617 A CN2012101567617 A CN 2012101567617A CN 201210156761 A CN201210156761 A CN 201210156761A CN 102722533 A CN102722533 A CN 102722533A
- Authority
- CN
- China
- Prior art keywords
- report
- server
- template
- user
- module
- 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
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention pertains to the field of computer technologies, and especially relates to a method and a system for uniformly displaying and filling a large number of reports based on a component oriented WEB application system. The method comprises three processes of a report template making process, a report filling process and a report displaying process. The system comprises a client module, a server module and a report information database. The useful function of this invention lies in that: compared with the prior art, the method and the system for displaying and filling the reports implemented according to the technical scheme of the invention enable users to modify business reports at any time according to business needs and release a report template, support report network filling, submission, review, and audit, make interaction between users related to the reports become convenient and efficient so as to meet needs of business adjustment or business change, and solve problems, such as poor report system maintainability, difficult report system upgrade, poor report system interactive ability, etc., with WEB applications.
Description
Technical field
The invention belongs to field of computer technology, refer to especially a kind ofly represent and make a report on method towards a large amount of form unifications of WEB application system based on assembly.
Background technology
Along with the Internet Information Technology Development, each government bodies, enterprises and institutions have higher requirement to IT application process, and urgent hope utilizes the WEB technology to help all kinds of operation flows of oneself management, realizes the robotization of operation flow.Need input and lots of data in the WEB application system, and with result with various forms of report output, so that supvrs carry out analysis and decision better.Receive the influence of factors such as economy and social environment, the WEB system business process can adjust accordingly or change, and the data of related form and form also need adjust accordingly.Therefore, the WEB application system press for and aly can articulate data with existing storehouse system, support dynamic data source, have powerful data-handling capacity and expressive ability, can be employed by users, report form showing and make a report on instrument cheaply.
In the realization of information-based project; Many systems tend to buy the generation that the business report generation system is realized form, and such as Crystal Report, Formula One, Cognos etc., these Development of Software processes all are that carry out at the center with the pattern; Its report data and the report style degree of coupling are too high; Having under the situation that a large amount of report styles are lack of standardization and pattern is various, be unfavorable for that modification is safeguarded and reusability is relatively poor, wasting the man power and material greatly.
Though; A few money business report softwares (like the FineReport of sail software company and the RAQ of profit universe company) have appearred in domestic form software market; Having solved the user need not programme and can produce the problem of Chinese style complex report forms; Both supported multi-data source, also supported the association of multi-data source, won favorable comment in the form software market.But they all adopt Java Swing technological development, have natural deployment, upgrading difficulty, and are the commercial products that needs paying to buy, and use cost is higher.
WEB application system great majority present all are based on the Html page that we knew, and the Html page itself only is to be used for a kind of technology of text exhibition content.Have high interaction property but the user more and more pursues, enrich user experience and powerful client, and traditional WEB application system can not satisfy needs of people on multimedia and other interaction characteristics.
Summary of the invention
The object of the invention is to provide a kind of novel report form showing and makes a report on mode; Problems such as the maintainability of the reporting system during solution WEB uses is poor, upgrading is difficult, interaction capabilities is weak; Make the user can oneself define report form showing and the format and content of making a report on, to satisfy the needs of business reorganization or change.
The present invention achieves the above object through following technical scheme:
A kind of report form showing and the method for making a report on comprise that report form template manufacturing process, form make a report on process and three processes of report form showing process, and report form template manufacturing process may further comprise the steps:
1) user is in advance with traditional report making instrument design report form template;
2) to import behind the report form template that the user makes with the cell be that the base unit content is carried out abstract to form and described with the XML language in system, adopts then to make the Flex component construction by oneself and go out the XML report form template;
3) the XML report form template that builds is sent request through the template release module to server;
4) receive this request after, server carries out after the authentication XML report form template being stored in the report messages database; The form process of making a report on may further comprise the steps:
When 1) user need fill out certain form, send request to server earlier;
2) after authentication was carried out in the server request of receiving, authorized user read the XML report form template from the report messages database, represent and make a report on the page, supplied the user to make a report on data;
When 3) user reports and submits form, send the relevant information of asking and submitting to it to make a report on to server earlier;
4) after server is received request, the information that the user has made a report on is examined, after audit was passed through, server write the report messages database with the relevant information of reporting and submitting;
5) server can be according to the rule of appointment, and the report form embodiment information and the report data information of other data sources of extracting of timing automatic write the report messages database;
The report form showing process may further comprise the steps:
When 1) user need have access to form, send the request of having access to server earlier;
2) after server is received request, the server request of receiving carrying out authentication;
3) user through authentication after, read in the report messages database report messages and represent.
As preferably, the described traditional report making instrument of the step 1) of report form template manufacturing process is Excel.
As preferably, the step 2 of report form template manufacturing process) described form is carried out the data structure that all forms when abstract all are conceptualized as a two dimension, all kinds of complex report forms are the different merging forms of the cell of this two-dimension table.
As preferably, the step 2 of report form template manufacturing process) described XML report form template comprises the statement form configuration, is divided into gauge outfit format configuration, content format configuration, makes a report on format configuration.
A kind of report form showing with make a report on system; Comprise client modules, server module and report messages database, described client modules comprises that report component designer, template release module, form are made a report on module, form reports and submits module and form to have access to module five major parts; The service end module comprise read and write data, three Web of authenticating user identification and business processing interface use; Described report messages database comprises report definition table, report form embodiment table and form contents table at least; The field of report definition table comprises major key ID, statement heading, corresponding XML format module document location at least, makes a report on explanation and another name; The field of report form embodiment table comprises major key ID, related report definition table major key ID, establishment information at least, makes a report on information and classification, and the field of form contents table comprises major key ID, related report definition table major key ID, report form embodiment major key ID, location of content and cell value at least.
Beneficial effect of the present invention:
The report form showing of realizing according to technical scheme of the present invention with make a report on method; Compare current techniques; Make the user to revise bordereaux at any time and to issue report form template according to service needed; Support form to carry out network and make a report on, report and submit and have access to audit, make to become convenient and swift between the user relevant alternately, to satisfy the needs of business reorganization or change with form.Problems such as the maintainability of the reporting system during solution WEB uses is poor, upgrading is difficult, interaction capabilities is weak.
Description of drawings
Fig. 1 is a schematic diagram of the present invention
Fig. 2 is report messages database structure figure
Fig. 3 is the client modules structural drawing
Fig. 4 is a process flow diagram of the present invention
Embodiment
Embodiment 1: below in conjunction with specific embodiment the present invention is described further, but protection scope of the present invention is not limited in this:
Like Fig. 1, Fig. 2, shown in Figure 3; A kind of report form showing with make a report on system; Comprise client modules, server module and report messages database, described client modules comprises that report component designer, template release module, form are made a report on module, form reports and submits module and form to have access to module five major parts; The service end module comprise read and write data, three Web of authenticating user identification and business processing interface use; Described report messages database comprises report definition table, report form embodiment table and form contents table at least; The field of report definition table comprises major key ID, statement heading, corresponding XML format module document location at least, makes a report on explanation and another name; The field of report form embodiment table comprises major key ID, related report definition table major key ID, establishment information at least, makes a report on information and classification, and the field of form contents table comprises major key ID, related report definition table major key ID, report form embodiment major key ID, location of content and cell value at least.
Certain unit (Party A) needs to collect a collection of report data and externally issues and represents.The source of data comprises 2 aspects, and each subunit of its subordinate (Party A subordinate) is made a report on, and obtains from the data source (Party B) of another unit automatically.The data of form generally are divided into 2 types: a kind of is to expand capable form, for example table 1; A kind of is the fixedly form of ranks, for example table 2.
Main cement production enterprise grog yield data table
| Preface | Enterprise name | Output (ten thousand tons) |
| Number | ||
| 1 | Xx cement mill, Zhejiang Province | 1098 |
| 2 | Xx cement mill, Wuhu City | 675 |
| 3 | Xx cement mill, Taizhou city | 763 |
| 4 | Xx cement mill, Quzhou City | 432 |
Table 1
XX economizes the animal activity horizontal data
Table 2
As shown in Figure 4, concrete treatment scheme is following:
1) prepare statement template: Party A's managerial personnel use browser login native system, and the Flex report form tool that using system provides is with the online report form template (comprise form and make a report on verification) of having drawn of the form of similar Excel.
2) generate the XML format module: the system analysis template generates the Template Information file of corresponding XML form automatically and is kept on the report server, writes down report definition table information simultaneously, issues the XML template then.
The XML format module message file that generates is following:
Table 1
Table 2
Issue XML template:
3) page is made a report in generation according to the XML template.
4) data are made a report on: the personnel that make a report on of Party A subordinate unit, use browser login native system, and system obtains the Report List of having the right to make a report on automatically according to the authority of making a report on the user.The personnel of making a report on choose one type of form wherein, and the Flex that using system provides makes a report on instrument, make a report on report data and are saved in the server.In this process, system can carry out legitimate verification to making a report on data, after checking is passed through, makes a report on form for each part, writes down a report form embodiment data recording, according to the content-data of form, writes down many content data recordings simultaneously.
5) report data is handled: the personnel that make a report on of Party A subordinate unit recommend module for admission to school in the using system after the completion data are made a report on, report data is reported Party A's auditor.In this process, system triggers prompting message Party A's auditor notifies the auditor to examine.Can be used to have access to through the data of reporting and submitting after the audit, otherwise notifications are made a report on the user and are made a report on form again.The data of recommendation for admission to school, major part all is single data, like table one, what make a report on is the data that the specific people provides basically.System is a foundation with isolated data, and data are carried out unified processing and gathered, and forms the data of scale, and the uniform data of for a moment everyone being made a report on like table gathers, and forms final data.
6) generate the report form showing page according to template and the data that gather: Party A and the user of subordinate unit thereof, use browser login native system, according to the authority of self, Flex form that can using system is had access to module, has access to report messages.Flex has access to module, and abundant report form is provided, and comprises that the formatted data of making a report on represents, and represents according to conditional information retrieval, and all kinds of broken line graphs are provided, pie chart, the representing of histogram.What make that the user can be clear checks the Various types of data summary information.In the system, articulate the automatic grabbing module of multi-data source data, can be according to the rule of appointment, the report form embodiment information of other data sources of extracting of timing automatic and report data information.In the present embodiment, the Party A system manager gets into data through browser and grasps configuration module automatically after the report form template issue, and configuration is grasped the storehouse and grasped rule.System grasps report form embodiment data and the form content-data that the Party B examined automatically.
Above said be specific embodiment of the present invention and the know-why used, if the change of doing according to conception of the present invention, when the function that it produced does not exceed spiritual that instructions and accompanying drawing contain yet, must belong to protection scope of the present invention.
Claims (5)
1. report form showing and the method for making a report on is characterized in that comprising that report form template manufacturing process, form make a report on process and three processes of report form showing process, and report form template manufacturing process may further comprise the steps:
1) user is in advance with traditional report making instrument design report form template;
2) to import behind the report form template that the user makes with the cell be that the base unit content is carried out abstract to form and described with the XML language in system, adopts then to make the Flex component construction by oneself and go out the XML report form template;
3) the XML report form template that builds is sent request through the template release module to server;
4) receive this request after, server carries out after the authentication XML report form template being stored in the report messages database;
The form process of making a report on may further comprise the steps:
When 1) user need fill out certain form, send request to server earlier;
2) after authentication was carried out in the server request of receiving, authorized user read the XML report form template from the report messages database, represent and make a report on the page, supplied the user to make a report on data;
When 3) user reports and submits form, send the relevant information of asking and submitting to it to make a report on to server earlier;
4) after server is received request, the information that the user has made a report on is examined, after audit was passed through, server write the report messages database with the relevant information of reporting and submitting;
5) server can be according to the rule of appointment, and the report form embodiment information and the report data information of other data sources of extracting of timing automatic write the report messages database;
The report form showing process may further comprise the steps:
When 1) user need have access to form, send the request of having access to server earlier;
2) after server is received request, the server request of receiving carrying out authentication;
3) user through authentication after, read in the report messages database report messages and represent.
2. a kind of report form showing according to claim 1 and the method for making a report on is characterized in that the described traditional report making instrument of the step 1) of report form template manufacturing process is Excel.
3. a kind of report form showing according to claim 1 and the method for making a report on; It is characterized in that; The step 2 of report form template manufacturing process) described form is carried out the data structure that all forms when abstract all are conceptualized as a two dimension, all kinds of complex report forms are the different merging forms of the cell of this two-dimension table.
4. according to claim 1, the described a kind of report form showing of 2 or 3 arbitrary claims and the method for making a report on; It is characterized in that; The step 2 of report form template manufacturing process) described XML report form template comprises the statement form configuration, is divided into gauge outfit format configuration, content format configuration, makes a report on format configuration.
A report form showing with make a report on system; It is characterized in that comprising client modules, server module and report messages database, described client modules comprises that report component designer, template release module, form are made a report on module, form reports and submits module and form to have access to module five major parts; The service end module comprise read and write data, three Web of authenticating user identification and business processing interface use; Described report messages database comprises report definition table, report form embodiment table and form contents table at least; The field of report definition table comprises major key ID, statement heading, corresponding XML format module document location at least, makes a report on explanation and another name; The field of report form embodiment table comprises major key ID, related report definition table major key ID, establishment information at least, makes a report on information and classification, and the field of form contents table comprises major key ID, related report definition table major key ID, report form embodiment major key ID, location of content and cell value at least.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2012101567617A CN102722533A (en) | 2012-05-09 | 2012-05-09 | Method and system for displaying and filling report |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2012101567617A CN102722533A (en) | 2012-05-09 | 2012-05-09 | Method and system for displaying and filling report |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN102722533A true CN102722533A (en) | 2012-10-10 |
Family
ID=46948294
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2012101567617A Pending CN102722533A (en) | 2012-05-09 | 2012-05-09 | Method and system for displaying and filling report |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102722533A (en) |
Cited By (17)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103761642A (en) * | 2013-12-29 | 2014-04-30 | 远光软件股份有限公司 | Method and device for report data conversion according to measurement units |
| WO2014079304A1 (en) * | 2012-11-26 | 2014-05-30 | 中兴通讯股份有限公司 | Report creation method, device and system |
| CN104063468A (en) * | 2014-06-27 | 2014-09-24 | 北京思特奇信息技术股份有限公司 | Data report automatic generating and extracting method and device |
| CN104199663A (en) * | 2014-09-02 | 2014-12-10 | 国家电网公司 | Comprehensive automated information table automatic generating method and system |
| CN105069092A (en) * | 2015-08-05 | 2015-11-18 | 深圳联友科技有限公司 | Report display method, system and mobile terminal |
| CN105893594A (en) * | 2016-04-18 | 2016-08-24 | 中邮建技术有限公司 | Information data design method capable of dynamically configuring data types |
| CN106445536A (en) * | 2016-09-28 | 2017-02-22 | 湛江市霞山区新软佳科技有限公司 | Automated business design management system |
| CN107122961A (en) * | 2017-05-16 | 2017-09-01 | 上海斐晟企业管理有限公司 | Excel nested report data processing methods based on SAP system |
| CN107145477A (en) * | 2017-04-28 | 2017-09-08 | 郑州云海信息技术有限公司 | A kind of reporting system based on FineReport instruments |
| CN103885999B (en) * | 2013-03-28 | 2017-11-07 | 中国证券监督管理委员会信息中心 | A kind of definition XBRL and business corresponding relation index template |
| CN107392560A (en) * | 2016-05-16 | 2017-11-24 | 杨国成 | A kind of Excel list datas issue acquisition method and system based on internet |
| CN109598483A (en) * | 2018-12-03 | 2019-04-09 | 四川长虹电器股份有限公司 | A kind of accurate report work method of the web front-end based on calendar |
| CN109918067A (en) * | 2019-01-23 | 2019-06-21 | 中国平安人寿保险股份有限公司 | Report Customization method, apparatus, client and storage medium |
| CN111143358A (en) * | 2019-12-13 | 2020-05-12 | 航天信息股份有限公司 | Report configuration method and system |
| CN112183050A (en) * | 2020-10-12 | 2021-01-05 | 贵州电网有限责任公司 | Method and system for realizing automatic data report design and collection |
| CN112257398A (en) * | 2020-12-22 | 2021-01-22 | 广州思迈特软件有限公司 | Data processing method, user terminal, server and electronic equipment |
| CN116611412A (en) * | 2023-07-20 | 2023-08-18 | 云筑信息科技(成都)有限公司 | Report form filling and displaying method based on interaction between Excel template and front end |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101599067A (en) * | 2009-06-02 | 2009-12-09 | 广东金宇恒科技有限公司 | A kind of method of self-customizing report forms |
| CN101650711A (en) * | 2009-08-18 | 2010-02-17 | 深圳市科陆电子科技股份有限公司 | Method for generating report |
| CN101650712A (en) * | 2009-08-18 | 2010-02-17 | 深圳市科陆电子科技股份有限公司 | Generating management method and system of self-defined report |
-
2012
- 2012-05-09 CN CN2012101567617A patent/CN102722533A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101599067A (en) * | 2009-06-02 | 2009-12-09 | 广东金宇恒科技有限公司 | A kind of method of self-customizing report forms |
| CN101650711A (en) * | 2009-08-18 | 2010-02-17 | 深圳市科陆电子科技股份有限公司 | Method for generating report |
| CN101650712A (en) * | 2009-08-18 | 2010-02-17 | 深圳市科陆电子科技股份有限公司 | Generating management method and system of self-defined report |
Cited By (20)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2014079304A1 (en) * | 2012-11-26 | 2014-05-30 | 中兴通讯股份有限公司 | Report creation method, device and system |
| CN103885999B (en) * | 2013-03-28 | 2017-11-07 | 中国证券监督管理委员会信息中心 | A kind of definition XBRL and business corresponding relation index template |
| CN103761642A (en) * | 2013-12-29 | 2014-04-30 | 远光软件股份有限公司 | Method and device for report data conversion according to measurement units |
| CN104063468A (en) * | 2014-06-27 | 2014-09-24 | 北京思特奇信息技术股份有限公司 | Data report automatic generating and extracting method and device |
| CN104063468B (en) * | 2014-06-27 | 2017-11-10 | 北京思特奇信息技术股份有限公司 | A kind of data sheet automatically generates and extracting method and device |
| CN104199663A (en) * | 2014-09-02 | 2014-12-10 | 国家电网公司 | Comprehensive automated information table automatic generating method and system |
| CN105069092A (en) * | 2015-08-05 | 2015-11-18 | 深圳联友科技有限公司 | Report display method, system and mobile terminal |
| CN105069092B (en) * | 2015-08-05 | 2018-08-17 | 深圳联友科技有限公司 | A kind of method, system and the mobile terminal of report displaying |
| CN105893594A (en) * | 2016-04-18 | 2016-08-24 | 中邮建技术有限公司 | Information data design method capable of dynamically configuring data types |
| CN107392560A (en) * | 2016-05-16 | 2017-11-24 | 杨国成 | A kind of Excel list datas issue acquisition method and system based on internet |
| CN106445536A (en) * | 2016-09-28 | 2017-02-22 | 湛江市霞山区新软佳科技有限公司 | Automated business design management system |
| CN107145477A (en) * | 2017-04-28 | 2017-09-08 | 郑州云海信息技术有限公司 | A kind of reporting system based on FineReport instruments |
| CN107122961A (en) * | 2017-05-16 | 2017-09-01 | 上海斐晟企业管理有限公司 | Excel nested report data processing methods based on SAP system |
| CN109598483A (en) * | 2018-12-03 | 2019-04-09 | 四川长虹电器股份有限公司 | A kind of accurate report work method of the web front-end based on calendar |
| CN109918067A (en) * | 2019-01-23 | 2019-06-21 | 中国平安人寿保险股份有限公司 | Report Customization method, apparatus, client and storage medium |
| CN109918067B (en) * | 2019-01-23 | 2024-05-03 | 中国平安人寿保险股份有限公司 | Report customization method, device, client and storage medium |
| CN111143358A (en) * | 2019-12-13 | 2020-05-12 | 航天信息股份有限公司 | Report configuration method and system |
| CN112183050A (en) * | 2020-10-12 | 2021-01-05 | 贵州电网有限责任公司 | Method and system for realizing automatic data report design and collection |
| CN112257398A (en) * | 2020-12-22 | 2021-01-22 | 广州思迈特软件有限公司 | Data processing method, user terminal, server and electronic equipment |
| CN116611412A (en) * | 2023-07-20 | 2023-08-18 | 云筑信息科技(成都)有限公司 | Report form filling and displaying method based on interaction between Excel template and front end |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102722533A (en) | Method and system for displaying and filling report | |
| AU2017212801B2 (en) | Systems and methods for securing and disseminating time sensitive information using a blockchain | |
| US11995130B2 (en) | Systems and methods for digitization services | |
| CN104363255A (en) | Distributive patent service system | |
| CN103020093A (en) | Method and system for recording and displaying extensible business reporting language (XBRL) information disclosure report | |
| CN102880683A (en) | Automatic network generation system for feasibility study report and generation method thereof | |
| Zhang | Beyond infrastructure: Re-thinking China’s foreign direct investment in Malaysia | |
| CN105488655A (en) | Free flow-based official document flow method | |
| CN101751400A (en) | System and method of technical data analysis and system of patent analysis | |
| CN115292754A (en) | Credit investigation platform credit data risk monitoring method | |
| CN110704280A (en) | Main data monitoring system | |
| US20150169515A1 (en) | Data driven synthesizer | |
| CN107783870A (en) | A kind of server-compatible test result management method and system | |
| CN117132226A (en) | User behavior auditing and managing system | |
| CN115619552A (en) | Asynchronous processing method and device of transaction bill, electronic equipment and medium | |
| CN103714412A (en) | Sci-tech novelty retrieval management system | |
| Drvar et al. | The future of data collection and data management: Agile RegOps for digitalizing the regulatory value chain | |
| CN112596806A (en) | Data lake data loading script generation method and system | |
| CN101950305A (en) | Method and system for organizing business demonstration data of supply chain network | |
| Hu et al. | Design and Implementation of Project Schedule Management Data Collection and Analysis System | |
| US20170140399A1 (en) | Commitments and forecasting management | |
| US11829343B2 (en) | Generating a business object | |
| Huang | Design and Development of University Information System Based on MDM-A Case Study of the Service Satisfaction Evaluation System | |
| Minggao et al. | Research on the Application of LLM in Power Finance Middle Platform | |
| CN201974846U (en) | Data collecting and counting 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 | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20121010 |