CN108388550A - Full Dynamic Generating Report implementation method, system and equipment based on Stimulsoft - Google Patents
Full Dynamic Generating Report implementation method, system and equipment based on Stimulsoft Download PDFInfo
- Publication number
- CN108388550A CN108388550A CN201711123229.4A CN201711123229A CN108388550A CN 108388550 A CN108388550 A CN 108388550A CN 201711123229 A CN201711123229 A CN 201711123229A CN 108388550 A CN108388550 A CN 108388550A
- Authority
- CN
- China
- Prior art keywords
- report
- data
- dynamic
- stimulsoft
- memory table
- 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
Classifications
-
- 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/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention provides a kind of base Stimulsoft generations report implementation method comprising is built according to demand by the data set of code dynamic creation；Operation is carried out to the data set according to demand, generates the memory table of report data content specified according to demand；Dynamic construction report interface element；Report data is filled using the memory table dynamic built；Report to having had been filled with data is compiled generation report display.The present invention generates report implementation method all by code dynamic creation with Stimulsoft, data Layer is built using Dram table, data filling uses construction on site memory table dynamic filling technique, the data Layer of report can be built into using the filling of construction on site memory table by an entirety, memory table advantage is to take up less resources, and speed is fast, avoids traditional directory charging efficiency dependent on database processing bottleneck or the designed data source of traditional immobilization.The present invention also provides one kind generating report implementation method, system and equipment with Stimulsoft.
Description
Technical field
The present invention relates to technical field of information processing more particularly to a kind of base Stimulsoft generate report implementation method,
System and equipment.
Background technology
Report is to use the Interface Elements such as table, chart usually intuitive display data, is finally reached data analysis function.
It can be used for making the tool such as word, Excel, wps etc. of report on the market at present.This kind of software advantage is logical
It is strong with property, report can be enriched by graphic interface content of edit pattern.The disadvantage is that interface is closed, particular field can not be applied to
It closes reporting system fusion and calls editor etc., so the occasion of special applications such as Spot Data Acquisition System is to pass through such system
Make Software Create report, then needs that data are filled into this kind of software one by one manually, and analysis system is designed according to data source
Class report is counted, since general on-site data gathering analysis data pattern is single, fixed, if analyzed by such Software Create
Report then needs every time tabulation manually, troublesome in poeration in this way, process is cumbersome, repetitive operation is too big.
Since the software interfaces such as word, Excel, wps are closed, report data can not refresh in real time, and market occurs one at present
The report writer system of a little application of special occasions, such tool has open external interface, and data processing is flexible, figure
Changing editing interface makes report form template establishment simple as being edited office.External interface can provide different platform exploitation
Upper computer software call, in this way the Data Analysis Services report of certain applications is only needed to do in fact and a set of meets number
Macro or mass analysis class report form template according to statistics.Such report also has a point, and data can be with dynamic refresh, in this way need not picture
Office like that every time make report and filled by hand data manually.
The mainstream report generating system general process flow that market can provide external interface at present mainly has：1., figure
Change report form template to create, it is main that the report interface element that object is standard is created using bar chart editor, such as header, footer, figure
Table, tables of data, label, horizontal line, radio box check box etc..2., report form template interface element attribute configuration.3., report form template
Data source is built.4., report form template data source filling.5., compiling report form template.6., generate report content.
The mainstream report generating system general process flow defect that market can provide external interface at present mainly has：①、
Based on interface fixed form underaction, it is unsatisfactory for attribute dynamic edit-modify of specific demand etc..2., data source matches
Underaction is set, fixed field processing cannot be satisfied some special applications demand occasions.3., for tables of data, it is general
Process flow has fixed processing to the filling quantity of tables of data row object, can not dynamically change.In this way for some applied fields
For conjunction, the fixed row of quantity can only be analyzed.
At present it is existing to the improved technology of this kind of general process flow such as：It is big that CN105260349A-can dynamically change template
Small Ireport report production methods, to report form template dynamic modification size, but such processing mode still is based on and has compiled
The template object defined, still underaction are collected, only to the width calculation processing of field, changes template attributes, it is right
The data needed for report still use template way immobilization to handle.
Invention content
The technical program embodiment is designed to provide a kind of base Stimulsoft of the full dynamic generation of the template of report
Generate report realization method and system.
The present invention provides a kind of base Stimulsoft generations report implementation method, which is characterized in that including structure according to demand
It builds by the data set of code dynamic creation；Operation is carried out to the data set according to demand, generates report number specified according to demand
According to the memory table of content；Dynamic construction report interface element；Report data is filled using the memory table dynamic built；To
The report for being filled through data is compiled generation report display.
Further, it is that the data that host computer voluntarily generates are built, including instantiation is produced to build dynamic data set
A raw empty table, the table name of the sky table is the big classification that specific report needs statistical analysis, display；Empty table creates column data, row
Entitled specific report page display gauge head；Row data are created in table.
Further, data set is obtained by data base querying and builds memory table, including：Instantiate an empty data set；
Empty tables of data is added to data set, and it is for the big type of report page to name table name；The memory table gauge outfit built as needed
And data generate query statement in table；It initiates to inquire to database, the data set of return is filled to the null data set of instantiation.
Further, in the step of carrying out operation to the memory table according to demand, which includes that data row are added, split
Or the operations such as merging.
Further, structure report interface element includes building each element coordinate, each element width and height.
Further, the dynamic construction of tables of data is related to the quantity of memory table and columns in interface element.
Further, the step of dynamic construction report interface element includes externally reserving interface element attribute to external
Mouthful.
Further, the step of report data is filled using the memory table dynamic built includes with ergodic data collection
Memory table table name mode is filled the corresponding tables of data of the memory table of structure.
The present invention also provides a kind of, and the full Dynamic Generating Report based on Stimulsoft realizes system comprising
Memory table builds module, for being built according to demand by the data set of code dynamic creation；According to demand to the data set
Operation is carried out, the memory table of report data content specified according to demand is generated；
Report feed generation module is used for dynamic construction report interface element；Using the memory table dynamic filling report built
Table data；Report to having had been filled with data is compiled generation report display.
The present invention also provides a kind of equipment comprising：One or more processors；For storing one or more programs
Memory;When one or more of programs are executed by one or more processors so that one or more of processors
Execute method as the aforementioned.
The table element provided the present invention is based on the full Dynamic Generating Report implementation method of Stimulsoft is all moved by code
State creates, and on-fixed interface template creates, and data Layer is built using Dram table, and data filling uses construction on site memory table
The data Layer of report can be built into an entirety, memory table advantage by dynamic filling technique using the filling of construction on site memory table
It is to take up less resources, and speed is fast, thus is avoided that traditional directory charging efficiency is solid dependent on database processing bottleneck or tradition
Surely change designed data source.
Description of the drawings
It, below will be to attached needed in embodiment in order to illustrate more clearly of the technical solution of the technical program
Figure is briefly described, it should be apparent that, the accompanying drawings in the following description is only some embodiments of the present invention, for ability
For the those of ordinary skill of domain, without creative efforts, it can also be obtained according to these attached drawings other attached
Figure.
Fig. 1 is the full Dynamic Generating Report implementation method block diagram provided in an embodiment of the present invention based on Stimulsoft.
Fig. 2 is the flow chart that host computer provided in an embodiment of the present invention voluntarily generates memory table.
Fig. 3 is the flow chart that data base querying provided in an embodiment of the present invention obtains data set structure memory table.
Fig. 4 is the module that the full Dynamic Generating Report provided in an embodiment of the present invention based on Stimulsoft realizes system
Figure.
Specific implementation mode
Below in conjunction with the attached drawing in the technical program embodiment, the technical solution in the technical program embodiment is carried out
Clearly and completely describing, it is clear that described embodiment is only the technical program a part of the embodiment, rather than whole
Embodiment.Based on the embodiment in the technical program, those of ordinary skill in the art are without creative efforts
The every other embodiment obtained, shall fall within the protection scope of the present invention.
Referring to Fig. 1, base Stimulsoft generates report implementation method, including at least following lower step：S100, according to need
Ask structure by the data set of code dynamic creation.
Memory table structure can be that the data that host computer voluntarily generates are built, the tables of data such as voluntarily created.Also may be used
To be the data set generated by database retrieval, memory table building process mainly has table name, gauge outfit content, data content in table.
The effect of table name is mainly used for distinguishing with inside a report the different statistical item pages.Database platform can be MySQL,
The relevant databases such as Sybase, Oracle, Microsoft SQL Server.Host computer journey in Windows operating systems
Sequence platform generally selects winform or WPF etc. based on .Net Framework platform frameworks.
Two kinds of situations are illustrated respectively below.
It is that the data that host computer voluntarily generates are built, including instantiation generates a sky to build dynamic data set
Table, the table name of the sky table are the big classification that specific report needs statistical analysis, display；Empty table creates column data, arranges entitled specific
Report page display gauge head；Row data are created in table.
Specifically, referring to Fig. 2, instantiation generates an empty table, table name is that specific report needs statistical analysis, display
Big classification.Each big classification corresponds to some specific content of pages of report respectively.Such as need to have first page in the report generated be
Cover page, second page are all statistical average pages, the third page is all data variance, page four be the every of all data
Rows summary pages such as a row maximum value, minimum value etc..Then the empty table of respective examples shows it can is that dt_ covers, dt_ be average, dt_
Variance, dt_ rows summarize etc..It is different classes of that the effect of report table name is that code scene dynamic construction report needs to create those
New page.
The newly-built row of empty table, row name can be specific report page display gauge head.To need the table built will corresponding report page
For face two, gauge outfit 1 be equipment 1, gauge outfit 2 is that 2 gauge outfit 3 of equipment is equipment three.The programmability advantage of gauge outfit is can be real
Existing report data source field dynamic adjusts.
Row data are created in table, by taking the table corresponding page two for needing to build as an example, one data of row be equipment 1 average value,
The average value etc. that row two is the average value of equipment two, row 3 is equipment 3.
Referring to Fig. 3, obtaining data set by data base querying builds memory table, including one empty data set of instantiation；
Empty tables of data is added to according to collection, and it is for the big type of report page to name table name；The memory table gauge outfit that builds as needed and
Data generate query statement in table；It initiates to inquire to database, the data set of return is filled to the null data set of instantiation.
S200, operation is carried out to the data set according to demand, generates the memory of report data content specified according to demand
Table.
In the step of carrying out operation to the memory table according to demand, which includes data row being added, splits or merges etc.
Operation.
S300, dynamic construction report interface element.
Based on the report tool interface that current market provides, programming mode code construction report is used based on Stimulsoft
Surface and interface element, such as text, label, chart, tables of data, horizontal line, radio box and check box, interface element establishment need to note
Two points of meaning：（1）, each element coordinate；（2）, each element width and height.
The dynamic construction of tables of data depends on the quantity and columns of memory table, the report that such later stage generates in interface element
Columns will not be limited.
Building process externally reserves interface element attribute external interface, and report interactive operation is provided to do later stage host computer.
S400, report data are filled using the memory table dynamic built.The step includes in ergodic data collection
Table table name mode is deposited to be filled the corresponding tables of data of the memory table of structure.
S500, generation report display is compiled to the report for having had been filled with data.
The system for the full Dynamic Generating Report realization based on Stimulsoft that the present invention also provides a kind of comprising
Memory table builds module 201, for being built according to demand by the data set of code dynamic creation；According to demand to the data
Collection carries out operation, generates the memory table of report data content specified according to demand.
Specifically, building data set according to specific business demand, the establishment of data set can be by disparate databases platform
Inquiry.It can also be from host computer structure.Memory table structure module 201 further includes calculating logic processing module, is patrolled
Processing module is collected to be used to carry out operation to data set.One or several among data row, fractionation or merging is added in operation.
Report feed generation module 202 is used for dynamic construction report interface element；Using the memory table dynamic built
Fill report data；Report to having had been filled with data is compiled generation report display.
202 building process of report feed generation module externally reserves interface element attribute external interface, for later stage host computer
Report interactive operation is provided.
The present invention also provides a kind of equipment comprising：One or more processors；For storing one or more programs
Memory；When one or more of programs are executed by one or more processors so that one or more of processors
Execute method as the aforementioned.
Base Stimulsoft generations report implementation method table element provided by the invention is non-solid all by code dynamic creation
It delimits face die plate to create, data set is built using Dram table, and data filling is using construction on site memory table dynamic filling skill
Art.And using the filling of construction on site memory table that the data Layer of report can be built into an entirety, memory table advantage is to occupy money
Source is few, and speed is fast, thus is avoided that traditional directory charging efficiency dependent on database processing bottleneck or traditional immobilization design
Good data source.
And due to can be can be changed with construction on site, memory literary name section, avoiding conventional construction data source data field can not
The situation of change.To make report data bind flexibility and changeability, as gauge outfit field contents follow directly after memory table gauge outfit.Tables of data
Columns quantity does not do restriction processing, and the total receiving columns of such tables of data is unlimited, and dynamic adjusts.
It uses this method that can play the role of to specific data analysis application occasion at present key, is such as acquisition
It unites the processing report process of host computer, this have the effect that not limiting the single main body collecting device quantity of acquisition system,
Report can accommodate variable collecting device data, and can open up interface alternation simultaneously for particular user requirements host computer allows use
Family self-defining report attribute, such as replace in table font and size, font whether overstriking, font color, shade color, from
And realize interactivity Report Operations.
Finally it should be noted that：The above embodiments are merely illustrative of the technical solutions of the present invention, rather than its limitations；Although
Present invention has been described in detail with reference to the aforementioned embodiments, and those skilled in the art are when understanding：It still can be with
Technical scheme described in the above embodiments is modified or equivalent replacement of some of the technical features；And
These modifications or replacements, the spirit and model of various embodiments of the present invention technical solution that it does not separate the essence of the corresponding technical solution
It encloses.
Claims (10)
1. a kind of base Stimulsoft generates report implementation method, which is characterized in that including being built according to demand by code dynamic
The data set of establishment；Operation is carried out to the data set according to demand, generates the memory of report data content specified according to demand
Table；Dynamic construction report interface element；Report data is filled using the memory table dynamic built；To having had been filled with data
Report be compiled generation report display.
2. base Stimulsoft as described in claim 1 generates report implementation method, which is characterized in that build dynamic data
Integrate the data voluntarily generated as host computer to be built, including instantiation generates an empty table, the table name of the sky table is specific report
Table needs the big classification of statistical analysis, display；Empty table creates column data, arranges entitled specific report page display gauge head；Biao Neixin
Construction Bank's data.
3. base Stimulsoft as claimed in claim 2 generates report implementation method, which is characterized in that obtained by data base querying
Data set is taken to build memory table, including：Instantiate an empty data set；Empty tables of data is added to data set, and names table name
For for the big type of report page；Data generate query statement in the memory table gauge outfit and table built as needed；To database
Inquiry is initiated, the data set of return is filled to the null data set of instantiation.
4. base Stimulsoft as described in claim 1 generates report implementation method, which is characterized in that interior to this according to demand
It deposits in the step of table carries out operation, which includes the operations such as data row being added, splits or merges.
5. base Stimulsoft as described in claim 1 generates report implementation method, which is characterized in that structure report interface member
Element includes building each element coordinate, each element width and height.
6. base Stimulsoft as described in claim 1 generates report implementation method, which is characterized in that data in interface element
The dynamic construction of table is related to the quantity of memory table and columns.
7. base Stimulsoft as described in claim 1 generates report implementation method, which is characterized in that dynamic construction report circle
The step of surface element includes externally reserving interface element attribute external interface.
8. base Stimulsoft as described in claim 1 generates report implementation method, which is characterized in that report data is using
The step of memory table dynamic built is filled includes the memory table pair with ergodic data collection memory table table name mode to structure
The tables of data answered is filled.
9. the full Dynamic Generating Report based on Stimulsoft realizes that system, feature are being, including memory table builds module,
For being built according to demand by the data set of code dynamic creation；Operation is carried out to the data set according to demand, is generated according to need
Seek the memory table of specified report data content；Report feed generation module is used for dynamic construction report interface element；Using
The memory table dynamic filling report data built；Report to having had been filled with data is compiled generation report display.
10. a kind of equipment, which is characterized in that including：One or more processors；Storage for storing one or more programs
Device;
When one or more of programs are executed by one or more processors so that one or more of processors execute
Such as claim 1-8 any one of them methods.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711123229.4A CN108388550A (en) | 2017-11-14 | 2017-11-14 | Full Dynamic Generating Report implementation method, system and equipment based on Stimulsoft |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711123229.4A CN108388550A (en) | 2017-11-14 | 2017-11-14 | Full Dynamic Generating Report implementation method, system and equipment based on Stimulsoft |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108388550A true CN108388550A (en) | 2018-08-10 |
Family
ID=63076917
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711123229.4A Pending CN108388550A (en) | 2017-11-14 | 2017-11-14 | Full Dynamic Generating Report implementation method, system and equipment based on Stimulsoft |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108388550A (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103064689A (en) * | 2013-01-04 | 2013-04-24 | 大唐软件技术股份有限公司 | Implementation method and system for dynamically generating report pages |
| CN103426080A (en) * | 2013-08-09 | 2013-12-04 | 国家电网公司 | Daily production report system of pumped storage power station |
| US20140143270A1 (en) * | 2012-11-19 | 2014-05-22 | James Michael Amulu | Generating dynamic drilldown reports |
| CN105446948A (en) * | 2015-11-13 | 2016-03-30 | 武汉鸿图节能技术有限公司 | Report automatic generation method and system |
-
2017
- 2017-11-14 CN CN201711123229.4A patent/CN108388550A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20140143270A1 (en) * | 2012-11-19 | 2014-05-22 | James Michael Amulu | Generating dynamic drilldown reports |
| CN103064689A (en) * | 2013-01-04 | 2013-04-24 | 大唐软件技术股份有限公司 | Implementation method and system for dynamically generating report pages |
| CN103426080A (en) * | 2013-08-09 | 2013-12-04 | 国家电网公司 | Daily production report system of pumped storage power station |
| CN105446948A (en) * | 2015-11-13 | 2016-03-30 | 武汉鸿图节能技术有限公司 | Report automatic generation method and system |
Non-Patent Citations (2)
| Title |
|---|
| EDISONER: "Stimulsoft报表操作笔记（一）：统计", 《HTTPS://WWW.CNBLOGS.COM/EDISONER/P/6798761.HTML》 * |
| 朱闻亚: "基于C2C电子商务创业的理论与实践研究", 《武汉：武汉大学出版社》 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11816100B2 (en) | Dynamically materialized views for sheets based data | |
| US20230084389A1 (en) | System and method for providing bottom-up aggregation in a multidimensional database environment | |
| CN100530083C (en) | Programming interface for a computer program | |
| US11086894B1 (en) | Dynamically updated data sheets using row links | |
| Iivari | Object-orientation as structural, functional and behavioural modelling: a comparison of six methods for object-oriented analysis | |
| CN102426582B (en) | Data manipulation management devices and data manipulation management method | |
| CN110399420A (en) | A kind of deriving method, electronic equipment and the medium of configurableization Excel format | |
| CN101923549A (en) | User-defined visual intelligent track clue analytical system and establishing method | |
| CN103970899A (en) | Service-oriented metadata relevance extraction management method and management system | |
| CN103984755A (en) | Multidimensional model based oil and gas resource data key system implementation method and system | |
| CN106844324B (en) | Method for exporting variable column data into Excel format | |
| CN108804602A (en) | A kind of distributed spatial data storage computational methods based on SPARK | |
| CN107391652A (en) | A kind of templating form interface defines system and method | |
| US20040181518A1 (en) | System and method for an OLAP engine having dynamic disaggregation | |
| CN100447781C (en) | Method and system for mapping XML to N-dimensional data structure | |
| CN108170855B (en) | CityGML and IFC data unified query and data extraction method | |
| CN102722368B (en) | Plug-in software designing method based on document tree and message pump | |
| CN105426527A (en) | Method for unified data modeling in informatization surveying and mapping production equipment integration process | |
| CN110134511A (en) | A kind of shared storage optimization method of OpenTSDB | |
| CN105912723A (en) | Storage method of custom field | |
| Egenhofer et al. | Interacting with GIS | |
| CN107480235A (en) | A kind of database framework of data platform | |
| CN100565519C (en) | Data bank service disposal route based on the uniform data sign | |
| CN105550176A (en) | Basic mapping method for relational database and XML | |
| CN103970900B (en) | Multi-dimensional cross data flexible management method and system based on industrial field |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180810 |
|
| RJ01 | Rejection of invention patent application after publication |