CN101650712A - Generating management method and system of self-defined report - Google Patents
Generating management method and system of self-defined report Download PDFInfo
- Publication number
- CN101650712A CN101650712A CN200910305760A CN200910305760A CN101650712A CN 101650712 A CN101650712 A CN 101650712A CN 200910305760 A CN200910305760 A CN 200910305760A CN 200910305760 A CN200910305760 A CN 200910305760A CN 101650712 A CN101650712 A CN 101650712A
- Authority
- CN
- China
- Prior art keywords
- report
- data
- file
- self
- server
- 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
- 238000007726 management method Methods 0.000 title claims abstract description 44
- 230000002349 favourable effect Effects 0.000 abstract description 2
- 230000006870 function Effects 0.000 description 42
- 238000000034 method Methods 0.000 description 40
- 235000010627 Phaseolus vulgaris Nutrition 0.000 description 11
- 244000046052 Phaseolus vulgaris Species 0.000 description 11
- 238000012545 processing Methods 0.000 description 8
- 230000008569 process Effects 0.000 description 6
- 238000004364 calculation method Methods 0.000 description 5
- 230000000295 complement effect Effects 0.000 description 5
- 238000009877 rendering Methods 0.000 description 5
- 230000004044 response Effects 0.000 description 5
- 238000007689 inspection Methods 0.000 description 4
- 238000013507 mapping Methods 0.000 description 4
- 238000012795 verification Methods 0.000 description 4
- 239000012467 final product Substances 0.000 description 3
- 230000002950 deficient Effects 0.000 description 2
- 238000000151 deposition Methods 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 239000000047 product Substances 0.000 description 2
- 230000009897 systematic effect Effects 0.000 description 2
- 241001269238 Data Species 0.000 description 1
- 235000004240 Triticum spelta Nutrition 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000006243 chemical reaction Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000018109 developmental process Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 239000000945 filler Substances 0.000 description 1
- 230000008676 import Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000008929 regeneration Effects 0.000 description 1
- 238000011069 regeneration method Methods 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to a generating management method of self-defined reports, which is used for browser/server architecture and comprises the following steps: on a browser, calling an application on a server; displaying all report pages of all report lists on the server, and selecting one of the reports; and generating the selected report by the server, and transmitting to the selected report the browser. The invention also relates to a generating management system for self-defined reports. The invention has the advantages that since the template of each report comprises a template file, atype file and a defined file, during report generation, the format and the data of the report are combined after being separately generated; therefore, the system has favorable expansibility and supports self-defined inquiry conditions.
Description
Technical field
The present invention relates to computer realm, more particularly, relate to a kind of generation management method and system of self-defined report.
Background technology
The various application systems of present domestic every profession and trade are more and more higher to the requirement of secondary development.Wherein a lot of systems have all spelt out software systems will the self-defined report system, can be designed, be defined form by the user voluntarily.Also realized the self-defined report module in some software products, but not the self-defined report on the complete meaning, only provided the report style of some standards, the data item that the operator can select some systems to provide on the report style that provides is with generating form.This form has several defectives: extendability is poor, if data item Reports module does not if desired provide or required data display pattern changes to some extent, and the existing pattern that system provides is not supported, just can't generate required form; Can not support self-defined inquiry conditional definition completely.Other has some software products, as iReport, and Birt etc., these report tools provide self-defining Report Designer, can use SQL query, Java Bean in form.But these report tools are a report-building tool, want outer program to call and provide parameter or data could generate report file during operation, itself are not a form operation platform, can not carry out the form issue, generate the self-defined inquiry condition.
Summary of the invention
The technical problem to be solved in the present invention is, poor at the above-mentioned extendability of prior art, as not support self-defined inquiry condition defective provides a kind of favorable expandability, supports the generation management method and the system of a kind of self-defined report of self-defined inquiry condition
The technical solution adopted for the present invention to solve the technical problems is: construct a kind of self-defined report and generate management method, be used for browser/server structure, comprise the steps:
A) calling utilization program on the server on the browser, the report page of all form inventories on the display server is selected one of them form;
B) server generates selected form, is sent to described browser.
Generate in the management method at self-defined report of the present invention, also be included on the described server and set up report file, it comprises:
M) use Excel to generate a plurality of report files that are stored in the server.
Generate in the management method described step M at self-defined report of the present invention) in further comprise the steps:
M1) use Excel to obtain report form template, generate template file;
M2) divide section with described template file, and define each section in the described template file, generate the pattern file;
M3) data in above-mentioned each section of definition, the generation definition file;
M4) above-mentioned file is sent to assigned address in the form catalogue of server, obtains a report file.
Generate in the management method described step M2 at self-defined report of the present invention) described in the definition section comprise: define the position of the data item of placing in this section, described data item and the display format of described data.
Generate in the management method described step M3 at self-defined report of the present invention) described in data in the described section of definition comprise: the source of data, data query mode, data query conditions, data computation and data are filled.
Generate in the management method described step M4 at self-defined report of the present invention) further comprise the steps:
M41) described template file, pattern file and defined file are sent in the described server assigned catalogue;
M42) refresh report page, obtain the inventory of the form that above-mentioned file generates.
Generate in the management method described step B at self-defined report of the present invention) further comprise:
B1) produce this report query conditions input page;
B2) according to the content of described querying condition input page, data query generates form;
B3) form of output generation is to described browser.
The present invention has also disclosed a kind of self-defined report and has generated management system, is used for browser/server framework, comprises on the described server:
Form runtime engine: be used to resolve the report definition file, data that the inquiry form needs and generation form;
Report Server Management platform: be used for issue, manage all kinds of forms;
The form operation platform: be used to be presented at the form inventory of issuing on the described management platform, call described runtime engine when selected when one in the described form inventory, search, generate form, and output.
In system of the present invention, described form runtime engine further comprises the querying condition input page generation unit that is used for being produced by time in selecting at form of described form inventory the querying condition input page.
In system of the present invention, described Report Server Management platform comprises: be used to deposit described report definition file report definition document storage catalogue, be used to deposit described report form template file and pattern file report form template file and pattern document storage catalogue, be used to deposit in form binding data source self-defining data source binding form storing directory, be used to deposit the self-defining function statement document storage catalogue of statement file and the self-defined inquiry condition page storing directory that is used to deposit described query page.
Implement the generation management method and the system of self-defined report of the present invention, has following beneficial effect: owing to comprise template file, pattern file and defined file in the template of each report file, therefore, the data of generation form Times tableau format and form are separately to generate the back making up.So its extendability is better, support self-defined inquiry condition.
Description of drawings
Fig. 1 is the product process figure of form in the generation management method of self-defined report of the present invention and the system embodiment;
Fig. 2 is form inventory product process figure among the described embodiment;
Fig. 3 is a system architecture synoptic diagram among the described embodiment;
Fig. 4 is a bibliographic structure synoptic diagram in the Report Server Management platform among the described embodiment.
Embodiment
Embodiments of the present invention is further illustrated below in conjunction with accompanying drawing.
As shown in Figure 1, in the generation management method and system embodiment of self-defined report of the present invention, its report form generation method comprises the steps:
Step S11 shows the form inventory, and chooses one of them: in this step, calling utilization program on the server on the browser, and the report page of all form inventories on the display server, and choose one of them form.
Step S12 produces the report query input page: after server is received the selected form of browser submission, produce a report query input page on above-mentioned browser, the effect of this inquiry input page is to be used for further defining the items relevant with data in the form such as the Data Source of this form, data layout.
Step S13 is according to described inquiry input page content, and data query generates form: because the pattern of form and the data in the form all are defined, so, in this step, exactly each part mentioned above is organized, generate form.
The form that step S14 output is generated: in this step, the form of above-mentioned generation is sent on the described browser shows.
Top step can be described below: click a form, generate the page of input inquiry condition according to the input parameter of configuration, the querying condition of input appointment is also submitted to, and the Report Engine data query generates report file and output to browser display with the Html form.Also may be output as the Excel file.Generate the page of input inquiry condition according to the input parameter in the definition; The input inquiry condition is submitted inquiry to; From the list of submitting to, obtain the input value of query argument; Give each data source with querying condition and carry out inquiry; The result that inquiry is returned is placed in the set of data objects; To the data in the data object set calculate again, processing such as statistics; Generate the ExcelReport object, the data in the set of data objects are outputed to the ExcelReport object, generate report file.
In Fig. 1, we have directly called the form inventory, and still, this form inventory need make up equally in advance.Fig. 2 shows the structure flow process of form inventory, in Fig. 2, comprises the steps:
Step S21 uses Excel to obtain report form template, generates template file: in this step, and according to demand, with Excel magazine table template.Generate the template file (xls file) of an Excel form.
Step S22 generates the pattern file of above-mentioned report form template: template by divided each section with upper type, is reserved the data item that will place in each section.And the position of data item, display format etc.With these configuration information record in the pattern file.Generate one style file (xml file).
Step S23 generates the defined file of above-mentioned report form template: the Data Source of design form, how to inquire about querying condition.Whether the original query data need computing again.Data are filled (being complementary with the data item that defines in the pattern file).With these configuration information record in the report definition file.Generate a defined file (xml file).
Step S24 stores above-mentioned file to assigned catalogue, obtains report file: in this step, above-mentioned three files are uploaded onto the server in the assigned catalogue, can obtain report file.
Step S25 refreshes report page, obtains the form inventory: refresh list in report page, just can see the form of new submission.
Repeatedly repeat above-mentioned steps S21 in advance to S25, promptly configurable a plurality of report form templates certainly, if temporary needs increases a report form template, also can be carried out above-mentioned steps S21 separately to S25.
In the present embodiment, defined the input parameter of form in the pattern file, data source, data computation method, data output etc.; And defined file is the XML file of a standard format, and its form meets the requirement of XML file layout.With UTF-8 as coded format.
Also disclose a kind of self-defined report in the present embodiment and generated management system, this system is used for browser/server framework, comprise on the described server: be used to resolve the report definition file, data that the inquiry form needs and the form runtime engine 1 that generates form, be used for issuing, manage the Report Server Management platform 3 of all kinds of forms and be used to be presented at the form inventory issued on the described management platform, when of described form inventory is selected, call that described form runtime engine 1 goes to search, the form operation platform 2 of generation, output report.Structure between above-mentioned form runtime engine 1, form operation platform 2 and the Report Server Management platform 3 as shown in Figure 3.Wherein, described form runtime engine 1 further comprises the querying condition input page generation unit that is used for being produced by time in selecting at form of described form inventory the querying condition input page.
As mentioned above, Report Server Management platform 3 is used for all kinds of forms of release management, it comes down to the catalogue of these forms is managed, as shown in Figure 4, getting catalogue in the Report Server Management platform 3 comprises: the report definition document storage catalogue 31 that is used to deposit described report definition file, be used to deposit the report form template file and the pattern document storage catalogue 32 of described report form template file and pattern file, be used to deposit in the self-defining data source binding form storing directory 33 in form binding data source, be used to deposit the self-defining function statement document storage catalogue 34 of statement file and the self-defined inquiry condition page storing directory 35 that is used to deposit described query page.
As previously mentioned, in the present embodiment, system start-up loads self-defining function statement file, loads dictionary table definition, data source definitions etc.; When a self-defined report title is selected, system start-up self-defined report engine (Engine) is handled, its process is as follows: at first according to report definition object of report definition file build (ReportDefine object), then according to this definition object structure self-defined report processing engine (Engine) class example; From ReportDefine.inputParameters, can learn self-defined inquiry condition, for each querying condition generates corresponding querying condition input control into this report definition.Generate the page of each querying condition of input at last.Imported when submitting to behind the querying condition, system carries out verification according to the method for inspection that defines in the querying condition to input value, and verification succeeds just can be submitted inquiry to.Submit to after the inquiry, the querying condition that system handles is submitted to is put into Engine.inputData with all parameter input values; And handle data source definitions among the ReportDefine one by one: for the SQL data source, the embedded expression formula among the treatment S QL obtains the target SQL statement, carries out inquiry, obtains Query Result, and DataSet puts into Engine.data with Query Result; For the Java data source,, carry out a Java method by calling self-defining function.The data object that this method is returned is put into Engine.data; For the DSF data source, at first construct a DSF object, on this object, carry out inquiry then, the DataSet object that returns is put into Engine.data.After handling above-mentioned data source definitions according to ReportDefine in the definition of .calData part, the data object of depositing among the Engine.data calculates again, for example produces some statisticss etc.The data in the existing object can be revised, also new data can be produced.New input generally deposits among the new map.When above-mentioned data calculate again finish after, according to ExcelEngine object of report style file build, then according among the ReportDefine.segmentDatafile to the definition of data item output data of each section to the ExcelEngine object; If bind on whole section to the data object, data object is taken out from Engine.data, directly submit to the ExcelEngine object, generate the appropriate section of form; If the sector data item is configuration one by one, at first construct a new map, call self-defining function and embedded expression formula processing engine, the data item allocation formula is calculated, data item title and result of calculation are put into map, after the total data item of this section is all handled, whole map is submitted to the ExcelEngine object, generate the appropriate section of form.So far, report generation finishes.
By the Html pattern form content is presented on the client browser if desired, the export method of calling excel Engine so obtains the form content of Html form, then the Html content is written to response, finally is presented on the client browser.In general, the form content should be presented at independently in the frame; Generate the Excel file if desired and download to this machine for the client, the export method of calling excel Engine so, obtain byte[] the Excel file content of form, the response that then data write direct, client browser will point out and download or open the Excel file; Generate the Excel file at server end if desired, can call the ExcelEngine.write method, the form content is written in the file of Excel form.So far, report output is to client.
Said above that defined file was the XML file of a standard format, its form meets the requirement of XML file layout.With UTF-8 as coded format.Defined file in the present embodiment is as follows:
Common detail list _ SQL data source _ operator's inventory .xml
<？xml?version＝″1.0″encoding＝″UTF-8″？>
<reportdefine>
<report-define
Name=" operator's inventory "
type ＝″grid″
Stylefilename=" the common detail list operator of DataSet inventory _ style.xml "/〉
<input-parameters>
<item
no ＝″1″
name ＝″s_gdj″
Displaytext=" affiliated power supply administration "
datatype?＝″c″
allowignore?＝″false″
min ＝″″
max ＝″″/>
</input-parameters>
<datasource>
<sql
name ＝″czy″
sql ＝’select?a.*，b.s_itemvalue?as?s_gdj_text，c.s_mc?as?s_js_text
from?czy?a，pub_dictitem?b，js?c
where?a.s_gdj?＝?b.s_itemid?and?b.n_typeid?＝?7
and?a.s_jsbh?＝?c.s_jsbh
[％＝getInput(e，″s_gdj″).length()>0？″and?a.s_gdj?＝?&apos；″+getInput(e，″s_gdj″)+″&apos；″:″″％]
order?by?a.s_czybh’
/>
</datasource>
<caldata>
</caldata>
<segment-data>
<title
bind ＝″false″>
<item?name?＝″title″formula?＝’getInput(e，″s?gdj.text″)’/>
<item?name?＝″printdate″formula?＝’today()’/>
</title>
<body
bind ＝″true″
type ＝″dataset″
source ＝″czy″/>
</segment-data>
＜remark〉in the xml text, less than-﹠amp; Lt; Greater than-﹠amp; Gt; Double quotation marks-﹠amp; Quot; Dan Yinhao ﹠amp; Apos;＜/remark 〉
</reportdefine>
This document is exactly the XML file of a standard format, and form meets the requirement of XML file layout.With UTF-8 as coded format.
Attention: when the defined node attribute, property content must meet the call format of XML file.Several special characters wherein should use escape character.
Less than (＜)-﹠amp; Lt; Greater than (＞)-﹠amp; Gt; Double quotation marks (")-﹠amp; Quot; Single quotation marks (')-﹠amp; Apos;
＜and symbol must use escape character.
If attribute definition can use single quotation marks in the property content so, but double quotation marks must be used escape character with the double quotation marks beginning.
If attribute definition can use double quotation marks in the property content so, but single quotation marks must be used escape character with the single quotation marks beginning.
In the defined file of present embodiment, root node the name be called＜reportdefine,＜reportdefine〉first child node be＜report-define, this node is the definition to whole form, and following attribute is arranged:
<report-define
Name=" operator's inventory "
type ＝″grid″
Stylefilename=" the common detail list of DataSet _ operator inventory _ style.xml "/〉
In the above in the attribute of Miao Shuing, name: report name, String, if output Excel file during operation, then the Excel filename is exactly this name.
Type: form classification, Sting, optional value: card/grid/group
Card-card form, unirecord, a table body
The detailed form of grid-, gauge outfit, table tail, a plurality of detailed districts
The group-form that divides into groups, gauge outfit, table tail, a plurality of groupings.A packets headers, grouping tail can be arranged, a plurality of detailed districts in each grouping.
Stylefilename: the employed pattern filename of this form, String notes having only filename, does not have the path, path definition is in global parameter.
In the defined file of present embodiment, input parameter is defined in＜input-parameters〉section in.These parameters can be simple input parameters, be mapped to the input parameter on the data source field, complicated input parameter and the self-defined inquiry condition page.If form does not need input parameter,＜input-parameters〉section can not have child node.
When these parameters were simple input parameter, its code was as follows:
<input-parameters>
<item
no ＝″1″
name ＝″s_gdj″
Displaytext=" power supply administration's numbering "
show ＝“true”
datatype ＝″c″
allowignore?＝″false″
min ＝″″
max ＝″″ initvalue?＝“0001”/>
</input-parameters>
Each input parameter is an Item item.Wherein:
No: the sequence number of this input parameter, int ,=1, can not omit
Name: the title of this input parameter, String can not omit
Displaytext: the label of this input parameter.String, this label are presented at the left side of input control when moving.If be provided with the mapping attribute, can use the Chinese name of field to make label, can omit.
Show: whether show this input parameter.Boolean。Be defaulted as true.If be set to false, then only export during program run a name by name＜hidden object, but do not show this input parameter.Can be in program the value of setting.During show=false, other mapping attributes, the render attribute all no longer works.
Datatype: the data type of this input parameter, String, optional value is: c/n/d, i.e. character type/numeric type/date time type.Be defaulted as character type.When parameter is simple input parameter, can not omit.
Allowignore: whether this input parameter can be ignored, Boolean, " true "/" false ", be defaulted as " true ".If this parameter-definition is false, must imports this parameter query when then moving and just can submit to.
Min: allow the minimum value of input, String.Data type is to work during type on numeric type or date.If be not empty, then imported when this parameter is submitted inquiry to and can carry out the minimum value inspection.If do not need to check, then be empty.
Max: allow the maximal value of input, String.Data type is to work during type on numeric type or date.If be not empty, then imported when this parameter is submitted inquiry to and can carry out the maximal value inspection.If do not need to check, then be empty.
Initvalue: initial value.String can be sky.Should value can be presented in the input control during operation as default value.Initvalue can use embedded expression formula.As: initvalue=' [%=getSessionAttr (" GDJBH_String ") %] ' will number as initial value with the power supply administration at current register person place when moving.About embedded expression formula, will be in follow-up chapters and sections introduction.
More than defined a input parameter the most basic.Query page can show that a text box is used for manually importing power supply administration's numbering during operation.And can not be sky.
Use other mode input parameters if desired, as use combobox to show optional power supply administration, perhaps use dtpicker to show a date, can use the configuration information of certain field that is mapped on the data source to generate input parameter (implication about data source sees also relevant documentation) so, its code is as follows:
<item
no ＝″1″
name ＝″s_gdj″
Displaytext=" affiliated power supply administration "
mapping ＝″unireport?inputparameter.s?gdj″
allowignore?＝″false″
initvalue ＝“0001”/>
Wherein, mapping: be mapped on certain field of certain data source object.String。Form is: data source object name field name.Such as, defined the field of a s_gdj by name among the DSN unireport_inputparameter, will generate the combobox that can not edit when moving so, fill this combobox with the project in the dictionary table " power supply administration " then.
The input parameter that is mapped on the data source field can show as: text box, editable combobox, the combobox that can not edit, checkbox, DTPicker, various patterns such as button.And conditions such as max min can be set.
To some complicated especially input parameter, during as input power supply administration, wish that input control is one＜hidden〉record power supply administration numbering, and then show that the text box that can not edit shows power supply administration's title, the next door shows a selector button more then.Eject a window of selecting power supply administration by select button, selected after the power supply administration, with the number record of selecting power supply administration at＜hidden in, will select the title of power supply administration to be presented in the text box.This complicated situation can use the render method to render a special input control.Its code is as follows:
<item
no ＝″1″
name ＝″s_gdj″
show ＝″true″
Displaytext=" power supply administration "
render ＝″Render_Gdj(’s_gdj’)″
Initvalue=' 0001| garden power supply administration '
/>
Wherein, render: definition rendering intent.String。Generate the layer of a div_s_gdj by name here when rendering intent is meant program run in label the right elder generation, content is empty, calls the content of corresponding rendering objects generation div_s_gdj in the JS script then in the body_onload of page incident again.As above generate text box and button, and response button is pressed incident
As above, in a userfunction.js file by name, defined this rendering objects of Render_Gdj in advance.Code is as follows:
var?Render_Gdj?＝?Class.create()；
Render_Gdj.prototype＝{
id:″″.
text:″″，
initialize:function(id){
this.id＝id；
this.text＝id+″.text″；
}，
toString:function(){
return″<input?type＝’hidden’id＝’″+this.id+″’name＝’″+this.id+″’>″+
″<input?type＝’text’id＝’″+this.text+″’name＝’″+this.text+″’class＝’input_80width’readonly>″+
"＜input type=' button ' value='? ' title=' selects power supply administration ' class=' button ' style=' width:15 ' onclick=' javascript:render_ "+this.id+ " .onclick (); ' ";
}，
onclick:function(){
var?ret?＝?pub_select_record(
" please select a power supply administration ",
" power supply administration's numbering | 10|c ~ power supply administration's title | 20|c ",
″select?s_itemid.s_itemvalue?from?pub_dictitem?where?n_typeid?＝?7orderby?s_itemid″)；
if(ret?＝＝?null)return；
$(this.id).value?＝?ret[0]；
$(this.text).value?＝?ret[1]；
}，
render:function(div){
if(div?＝＝?null?||?div?＝＝?undefined){
$(″div_″+this.id).innerHTML?＝?this.toString()；
}else{
$(div).innerHTML?＝?this.toString()；
}
}，
setValue:function(value){
if(value?＝＝?null?||?value?＝＝?″″)return；
var?ss＝value.split(″|″)；
$(this.id).value?＝?ss[0]；
if(ss.length?>?1){
$(this.text).value?＝?ss[1]；
}
}
}；
During operation, the querying condition page can generate the JS object of a render_s_gdj by name, calls the content that render_s_gdj.render () method generates div_s_gdj then.By using rendering objects, can generate any complicated query condition entry frame.
For special complicated query condition.If can't use above method to generate, but the also page of self-defined inquiry condition of that operator saves as html file or jsp file.Then file is uploaded in the assigned catalogue, and at＜input-parameters to add attribute searchpage in the node and indicate this form and use a self-defining query page.As
<input-parameters?searchpage＝”/unireport_searchpage/operator_list.jsp”>
After having specified self-defining query page, need not to dispose again each input parameter.Custom profile generally leaves in the virtual directory.
In addition, each form is all wanted the definition of data source.In the form one or more data sources can be arranged.When system moves,, inquire about, obtain data according to data parameters.The data storage of obtaining is in set of data objects.In the present embodiment, data source definitions is at＜datasource〉in the section.As following data source definitions:
<datasource>
<sql
name ＝″dlsd″
sql ＝″select?n_zxygz，datepart(Hour，d_cjsj)as?n_hour?from?dlsdwhere?s_bbh?＝’[％＝getInput(”s_bbh”)％]’and?d_cjsj>＝’[％＝getInput(”d_rq”)％]’and?d_cjsj<’[％＝getInput(”d_rq1”)％]’order?by?d_cjsj″/>
<sql
name ＝″ssl″
sql ＝″select?n_ua，n_ub，n_uc，datepart(Hour，d_cjsj)as?n_hour?fromssl?where?s_bbh?＝’[％＝getInput(”s_bbh”)％]’and?d_cjsj>＝’[％＝getInput(”d_rq”)％]’and?d_cjsj<’[％＝getInput(”d_rq1”)％]’order?by?d_cjsj″/>
</datasource>
Each data source definitions is in a child node.Each data source all has a name attribute, defines the title of this data source.Data in the routine access data source object also are to visit according to title afterwards.The different pieces of information source should dispose different titles.System supports three kinds of data sources: the SQL data source: by defining the SQL statement of a data query, in database, carry out inquiry, with Query Result as the data source content.Support embedded expression formula in the SQL statement.Java data source:, obtain required data by visiting a Java method.This Java method can be the method for local class, also can be a long-range EJB method call.DSF data source:, obtain desired data by visit DSF (DataSourceDefine) object.The data query source is returned field and all has been defined in the DSF object, only need submit to querying condition to get final product during inquiry.Can think the senior version of SQL data source, be about to return after code field is changed in the underlying table data.And can format processing to field value.In a form, can dispose a plurality of several data source simultaneously.
The data object that returns after data source executes inquiry has following several:
The Java Bean that BEAN-is single, actual is exactly a java class example.Obtain data by the visit appointed method.
MAP-Java Map object.Can from Map, obtain data by Key.
ARRAY-Java Array object, i.e. array.The data of the inside are (index) visit in order.
LIST-Java List object.Similar with Array, the data of the inside are (index) visit in order.
DATASET_ROW-Java DataSet object.Be the object data set object, but only use the current record among the DataSet.
LIST_BEAN-Java List＜Bean〉object, the set of Bean object.
MAP_BEAN-Java Map object, Map＜BeanName, BeanObject 〉.Once call and return a plurality of Bean.After returning, will be that name is put into the return data object set with BeanObject with data source name .BeanName.Generally do not need to define the Java data source method that the rreturn value type is MAP_BEAN.The a plurality of data sources of definable, the Java call method of each data source returns single Bean.
LIST_MAP-Java List＜Map〉object.Each element among the List is a Map.
The DATASET-object data set.(self-defined) is similar to ResaultSet.Wherein can comprise many records.
GROUP_MAP-Java Map＜Bean1, List＜Bean2〉object.Generally be used for providing data to the grouping form.Bean1 is used to provide the data of grouping, List＜Bean〉be used for providing data to the detail district of this grouping.
It is the wall scroll record that above-mentioned BEAN, MAP, ARRAY, LIST, DATASET_ROW object can be used as, and only comprises a plurality of attribute datas of an entity.Can be used to fill each section in the form.
Above-mentioned LIST_BEAN, LIST_MAP, DATASET comprise many records, can be used for filling detailed district.
Above-mentioned GROUP_MAP had both comprised integrated data, also comprised the grouping detailed data, and being used for provides data to the grouping form.
Above-mentioned MAP_BEAN comprises a plurality of mutual incoherent Bean.
SQL data source and DSF data source are only returned the DATASET data object, and the Java data source can be returned any data object
Is the SQL data source with sql as the data source that the child node title defines, and its code is as follows:
<sql
name ＝″dlsd″
sql ＝″select?n_zxygz，datepart(Hour，d_cjsj)as?n_hour?from?dlsd?wheres_bbh?＝’[％＝getInput(”s_bbh”)％]’and?d_cjsj>＝’[％＝getInput(”d_rq”)％]’andd_cjsj<’[％＝getInput(”d_rq1”)％]’order?by?d_cjsj″/>
Wherein:
Name: the title of this data source.String。
Sql: the SQL of data query, String supports embedded expression formula.Clear in the above example in order to browse, change back original value with the escape character among the SQL, should note during actual disposition.
The result that the SQL data source is returned is a record set (DataSet) object.
Is the java data source with java as the data source of child node title definition, and the Java data source is meant visits the data source that a java method obtains in the time of running.Its code is as follows:
<java
name ＝″czy″
method ＝’getCZYList(getInput(″s_gdj″))’
return ＝″list_bean″/>
Wherein:
Name: DSN, String
Method: method name, String.Support self-defining function.
Return: the return data type, String, optional value comprises bean, map, array, list, dataset_row, list_bean, map_bean, list_map, dataset, group_map;
In foregoing, the method method can be used self-defining function.The statement file of self-defining function should load when the web startup of server.
In above method getCZYList (getInput (" s_gdj ")), used a self-defining function getCZYList (getInput (e, " s_gdj ")), the statement of this function is as follows:
public?static?ArrayList?getCZYList(String?gdj)throws?UniException{
}
Stated and just can in self-defining function, use after this method.
The data of returning after method is finished leave in earlier in the return data set.
Is the DSF data source with dsf as the data source that the child node title defines, and its code is as follows:
<dsf
name ＝″czy″
alias ＝“xt_czy”
preset_where?＝“s_isadmin＝‘0’”
preset_orderby?＝“s_czybh”/>
Wherein:
Name: the title of this data source.String。
Alias: the another name of data source, String.
Preset_where: the querying condition that presets.String。Can omit.
Preset_orderby: the sort criteria that presets, String.Can omit.
The DSF data source can be regarded the upgrading of SQL data source as, and it also is to return a DataSet object.But the DSF data source is by inquiring about on the DSF object, returning the good field of predefined.And raw data is carried out the conversion of Value-Text and the processing of some data formattings according to the transcoding mode that defines among the DSF.The querying condition of Presetwhere and when operation input can be combined during inquiry and inquire about (being the And relation between two querying conditions).As above example can be keeper's operator only in the Query Result.And the sort criteria of acquiescence is to sort by operator's numbering.
In the defined file of present embodiment, data computation process again are defined in＜caldata〉section in.Can be sky.For example:
<caldata>
mymap?＝?new?HashMap()；
mymap.put(″usercount″，getDataSet(″czy″).count(″*″))；
mymap.put(″avg_age″，getDataSet(″czy″).avg(″age″))；
pubData(e，″totaldata″，mymap)；
</caldata>
System is placed on the data object that returns in the set of data objects after each data source is handled.Can calculate again the data in the data object set.Calculate the calculating (as DataSet) that generally comprises the data dummy column again; Data are added up (as counting, summation, maximizing minimum value mean value etc.), and the statistics data of generation can store new data object (as Map of new generation) into.
Computation process all realizes by self-defining function again.By at＜caldata〉the configuration self-defining function realizes between the node.Self-defining function can be many, every statement end be branch (; ), grammer will meet the syntax rule of Java language.Order is carried out between many statements.
In above-mentioned example, at first generate a HashMap object mymap, give among this map then and added two data item: usercount? the record number summation of data set czy, avg_age? data set czy averages to the full complement at the age.At last this map is added in the set of data objects.Also can use this data object at written-out program.
After data are calculated and finished, just carry out data output step, in the defined file of present embodiment, data output is defined in＜segment-data〉in the section.As follows:
<segment-data>
<title
bind ＝″false″>
<item?name?＝″title″formula?＝’getInput(″s_gdj.text″)’/>
<item?name?＝″printdate″formula?＝’today()’/>
</title>
<body
bind ＝″true″
type ＝″list_bean″
source ＝″czy″/>
</segment-data>
In the present embodiment, data output refers to submits to the ExcelEngine object with data by section, generates the form section by the ExcelEngine object, and padding data, generates form at last.
At＜segment-data〉defined each data item in each section of form in the section and be tied on which data object in the set of data objects.A section can be bundled on the data object, each data item that also can dispose in the section is bundled on the different field (or attribute) of different data objects.＜segment-data〉section each child node title should be nodename with the report band name section.
Wherein:
Bind: whether this section is bundled on the data object.Boolean can not omit.If bind=" false " represents that the data item needs in this section dispose one by one.Being configured in＜item of each data item〉in the child node.
The Item child node:
Name: data item title, String.
Formula: data output formula, String.Use self-defining function.
Wherein, the Name of Item need be complementary with the data item title that defines in the report style file.As above form, the definition of data item of gauge outfit section is in the pattern file:
<report-title-define>
＜item name=" title " row=" 2 " col=" b " display=" true " format=" %1$s operator's inventory " format_data_type=" c " length=" 0 " datatype=" c "/〉
<item?name＝″printdate″row＝″3″col＝″e″display＝″true″format＝″″length＝″0″datatype＝″d″/>
</report-title-define>
Two data item: title and printdate have wherein been defined.
If bind=" true " just do not needed one by one configuration data items again.
Type: data object classification, String, optional value: bean, map, array, list, dataset_row, list_bean, list_map, dataset
Source: the data object title, String can use any object in the set of data objects.
After having carried out binding configuration, system will be directly gives the ExcelEngine object data object and removes cell in the filler section.But guarantee that the data item title that defines in each data name in the data object and the report style file is complementary when visit data item (by name) or order is complementary when visit data item (in order).
In the present embodiment, if form is defined as a grouping form (＜report-define type=" group " 〉), so also need to define the integrated data deferent segment.If form is other types, then do not need this section code:
<group-data
datasource ＝″dataset″
dsgroup ＝″yh″
dsbody ＝″gdjl″
filterfield ＝″s_bbh″/>
Wherein:
Datasource: data source classification, String, optional value: dataset/map.Which kind of data source expression uses.During datasource=" dataset ", need the following attribute of definition:
Dsgroup: packet partial data set (DataSet) object oriented, String
Dsbody: the detailed partitioned data set (PDS) object oriented that divides into groups, String
Filterfield: filtered fields title, String
Datasource=" map " is to need the following attribute of definition:
Map: integrated data object (Map) title, String.
Can make in two ways and provide data for the grouping form.One uses two object data sets.Dsgroup and dsbody.Read data among the dsgroup during operation in order as the integrated data item, press the filterfield field then and filter, obtain the corresponding detailed data item of current group record, the detailed data that regeneration should grouping to dsbody.It two is to use a Map object,＜groupBean, List＜Bean〉〉, groupBean provides packet partial data, List＜Bean〉part provides the detailed data of this grouping.
Attention: when report definition was the grouping form, the gauge outfit table portion of form also needed by the section definition, and packet partial is defined in＜group-data〉in.
In addition, in the present embodiment, system also can use self-defining function.Self-defining function can be used separately, also can be placed on to embed in the expression formula.Such as initvalue=' [%=getSessionAttr (" GDJBH_String ") %] | [%=getSessionAttr (" GDJMC_String ") %] ' in, getSessionAttr (" GDJBH_String ") is exactly that a self-defining function is placed on example in the embedded expression formula.And for example: sql=" select n_zxygz; datepart (Hour, d_cjsj) as n_hour from dlsd where s_bbh=' [%=getInput (" s_bbh ") %] ' and d_cjsj 〉=' [%=getInput (" d_rq ") %] ' and d_cjsj＜' [%=getInput (" d_rq1 ") %] ' order by d_cjsj " also is the example of embedded expression formula.
Embedded expression formula is meant that this content itself is one section text, and wherein embedding has [%.......%] such label, is embedded expression formula in the label, and the soluble execution of runtime system embeds expression formula, replaces label with result of calculation.The net result text is offered program to be used.Content in the label [%%] should be an effective Java statement, can comprise self-defining function, system function, various operational symbols.But final calculation result should be returned a character string.Statement in the label should with=(equal sign) beginning.And during string variable of internal representation, should be with double quotation marks (") as the border at character string two ends.And for example:＜item name=" title " formula=' getInput (" s_gdj.text ") '/, be exactly the self-defining function of an example that directly uses
Visit place application system function, variable are all undertaken by self-defining function in the self-defined report.When system moves,, carry out data computation, return result of calculation and output in the form by the engine calling self-defining function.Therefore all and the relevant function of data access calculating of system all realizes by self-defining function.Self-defining function also is a big characteristic of system.When system installs, provide a part of self-defining function.In actual motion, if provide not enough, can oneself the redevelopment corresponding java applet, be packaged into the Jar file after having developed, be distributed in the corresponding lib catalogue of application server, then the statement of function is added in the self-defining function statement file, just can have been used the self-defining function that newly adds.
In fact self-defining function has been used BSH to wrap and has been calculated self-defining function or expression formula.
Implement described self-defined report at this and produce in the management system, in fact management platform is exactly the bibliographic structure of managerial report defined file, and file is uploaded and downloaded and deletion.Wherein, its data file content structure is as follows:
Unireport: data file root directory
-define: report definition document storage catalogue.Deposit under this catalogue of report definition file (xml form) and can create subdirectory name arbitrarily, just as the systematic name of form, catalogue progression without limits for directory name.The report definition file extent is called .xml.
-dsf: self-defining data source binding form storing directory.It under the catalogue definition of total data source binding form.Can create subdirectory name arbitrarily under this catalogue, just as the systematic name of form, catalogue progression without limits for directory name.Empty file of each report definition.File " report display title ~ corresponding data source another name .txt " by name, extension name is any, and no extension name also can.
-model: report form template file and pattern document storage catalogue.Template file (xls form), pattern file (xml form)
-userfunction: self-defining function statement document storage catalogue.The statement file is text (a txt form)
-unireport_searchpage: self-defined inquiry condition page storing directory.During operation this catalogue is mapped as a virtual directory under the web server.If the web server does not support to shine upon virtual directory, also this catalogue can be placed directly under the webapps.
In the present embodiment, structure is identical with document directory structure and report file name, has simplified the classification and the release management of form like this.Create new branch time-like, only need under assigned catalogue, to create new directory and get final product, also report file need be uploaded to assigned catalogue and get final product and issue new form.
In the present embodiment, in fact operation platform is exactly the operation interface of system.After operator's login, can see announced each form, click a report name, system is according to the input parameter generated query condition entry page that defines in this form.Submit to after operator's input inquiry condition and can see the form content.In the present embodiment, during system start-up, load self-defining function statement file, load dictionary table definition, data source definitions etc.When system moves, the operator clicks a self-defined report title, start self-defined report engine (Engine) processing procedure: at first according to report definition object of report definition file build (ReportDefine object), then according to this definition object structure self-defined report processing engine (Engine) class example; From ReportDefine.inputParameters, can learn self-defined inquiry condition, for each querying condition generates corresponding querying condition input control into this report definition.Generate the page of each querying condition of input at last.Imported when submitting to behind the querying condition, system carries out verification according to the method for inspection that defines in the querying condition to input value, and verification succeeds just can be submitted inquiry to.Afterwards, Report Engine is handled the querying condition of submitting to, all parameter input values is put into Engine.inputData, and handle the data source definitions among the ReportDefine one by one.After handling data source definitions,, the data object of depositing among the Engine.data is calculated again, for example produce some statisticss etc. according to the definition of .calData part among the ReportDefine.The data in the existing object can be revised, also new data can be produced.New input generally deposits among the new map.Afterwards, according to ExcelEngine object of report style file build, arrive the ExcelEngine object according to the definition of data item output data to each section among the ReportDefine.segmentDatafile then.Wherein, for the SQL data source, the embedded expression formula among the treatment S QL obtains the target SQL statement, carries out inquiry, obtains Query Result, and DataSet puts into Engine.data with Query Result; For the Java data source,, carry out a Java method by calling self-defining function.The data object that this method is returned is put into Engine.data; For the DSF data source, at first construct a DSF object, on this object, carry out inquiry then, the DataSet object that returns is put into Engine.data.And on the whole section to of a binding data object, data object is taken out from Engine.data, directly submit to the ExcelEngine object, generate the appropriate section of form.When the sector data item is to dispose one by one, at first construct a new map, call self-defining function and embedded expression formula processing engine, the data item allocation formula is calculated, data item title and result of calculation are put into map, after the total data item of this section is all handled, whole map is submitted to the ExcelEngine object, generate the appropriate section of form.
When output report, by the Html pattern form content is presented on the client browser if desired, the export method of calling excel Engine so obtains the form content of Html form, then the Html content is written to response, finally is presented on the client browser.In general, the form content should be presented at independently in the frame; Generate the Excel file if desired and download to this machine for the client, the export method of calling excel Engine so, obtain byte[] the Excel file content of form, the response that then data write direct, client browser will point out and download or open the Excel file; Generate the Excel file at server end if desired, can call the ExcelEngine.write method, the form content is written in the file of Excel form.
The above embodiment has only expressed several embodiment of the present invention, and it describes comparatively concrete and detailed, but can not therefore be interpreted as the restriction to claim of the present invention.Should be pointed out that for the person of ordinary skill of the art without departing from the inventive concept of the premise, can also make some distortion and improvement, these all belong to protection scope of the present invention.Therefore, the protection domain of patent of the present invention should be as the criterion with claims.
Claims (10)
1. a self-defined report generates management method, is used for browser/server structure, it is characterized in that, comprises the steps:
A) calling utilization program on the server on the browser, the report page of all form inventories on the display server is selected one of them form;
B) server generates selected form, is sent to described browser.
2. self-defined report according to claim 1 generates management method, it is characterized in that also be included on the described server and set up report file, it comprises:
M) use Excel to generate a plurality of report files that are stored in the server.
3. self-defined report according to claim 2 generates management method, it is characterized in that described step M) in further comprise the steps:
M1) use Excel to obtain report form template, generate template file;
M2) divide section with described template file, and define each section in the described template file, generate the pattern file;
M3) data in above-mentioned each section of definition, the generation definition file;
M4) above-mentioned file is sent to assigned address in the form catalogue of server, obtains a report file.
4. self-defined report according to claim 3 generates management method, it is characterized in that described step M2) described in the definition section comprise: define the position of the data item of placing in this section, described data item and the display format of described data.
5. self-defined report according to claim 4 generates management method, it is characterized in that described step M3) described in the data of definition in the described section comprise: the source of data, data query mode, data query conditions, data computation and data are filled.
6. self-defined report according to claim 5 generates management method, it is characterized in that described step M4) further comprise the steps:
M41) described template file, pattern file and defined file are sent in the described server assigned catalogue;
M42) refresh report page, obtain the inventory of the form that above-mentioned file generates.
7. self-defined report according to claim 1 generates management method, it is characterized in that described step B) further comprise:
B1) produce this report query conditions input page;
B2) according to the content of described querying condition input page, data query generates form;
B3) form of output generation is to described browser.
8. a self-defined report generates management system, is used for browser/server framework, it is characterized in that, comprises on the described server:
Form runtime engine: be used to resolve the report definition file, data that the inquiry form needs and generation form;
Report Server Management platform: be used for issue, manage all kinds of forms;
The form operation platform: be used to be presented at the form inventory of issuing on the described management platform, call described runtime engine when selected when one in the described form inventory, search, generate form, and output.
9. self-defined report according to claim 8 generates management system, it is characterized in that described form runtime engine further comprises the querying condition input page generation unit that is used for being produced by time in selecting at form of described form inventory the querying condition input page.
10. self-defined report according to claim 9 generates management system, it is characterized in that described Report Server Management platform comprises: be used to deposit described report definition file report definition document storage catalogue, be used to deposit described report form template file and pattern file report form template file and pattern document storage catalogue, be used to deposit in form binding data source self-defining data source binding form storing directory, be used to deposit the self-defining function statement document storage catalogue of statement file and the self-defined inquiry condition page storing directory that is used to deposit described query page.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN200910305760A CN101650712A (en) | 2009-08-18 | 2009-08-18 | Generating management method and system of self-defined report |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN200910305760A CN101650712A (en) | 2009-08-18 | 2009-08-18 | Generating management method and system of self-defined report |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101650712A true CN101650712A (en) | 2010-02-17 |
Family
ID=41672951
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN200910305760A Pending CN101650712A (en) | 2009-08-18 | 2009-08-18 | Generating management method and system of self-defined report |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101650712A (en) |
Cited By (35)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101877098A (en) * | 2010-03-23 | 2010-11-03 | 苏州德融嘉信信用管理技术有限公司 | Bank credit and debit service report system and entry generating method thereof |
| CN101894099A (en) * | 2010-06-29 | 2010-11-24 | 北京科技大学 | Report template customization method |
| CN102201009A (en) * | 2011-06-21 | 2011-09-28 | 深圳市凯立德科技股份有限公司 | Form generating method and device |
| CN102722533A (en) * | 2012-05-09 | 2012-10-10 | 浙江图讯科技有限公司 | Method and system for displaying and filling report |
| CN102902546A (en) * | 2012-10-12 | 2013-01-30 | 重庆亚德科技股份有限公司 | Common report list assembly |
| CN104040535A (en) * | 2012-01-09 | 2014-09-10 | 微软公司 | Custom browser-side spreadsheet functions |
| CN104133826A (en) * | 2013-09-26 | 2014-11-05 | 腾讯科技（深圳）有限公司 | Method for creating data report business, relevant device and business system |
| CN104317839A (en) * | 2014-10-10 | 2015-01-28 | 北京国双科技有限公司 | Method and device for generating report form template |
| CN104361121A (en) * | 2014-12-02 | 2015-02-18 | 福建工程学院 | Batch analysis method for WEB report system formula |
| CN104615435A (en) * | 2015-02-11 | 2015-05-13 | 浪潮通用软件有限公司 | Method and device for implementing data wizards |
| CN104699748A (en) * | 2014-12-19 | 2015-06-10 | 深圳市燃气集团股份有限公司 | Method and system for showing report form with non-fixed column numbers |
| CN105446948A (en) * | 2015-11-13 | 2016-03-30 | 武汉鸿图节能技术有限公司 | Report automatic generation method and system |
| CN106257445A (en) * | 2015-06-17 | 2016-12-28 | 中兴通讯股份有限公司 | The display packing of field and device |
| CN106874247A (en) * | 2017-01-03 | 2017-06-20 | 北京神州绿盟信息安全科技股份有限公司 | A kind of report form generation method and device |
| CN106886484A (en) * | 2017-02-22 | 2017-06-23 | 郑州云海信息技术有限公司 | Report form generation method and device based on sea of clouds system |
| CN107274098A (en) * | 2017-06-20 | 2017-10-20 | 国网江苏省电力公司无锡供电公司 | A kind of method of the grid equipment information intelligent storage based on dispatching of power netwoks technology |
| CN107608950A (en) * | 2016-07-11 | 2018-01-19 | 陈鹏 | A kind of method for generating electronic report forms |
| CN108228551A (en) * | 2018-01-08 | 2018-06-29 | 平安科技（深圳）有限公司 | Data lead-in method, device, equipment and the computer readable storage medium of excel |
| CN103473234B (en) * | 2012-06-07 | 2018-07-06 | 中兴通讯股份有限公司 | A kind of method, apparatus and system from web-query system export report |
| CN108268525A (en) * | 2016-12-30 | 2018-07-10 | 深圳市优朋普乐传媒发展有限公司 | A kind of report implementation method and device based on Excel template |
| CN108460007A (en) * | 2018-02-11 | 2018-08-28 | 悦锦软件系统（上海）有限公司 | A kind of automation report logic engine and method |
| CN108536660A (en) * | 2018-04-03 | 2018-09-14 | 福建榕基软件工程有限公司 | A kind of generation method and terminal of self-defined report |
| CN108959221A (en) * | 2018-06-04 | 2018-12-07 | 广州环通信息技术有限公司 | A kind of the electrical form deriving method and system in the electrical form export library based on open source |
| CN109213818A (en) * | 2018-08-15 | 2019-01-15 | 平安科技（深圳）有限公司 | Table deriving method, device, computer equipment and storage medium |
| CN109343968A (en) * | 2018-08-02 | 2019-02-15 | 武汉斗鱼网络科技有限公司 | A kind of method and relevant apparatus obtaining data |
| CN109388612A (en) * | 2018-09-14 | 2019-02-26 | 中国科学院光电研究院 | A kind of method, equipment, system and the medium of data summarization document structure tree |
| CN109522370A (en) * | 2018-10-29 | 2019-03-26 | 珠海迎迎科技有限公司 | A kind of automatic table generation method and device based on SQL |
| CN109614408A (en) * | 2018-10-25 | 2019-04-12 | 南京行者易智能交通科技有限公司 | The implementation method of web terminal self-defined report based on spring and poi |
| CN109669693A (en) * | 2017-10-16 | 2019-04-23 | 航天信息股份有限公司 | A kind of method and system generating forms pages based on dynamic page |
| CN109829141A (en) * | 2018-12-28 | 2019-05-31 | 陈德芹 | A kind of project table generation method and device |
| CN110555025A (en) * | 2019-08-29 | 2019-12-10 | 中邮科通信技术股份有限公司 | method and system for realizing WEB form custom field |
| CN111339087A (en) * | 2020-02-20 | 2020-06-26 | 重庆锐云科技有限公司 | Method for automatically exporting real estate marketing data monitoring result report as Excel file |
| CN112417836A (en) * | 2020-11-27 | 2021-02-26 | 智业软件股份有限公司 | Automatic table generation method, terminal equipment and storage medium |
| CN113032633A (en) * | 2021-04-15 | 2021-06-25 | 内蒙古金财信息技术有限公司 | Method for customizing table by using reference data item |
| CN114356334A (en) * | 2022-01-20 | 2022-04-15 | 山东捷瑞数字科技股份有限公司 | TableView-based mobile terminal dynamic form generation method and device |
-
2009
- 2009-08-18 CN CN200910305760A patent/CN101650712A/en active Pending
Cited By (48)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101877098A (en) * | 2010-03-23 | 2010-11-03 | 苏州德融嘉信信用管理技术有限公司 | Bank credit and debit service report system and entry generating method thereof |
| CN101894099A (en) * | 2010-06-29 | 2010-11-24 | 北京科技大学 | Report template customization method |
| CN101894099B (en) * | 2010-06-29 | 2011-07-27 | 北京科技大学 | Report template customization method |
| CN102201009A (en) * | 2011-06-21 | 2011-09-28 | 深圳市凯立德科技股份有限公司 | Form generating method and device |
| CN104040535B (en) * | 2012-01-09 | 2017-02-22 | 微软技术许可有限责任公司 | Custom browser-side spreadsheet functions |
| US9389891B2 (en) | 2012-01-09 | 2016-07-12 | Microsoft Technology Licensing, Llc | Custom browser-side spreadsheet functions |
| CN104040535A (en) * | 2012-01-09 | 2014-09-10 | 微软公司 | Custom browser-side spreadsheet functions |
| CN102722533A (en) * | 2012-05-09 | 2012-10-10 | 浙江图讯科技有限公司 | Method and system for displaying and filling report |
| CN103473234B (en) * | 2012-06-07 | 2018-07-06 | 中兴通讯股份有限公司 | A kind of method, apparatus and system from web-query system export report |
| CN102902546A (en) * | 2012-10-12 | 2013-01-30 | 重庆亚德科技股份有限公司 | Common report list assembly |
| CN104133826A (en) * | 2013-09-26 | 2014-11-05 | 腾讯科技（深圳）有限公司 | Method for creating data report business, relevant device and business system |
| CN104317839A (en) * | 2014-10-10 | 2015-01-28 | 北京国双科技有限公司 | Method and device for generating report form template |
| CN104317839B (en) * | 2014-10-10 | 2017-11-14 | 北京国双科技有限公司 | The method and apparatus for generating report form template |
| CN104361121A (en) * | 2014-12-02 | 2015-02-18 | 福建工程学院 | Batch analysis method for WEB report system formula |
| CN104361121B (en) * | 2014-12-02 | 2017-08-08 | 福建工程学院 | A kind of batch analytic method of WEB reporting systems formula |
| CN104699748A (en) * | 2014-12-19 | 2015-06-10 | 深圳市燃气集团股份有限公司 | Method and system for showing report form with non-fixed column numbers |
| CN104699748B (en) * | 2014-12-19 | 2018-06-12 | 深圳市燃气集团股份有限公司 | It is a kind of to show the method and its system for being not fixed row report |
| CN104615435A (en) * | 2015-02-11 | 2015-05-13 | 浪潮通用软件有限公司 | Method and device for implementing data wizards |
| CN106257445A (en) * | 2015-06-17 | 2016-12-28 | 中兴通讯股份有限公司 | The display packing of field and device |
| CN105446948A (en) * | 2015-11-13 | 2016-03-30 | 武汉鸿图节能技术有限公司 | Report automatic generation method and system |
| CN107608950A (en) * | 2016-07-11 | 2018-01-19 | 陈鹏 | A kind of method for generating electronic report forms |
| CN108268525A (en) * | 2016-12-30 | 2018-07-10 | 深圳市优朋普乐传媒发展有限公司 | A kind of report implementation method and device based on Excel template |
| CN106874247A (en) * | 2017-01-03 | 2017-06-20 | 北京神州绿盟信息安全科技股份有限公司 | A kind of report form generation method and device |
| CN106886484A (en) * | 2017-02-22 | 2017-06-23 | 郑州云海信息技术有限公司 | Report form generation method and device based on sea of clouds system |
| CN107274098A (en) * | 2017-06-20 | 2017-10-20 | 国网江苏省电力公司无锡供电公司 | A kind of method of the grid equipment information intelligent storage based on dispatching of power netwoks technology |
| CN109669693A (en) * | 2017-10-16 | 2019-04-23 | 航天信息股份有限公司 | A kind of method and system generating forms pages based on dynamic page |
| CN108228551A (en) * | 2018-01-08 | 2018-06-29 | 平安科技（深圳）有限公司 | Data lead-in method, device, equipment and the computer readable storage medium of excel |
| WO2019134225A1 (en) * | 2018-01-08 | 2019-07-11 | 平安科技（深圳）有限公司 | Excel data import method, apparatus and device, and computer readable storage medium |
| CN108460007A (en) * | 2018-02-11 | 2018-08-28 | 悦锦软件系统（上海）有限公司 | A kind of automation report logic engine and method |
| CN108536660A (en) * | 2018-04-03 | 2018-09-14 | 福建榕基软件工程有限公司 | A kind of generation method and terminal of self-defined report |
| CN108536660B (en) * | 2018-04-03 | 2023-08-04 | 福建榕基软件工程有限公司 | Custom report generation method and terminal |
| CN108959221A (en) * | 2018-06-04 | 2018-12-07 | 广州环通信息技术有限公司 | A kind of the electrical form deriving method and system in the electrical form export library based on open source |
| CN109343968A (en) * | 2018-08-02 | 2019-02-15 | 武汉斗鱼网络科技有限公司 | A kind of method and relevant apparatus obtaining data |
| CN109343968B (en) * | 2018-08-02 | 2020-09-04 | 武汉斗鱼网络科技有限公司 | Method and related device for acquiring data |
| CN109213818A (en) * | 2018-08-15 | 2019-01-15 | 平安科技（深圳）有限公司 | Table deriving method, device, computer equipment and storage medium |
| CN109388612B (en) * | 2018-09-14 | 2021-01-15 | 中国科学院光电研究院 | Method, equipment, system and medium for generating data summary document |
| CN109388612A (en) * | 2018-09-14 | 2019-02-26 | 中国科学院光电研究院 | A kind of method, equipment, system and the medium of data summarization document structure tree |
| CN109614408A (en) * | 2018-10-25 | 2019-04-12 | 南京行者易智能交通科技有限公司 | The implementation method of web terminal self-defined report based on spring and poi |
| CN109614408B (en) * | 2018-10-25 | 2019-09-20 | 南京行者易智能交通科技有限公司 | The implementation method of web terminal self-defined report based on spring and poi |
| CN109522370A (en) * | 2018-10-29 | 2019-03-26 | 珠海迎迎科技有限公司 | A kind of automatic table generation method and device based on SQL |
| CN109829141A (en) * | 2018-12-28 | 2019-05-31 | 陈德芹 | A kind of project table generation method and device |
| CN110555025A (en) * | 2019-08-29 | 2019-12-10 | 中邮科通信技术股份有限公司 | method and system for realizing WEB form custom field |
| CN110555025B (en) * | 2019-08-29 | 2022-05-24 | 中邮科通信技术股份有限公司 | Method and system for realizing WEB form custom field |
| CN111339087A (en) * | 2020-02-20 | 2020-06-26 | 重庆锐云科技有限公司 | Method for automatically exporting real estate marketing data monitoring result report as Excel file |
| CN112417836A (en) * | 2020-11-27 | 2021-02-26 | 智业软件股份有限公司 | Automatic table generation method, terminal equipment and storage medium |
| CN113032633A (en) * | 2021-04-15 | 2021-06-25 | 内蒙古金财信息技术有限公司 | Method for customizing table by using reference data item |
| CN114356334A (en) * | 2022-01-20 | 2022-04-15 | 山东捷瑞数字科技股份有限公司 | TableView-based mobile terminal dynamic form generation method and device |
| CN114356334B (en) * | 2022-01-20 | 2022-08-05 | 山东捷瑞数字科技股份有限公司 | TableView-based mobile terminal dynamic form generation method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101650712A (en) | Generating management method and system of self-defined report | |
| CN101308490B (en) | Dynamic report generation method and platform | |
| CN101425063B (en) | Multi-dimension data set displaying and browsing method and equipment | |
| CN100458793C (en) | Mapping conversion method between data access level Xml format data and relational data | |
| JP4563189B2 (en) | Database management system and database management method | |
| CN101727324B (en) | Code generation method and device | |
| US20030221162A1 (en) | Meta-templates in website development and methods therefor | |
| CN110020307A (en) | A kind of method for drafting and device of client's end-view | |
| CN101446971B (en) | Method for building content management system and device thereof | |
| US8725487B2 (en) | Techniques to automatically generate simulated information | |
| CN101403968B (en) | Model-driven software development method and system based on template | |
| CN110673848A (en) | Enterprise information management system configuration platform based on JavaWeb | |
| CN104615425A (en) | Method and system for developing software system based on features and feature tree | |
| CN101799753B (en) | Method and device for realizing tree structure | |
| Kongdenfha et al. | Rapid development of spreadsheet-based web mashups | |
| CN106407170A (en) | Rapid generation method and system for data report | |
| CN110543303B (en) | Visual service platform | |
| CN103489061A (en) | Batch data processing device and batch data processing method | |
| CN116468010A (en) | Report generation method, device, terminal and storage medium | |
| JPWO2011118003A1 (en) | Web application construction system, web application construction method, web application construction program, and recording medium recording web application construction program | |
| CN102420862B (en) | A kind of Internet of things middleware message form conversion method | |
| Jennings | Professional ADO. NET 3.5 with LINQ and the Entity Framework | |
| CN114371845A (en) | Form generation method and device | |
| Bochicchio et al. | WARP: Web application rapid prototyping | |
| KR20080066361A (en) | Ontology search 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 |
Application publication date: 20100217 |