CN101650710A - Online software service system as well as method and device for generating report - Google Patents
Online software service system as well as method and device for generating report Download PDFInfo
- Publication number
- CN101650710A CN101650710A CN200910109085A CN200910109085A CN101650710A CN 101650710 A CN101650710 A CN 101650710A CN 200910109085 A CN200910109085 A CN 200910109085A CN 200910109085 A CN200910109085 A CN 200910109085A CN 101650710 A CN101650710 A CN 101650710A
- Authority
- CN
- China
- Prior art keywords
- report
- file
- data
- template file
- excel
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
Abstract
The invention is suitable for the field of information processing and provides an online software service system as well as a method and a device for generating a report. The method comprises the following steps: when receiving a report generating request, a network server obtains basic data from a database server and obtains a report template file from a file server; the network server fills thebasic data into a basic data area of the report template file by a report generating assembly and transmits the report template file filled with the basic data to a network client end; and the networkclient end executes report data generating operation in the report template file on the basic data of the basic data area in the report template file by table processing software, generates report data and displays the generated report data in the report data area of the report template file so as to generate a target report. The method for generating the report can simply and rapidly generate the report and has low cost and high efficiency.
Description
Technical field
The invention belongs to field of information processing, relate in particular to a kind of online software service system and report form generation method and device.
Background technology
(Software-as-a-service SaaS) is a kind of application model that software service is provided by the internet in online software service.SaaS provider is that information-based needed all-network infrastructure and software, hardware running platform are built by enterprise, and be responsible for the enforcement in all early stages, a series of services such as maintenance in later stage, enterprise need not to buy software and hardware again, builds machine room, configuration information management person, can use various business management softwares by the internet, greatly reduce the threshold and the risk of IT application in enterprises, for enterprise has saved great amount of cost, therefore, SaaS is used widely.
Form has critical role as requisite part in the business management software in business management software, therefore nearly all SaaS manufacturer of doing business management software all provides Web report generation function at present.There are following several report form generation methods in prior art:
See also Fig. 1, it is the process flow diagram that passes through form developing instrument generation form that prior art provides, its detailed process is summarized as follows: the user sends the form request to Web server, Web server is forwarded to report server with the form request, report server generates the required business datum of form to the database server request, database server is back to report server with business datum, report server generates form according to business datum and default report style, and by Web server the form that generates is returned to the user.Wherein report server may generate the form of different-format according to the difference of form request, as PDF, XLS form, html format etc.This report form generation method is owing to adopt the form developing instrument to generate form, if and the form developing instrument that adopts the third party to provide, then increase the cost of enterprise greatly, if develop the form developing instrument voluntarily, then, also will increase the cost of enterprise greatly because the form developing instrument is complicated and the technical threshold height.Excel is as the popular Excel in the whole world in addition, because it is simple and easy to usefulness, powerful, so most of enterprise is all with the first-selected ways of presentation of Excel as form, it is the function of Excel file layout that thereby existing SaaS manufacturer also all provides report output, but just Excel is used as a kind of form result's display mode usually, and does not take into full account the demand of user form result's secondary analysis.
Prior art provides a kind of Excel formation component technology, is used for reading and writing the Excel file by the mode of programming.As Apache POI is a kind of Excel formation component, and the open source code letter formula storehouse that this Excel formation component is an Apache Software Foundation provides API to the function of Java formula to the read and write of Microsoft Office form archives.Because adopt pure Java to write,, can finish read-write operation to Microsoft Office file so need not the support of Window operating system and MicrosoftOffice assembly.
Summary of the invention
The purpose of the embodiment of the invention is to provide the report form generation method in a kind of online software service system, is intended to solve report form generation method cost height, the high problem of exploitation complexity in the conventional online software service system.
The embodiment of the invention is achieved in that the report form generation method in a kind of online software service system, and described method comprises the steps:
A, the webserver are when receiving the report generation request, obtain master data according to described report generation request from database server, and obtaining the report form template file from file server, described report form template file comprises prime data area, report data zone and report data generating run;
B, the webserver are filled to the prime data area of described report form template file by the report generation assembly with described master data, and the report form template file that will fill master data is sent to networking client;
C, networking client carry out report data generating run in the report form template file by spreadsheet to the master data of prime data area in the report form template file, generate report data, and the report data that generates is presented at the report data zone of report form template file, generate the target form.
Another purpose of the embodiment of the invention is to provide a kind of report generation device, and described device comprises:
Basic data storage unit is used to store master data;
File storage unit is used to store the report form template file;
Network service element, be used for when receiving the report generation request, obtain master data according to described report generation request from described basic data storage unit, and obtain the report form template file from described file storage unit, the master data of obtaining is filled to the prime data area of report form template file by the report generation assembly;
Customer service unit, be used for by spreadsheet the report data generating run in the master data execution report form template file of report form template file prime data area, generate report data, and the report data that generates is presented at the report data zone of report form template file, generate the target form.
Another purpose of the embodiment of the invention is to provide a kind of online software service system, and described system comprises described report generation device.
In embodiments of the present invention, the webserver is when receiving the report generation request, obtain master data according to this report generation request from database server, and obtain the report form template file from file server, the master data of obtaining is write the prime data area of report form template file by the report generation assembly, networking client is carried out the default report data generating run of this report form template file by spreadsheet to the prime data area of report form template file, generate report data, thereby can be simple, generate form fast, and cost is low, the development efficiency height.
Description of drawings
Fig. 1 is the process flow diagram that passes through form developing instrument generation form that prior art provides;
Fig. 2 is the realization flow figure of the report form generation method in the software on-line system that provides of the embodiment of the invention;
Fig. 3 is the realization flow figure of the report form generation method in the software on-line system that provides of another embodiment of the present invention;
Fig. 4 is the synoptic diagram of the Excel form of the generation that provides of the embodiment of the invention;
Fig. 5 is the synoptic diagram of the Excel template file that provides of the embodiment of the invention;
Fig. 6 is the structured flowchart of the report generation device that provides of the invention process;
Fig. 7 is the concrete structure block diagram of the report generation device that provides of the embodiment of the invention.
Embodiment
In order to make purpose of the present invention, technical scheme and advantage clearer,, the present invention is further elaborated below in conjunction with drawings and Examples.Should be appreciated that specific embodiment described herein only in order to explanation the present invention, and be not used in qualification the present invention.
In embodiments of the present invention, the webserver is when receiving the report generation request, obtain master data according to this report generation request from database server, and obtain the report form template file from file server, the master data of obtaining is write the prime data area of report form template file by the report generation assembly, and with this report form template file transfer to networking client, networking client is carried out the default report data generating run of this report form template file by spreadsheet to the master data of prime data area in the report form template file, generate report data, and this report data write the report data zone of report form template file, generate the target form.
Fig. 2 shows the realization flow of the report form generation method in the online software service system that the embodiment of the invention provides, and details are as follows:
In step S101, the webserver obtains master data according to this report generation request from database server, and obtains the report form template file from file server when receiving the report generation request.
Wherein database server is used to store master data.Wherein master data is meant and generates the needed raw data of form, as selling detailed data, buying detailed data etc.
File server is used to store the report form template file, and this report form template file can be the report form template file of presetting, and also can be the self-defined report template file.This report form template file comprises prime data area and report data zone.Wherein prime data area is used to load master data, and it generally includes only gauge outfit, does not comprise concrete data content.The report data zone is used to show report data.This report data is the master data that prime data area loads to be carried out the report data generating run generate.Wherein the report data generating run is preset in the report form template file, includes but not limited to pivot operation, division operation, formula manipulation, macro operation and figure table handling etc.
Wherein the report form template file can be the report form template file of Excel template file or extended formatting.
In step S102, the webserver is filled to the prime data area of report form template file by the report generation assembly with the master data of obtaining, and this report form template file is sent to networking client.
Wherein the report generation assembly is meant the program module that is used for reading and writing by the mode of programming report file, need not the support of Window operating system and report form processing software, can finish the read-write operation to report file.This report generation assembly can be Excel formation component or extended formatting report generation assembly.
In step S103, networking client is carried out report data generating run default in the report form template file by spreadsheet to the master data of prime data area in the report form template file, generate report data, and the report data that generates is presented at the report data zone of report form template file, generate the target form.
Wherein spreadsheet can be the spreadsheet of Excel spreadsheet or extended formatting.
Fig. 3 shows the realization flow of the report form generation method in the online software service system that another embodiment of the present invention provides, and details are as follows:
In step S201, the webserver obtains master data according to this report generation request from database server, and obtains the Excel template file from file server when receiving the report generation request.
Wherein database server is used to store master data.Wherein master data is meant and generates the needed raw data of form, as selling detailed data, buying detailed data etc.
File server is used to store the Excel template file, and this Excel template file can be the Excel template file of presetting, and also can be self-defined Excel template file.This Excel template file comprises prime data area and report data zone.Wherein prime data area is used to load master data, and it generally includes only gauge outfit, does not comprise concrete data content.The report data zone is used to show report data.This report data is the master data that prime data area loads to be carried out the report data generating run generate.Wherein the report data generating run is preset in the Excel template file, includes but not limited to pivot operation, division operation, formula manipulation, macro operation and figure table handling etc.Wherein multiple report data generating run can be used to generate the report data of same dimension, also can be used to generate the report data of different dimensions.Wherein the dimension of report data is meant the foundation that generates report data, as based on the Sales Reports of stock, based on business personnel's Sales Reports etc.
In embodiments of the present invention, obtain master data from database server, and it is specific as follows to obtain the step of Excel template file from file server according to this report generation request:
From database server, obtain the needed master data of this form of generation according to the report generation request that receives, and from file server, obtain the needed Excel template file of this form of generation.As when this report generation request indication needs to generate Sales Reports, then according to this report generation request, from database server, obtain the master data that generates these Sales Reports, promptly sell detailed data, and from file server, obtain and generate the needed Excel template file of these Sales Reports, i.e. Sales Reports template.The gauge outfit of the prime data area of this Sales Reports template is each field of default sale detailed data.
In step S202, the webserver is filled to the prime data area of Excel template file by the Excel formation component with the master data of obtaining, and this Excel template file is sent to networking client.
Wherein the Excel formation component is meant the program module that is used for reading and writing by the mode of programming the Excel file.As Apache POI is a kind of Excel formation component, and the open source code letter formula storehouse that this Excel formation component is an Apache Software Foundation provides API to the function of Java formula to the read and write of Microsoft Office form archives.Because adopt pure Java to write,, can finish read-write operation to Microsoft Office file so need not the support of Window operating system and Microsoft Office assembly.Owing to by the Excel formation component process that the master data of obtaining writes the prime data area of Excel template file is belonged to prior art, therefore is summarized as follows herein:
The Excel formation component is filled to master data according to the gauge outfit of prime data area in the Excel template file prime data area of Excel template file.Comprise following field as the gauge outfit when the prime data area of the Excel template file that obtain: merchandising, business personnel, selling time etc., fill the master data of obtaining this moment according to the above-mentioned field that gauge outfit comprises.
In step S203, networking client is carried out report data generating run default in the Excel template file by the Excel spreadsheet to the master data of prime data area in the Excel template file, generate report data, and the report data that generates is presented at the report data zone of Excel template file, generate the Excel form.
Wherein the process of the master data of prime data area in the Excel template file being carried out report data generating run default in the Excel template file by the Excel spreadsheet belongs to prior art, does not repeat them here.Seeing also Fig. 4, is the synoptic diagram of the Excel form that obtains after the execution in step S203 that provides of the embodiment of the invention.
In embodiments of the present invention, by default or the self-defined Excel template file that comprises prime data area, report data zone and data generating run, and with the intermediate carrier of this Excel template file as the generation form, the report capability that makes full use of the Excel spreadsheet generates the Excel form, thereby simplified the step of form exploitation greatly, reduced the form cost of developing.
In another embodiment of the present invention, before step S201, this method also comprises the steps:
Networking client receives the report generation request of user's input, and this report generation request is sent to the webserver.After step S203, this method also comprises the steps:
Networking client is showed the Excel form of generation to the user.
In order to make the user can develop the form that meets self-demand voluntarily, satisfy user's different demands, in another embodiment of the present invention, this method also comprises the steps:
The webserver receives the self-defined template request that networking client sends, and generates new Excel file according to this self-defined template request, and should be sent to networking client by new Excel file.This new Excel file is the Excel file that includes only the prime data area gauge outfit.At this moment, networking client sends the self-defined template request to the webserver, and when the new Excel file that receives that the webserver returns, by the Excel spreadsheet new Excel file is carried out the report data generating run, create the report data district, generate self-defined Excel template file.Its concrete steps are as follows:
A, the webserver obtain alternative field from database server, and provide the alternative field of obtaining to networking client.
Wherein alternative field is meant the field that finally can export in self-defining Excel template file, generally from database server, obtain Structured Query Language (SQL) (the Structured Query Language of certain professional master data, SQL) pre-set, so the respective alternative field is also determined.
B, networking client receive the output field that the user selects from alternative field, and send the self-defined template request to the webserver.
Wherein alternative field is meant the field that finally can export in self-defining Excel template file, but in some cases, and do not require that all alternative fields all export in self-defining Excel template file, the user can select the field that need export in self-defining Excel template file from alternative field, i.e. the output field selected of user.
Networking client sends the self-defined template request to the webserver, and carry the output field that the user selects from alternative field receive the output field that the user selects from alternative field after.
C, the webserver are after receiving Excel file generation request, and the output field according to the user selects from alternative field dynamically generates new Excel file by the Excel formation component, and should return networking client by new Excel file.This new Excel file is the Excel file that comprises the prime data area gauge outfit.Wherein the field of the prime data area gauge outfit of new Excel file is the output field that the user selects from alternative field.
D, networking client carry out the report data generating run by the Excel spreadsheet to new Excel file, create the report data district, generate self-defined Excel template file.The report data generating run only is the operation that prime data area is carried out, and this moment is actual traffic data not, and when next time, request defined template herein, master data was filled these operations of back and will be performed to generate form.See also Fig. 5, the synoptic diagram of definition report data generating run in new Excel file that provides for the embodiment of the invention.Can directly use self-defined Excel template file after making the user, in another embodiment of the present invention, the self-defined Excel template file that networking client will generate is uploaded to the webserver.
Wherein the report data generating run is one or more combinations in pivot operation, division operation, formula manipulation, macro operation and the icon operation.And multiple report data generating run can be used to generate the report data of same dimension, also can be used to generate the report data of different dimensions.
E, the webserver receive the self-defined Excel template file that networking client is uploaded, and should be saved to file server by self-defined Excel template file.
In embodiments of the present invention, after self-defined Excel template file finishes, when next time, the user asked this form, to generate form according to report form generation method shown in Figure 3, at this moment, in step S20l, the Excel template file that the webserver obtains from file server according to the report generation request is self-defined Excel template file; In step S202, when the webserver is filled to the prime data area of Excel template file by the Excel formation component with the master data of obtaining, the output field of selecting from alternative field according to the user is filled the prime data area of self-defined Excel template file, so that the gauge outfit of prime data area is consistent in data of filling and the self-defined Excel template file.
Fig. 6 shows the structure of the report generation device that the embodiment of the invention provides, and for convenience of explanation, only shows the part relevant with the embodiment of the invention.This report generation device can be to be built in the unit that software unit, hardware cell or software and hardware in the online software service system combine, and perhaps is integrated in the application system of online software service system or this system as suspension member independently.Wherein:
Basic data storage unit storage master data.Wherein master data is meant and generates the needed raw data of form, as selling detailed data, buying detailed data etc.Wherein basic data storage unit is arranged in the database server.
File storage unit storage report form template file, this report form template file can be the report form template file of presetting, and also can be user-defined report form template file.This report form template file comprises prime data area and report data zone.Wherein prime data area is used to load master data, and it generally includes only gauge outfit, does not comprise concrete data content.The report data zone is used to show report data.This report data is the master data that prime data area loads to be carried out the report data generating run generate.Wherein the report data generating run is preset in the report form template file, includes but not limited to pivot operation, division operation, formula manipulation, macro operation and figure table handling etc.Wherein multiple report data generating run can be used to generate the report data of same dimension, also can be used to generate the report data of different dimensions.Wherein the dimension of report data is meant the foundation that generates report data, as based on the Sales Reports of stock, based on business personnel's Sales Reports etc.Wherein file storage unit is arranged at file server.
Wherein the report form template file can be the report form template file of Excel template file or extended formatting.
Network service element is when receiving the report generation request, according to obtaining master data in the basic data storage unit of this report generation request from be arranged at database server, and from the file storage unit that is arranged at file server, obtain the report form template file, by the report generation assembly master data of obtaining is filled to the prime data area of report form template file, and the customer service unit that this report form template file is sent to.Wherein network service element is arranged in the webserver.In embodiments of the present invention, when the report form template file is the Excel template file, network service element is when receiving the report generation request, according to obtaining master data in the basic data storage unit of this report generation request from be arranged at database server, and from the file storage unit that is arranged at file server, obtain the Excel template file, by the Excel formation component master data of obtaining is filled to the prime data area of Excel template file, and the customer service unit that this Excel template file is sent to.
The master data of prime data area is carried out report data generating run default in the report form template file in the report form template file that customer service unit returns network service element by spreadsheet, generate report data, and the report data that generates is presented at the report data zone of report form template file, generate the target form.Wherein customer service unit is arranged at networking client.In embodiments of the present invention, when form is the Excel form, then the master data of prime data area is carried out report data generating run default in the Excel template file in the Excel template file that network service element returned by the Excel spreadsheet of customer service unit, generate report data, and the report data that generates is presented at the report data zone of Excel template file, generate the Excel form.
In another embodiment of the present invention, this customer service unit also is used to receive the report generation request that the user sends, and this report generation request is sent to network service element.
In order to make the user can develop the form that meets self-demand voluntarily, satisfy user's different demands, in another embodiment of the present invention, customer service unit also is used for sending the self-defined template request to network service element, and when receiving the new report file that network service element returns, by spreadsheet receive and storage to the report data generating run of new report file, generate the self-defined report template file.At this moment, network service element receives the self-defined template request that customer service unit sends, and generates new report file according to this self-defined template request, and should be back to customer service unit by new report file.When the form of form is Excel, customer service unit sends the self-defined template request to network service element, and when the new Excel file that receives that network service element returns, by the Excel spreadsheet receive and storage to the report data generating run of new Excel file, generate self-defined Excel template file.At this moment, network service element receives the self-defined template request that customer service unit sends, and generates new Excel file according to this self-defined template request, and should be back to customer service unit by new Excel file.
After making the user, can directly adopt the self-defined report template file to generate form, in another embodiment of the present invention, customer service unit is uploaded to network service element with the self-defined report template file that generates, at this moment, network service element is saved to this self-defined report template file in the file storage unit, in order to using later on.When the form of form was Excel, the self-defined Excel template file that customer service unit will generate was uploaded to network service element, and at this moment, network service element should be saved in the file storage unit by self-defined Excel template file
In embodiments of the present invention, when basic data storage unit is arranged at database server, file storage unit is arranged at file server, network service element is arranged at the webserver, when customer service unit is arranged at networking client, the networking client and the webserver carry out two-way communication, and the webserver carries out two-way communication with file server, database server respectively.
Fig. 7 shows the concrete structure block diagram of the report generation device that the embodiment of the invention provides, and for convenience of explanation, only shows the part relevant with the embodiment of the invention.Wherein:
Master data acquisition module 31 obtains master data according to this report generation request from basic data storage unit 1 when receiving the report generation request.Its detailed process is as follows: obtain from basic data storage unit 1 according to the report generation request that receives and generate the needed master data of this form, as when this report generation request indication needs to generate Sales Reports, then according to this report generation request, from basic data storage unit 1, obtain the master data that generates these Sales Reports, promptly sell detailed data.
Report form template acquisition module 32 obtains the report form template file according to this report generation request from file storage unit 2 when receiving the report generation request.Wherein the report form template file can be the report form template file of Excel template file or extended formatting.Wherein report form template acquisition module 32 detailed process of obtaining the Excel template file from file storage unit 2 is as follows: obtain from file storage unit 2 according to the report generation request that receives and generate the needed Excel template file of this form.As when this report generation request indication needs to generate Sales Reports,, from file storage unit 2, obtain and generate the needed Excel template file of these Sales Reports, i.e. Sales Reports template then according to this report generation request.The gauge outfit of the prime data area of this Sales Reports template is each field of default sale detailed data.
The master data that master data filler cells module 33 is obtained master data acquisition module 31 by the report generation assembly is filled to the prime data area of the report form template file that report form template acquisition module 32 obtains, and this report form template file is back to customer service unit 4.Wherein adopt the report generation assembly that the detailed process that master data is filled to the prime data area of report form template file is belonged to prior art, do not repeat them here.Wherein the report generation assembly can be Excel formation component or extended formatting report generation assembly.
In another embodiment of the present invention, this customer service unit 4 also comprises report generation request sending module 42 and form display module 43.Wherein report generation request sending module 42 receives the report generation request that the user sends, and this report generation request is sent to network service element 3.Form display module 43 is showed the target form that report generation module 41 generates to the user.
In order to make the user can develop the form that meets self-demand voluntarily, satisfy user's different demands, in another embodiment of the present invention, this customer service unit 4 also comprises self-defined template request module 44 and self-defined template generation module 45.Wherein:
The alternative field that self-defined template request module 44 received and showed network service element 3 outputs, and receive the output field that the user selects from alternative field, send the self-defined template request to network service element 3.Wherein alternative field is meant the field that finally can export in self-defining report form template file, but in some cases, and do not require that all alternative fields all export in self-defining report form template file, the user can select the field that need export in self-defining report form template file from alternative field, i.e. the output field selected of user.Wherein self-defining report form template file can be the report form template file of Excel form, also can be the report form template file of extended formatting.
Self-defined template generation module 45 carries out the report data generating run by spreadsheet to new report file when receiving the new report file that network service element 3 returns, create the report data district, generates the self-defined report template file.Wherein the report data generating run is one or more combinations in pivot operation, division operation, formula manipulation, macro operation and the icon operation.And multiple report data generating run can be used to generate the report data of same dimension, also can be used to generate the report data of different dimensions.In embodiments of the present invention, when report form template file that self-defining report form template file is the Excel form, self-defined template generation module 45 is when the new Excel file that receives that network service element 3 returns, by the Excel spreadsheet new Excel file is carried out the report data generating run, create the report data district, generate self-defined Excel template file.
Can directly adopt self-defined Excel template file to generate form after making the user, in another embodiment of the present invention, this customer service unit 4 also comprises transmission module 46 on the self-defined template.Transmission module 46 is uploaded to network service element 3 with the self-defined report template file that self-defined template generation module 45 generates on this self-defined template.Wherein the self-defined report template file can be the report form template file of Excel template file or extended formatting.
This network service element 3 also comprises alternative field acquisition module 34 and new report file generation module 35.Wherein:
Alternative field acquisition module 34 obtains alternative field from basic data storage unit 1, and provides the alternative field of obtaining to customer service unit.Wherein alternative field is meant the field that finally can export in self-defining report form template file.Wherein self-defining report form template file can be the report form template file of self-defined Excel template file or extended formatting.
New report file generation module 35 receives the self-defined template request that customer service unit 4 sends, the output field of carrying according to this self-defined template request by the report generation assembly generates new report file, and should be back to customer service unit 4 by new report file.This new report file is the report file that comprises the prime data area gauge outfit.Wherein the field of the prime data area gauge outfit of new report file is the output field that the user selects from alternative field.This new report file can be the report file of new Excel file or new extended formatting.
Also comprise self-defined template preservation unit 36 in this network service element 3 of another embodiment of the present invention.This self-defined template is preserved the self-defined report template file of unit 36 being uploaded by customer service unit 4 and is saved to file storage unit 2.
In embodiments of the present invention, in the form exploitation, introduce the notion of report form template file (particularly Excel template file), and with its intermediate carrier as the generation form, make full use of the powerful report capability of spreadsheet (as the Excel spreadsheet) self, the developer only needs master data to be write report file and develop corresponding report form template file, make the form exploitation in the online software service system become simple unusually, quick, be specially adapted to the form of analyzing by different dimensions for the same base notebook data.Can realize the self-defined of form.Made full use of the use popularity and the simple ease for use of form, made report data generating runs such as domestic consumer only need simply have an X-rayed, formula, chart can finish the personalization of form.Cost is low, has saved report tool copyright royalty and report server expense.Dispose easily, need extra deployment hardly.Owing to can produce many forms usually from different dimensions, thereby reduced the number of times that the user asks the webserver, alleviated the burden of the webserver for identical master data.
The above only is preferred embodiment of the present invention, not in order to restriction the present invention, all any modifications of being done within the spirit and principles in the present invention, is equal to and replaces and improvement etc., all should be included within protection scope of the present invention.
Claims (15)
1, the report form generation method in a kind of online software service system is characterized in that described method comprises the steps:
A, the webserver are when receiving the report generation request, obtain master data according to described report generation request from database server, and obtaining the report form template file from file server, described report form template file comprises prime data area, report data zone and report data generating run;
B, the webserver are filled to the prime data area of described report form template file by the report generation assembly with described master data, and the report form template file that will fill master data is sent to networking client;
C, networking client carry out report data generating run in the report form template file by spreadsheet to the master data of prime data area in the report form template file, generate report data, and the report data that generates is presented at the report data zone of report form template file, generate the target form.
2, the method for claim 1 is characterized in that, in the time will generating the Excel form, described steps A, B, C replace with:
A, the webserver are when receiving the report generation request, obtain master data according to described report generation request from database server, and obtaining the Excel template file from file server, described Excel template file comprises prime data area, report data zone and report data generating run;
B, the webserver are filled to the prime data area of described Excel template file by the Excel formation component with described master data, and the Excel template file that will fill master data is sent to networking client;
C, networking client pass through the Excel spreadsheet to the report data generating run in the master data execution Excel template file of prime data area in the report form template file, generate report data, and the report data that generates is presented at the report data zone of Excel template file, generate the Excel form.
3, method as claimed in claim 1 or 2 is characterized in that, described report data generating run is one or more combinations in pivot operation, division operation, formula manipulation, macro operation and the figure table handling.
4, method as claimed in claim 3 is characterized in that, multiple report data generating run is used to generate the report data of same dimension, perhaps is used to generate the report data of different dimensions.
5, the method for claim 1 is characterized in that, before described steps A, described method also comprises the steps:
Networking client receives the report generation request of user's input, and described report generation request is sent to the webserver; After described step C, described method also comprises:
Networking client is showed the target form of generation to the user.
6, method as claimed in claim 2 is characterized in that, described method also comprises the steps:
D, the webserver receive the self-defined template request that networking client sends, and generate new report file according to described self-defined template request, and described new report file is sent to networking client; Networking client sends the self-defined template request to the webserver, and when receiving the new report file that the webserver returns, by spreadsheet new report file is carried out the report data generating run, create the report data district, generate the self-defined report template file.
7, method as claimed in claim 6 is characterized in that, described step D specifically comprises:
The webserver obtains alternative field from database server, and provides the alternative field of obtaining to networking client;
Networking client receives the output field that the user selects from alternative field, and sends the self-defined template request to the webserver;
The webserver according to the output field that the user selects, dynamically generate new report file by the report generation assembly, and the new report file that will generate returns networking client from alternative field after receiving the self-defined template request;
Networking client receives new report file, and new report file is carried out the report data generating run by spreadsheet, create the report data district, generate the self-defined report template file, and the self-defined report template file that generates is uploaded to the webserver;
The webserver receives the self-defined report template file that networking client is uploaded, and the self-defined report template file is saved to file server.
8, a kind of report generation device is characterized in that, described device comprises:
Basic data storage unit is used to store master data;
File storage unit is used to store the report form template file;
Network service element, be used for when receiving the report generation request, obtain master data according to described report generation request from described basic data storage unit, and obtain the report form template file from described file storage unit, the master data of obtaining is filled to the prime data area of report form template file by the report generation assembly;
Customer service unit, be used for by spreadsheet the report data generating run in the master data execution report form template file of report form template file prime data area, generate report data, and the report data that generates is presented at the report data zone of report form template file, generate the target form.
9, device as claimed in claim 8 is characterized in that,
Described file storage unit is used to store the Excel template file;
Described network service element is used for when receiving the report generation request, obtain master data according to described report generation request from described basic data storage unit, and obtain the Excel template file from described file storage unit, the master data of obtaining is filled to the prime data area of Excel template file by the Excel formation component;
Described customer service unit is used for by the Excel spreadsheet the report data generating run in the master data execution Excel template file of Excel template file prime data area, generate report data, and the report data that generates is presented at the report data zone of Excel template file, generate the Excel form.
10, device as claimed in claim 8, it is characterized in that, described basic data storage unit is arranged in the database server, described file storage unit is arranged in the file server, described network service element is arranged in the webserver, the described webserver carries out two-way communication with described database server, file server respectively, and described customer service unit is arranged at networking client, and the described networking client and the described webserver carry out two-way communication.
11, device as claimed in claim 8 is characterized in that, described customer service unit comprises:
The report generation request sending module is used to receive the report generation request of user's input, and this report generation request is sent to network service element;
The form display module is used for showing to the user target form of generation.
12, device as claimed in claim 8 is characterized in that, described customer service unit also comprises:
The self-defined template request module is used to receive and show the alternative field of described network service element output, and receives the output field that the user selects from alternative field, sends the self-defined template request to described network service element;
The self-defined template generation module is used for by spreadsheet new report file being carried out the report data generating run when receiving the new report file that described network service element returns, and creates the report data district, generates the self-defined report template file.
13, device as claimed in claim 11 is characterized in that, described network service element comprises:
Alternative field acquisition module is used for obtaining alternative field from described basic data storage unit, and provides the alternative field of obtaining to described customer service unit;
New report file generation module, be used to receive the self-defined template request that described customer service unit sends, the output field of carrying according to described self-defined template request by the report generation assembly generates new report file, and described new report file is back to described customer service unit.
14, device as claimed in claim 11 is characterized in that, described customer service unit also comprises:
Transmission module on the self-defined template is used for the self-defined report template file that described self-defined template generation module generates is uploaded to described network service element;
Described network service element also comprises:
Self-defined template is preserved the unit, and the self-defined report template file that is used for transmission module on the described self-defined template is uploaded is saved to described file storage unit.
15, a kind of online software service system is characterized in that, described system comprises the described report generation device of the arbitrary claim of claim 8-14.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2009101090856A CN101650710B (en) | 2009-08-03 | 2009-08-03 | Online software service system as well as method and device for generating report |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2009101090856A CN101650710B (en) | 2009-08-03 | 2009-08-03 | Online software service system as well as method and device for generating report |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN101650710A true CN101650710A (en) | 2010-02-17 |
| CN101650710B CN101650710B (en) | 2011-12-28 |
Family
ID=41672949
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2009101090856A Active CN101650710B (en) | 2009-08-03 | 2009-08-03 | Online software service system as well as method and device for generating report |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101650710B (en) |
Cited By (32)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102148833A (en) * | 2011-04-18 | 2011-08-10 | 中国工商银行股份有限公司 | Method for transmitting data report, server, client and system |
| CN102368778A (en) * | 2011-11-29 | 2012-03-07 | 北京中电普华信息技术有限公司 | Data processing method, user side and server |
| CN103020032A (en) * | 2012-12-28 | 2013-04-03 | 无锡城市云计算中心有限公司 | Report generation method in cloud computing system |
| CN103034658A (en) * | 2011-09-29 | 2013-04-10 | 福建睿能电子有限公司 | Method and system for querying data and exporting report |
| CN103268335A (en) * | 2013-05-13 | 2013-08-28 | 中国农业银行股份有限公司 | Report data filling method and system |
| CN103279863A (en) * | 2013-06-08 | 2013-09-04 | 北京创腾科技有限公司 | Automatic generation method and system of report file |
| CN103646016A (en) * | 2013-12-30 | 2014-03-19 | 金蝶软件（中国）有限公司 | Implementation method of user-defined financial statement and server |
| CN103914438A (en) * | 2012-12-30 | 2014-07-09 | 航天信息股份有限公司 | Template and tag implementation based excel display and export method and system |
| CN104063219A (en) * | 2014-06-25 | 2014-09-24 | 北京思特奇信息技术股份有限公司 | Form development method and system for WEB system |
| CN104252463A (en) * | 2013-06-26 | 2014-12-31 | 中国银联股份有限公司 | Db2 database management method based on web system |
| CN104360992A (en) * | 2014-12-02 | 2015-02-18 | 福建工程学院 | WEB report design system built based on EXCEL platform and implementation method |
| CN105354240A (en) * | 2015-10-14 | 2016-02-24 | 金蝶软件（中国）有限公司 | Report file processing method and apparatus |
| CN105447068A (en) * | 2014-11-18 | 2016-03-30 | 国网山东省电力公司 | SAP system based dynamic report generation method and system |
| CN105446949A (en) * | 2015-11-30 | 2016-03-30 | 用友优普信息技术有限公司 | Information display method and information display apparatus |
| CN105574129A (en) * | 2015-12-14 | 2016-05-11 | 浪潮软件股份有限公司 | Data managing method and system |
| CN105608065A (en) * | 2015-12-16 | 2016-05-25 | 北京奇虎科技有限公司 | Chart generation method and apparatus |
| CN105955730A (en) * | 2016-04-26 | 2016-09-21 | 浪潮电子信息产业股份有限公司 | Method for obtaining SSR (Server Security Reinforcement) centralized management platform statement |
| CN107277003A (en) * | 2017-06-12 | 2017-10-20 | 郑州云海信息技术有限公司 | A kind of account security management method and system |
| CN107657046A (en) * | 2017-09-30 | 2018-02-02 | 广东美的制冷设备有限公司 | The generation method and storage medium of air conditioner BI reporting systems, air conditioner BI forms |
| CN107844464A (en) * | 2017-11-08 | 2018-03-27 | 中国科学院、水利部成都山地灾害与环境研究所 | Filing system and method based on data insertion |
| CN107992343A (en) * | 2017-12-08 | 2018-05-04 | 珠海华索软件科技有限公司 | A kind of method and system of logging data |
| CN108335087A (en) * | 2018-03-09 | 2018-07-27 | 吴祥荣 | Value-added tax invoice for sales data statistical approach based on EXCEL and device |
| CN108351883A (en) * | 2015-10-24 | 2018-07-31 | 甲骨文国际公司 | The display of dynamic context hinge network analysis |
| CN108717430A (en) * | 2018-05-11 | 2018-10-30 | 重庆工商职业学院 | A kind of the webpage report form generation method and system of big data analysis |
| CN109558188A (en) * | 2017-09-27 | 2019-04-02 | 卡西欧计算机株式会社 | Display control method, control method and storage medium |
| CN109918067A (en) * | 2019-01-23 | 2019-06-21 | 中国平安人寿保险股份有限公司 | Report Customization method, apparatus, client and storage medium |
| CN110019136A (en) * | 2017-12-28 | 2019-07-16 | 中国移动通信集团内蒙古有限公司 | Report generating system and report form generation method |
| CN110162533A (en) * | 2019-05-23 | 2019-08-23 | 顶象科技有限公司 | Report update method and device |
| CN110347992A (en) * | 2019-07-10 | 2019-10-18 | 成都函夏科技有限公司 | Data analysing method and system based on electronic report forms |
| CN112668293A (en) * | 2021-01-04 | 2021-04-16 | 清华大学深圳国际研究生院 | Data report processing method |
| CN114036919A (en) * | 2021-11-23 | 2022-02-11 | 北京三维天地科技股份有限公司 | Electronic experiment record book management method and system |
| WO2024007906A1 (en) * | 2022-07-06 | 2024-01-11 | 北京字跳网络技术有限公司 | Data processing method and apparatus, electronic device, and storage medium |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106156075B (en) * | 2015-03-31 | 2019-08-02 | 中国科学院声学研究所 | A kind of method and device of report generation and displaying |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1189835C (en) * | 2002-02-10 | 2005-02-16 | 华为技术有限公司 | Method for realizing intelligent report forms |
| CN1504879A (en) * | 2002-12-02 | 2004-06-16 | 深圳市中兴通讯股份有限公司 | Method and system for realizing cross-platform and complex statistics calculation statement |
| CN101183371B (en) * | 2007-12-12 | 2010-06-09 | 中兴通讯股份有限公司 | Method for quickly finishing large data-handling and reporting system |
-
2009
- 2009-08-03 CN CN2009101090856A patent/CN101650710B/en active Active
Cited By (40)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102148833A (en) * | 2011-04-18 | 2011-08-10 | 中国工商银行股份有限公司 | Method for transmitting data report, server, client and system |
| CN103034658A (en) * | 2011-09-29 | 2013-04-10 | 福建睿能电子有限公司 | Method and system for querying data and exporting report |
| CN102368778A (en) * | 2011-11-29 | 2012-03-07 | 北京中电普华信息技术有限公司 | Data processing method, user side and server |
| CN103020032A (en) * | 2012-12-28 | 2013-04-03 | 无锡城市云计算中心有限公司 | Report generation method in cloud computing system |
| CN103914438A (en) * | 2012-12-30 | 2014-07-09 | 航天信息股份有限公司 | Template and tag implementation based excel display and export method and system |
| CN103268335A (en) * | 2013-05-13 | 2013-08-28 | 中国农业银行股份有限公司 | Report data filling method and system |
| CN103279863A (en) * | 2013-06-08 | 2013-09-04 | 北京创腾科技有限公司 | Automatic generation method and system of report file |
| CN104252463A (en) * | 2013-06-26 | 2014-12-31 | 中国银联股份有限公司 | Db2 database management method based on web system |
| CN104252463B (en) * | 2013-06-26 | 2018-09-04 | 中国银联股份有限公司 | A kind of db2 data base management methods based on web system |
| CN103646016B (en) * | 2013-12-30 | 2018-05-01 | 深圳市金蝶精斗云网络科技有限公司 | The customized implementation method of financial statement and server |
| CN103646016A (en) * | 2013-12-30 | 2014-03-19 | 金蝶软件（中国）有限公司 | Implementation method of user-defined financial statement and server |
| CN104063219A (en) * | 2014-06-25 | 2014-09-24 | 北京思特奇信息技术股份有限公司 | Form development method and system for WEB system |
| CN104063219B (en) * | 2014-06-25 | 2017-09-15 | 北京思特奇信息技术股份有限公司 | The form development approach and system of a kind of WEB systems |
| CN105447068A (en) * | 2014-11-18 | 2016-03-30 | 国网山东省电力公司 | SAP system based dynamic report generation method and system |
| CN104360992A (en) * | 2014-12-02 | 2015-02-18 | 福建工程学院 | WEB report design system built based on EXCEL platform and implementation method |
| CN105354240B (en) * | 2015-10-14 | 2019-09-06 | 金蝶软件（中国）有限公司 | Report file treating method and apparatus |
| CN105354240A (en) * | 2015-10-14 | 2016-02-24 | 金蝶软件（中国）有限公司 | Report file processing method and apparatus |
| CN108351883A (en) * | 2015-10-24 | 2018-07-31 | 甲骨文国际公司 | The display of dynamic context hinge network analysis |
| CN108351883B (en) * | 2015-10-24 | 2022-04-19 | 甲骨文国际公司 | Display of dynamic contextual pivot grid analysis |
| CN105446949A (en) * | 2015-11-30 | 2016-03-30 | 用友优普信息技术有限公司 | Information display method and information display apparatus |
| CN105574129A (en) * | 2015-12-14 | 2016-05-11 | 浪潮软件股份有限公司 | Data managing method and system |
| CN105608065A (en) * | 2015-12-16 | 2016-05-25 | 北京奇虎科技有限公司 | Chart generation method and apparatus |
| CN105955730A (en) * | 2016-04-26 | 2016-09-21 | 浪潮电子信息产业股份有限公司 | Method for obtaining SSR (Server Security Reinforcement) centralized management platform statement |
| CN107277003A (en) * | 2017-06-12 | 2017-10-20 | 郑州云海信息技术有限公司 | A kind of account security management method and system |
| CN109558188A (en) * | 2017-09-27 | 2019-04-02 | 卡西欧计算机株式会社 | Display control method, control method and storage medium |
| CN109558188B (en) * | 2017-09-27 | 2022-04-05 | 卡西欧计算机株式会社 | Display control method, and storage medium |
| CN107657046A (en) * | 2017-09-30 | 2018-02-02 | 广东美的制冷设备有限公司 | The generation method and storage medium of air conditioner BI reporting systems, air conditioner BI forms |
| CN107844464A (en) * | 2017-11-08 | 2018-03-27 | 中国科学院、水利部成都山地灾害与环境研究所 | Filing system and method based on data insertion |
| CN107992343A (en) * | 2017-12-08 | 2018-05-04 | 珠海华索软件科技有限公司 | A kind of method and system of logging data |
| CN110019136A (en) * | 2017-12-28 | 2019-07-16 | 中国移动通信集团内蒙古有限公司 | Report generating system and report form generation method |
| CN108335087A (en) * | 2018-03-09 | 2018-07-27 | 吴祥荣 | Value-added tax invoice for sales data statistical approach based on EXCEL and device |
| CN108717430A (en) * | 2018-05-11 | 2018-10-30 | 重庆工商职业学院 | A kind of the webpage report form generation method and system of big data analysis |
| CN109918067A (en) * | 2019-01-23 | 2019-06-21 | 中国平安人寿保险股份有限公司 | Report Customization method, apparatus, client and storage medium |
| CN110162533A (en) * | 2019-05-23 | 2019-08-23 | 顶象科技有限公司 | Report update method and device |
| CN110347992A (en) * | 2019-07-10 | 2019-10-18 | 成都函夏科技有限公司 | Data analysing method and system based on electronic report forms |
| CN112668293A (en) * | 2021-01-04 | 2021-04-16 | 清华大学深圳国际研究生院 | Data report processing method |
| CN112668293B (en) * | 2021-01-04 | 2023-09-19 | 清华大学深圳国际研究生院 | Data report processing method |
| CN114036919A (en) * | 2021-11-23 | 2022-02-11 | 北京三维天地科技股份有限公司 | Electronic experiment record book management method and system |
| CN114036919B (en) * | 2021-11-23 | 2022-05-24 | 北京三维天地科技股份有限公司 | Electronic experiment record book management method and system |
| WO2024007906A1 (en) * | 2022-07-06 | 2024-01-11 | 北京字跳网络技术有限公司 | Data processing method and apparatus, electronic device, and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN101650710B (en) | 2011-12-28 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101650710B (en) | Online software service system as well as method and device for generating report | |
| US8019860B2 (en) | Service accounting method and apparatus for composite service | |
| CN1728127B (en) | Method, system, and apparatus for providing access to workbook models through remote function calls | |
| US7680823B2 (en) | Custom report generation | |
| CN101976235B (en) | Extensible Word report automatically-generating method based on dynamic web page | |
| CN101821709B (en) | For the system of workflow generation, scheduling and/or execution, method and graphic user interface | |
| US8577904B2 (en) | Composite copy and paste for composite user interfaces | |
| CN100363892C (en) | Method and system for managing development objects for computer program code | |
| US20070061698A1 (en) | Designating, setting and discovering parameters for spreadsheet documents | |
| CN111125560B (en) | Data visualization processing method, device and computer system | |
| US20060229922A1 (en) | Association and visualization of schematized business networks | |
| CN101446971B (en) | Method for building content management system and device thereof | |
| JP4406565B2 (en) | Methods and software applications and systems for incorporating benchmarks into business software applications | |
| CN101266666A (en) | Document for commerce in trading partner network and interface definition based on same document | |
| US8291433B2 (en) | Unified, configurable services stack for integration of enterprise applications | |
| CN102637184A (en) | Method and system for customizing webpages | |
| US20120232934A1 (en) | Automated insurance policy form generation and completion | |
| CN102799690A (en) | Method for verifying page input by using database technology | |
| CN102917009B (en) | A kind of stock certificate data collection based on cloud computing technology and storage means and system | |
| CA2733857A1 (en) | Automated insurance policy form generation and completion | |
| CN102567797A (en) | Main formwork for generating document | |
| US20060070013A1 (en) | Method and system to drill down graphically | |
| US8214841B2 (en) | Calculating and communicating level of carbon offsetting required to compensate for performing a computing task | |
| US9298686B2 (en) | System and method for simulating discrete financial forecast calculations | |
| US6611817B1 (en) | Automated technique for code generation of datastream mappings |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant |