CN106897389A - Generate the device and method of report - Google Patents
Generate the device and method of report Download PDFInfo
- Publication number
- CN106897389A CN106897389A CN201710059894.5A CN201710059894A CN106897389A CN 106897389 A CN106897389 A CN 106897389A CN 201710059894 A CN201710059894 A CN 201710059894A CN 106897389 A CN106897389 A CN 106897389A
- Authority
- CN
- China
- Prior art keywords
- data
- report
- project
- extracted
- mesh
- 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.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 58
- 230000008676 import Effects 0.000 claims abstract description 20
- 230000003362 replicative effect Effects 0.000 claims description 14
- 238000000605 extraction Methods 0.000 claims description 13
- 230000010076 replication Effects 0.000 claims description 7
- 238000004891 communication Methods 0.000 description 6
- 230000006870 function Effects 0.000 description 4
- 238000011156 evaluation Methods 0.000 description 3
- 235000015170 shellfish Nutrition 0.000 description 3
- 230000008859 change Effects 0.000 description 2
- 230000000694 effects Effects 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 238000010586 diagram Methods 0.000 description 1
- 230000007613 environmental effect Effects 0.000 description 1
- 239000004744 fabric Substances 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 238000007639 printing Methods 0.000 description 1
- 230000008569 process Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
Abstract
The present invention provides a kind of method for generating report, is applied to be provided with the electronic equipment of the application for generating report.The method includes：Import Reports template and at least two data sources；The report template includes at least one mesh；Each project in described at least one mesh is arranged at a corresponding region in the report template；Data corresponding with each project in described at least one mesh are extracted respectively from least two data sources for importing；The corresponding region of each project is copied to after data copy corresponding with each project will be extracted；The report of a preset format of output.Present invention also offers a kind of device for generating report.Can be according to the report template and at least two data sources using the present invention, automatically generate and export a report for meeting the report template, thus, it is to avoid the report of artificial desintegration different data sources, reduce human cost, and relative to manually integrating more difficult error.
Description
Technical field
The present invention relates to enterprise information management system technical field, more particularly to a kind of device for generating report and generation report
The method of announcement.
Background technology
This part is it is intended that the embodiments of the present invention stated in claims provide background or context.Herein
Description in being included in this part because just do not recognize it is prior art.
The operation systems such as assets, budget generation report typically by the data in a data source imported into report template with
Generation report, and the form of its report template be generally all preset, it is changeless.For example, when carrying out Real Estate Appraisal, being
System can pre-set the report template of Real Estate Appraisal report, and multiple evaluation items are provided with report template, each assessment
Predeterminable area of the item setup in report template.When to assess certain house property, the data of the house property are imported, by the house property data
The data of correspondence each evaluation item copy to the corresponding predeterminable area of each evaluation item in report template respectively, and automatically generate
A Real Estate Appraisal report.However, in the above method, when multiple data sources are all imported into report template to generate one
During part report, such as when certain client has multiple house properties, if desired for the assessment that its multiple house property is recorded in a assessment report
As a result, the corresponding multiple reports of multiple data source generations are typically directed respectively into, it is then manually that the content of multiple reports is whole again
In closing a report.Thus human cost is of a relatively high, and manually integration report is easier to error.
The content of the invention
In consideration of it, be necessary to provide a kind of device and method for automatically generating report, can be according to a report template and many
Individual data source generates a report for meeting the report template automatically, to solve the above problems.
The present invention provides a kind of method for generating report, is applied to be provided with the electronic equipment of the application for generating report.Institute
The method for stating generation report includes：
Import Reports template and at least two data sources；The report template includes at least one mesh；It is described at least one
Each project in mesh is arranged at a corresponding region in the report template；In at least two data source, each data
Source is comprising at least one mesh in the report template；
Number corresponding with each project in described at least one mesh is extracted respectively from least two data sources for importing
According to；
The corresponding region of each project is copied to after data copy corresponding with each project will be extracted；
Wherein, in the corresponding region of each project, the corresponding region of an at least project includes described at least two for being extracted
The corresponding data of data source；
The report of a preset format of output.
Further, the present invention provide generation report method in, the layout type of the report of the preset format with
The layout type of the report template matches；The project of the entry format of the report of the preset format and the report template
Form matches.
Further, in the method for the generation report that the present invention is provided, in the report template, each single item purpose project lattice
Include starting symbol and terminating symbol in formula, the beginning symbol is arranged at the original position of respective items purpose region, described
Terminating symbol is arranged at the end position of respective items purpose region.
Further, in the method for the generation report that the present invention is provided：
It is described " to be extracted that copy to each project after data copy corresponding with each project corresponding
Region " includes：The duplication the position of symbol since the corresponding region of a destination item in described at least one mesh
One data, first data are by the data corresponding with the destination item extracted from the first data source of copy；
When the terminating symbol in the corresponding region of the destination item is detected, stop replicate data；
Judge whether to be extracted the second data corresponding with the destination item；
When extraction there are the second data corresponding with the destination item, institute is replicated after first data for replicating
State the entry format of destination item；
The second data are replicated since the position of the primary sign of the entry format for replicating, second data are copy
The data corresponding with the destination item extracted from the second data source；
When the terminating symbol of entry format of duplication is detected, stop replicate data.
Further, the method for the generation report that the present invention is provided also includes：
Data interpolation data source corresponding with each project will be extracted to identify；
According to the data source identification of addition, in the predeterminated position of the corresponding data of described each project of the report template
Add corresponding data source information.
Further, in the method for the generation report that the present invention is provided：
The report template includes assets assessment report template；
At least two data source includes：
At least two property data sources of same client；Or
An at least property data source of one client and an at least property data source of the client related to a client.
The present invention also provides a kind of device for generating report, is applied to be provided with the electronic equipment of the application that generation is reported,
The device of the generation report includes：
Import modul, for Import Reports template and at least two data sources；The report template includes at least one mesh；
Each project in described at least one mesh is arranged at a corresponding region in the report template；At least two data source
In, each data source is comprising at least one mesh in the report template；
Extraction module, for from import at least two data sources in extract respectively with it is each in described at least one mesh
The corresponding data of project；
Copy replication module, copy to after data copy corresponding with each project described every for that will be extracted
The corresponding region of one project；Wherein, in the corresponding region of each project, the corresponding region of an at least project includes and is carried
The corresponding data of at least two data source for taking；
Output module, the report for exporting preset format.
Further, the present invention provide generation report device in, the layout type of the report of the preset format with
The layout type of the report template matches；The project of the entry format of the report of the preset format and the report template
Form matches.
Further, in the device of the generation report that the present invention is provided：
Include starting symbol and terminating symbol, the beginning in the report template, in each single item purpose entry format
Symbol is arranged at the original position of respective items purpose region, and the terminating symbol is arranged at the stop bits of respective items purpose region
Put；
The copy replication module is additionally operable to：
It is described " to be extracted that copy to each project after data copy corresponding with each project corresponding
Region " includes：The duplication the position of symbol since the corresponding region of a destination item in described at least one mesh
One data, first data are by the data corresponding with the destination item extracted from the first data source of copy；
When the terminating symbol in the corresponding region of the destination item is detected, stop replicate data；
Judge whether to be extracted the second data corresponding with the destination item；
When extraction there are the second data corresponding with the destination item, institute is replicated after first data for replicating
State the entry format of destination item；
The second data are replicated since the position of the primary sign of the entry format for replicating, second data are copy
The data corresponding with the destination item extracted from the second data source
When the terminating symbol of entry format of duplication is detected, stop replicate data.
Further, the device of the generation report that the present invention is provided also includes：
Add module, identifies for will be extracted data interpolation data source corresponding with each project；And use
It is right in the predeterminated position addition of the corresponding data of described each project of the report template in the data source identification according to addition
The data source information answered.
Further, in the device of the generation report that the present invention is provided：
The report template includes assets assessment report template；
At least two data source includes：
At least two property data sources of same client；Or
An at least property data source of one client and an at least property data source of the client related to a client.
The device for generating report and the method for generation report that the present invention is provided, divide from least two data sources for importing
Data corresponding with each project in described at least one mesh are indescribably taken, and will be extracted corresponding with each project
Data copy is to the corresponding region of each project so that in the corresponding region of each project, an at least project pair
The region answered includes the corresponding data of at least two data source extracted, and the report of a preset format is exported afterwards.
, according to the report template and at least two data sources, output portion meets the report of the report template for it, thus, it is to avoid
The report of artificial desintegration different data sources, reduces human cost, and relative to manually integrating more difficult error.
Brief description of the drawings
Fig. 1 is the flow chart of the method for the generation report of first embodiment of the invention.
Fig. 2 is the flow chart of the method for the generation report of second embodiment of the invention.
Fig. 3 is the flow chart of the method for the generation report of third embodiment of the invention.
Fig. 4 is the exemplary structural representation of the electronic equipment of an embodiment of the present invention.
Fig. 5 is the exemplary functional block diagram of the device of the generation report of an embodiment of the present invention.
Main element symbol description
Following specific embodiment will further illustrate the present invention with reference to above-mentioned accompanying drawing.
Specific embodiment
It is below in conjunction with the accompanying drawings and specific real in order to be more clearly understood that the above objects, features and advantages of the present invention
The present invention will be described in detail to apply mode.It should be noted that in the case where not conflicting, presently filed embodiment and reality
Applying the feature in mode can be mutually combined.
Many details are elaborated in the following description in order to fully understand the present invention, described implementation method
Only a part of implementation method of the invention, rather than whole implementation methods.Based on the implementation method in the present invention, this area
The every other implementation method that those of ordinary skill is obtained under the premise of creative work is not made, belongs to guarantor of the present invention
The scope of shield.
Unless otherwise defined, all of technologies and scientific terms used here by the article with belong to technical field of the invention
The implication that technical staff is generally understood that is identical.The term for being used in the description of the invention herein is intended merely to description tool
The purpose of the implementation method of body, it is not intended that in the limitation present invention.
In the present invention, " report " refer to comprising herein below at least one written official document or private text, Ke Yishi
It is electronic form, or papery.The including but not limited to report of word forms, the report of ppt forms, excel forms
Report.
" data source " refers to the device or original media for providing data required for report.All foundation are stored in data source
The information of database connection.By providing correct DSN, you can find corresponding database connection.
In the present invention, using a report template, based at least two data sources, the report of a preset format of output,
The data extracted from one or two data sources can be included in the report of output, under same project, under at least one project
Include the data of at least two data source.Thus, in the report of output, can be comprising described at least under same project
Data in two data sources.
Further, in the present invention, the form of the report of output and be laid out can respectively with the form and cloth of report template
Office matches.Thus, in the report of output, form and layout based on report template are capable of achieving, different data sources correspondence is presented
Data.In the report of output, under same project, the form that the data of each data source are presented is identical, that is, repeat；And
And under same project, the content of each data source of presentation is also all content corresponding with the same project, that is, in number
It is also what is repeated on corresponding relation according to content and project.
Include starting symbol and terminating symbol, the beginning in the report template, in each single item purpose entry format
Symbol is arranged at the original position of respective items purpose region, and the terminating symbol is arranged at the stop bits of respective items purpose region
Put.When performing the present invention, met using starting of setting of the corresponding region of project in report template and terminating symbol is replicated
The corresponding data of the project extracted from data source.And, when there are the corresponding data of same project in each data source, can
The corresponding region of the project is copied to after all being copied with the corresponding data of the project that will be extracted.
Specifically, corresponding first data of the project that can will be extracted and copy from the first data source, and according to report
The entry format of the project in slide former, the position of symbol is replicated since the corresponding region setting of the project, until will copy
First data duplication of shellfish after the terminating symbol for detecting the corresponding region of the project, judges to the corresponding region of the project
Whether with the project corresponding second data are extracted, if it is, being replicated after first data for replicating described
The entry format of project, replicates the second data, second data since the position of the primary sign of the entry format for replicating
It is the data corresponding with the project extracted from the second data source of copy；When the knot of the entry format for detecting duplication
During beam symbol, stop replicate data.
It is achieved thereby that using the preset term form of the project in report template, the data of the first data source that will be copied
This purpose region is copied to, then further according to preset term form, the data of the second data source for copying this is also copied to
Item purpose region.
Fig. 1 is the flow chart of the method for the generation report of first embodiment of the invention, and the method for the generation report can
It is applied to be provided with the electronic equipment of the application that generation is reported.As shown in figure 1, the method for generation report includes following step
Suddenly：
101：Import Reports template and at least two data sources；The report template include at least one mesh, it is described at least
Each project in one project is arranged at a corresponding region in the report template, at least two data source, each
Data source is comprising at least one mesh in the report template.
The report template and at least two data sources can be stored in the electronic equipment, it is also possible to be stored in
In another electronic equipment (such as server) of electronic equipment communication connection.Can also be that the report template storage exists
In the electronic equipment, and at least two data source is stored in another electronic equipment, as long as the electronic equipment can
The report template and at least two data sources are obtained and imported, is not limited herein.
It is understood that the report template can be assets assessment template, such as template of Real Estate Appraisal report.
In report template, each project is all disposed within a corresponding region, and the corresponding region of each project is different.
At least two data source can include：At least two property data sources of same client；Or one client extremely
A few property data source and an at least property data source of the client related to a client.For example, it may be client A is extremely
The data source of the data source of few two data of real estate assets, or at least data of a real estate assets of client A
With its company or the data source of at least data of a real estate assets of its family members.
Described at least one mesh can include it is following at least one：Obligee's Name or Designation, right obtain the time,
Right acquisition modes, estimated value, fitting case and ambient environmental conditions.
The report template and at least two data source can be stored in performing the method for the generation report
In electronic equipment, it is also possible to which in another electronic equipment for passing through network connection with the electronic equipment, such as one services for storage
In device.Or the report template is stored in the electronic equipment and at least two number is stored in another electronic equipment
According to source, it is not limited herein.
It is understood that can also comprise the following steps after step 101：Receive the instruction of generation report.For example,
In the operation systems such as assets, budget, user can set pressing for the generation report of user interface in systems by clicking on
Button, to allow system to generate and receive the instruction of generation report.In other embodiments, generation report will can also be received
The step of instruction, is set before step 101, for example, it may be user clicks on generation report instruction, at least two is then chosen again
Individual data source, and Import Reports template and at least two data sources of selection.The mode for implementing can be arranged as required to,
It is not limited herein.
102：Extract corresponding with each project in described at least one mesh respectively from least two data sources for importing
Data.
For example, when having the first data source and the second data source, the corresponding number of first item is extracted from the first data source
According to the corresponding data of extraction first item from the second data source；The corresponding data of second item are extracted from the second data source,
The corresponding data of second item are extracted from the second data source.By that analogy.The order of extraction can also be arranged as required to, only
Will most the data of the respective disparity items of correspondence be all extracted in all of data source at last.
103：To be extracted that copy to each project after data copy corresponding with each project corresponding
Region, wherein, in the corresponding region of each project, the corresponding region of an at least project include extracted it is described at least
The corresponding data of two data sources.For example, when having the first data source and the second data source, by what is extracted from the first data source
The corresponding data of first item and extracted from the second data source during the corresponding data of first item all copy report template to
The corresponding region of first item.The corresponding data of second item will be extracted from the second data source and from the second data source
Extract the corresponding region of second item that the corresponding data of second item are all copied in report template.By that analogy.Extraction is copied
The order of shellfish can also be arranged as required to, as long as most the data of correspondence same project are all copied in all of data source at last
The corresponding region of the same project.
It is understood that in present embodiment, may be arranged as：In at least two data source extracted with
The corresponding data of same project are arranged according to preset order.For example, in the corresponding region of same project in report template, will
From the first data source extract data arrangement corresponding with the same project from the second data source extract with it is described
Before the corresponding data of same project.When there is more data sources, respectively sequential extracted from each data source with institute
State the corresponding data of same project.
104：The report of a preset format of output.The preset format can be .doc forms, or .ppt etc.
Extended formatting.That is, the report of output can be the document of the forms such as word document, or ppt.
It is described output preset format report can include it is following at least one：Show the report of the preset format
Accuse, show the preview interface of the report of the preset format, the report of the preset format is sent to printer printing.
It is understood that before step 104, the step of the form reported according to advance rule adjustment can also be set
Suddenly, after the form of basis advance rule adjustment report has been performed, then this part of report of preset format is exported.The advance rule can
With including at least one in following：Font in report is adjusted to default font, according to default typesetting format to report
Carry out typesetting, add undertaker's name and/or stamped signature in the stamped signature position of report.
It is understood that the layout type of the report of the preset format and entry format respectively with the report template
Layout type match with entry format.That is, the layout and the layout of the report template of the report of output are phases
Match, and the form of the report of output matches with the form of the report template.It is described match including：It is identical
It is close or identical.
Present embodiment provide the generation report method, from import at least two data sources in respectively extract with
The corresponding data of each project in described at least one mesh, and data copy corresponding with each project will be extracted
To the corresponding region of each project, after the completion of all items in described at least one mesh are copied, output is a pre-
If the report of form.It meets the report of the report template according to the report template and at least two data sources, output portion
Accuse, thus, it is to avoid the report of artificial desintegration different data sources, human cost is reduced, and integrate more relative to artificial
Do not allow error-prone.
Fig. 2 is the flow chart of the method for the generation report of second embodiment of the invention.Described second embodiment with
First embodiment is differred primarily in that, in second embodiment, the also data interpolation data source mark including that will be extracted
And in report the step of the predeterminated position of data adds corresponding data source information.It should be noted that in the present invention
Spirit or essential attributes in the range of, it is adaptable to each concrete scheme in first embodiment can also accordingly be applied to the
In two implementation methods, for the sake of saving space and avoiding to repeat, just repeat no more herein.
The method of the generation report shown in Fig. 2 can be applied in the operation systems such as assets, budget.As shown in Fig. 2 the generation
The method of report comprises the following steps：
201：Import Reports template and at least two data sources；The report template include at least one mesh, it is described at least
Each project in one project is arranged at a corresponding region in the report template, at least two data source, each
Data source is comprising at least one mesh in the report template.
202：Extract corresponding with each project in described at least one mesh respectively from least two data sources for importing
Data.
203：Data interpolation data source corresponding with each project will be extracted to identify.
The data source identification is to identify the source of the data of the extraction, e.g. the first data source or the second data source
Deng.
204：To be extracted that copy to each project after data copy corresponding with each project corresponding
Region；Wherein, in the corresponding region of each project, the corresponding region of an at least project include extracted it is described at least
The corresponding data of two data sources.It is understood that these data extracted have been added with data source identification.
205：According to the data source identification of addition, the report template the corresponding data of described each project it is default
Add corresponding data source information in position.The predeterminated position can be in the foremost of corresponding data, it is also possible to according to need
It is arranged on other positions.The data source information can include the bibliographic information of data, certain assets of such as certain client
Information.
206：The report of a preset format of output.
The method of the generation report that present embodiment is provided, in addition to the technique effect with first embodiment, also
Predeterminated position including the data interpolation data source mark that will be extracted and in data in report adds corresponding data source
The step of information, thus automatically generated satisfactory report.
Fig. 3 is the flow chart of the method for the generation report of third embodiment of the invention.Described the 3rd implementation method with
First embodiment is differred primarily in that, in the 3rd implementation method, also describe the report template entry format and
The specific steps of different data sources are replicated according to entry format.It should be noted that in spirit or essential attributes of the invention
In the range of, it is adaptable to it is real that each concrete scheme in first embodiment and second embodiment can also accordingly be applied to the 3rd
Apply in mode, for the sake of saving space and avoiding to repeat, just repeat no more herein.
The method of the generation report described in Fig. 3 can apply in the operation systems such as assets, budget.As shown in figure 3, the life
Method into report comprises the following steps：
301：Import Reports template and at least two data sources；The report template includes at least one mesh；It is described at least
Each project in one project is arranged at a corresponding region in the report template；In at least two data source, each
Data source is comprising at least one mesh in the report template.
Include starting symbol and terminating symbol, the beginning in the report template, in each single item purpose entry format
Symbol is arranged at the original position of respective items purpose region, and the terminating symbol is arranged at the stop bits of respective items purpose region
Put.
302：Extract corresponding with each project in described at least one mesh respectively from least two data sources for importing
Data.
303：Replicated the position of symbol since the corresponding region of a destination item in described at least one mesh
First data, first data are by the data corresponding with the destination item extracted from the first data source of copy.
304：When the terminating symbol in the corresponding region of the destination item is detected, stop replicate data.
305：Judge whether to be extracted the second data corresponding with the destination item, if it is, into step 306,
Otherwise enter step 309.
306：The entry format of the destination item is replicated after first data for replicating.
307：The second data are replicated since the position of the primary sign of the entry format for replicating, second data are to copy
The data corresponding with the destination item extracted from the second data source of shellfish.
308：When the terminating symbol of entry format of duplication is detected, stop replicate data.
309：The report of a preset format of output.
The method of the generation report that present embodiment is provided, in addition to the technique effect with first embodiment, also
Entry format including the destination item in the report template replicates the specific steps of different data sources, thus automatic raw
Into satisfactory report.
Above is the detailed description carried out to method provided by the present invention.According to different demands, in shown flow chart
The execution sequence of square can change, and some squares can be omitted.Electronic equipment provided by the present invention is described below.
Fig. 4 be an embodiment of the present invention in, there is provided Ying Yong the respective embodiments described above electronic equipment structural representation.As schemed
Shown in 4, electronic equipment 1 includes storage device 10.Described electronic equipment 1 can be the electronic equipments such as computer, server.
Electronic equipment 1 also includes the device 100 of generation report as shown in Figure 5, and the device 100 for generating report can be stored
In the storage device 10.The device 100 of described generation report can be used for Import Reports template and at least two data sources,
Data corresponding with each project in described at least one mesh are extracted respectively from least two data sources for importing, and by institute
The data copy corresponding with each project extracted exports a preset format to the corresponding region of each project
Report.It meets the report of the report template according to the report template and at least two data sources, output portion, because
And, it is to avoid the report of artificial desintegration different data sources, reduce human cost, and also it is more difficult relative to manually integrating
Error.
In present embodiment, electronic equipment 1 is a computer.Electronic equipment 1 can also include communication module 20, display screen
30 and processor 40.Storage device 10, communication module 20, display screen 30 can be electrically connected with processor 40 respectively.It is appreciated that
, electronic equipment 1 can also include other unshowned hardware.
Described storage device 10 can be different type storage device, for storing Various types of data.For example, it may be electric
The internal memory of sub- equipment 1, can also be the storage card that can be external in the electronic equipment 1, such as flash memory, SM cards (Smart Media
Card, smart media card), SD card (Secure Digital Card, safe digital card) etc..Storage device 10 is used to store each
Class data, for example, in the electronic equipment 1 install including generation report application program (Applications), using upper
State generation report method and set, the information such as the data that obtain.
Communication module 20 can be used for carrying out communication with other electronic equipments such as server being connected, to obtain data source etc.
Data.In one embodiment, electronic equipment 1 can not also include communication module 20.
Display screen 30 is installed on electronic equipment 1, is displayed for information.
Processor 40 is used to perform the method and the interior all kinds of softwares installed of the electronic equipment 1 of the generation report,
Software of such as operating system, the application of generation report and generation report etc..Processor 40 is including but not limited to processor
(Central Processing Unit, CPU), micro-control unit (Micro Controller Unit, MCU) etc. are used to explain
The device of the data in computer instruction and treatment computer software.
The device 100 of the generation report of electronic equipment 1 can include the module of one or more, one or more of moulds
Block can be stored in the storage device 10 of electronic equipment 1 and may be configured to by one or more processors (this implementation
Mode is a processor 40) perform, to complete the present invention.For example, refering to shown in Fig. 5, the device 100 of the generation report can
With including import modul 11, extraction module 12, copy replication module 13, output module 14, add module 15 and receiver module 16.
Module alleged by the present invention is the program segment for completing a specific function, than program more suitable for description software holding within a processor
Row process.
It is understood that each implementation method in the method for the above-mentioned generation report of correspondence, the device 100 for generating report can
To introduced in detail below with the function including part or all in each functional module shown in Fig. 5, each module.Need
Illustrate, identical noun related terms and its specific explanation in each implementation method of the method for above generation report
It is readily adaptable for use in the following function introduction to each module.For the sake of saving space and avoiding to repeat, just repeat no more herein.
Import modul 11 can be used for Import Reports template and at least two data sources；The report template includes at least one
Mesh；Each project in described at least one mesh is arranged at a corresponding region in the report template；At least two number
According in source, each data source is comprising at least one mesh in the report template.
Extraction module 12 can be used for from import at least two data sources in extract respectively with described at least one mesh
The corresponding data of each project.
Copy replication module 13 copies to institute after can be used to being extracted data copy corresponding with each project
State the corresponding region of each project；Wherein, in the corresponding region of each project, the corresponding region of an at least project includes
The corresponding data of at least two data source extracted.
When all items that output module 14 can be used in described at least one mesh copy completion, preset format is exported
Report.
Add module 15 can be used to being extracted data interpolation data source corresponding with each project and identify；And
Can be used for the data source identification according to addition, add in the predeterminated position of the corresponding data of described each project of the report template
Plus corresponding data source information.
Receiver module 16 can be used for after the import modul Import Reports template and at least two data sources, receive life
Into the instruction of report.
Described copy replication module 13 can be additionally used in：
Since the corresponding region of a destination item at least one mesh in report template the position of symbol
The first data are replicated, first data are by the number corresponding with the destination item extracted from the first data source of copy
According to；
When the terminating symbol in the corresponding region of the destination item is detected, stop replicate data；
Judge whether to be extracted the second data corresponding with the destination item；
When extraction there are the second data corresponding with the destination item, institute is replicated after first data for replicating
State the entry format of destination item；
The second data are replicated since the position of the primary sign of the entry format for replicating, second data are copy
The data corresponding with the destination item extracted from the second data source；
When the terminating symbol of entry format of duplication is detected, stop replicate data.
In several specific embodiments provided by the present invention, it should be understood that disclosed electronic equipment and method,
Can realize by another way.For example, system embodiment described above is only schematical, for example, described
The division of module, only a kind of division of logic function, can there is other dividing mode when actually realizing.
It is obvious to a person skilled in the art that the invention is not restricted to the details of above-mentioned one exemplary embodiment, Er Qie
In the case of without departing substantially from spirit or essential attributes of the invention, the present invention can be in other specific forms realized.Therefore, no matter
From the point of view of which point, embodiment all should be regarded as exemplary, and be nonrestrictive, the scope of the present invention is by appended power
Profit requires to be limited rather than described above, it is intended that all in the implication and scope of the equivalency of claim by falling
Change is included in the present invention.Any reference in claim should not be considered as the claim involved by limitation.This
Outward, it is clear that " including " word is not excluded for other units or step, odd number is not excluded for plural number.System, device or electronic equipment right
It is required that in multiple units for stating, module or device software or hardware can also be passed through by same unit, module or device
To realize.The first, the second grade word is used for representing title, and is not offered as any specific order.
Embodiment of above is merely illustrative of the technical solution of the present invention and unrestricted, although the preferably embodiment party with reference to more than
Formula has been described in detail to the present invention, it will be understood by those within the art that, can be to technical scheme
Modify or equivalent should not all depart from the spirit and scope of technical solution of the present invention.
Claims (10)
1. a kind of method for generating report, is applied to be provided with the electronic equipment of the application that generation is reported, it is characterised in that bag
Include：
Import Reports template and at least two data sources；The report template includes at least one mesh；In described at least one mesh
Each project be arranged at a corresponding region in the report template；In at least two data source, each data source is equal
Comprising at least one mesh in the report template；
Data corresponding with each project in described at least one mesh are extracted respectively from least two data sources for importing；
The corresponding region of each project is copied to after data copy corresponding with each project will be extracted；Its
In, in the corresponding region of each project, the corresponding region of an at least project includes at least two number for being extracted
According to the corresponding data in source；
The report of a preset format of output.
2. the method that generation as claimed in claim 1 is reported, it is characterised in that：The layout type of the report of the preset format
Layout type with the report template matches；The item of the entry format of the report of the preset format and the report template
Mesh form matches.
3. the method that generation as claimed in claim 2 is reported, it is characterised in that：In the report template, each single item purpose
Include starting symbol and terminating symbol in mesh form, the beginning symbol is arranged at the original position of respective items purpose region,
The terminating symbol is arranged at the end position of respective items purpose region.
4. the method that generation as claimed in claim 3 is reported, it is characterised in that：
It is described " to copy to the corresponding area of each project after data copy corresponding with each project be extracted
Domain " includes：The duplication first the position of symbol since the corresponding region of a destination item in described at least one mesh
Data, first data are by the data corresponding with the destination item extracted from the first data source of copy；
When the terminating symbol in the corresponding region of the destination item is detected, stop replicate data；
Judge whether to be extracted the second data corresponding with the destination item；
When extraction there are the second data corresponding with the destination item, the mesh is replicated after first data for replicating
The entry format of mark project；
Replicate the second data since the position of the primary sign of the entry format for replicating, second data are copy from the
The data corresponding with the destination item extracted in two data sources；
When the terminating symbol of entry format of duplication is detected, stop replicate data.
5. the method that the generation as described in claim any one of 1-4 is reported, it is characterised in that：Described at least two for being extracted
Data corresponding with same project are arranged according to preset order in data source.
6. the method that the generation as described in claim any one of 1-4 is reported, it is characterised in that also include：
Data interpolation data source corresponding with each project will be extracted to identify；
According to the data source identification of addition, in the predeterminated position addition of the corresponding data of described each project of the report template
Corresponding data source information.
7. the method that the generation as described in claim any one of 1-4 is reported, it is characterised in that：
The report template includes assets assessment report template；
At least two data source includes：
At least two property data sources of same client；Or
An at least property data source of one client and an at least property data source of the client related to a client.
8. a kind of device for generating report, is applied to be provided with the electronic equipment of the application that generation is reported, it is characterised in that bag
Include：
Import modul, for Import Reports template and at least two data sources；The report template includes at least one mesh；It is described
Each project at least one mesh is arranged at a corresponding region in the report template；In at least two data source,
Each data source is comprising at least one mesh in the report template；
Extraction module, for being extracted respectively and each project in described at least one mesh from least two data sources for importing
Corresponding data；
Copy replication module, for data copy corresponding with each project will to be extracted after copy to each single item
The corresponding region of mesh；Wherein, in the corresponding region of each project, the corresponding region of an at least project includes what is extracted
The corresponding data of at least two data source；
Output module, the report for exporting preset format.
9. the device that generation as claimed in claim 8 is reported, it is characterised in that：The layout type of the report of the preset format
Layout type with the report template matches；The item of the entry format of the report of the preset format and the report template
Mesh form matches.
10. the device that generation is reported as claimed in claim 8 or 9, it is characterised in that：
Include starting symbol and terminating symbol, the beginning symbol in the report template, in each single item purpose entry format
The original position of respective items purpose region is arranged at, the terminating symbol is arranged at the end position of respective items purpose region；
The copy replication module is additionally operable to：
The first data are replicated since the corresponding region of a destination item in described at least one mesh the position of symbol,
First data are by the data corresponding with the destination item extracted from the first data source of copy；
When the terminating symbol in the corresponding region of the destination item is detected, stop replicate data；
Judge whether to be extracted the second data corresponding with the destination item；
When extraction there are the second data corresponding with the destination item, the mesh is replicated after first data for replicating
The entry format of mark project；
Replicate the second data since the position of the primary sign of the entry format for replicating, second data are copy from the
The data corresponding with the destination item extracted in two data sources；
When the terminating symbol of entry format of duplication is detected, stop replicate data.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710059894.5A CN106897389B (en) | 2017-01-24 | 2017-01-24 | Report generation device and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710059894.5A CN106897389B (en) | 2017-01-24 | 2017-01-24 | Report generation device and method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN106897389A true CN106897389A (en) | 2017-06-27 |
| CN106897389B CN106897389B (en) | 2021-01-15 |
Family
ID=59198772
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710059894.5A Expired - Fee Related CN106897389B (en) | 2017-01-24 | 2017-01-24 | Report generation device and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106897389B (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108564462A (en) * | 2018-03-15 | 2018-09-21 | 平安普惠企业管理有限公司 | Acquisition methods, terminal device and the medium of collage-credit data |
| CN110309499A (en) * | 2019-07-05 | 2019-10-08 | 广东铭太信息科技有限公司 | Method for generating the device and online generation examination report of examination report |
| CN110728114A (en) * | 2018-06-29 | 2020-01-24 | 上海波客实业有限公司 | Analysis report generation method |
| CN111104784A (en) * | 2019-12-19 | 2020-05-05 | 金蝶软件（中国）有限公司 | Data integration method and related device |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101645062A (en) * | 2009-08-21 | 2010-02-10 | 金蝶软件（中国）有限公司 | Report form generation method, system and information management equipment |
| US20120323803A1 (en) * | 1999-09-30 | 2012-12-20 | Lee Eugene M | Method and system for electronic ip prosecution |
| CN104572597A (en) * | 2015-01-12 | 2015-04-29 | 浪潮通用软件有限公司 | Automatic word analysis report generation method and device |
| CN105786779A (en) * | 2016-03-01 | 2016-07-20 | 万达信息股份有限公司 | Method for achieving multi-line report based on document template in WPS online plug-in |
-
2017
- 2017-01-24 CN CN201710059894.5A patent/CN106897389B/en not_active Expired - Fee Related
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20120323803A1 (en) * | 1999-09-30 | 2012-12-20 | Lee Eugene M | Method and system for electronic ip prosecution |
| CN101645062A (en) * | 2009-08-21 | 2010-02-10 | 金蝶软件（中国）有限公司 | Report form generation method, system and information management equipment |
| CN104572597A (en) * | 2015-01-12 | 2015-04-29 | 浪潮通用软件有限公司 | Automatic word analysis report generation method and device |
| CN105786779A (en) * | 2016-03-01 | 2016-07-20 | 万达信息股份有限公司 | Method for achieving multi-line report based on document template in WPS online plug-in |
Non-Patent Citations (2)
| Title |
|---|
| 刨坑数据: "多数据源动态关联报表的制作（birt为例）", 《HTTPS://BLOG.CSDN.NET/U012388497/ARTICLE/DETAILS/46988545》 * |
| 张大川: "birt报表开发入门", 《HTTPS://BLOG.CSDN.NET/ZDC524/ARTICLE/DETAILS/46805205》 * |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108564462A (en) * | 2018-03-15 | 2018-09-21 | 平安普惠企业管理有限公司 | Acquisition methods, terminal device and the medium of collage-credit data |
| CN110728114A (en) * | 2018-06-29 | 2020-01-24 | 上海波客实业有限公司 | Analysis report generation method |
| CN110309499A (en) * | 2019-07-05 | 2019-10-08 | 广东铭太信息科技有限公司 | Method for generating the device and online generation examination report of examination report |
| CN110309499B (en) * | 2019-07-05 | 2020-07-17 | 广东铭太信息科技有限公司 | Device for generating examination report and method for generating examination report online |
| CN111104784A (en) * | 2019-12-19 | 2020-05-05 | 金蝶软件（中国）有限公司 | Data integration method and related device |
| CN111104784B (en) * | 2019-12-19 | 2024-03-12 | 金蝶软件（中国）有限公司 | Data integration method and related device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN106897389B (en) | 2021-01-15 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11003646B2 (en) | Data isolation in a blockchain network | |
| CN106611061B (en) | Database write-in method and system based on block chain network | |
| CN106897389A (en) | Generate the device and method of report | |
| Mak | Archaeology of a Digitization | |
| CN102591654B (en) | A kind of code generator based on SSH framework and method | |
| CN110245469B (en) | Webpage watermark generation method, watermark analysis method, device and storage medium | |
| CN106599321A (en) | DWG file annotation and signature generation and analysis plug-in, and use method thereof | |
| CN113672204A (en) | Interface document generation method, system, electronic equipment and storage medium | |
| CN109522332A (en) | Customer profile data merging method, device, equipment and readable storage medium storing program for executing | |
| CN110134596A (en) | The generation method and terminal device of test document | |
| CN112001159A (en) | Document generation method and device, electronic equipment and storage medium | |
| CN113377653A (en) | Method and device for generating test case | |
| CN109213316A (en) | Autoplacement engine | |
| Jungnickel et al. | Simultaneous editing of JSON objects via operational transformation | |
| CN104423902B (en) | Digital printing control method and system for secret papers | |
| CN113420304A (en) | Encryption and decryption method, device and computer readable medium for SPICE netlist and model | |
| CN116956326A (en) | Authority data processing method and device, computer equipment and storage medium | |
| Cao et al. | Stochastic dynamical low-rank approximation method | |
| JP7029204B1 (en) | Technical survey support equipment, technical survey support methods, and technical survey support programs | |
| CN106575341A (en) | Composite document access | |
| CN107491466A (en) | client device, information processing system and information processing method | |
| CN106155987A (en) | A kind of method realizing electronic document management based on virtual reality technology | |
| Dow et al. | PFA (S)[S] and countably compact spaces | |
| CN113010129A (en) | Virtual studio full-flow multi-terminal blackboard writing extraction method and device | |
| Lisle et al. | Cartan structure of infinite Lie pseudogroups |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20210115 |
|
| CF01 | Termination of patent right due to non-payment of annual fee |