CN101211360A - System and method for processing a plurality of data form of report forms data source - Google Patents
System and method for processing a plurality of data form of report forms data source Download PDFInfo
- Publication number
- CN101211360A CN101211360A CNA2006102014413A CN200610201441A CN101211360A CN 101211360 A CN101211360 A CN 101211360A CN A2006102014413 A CNA2006102014413 A CN A2006102014413A CN 200610201441 A CN200610201441 A CN 200610201441A CN 101211360 A CN101211360 A CN 101211360A
- Authority
- CN
- China
- Prior art keywords
- data
- data source
- source
- database
- binding relationship
- 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 provides a method for processing a plurality of data lists in a report form data source; the method includes the following steps: creating a data source according to users' demands for report forms and establish a plurality of data lists in a folder for the data source; normalized naming of all the data lists and establishing relative relationship for all the data lists; defining data in the database that is necessary for the data source according to users' demands, so as to build a binding relationship between the data source and the database; performing binding for the data field position in the report forms and the same data list in the data source folder or data field positions corresponding to a plurality of data lists, so as to establish binding relationship between the data source and the report forms; according to the binding relationship between the data source and the database, as well as the binding relationship between data sources and report forms, the invention can transmit the necessary data in the created report forms into corresponding field positions in the report forms from the database, so as to create the report forms. The invention further provides a system to process a plurality of data lists in a report forms data source.
Description
Technical field
The present invention relates to a kind of report form processing technology, relate in particular to a kind of system and method for handling a plurality of data forms in the report data source.
Background technology
Crystal report (Crystal Report) is the reporting system the most professional in the industry, that function is the strongest, and it is except powerful report capability, and maximum advantage is the integrated and interface of having realized with the popular developing instrument of the overwhelming majority.Characteristics such as it is powerful, efficient, integrated that crystal report has.
Crystal report also is a kind of instrument of chart production, because it uses simple, powerful, so be widely used in the chart production of various softwares, but, when having a plurality of data form simultaneously in the data source of a form, system is usually owing to confirming that data source causes list data to show.
Summary of the invention
In view of above content, be necessary to provide a kind of system that handles a plurality of data forms in the report data source, it can be placed on a plurality of data forms in the same data source, and the data binding of data source and data of database binding and data source and form is realized in standardize name back of these a plurality of data forms.
In view of above content, also be necessary to provide a kind of method of handling a plurality of data forms in the report data source, it can be placed on a plurality of data forms in the same data source, and the data binding of data source and data of database binding and data source and form is realized in standardize name back of these a plurality of data forms.
A kind of system that handles a plurality of data forms in the report data source, this system comprise computing machine and the database that links to each other with this computing machine.This computing machine comprises: creation module, be used for the demand of form being created a data source and under the catalogue of this data source, creating a plurality of data forms, and set up incidence relation according to the field key word with each data form regularization name and with each data form according to the user; The data binding module, the data that are used for setting the needed database of this data source according to user's needs to be setting up binding relationship with data source and database, and same data form under needed data field in the form and the data source catalogue or the corresponding data field of a plurality of data form are bound so that this data source and form are set up binding relationship; And the report generation module, be used for binding relationship according to the binding relationship of data source and database and data source and form and will generate the required data of form and import to the corresponding field of form from database with the generation form.
A kind of method of handling a plurality of data forms in the report data source, this method comprise the steps: that (a) creates a data source and create a plurality of data forms under the catalogue of this data source the demand of form according to the user; (b) set up incidence relation with each data form regularization name and with each data form according to the field key word; (c) set data in the needed database of this data source so that data source and database are set up binding relationship according to user's needs; (d) same data form under needed data field in the form and the data source catalogue or the corresponding data field of a plurality of data form are bound so that this data source and form are set up binding relationship; And (e) will generate the required data of form and from database, import to the corresponding field of form with the generation form according to the binding relationship of the binding relationship of data source and database and data source and form.
Compared to prior art, the system and method for a plurality of data forms can be placed on a plurality of data forms in the same data source in the described processing report data source, and standardize name back of these a plurality of data forms realized the operations such as data binding of data source and data of database binding and data source and form, whole process is simply quick, error is less, efficiently solves the problem of data collision when a plurality of data forms go out according to form under the data source.
Description of drawings
Fig. 1 is the hardware structure figure that the present invention handles system's better embodiment of a plurality of data forms in the report data source.
Fig. 2 is the functional block diagram that the present invention handles computing machine in system's better embodiment of a plurality of data forms in the report data source.
Fig. 3 is the operation process chart that the present invention handles the method better embodiment of a plurality of data forms in the report data source.
Embodiment
As shown in Figure 1, be the hardware structure figure that the present invention handles system's better embodiment of a plurality of forms in the crystal report data source.This system comprises a computing machine 1 and a database 2.This computing machine 1 is connected 3 with database 2 by one and links to each other.This connection 3 is that a database connects, as the open type data storehouse connect (Open Database Connectivity, ODBC), or the Java database connect (Java Database Connectivity, JDBC) etc.
Store several data in this database 2, be used to the generation form that various Data Sources are provided.Computing machine 1 comprises a plurality of functional modules, be used to create a data source and under the catalogue of this data source, create a plurality of data forms, and above-mentioned a plurality of data forms are standardized data source and database 2 are set up binding relationship and data source and form are set up binding relationship after the name, arrive the corresponding field of form with the generation form thereby utilize the binding relationship of the binding relationship of data source and database 2 and data source and form will generate the required data importing of form.
Consulting shown in Figure 2ly, is the functional block diagram of computing machine.The alleged module of the present invention is to finish the computer program code segments of specific function, be more suitable in the implementation of description software in computing machine than program, so the present invention describes with module the description of software.
Described computing machine 1 mainly comprises: creation module 10, data binding module 11, report generation module 12 and preservation module 13.
Described creation module 10 is used for according to the user demand of form being created a data source (DataSet), when creating a form, all need to create a data source, form is shown to the user according to the data in the data source, acquiescence comprises a data form (DataTable) under the catalogue of the new data source of creating, the user also can create other a plurality of data forms according to the needs of actual creation form under the catalogue of this data source, and utilize the field key word of each data form that each data form is set up incidence relation, and each data form must carry out the regularization name.In this preferred embodiment, the regularization of each data form name all adds the numeral name with Table, Table for example, Table1, Table2 etc.
The data that data binding module 11 is used for setting the needed database 2 of this data source according to user's needs to be setting up binding relationship with data source and database 2, and same data form under needed data field in the form and the data source catalogue or the corresponding data field of a plurality of data form are bound so that this data source and form are set up binding relationship.This data source is actually a data container, is a place that holds the required video data of form, and the user can be this data source binding data as required, and the needed data of data source promptly are set, and binds with database 2 then.
The form that preservation module 13 is used for being generated is kept at computing machine 1.
As shown in Figure 3, be the operation process chart that the present invention handles the method better embodiment of a plurality of data forms in the report data source.
It should be noted that at last, above embodiment is only unrestricted in order to technical scheme of the present invention to be described, although the present invention is had been described in detail with reference to preferred embodiment, those of ordinary skill in the art is to be understood that, can make amendment or be equal to replacement technical scheme of the present invention, and not break away from the spirit and scope of technical solution of the present invention.
Claims (6)
1. system that handles a plurality of data forms in the report data source, this system comprise computing machine and the database that links to each other with this computing machine, it is characterized in that this computing machine comprises:
Creation module is used for the demand of form being created a data source and create a plurality of data forms under the catalogue of this data source according to the user, and sets up incidence relation with each data form regularization name and with each data form according to the field key word;
The data binding module, the data that are used for setting the needed database of this data source according to user's needs to be setting up binding relationship with data source and database, and same data form under needed data field in the form and the data source catalogue or the corresponding data field of a plurality of data form are bound so that this data source and form are set up binding relationship; And
The report generation module is used for binding relationship according to the binding relationship of data source and database and data source and form and will generates the required data of form and import to the corresponding field of form from database to generate form.
2. the system of a plurality of data forms is characterized in that in the processing report data as claimed in claim 1 source, and described each data form regularization name is meant data form is added the numeral name with Table.
3. the system of a plurality of data forms is characterized in that described computing machine also comprises the preservation module in the processing report data as claimed in claim 1 source, and the form that is used for being generated is kept at computing machine.
4. a method of handling a plurality of data forms in the report data source is characterized in that, this method comprises the steps:
According to the user demand of form is created a data source and create a plurality of data forms under the catalogue of this data source;
Set up incidence relation with each data form regularization name and with each data form according to the field key word;
Set data in the needed database of this data source so that data source and database are set up binding relationship according to user's needs;
Same data form under needed data field in the form and the data source catalogue or the corresponding data field of a plurality of data form are bound so that this data source and form are set up binding relationship; And
To generate the required data of form according to the binding relationship of the binding relationship of data source and database and data source and form and from database, import to the corresponding field of form to generate form.
5. the method for a plurality of data forms is characterized in that in the processing report data as claimed in claim 4 source, and described each data form regularization name is meant data form is added the numeral name with Table.
6. the method for a plurality of data forms is characterized in that this method also comprises step: the form that is generated is kept in the computing machine in the processing report data as claimed in claim 4 source.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2006102014413A CN101211360A (en) | 2006-12-28 | 2006-12-28 | System and method for processing a plurality of data form of report forms data source |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2006102014413A CN101211360A (en) | 2006-12-28 | 2006-12-28 | System and method for processing a plurality of data form of report forms data source |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101211360A true CN101211360A (en) | 2008-07-02 |
Family
ID=39611392
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNA2006102014413A Pending CN101211360A (en) | 2006-12-28 | 2006-12-28 | System and method for processing a plurality of data form of report forms data source |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101211360A (en) |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101976236A (en) * | 2010-09-26 | 2011-02-16 | 用友软件股份有限公司 | Method and device for importing floating row data through worksheet |
| CN101763348B (en) * | 2008-12-26 | 2011-12-07 | 英业达股份有限公司 | Dynamic table type data acquisition system and method |
| CN102521711A (en) * | 2011-12-26 | 2012-06-27 | 北京瑞风协同科技股份有限公司 | Control method and device for construction of quality characteristic data model of equipment |
| CN108428030A (en) * | 2017-08-12 | 2018-08-21 | 中民筑友科技投资有限公司 | Quota store based on BIM and the associated method and device of WBS base libraries |
| WO2018201896A1 (en) * | 2017-05-04 | 2018-11-08 | 平安科技（深圳）有限公司 | List structure modelling method and apparatus, server and medium |
| CN109035480A (en) * | 2018-08-09 | 2018-12-18 | 北京智行者科技有限公司 | A kind of report data generation method |
| CN109102088A (en) * | 2018-08-09 | 2018-12-28 | 北京智行者科技有限公司 | A kind of processing method of report data |
| CN109117469A (en) * | 2018-09-03 | 2019-01-01 | 平安科技（深圳）有限公司 | Excel report file generation method, device, computer equipment and storage medium |
| CN117746999A (en) * | 2024-02-20 | 2024-03-22 | 之江实验室 | Data processing method and device, storage medium and electronic equipment |
-
2006
- 2006-12-28 CN CNA2006102014413A patent/CN101211360A/en active Pending
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101763348B (en) * | 2008-12-26 | 2011-12-07 | 英业达股份有限公司 | Dynamic table type data acquisition system and method |
| CN101976236A (en) * | 2010-09-26 | 2011-02-16 | 用友软件股份有限公司 | Method and device for importing floating row data through worksheet |
| CN102521711A (en) * | 2011-12-26 | 2012-06-27 | 北京瑞风协同科技股份有限公司 | Control method and device for construction of quality characteristic data model of equipment |
| CN102521711B (en) * | 2011-12-26 | 2016-03-02 | 北京瑞风协同科技股份有限公司 | The control method of the data model structure of equipment quality characteristic and device |
| WO2018201896A1 (en) * | 2017-05-04 | 2018-11-08 | 平安科技（深圳）有限公司 | List structure modelling method and apparatus, server and medium |
| CN108428030A (en) * | 2017-08-12 | 2018-08-21 | 中民筑友科技投资有限公司 | Quota store based on BIM and the associated method and device of WBS base libraries |
| CN109035480A (en) * | 2018-08-09 | 2018-12-18 | 北京智行者科技有限公司 | A kind of report data generation method |
| CN109102088A (en) * | 2018-08-09 | 2018-12-28 | 北京智行者科技有限公司 | A kind of processing method of report data |
| CN109117469A (en) * | 2018-09-03 | 2019-01-01 | 平安科技（深圳）有限公司 | Excel report file generation method, device, computer equipment and storage medium |
| CN117746999A (en) * | 2024-02-20 | 2024-03-22 | 之江实验室 | Data processing method and device, storage medium and electronic equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101211360A (en) | System and method for processing a plurality of data form of report forms data source | |
| US8069184B2 (en) | Systems and methods to implement extensibility of tenant content in a provider-tenant environment | |
| CN106776780B (en) | Data exchange and sharing method and system in cloud environment | |
| CN100388675C (en) | A method for implementing foreground data configuration in network management system | |
| US7680825B2 (en) | Systems and methods for generating tenant-specific properties for use in a provider-tenant environment | |
| CN101651576B (en) | Alarm information processing method and system | |
| CN105205117A (en) | Data table migrating method and device | |
| CN103210386B (en) | Method, system and the equipment of conglomeration search | |
| CN1233801A (en) | Message broker apparatus, method and computer program product | |
| CN102073640A (en) | Method, system and server for testing structured query language (SQL) statements | |
| TW200931285A (en) | Method, system and apparatus for combining distributed computational data | |
| CN103218294A (en) | Debugging method for embedded system, debugging conversion device and system | |
| CN109408507B (en) | Multi-attribute data processing method, device, equipment and readable storage medium | |
| CN104461516A (en) | Data processing method and device | |
| CN107347062A (en) | A kind of method, electronic equipment and the readable storage medium storing program for executing of daily record data processing | |
| CN105975489A (en) | Metadata-based online SQL code completion method | |
| CN107133233B (en) | Processing method and device for configuration data query | |
| CN102402515A (en) | General custom query system and method | |
| CN110647564A (en) | Hive table establishing method, electronic device and computer readable storage medium | |
| CN101335763B (en) | Data educing and transmitting method in intelligent network system | |
| CN113468571A (en) | Tracing method based on block chain | |
| US10846307B1 (en) | System and method for managing interactions with a data lake | |
| US20200089845A1 (en) | System and method for inter-program file control communication | |
| CN108573171A (en) | Greenplum data desensitization method, device, equipment and medium | |
| CN108932119B (en) | Project layering method based on android 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 | ||
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |
Open date: 20080702 |