CN103268335A - Report data filling method and system - Google Patents
Report data filling method and system Download PDFInfo
- Publication number
- CN103268335A CN103268335A CN2013101739872A CN201310173987A CN103268335A CN 103268335 A CN103268335 A CN 103268335A CN 2013101739872 A CN2013101739872 A CN 2013101739872A CN 201310173987 A CN201310173987 A CN 201310173987A CN 103268335 A CN103268335 A CN 103268335A
- Authority
- CN
- China
- Prior art keywords
- report
- data
- file
- server end
- client
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to a report data filling method and system. The method comprises of the steps of downloading report data files and report parameter configuration files from a server-side through a client-side and generating local initial data; showing a report form editing interface through a control according to a report form template and the local initial data and providing editable cells; performing in-form calculation and verification of the report form editing interface according to the report parameter configuration files after a confirmation instruction is received; generating data files according to filled data after verification is passed and uploading the data files to the server-side; and verifying received data files through the server-side and memorizing the data files in a report data history base after the verification is passed. The in-form calculation and verification in the existing report data filling scheme is transferred to the client-side, transfer is finished through the control operating in the client-side, and finally-finished report forms are submitted to the server-side in one time to perform in-stockroom operation, so that local system resources of the client-side can be fully utilized, and processing pressure of the server-side can be dispersed.
Description
Technical field
The present invention relates to data processing field, relate in particular to a kind of report data and make a report on method and system.
Background technology
At present, the main mode that report data is made a report on processing has two kinds, and a kind of is online online making a report on, and namely the user fills in data and submits in the browser page list, does processing such as subsequent calculations verification then at server; Another kind is that off-line is made a report on, and the data template that be about to need typing downloads to subscriber's local with the form of EXCEL, and the user fills and uploads onto the server after the related data and carry out subsequent operation.
For the online online mode of making a report on, because on line operation causes big pressure to server under the bigger situation of user concurrent amount, the data of typing many times are more, and cause work to be wasted because mistake occurring when submitting to.
Make a report on mode for off-line, though can solve online making a report in the mode because submitting to failure can't keep the problem of filling in data before, but owing to when making a report on, can't carry out alternately with server, therefore after submission, can repeatedly revise repeatedly according to filling in mistake by factor.
The data adjustment of existing analytic type reporting system and the processing after the amended record handle mainly be by server end in the daytime in batches mode realize, be the user at the online adjustment report data of B/S client or after uploading the report data file that off-line fills in, submit to server end to carry out subsequent operation again, utilize the system resource of server end to carry out calculating between the Biao Neibiao of latest data and processing such as verification.But this mode centralized operation when the user visits the peak causes the server-side system processing pressure excessive, and data processing time is long, also exists simultaneously above-mentioned online or off-line to make a report on other defective of mode.
The system resource pressure that causes at a large amount of manual data far exceeds this situation of server load-bearing capacity, be badly in need of exploring a kind of new data processing mode at present, can take full advantage of data and make a report on the system resource of client terminal local, the tonnage of distributing server end, final raising system operation stability and report form processing efficient satisfy the timeliness requirement that form is made a report on.
Summary of the invention
The objective of the invention is to propose a kind of report data and make a report on method and system, can utilize data to make a report on the system resource of client terminal local, the tonnage of distributing server end.
For achieving the above object, the invention provides a kind of report data and make a report on method, comprising:
Client is downloaded report data file and report parameter configuration file from server end, and generates local primary data according to described report data file;
Described client is made a report on control by the report data that operates in described client, represents the form editing interface according to default report form template and described local primary data, so that the user to be provided editable cell;
Described client is shown interior calculating and verification according to described report parameter configuration file to described form editing interface after receiving the affirmation instruction of user to described form editing interface;
After verification was passed through, the data of making a report on that described client will receive generated data file, and are uploaded to described server end;
Described server end carries out verification to the data file that receives, and verification by after be saved in the report data history library.
Further, before described client is downloaded report data file and report parameter configuration file from server end, also comprise:
Described server end is determined corresponding calculation check formula according to user's processing request;
Described server end is determined corresponding data list according to described calculation check formula, and extracts corresponding report data from the report data history library;
Described server end generates described report data file with described report data, and after all data pick-ups finish, generates corresponding described report parameter configuration file.
Further, described server end is determined corresponding data list according to described calculation check formula, and is specially from the operation that the report data history library extracts corresponding report data:
Described server end is executable SQL statement with described calculation check Formula Parsing, determines corresponding data list according to described executable SQL statement;
The calling program that moves on the described server end is carried out described executable SQL statement, to extract corresponding report data from a plurality of dimensions described report data history library.
Further, described server end generates described report data file with described report data, and after all data pick-ups finished, the operation that generates corresponding described report parameter configuration file was specially:
Described server end generates text with described report data, and is stored under the temp directory of described server end;
Described server end is after all data pick-ups finish, generate the report parameter configuration file of corresponding extend markup language form, described report parameter configuration file comprises corresponding relation and the versions of data information of filename of total number of files, tables of data and the described text of described text.
Further, after described server end generates described report data file and described report parameter configuration file, also comprise the operation with described report data file and described report parameter configuration file compression packing; And when described client is downloaded report data file and report parameter configuration file from server end, decompress, and generate local primary data according to the described report data file after decompressing.
Further, described report form template is provided by described server end, and described server end is carrying out data when packing, and described report form template and described report data file and described report parameter configuration file are packed in the lump.
Further, in according to described report parameter configuration file described form editing interface being shown, calculate and the operation of verification before, and before described client is uploaded to described server end with the data file of generation, also comprise:
Whether the versions of data information that described client is compared described local primary data correspondence is consistent with the versions of data information of described server end, if inconsistent, then described Client-Prompt user resubmits operation application.
Further, described client is made a report on control by the report data that operates in described client, represents the form editing interface according to default report form template and described local primary data, specifically comprises with the operation that the editable cell of user is provided:
Described client is made a report on control by the report data that operates in described client and is imported described local primary data;
According to default report form template described local primary data is represented described form editing interface with class Excel editing interface, and the editable cell of user is carried out the differentiation of background colour;
In the data amended record process of described cell, described report data is made a report on control and in real time described cell is carried out formula verification and format check according to described report parameter configuration file.
Further, the described operation of described form editing interface being shown interior calculating and verification according to described report parameter configuration file is specially:
Described client is calculated and verification in according to described report parameter configuration file described form editing interface being shown, if verification failure, then will edit the position that cursor navigates to the error unit lattice, and wrong formula and control information will be provided, carry out data modification with assisting users.
Further, make a report on data when generating data file what described client will receive, also generate the configuration file of described data file correspondence, and the file that described data file and configuration file compression packing obtain is uploaded to described server end;
Described server end carries out verification to the data file that receives, and verification by after the operation that is saved in the report data history library be specially:
Described server end receives the file of described client upload in the mode of formation, and records the file of described client upload in formation;
When described server end takes out record from formation, and when navigating to the file of described client upload and tables of data to be updated according to described record, judge whether described tables of data to be updated allows to upgrade operation, if allow, then the file to described client upload decompresses, and according to described configuration file described data file is carried out verification to described, if verification is passed through, then described data file is saved in the described report data history library, described tables of data to be updated is upgraded; If verification is not passed through, then point out described client to resend described data file and configuration file.
Further, if described tables of data to be updated is in the state of locking, then a back record is handled in the taking-up formation earlier of described server end.
For achieving the above object, the invention provides a kind of report data and make a report on system, comprising: the client and server end, described client operation has report data to make a report on control, and described server end comprises the report data history library;
Described client, be used for downloading report data file and report parameter configuration file from described server end, and generate local primary data according to described report data file, make a report on control by described report data again, represent the form editing interface according to default report form template and described local primary data, so that the user to be provided editable cell; After receiving the affirmation instruction of user to described form editing interface, according to described report parameter configuration file described form editing interface is shown interior calculating and verification, and after verification is passed through, the data of making a report on that receive are generated data file, and be uploaded to described server end;
Described server end is used for the data file that receives is carried out verification, and verification by after be saved in the described report data history library.
Further, described client specifically comprises:
The file download module is used for downloading report data file and report parameter configuration file from described server end;
The local data generation module is used for generating local primary data according to described report data file;
Editing interface represents module, is used for making a report on control by described report data, represents the form editing interface according to default report form template and described local primary data, so that the user to be provided editable cell;
The calculation check module is used for after receiving the affirmation instruction of user to described form editing interface, calculates and verification in according to described report parameter configuration file described form editing interface being shown;
Data file generation module is used for after verification is passed through, and the data of making a report on that receive are generated data file;
Transmission module on the file is used for the data file that described data file generation module generates is uploaded to described server end.
Further, described server end specifically comprises:
The formula determination module is used for determining corresponding calculation check formula according to user's processing request;
The report data abstraction module is used for determining corresponding data list according to described calculation check formula, and extracts corresponding report data from described report data history library;
The report data file generating module is used for described report data is generated described report data file;
The parameter configuration files generation module is used for generating corresponding described report parameter configuration file after described report data abstraction module finishes all data pick-ups.
Further, described client also comprises:
The version comparison module, be used for before transmission module on the described calculation check module of triggering and the file, whether the versions of data information of comparing described local primary data correspondence is consistent with the versions of data information of described server end, if inconsistent, then points out the user to resubmit operation application.
Based on technique scheme, the present invention will have report data now and make a report on and calculate in the table in the scheme and verification is transferred to client, finished by the control that moves on the client, the form of finally finishing the then disposable server end of submitting to carries out in-stockroom operation, so just can utilize the system resource of client terminal local fully, the tonnage of distributing server end.
Description of drawings
Accompanying drawing described herein is used to provide further understanding of the present invention, constitutes the application's a part, and illustrative examples of the present invention and explanation thereof are used for explaining the present invention, do not constitute improper restriction of the present invention.In the accompanying drawings:
Fig. 1 makes a report on the schematic flow sheet of an embodiment of method for report data of the present invention.
Fig. 2 makes a report on the schematic flow sheet of another embodiment of method for report data of the present invention.
Fig. 3 makes a report on the schematic flow sheet of the another embodiment of method for report data of the present invention.
Fig. 4 makes a report on the structural representation of an embodiment of system for report data of the present invention.
Embodiment
Below by drawings and Examples, technical scheme of the present invention is described in further detail.
For analytical reporting system, the part form needs the service-user manual intervention to generate, and this mainly refers to operations such as the amended record of report data and modification.The data of these amended records and modification may be can't directly obtain automatically from professional system for conducting business or management information system in the present reporting system, need manually carry out the data of amended record, also may be the data that need manually adjust because of the account injustice that system's reason causes.Accordingly, each issue form all has a large amount of manual demands, also just produced a large amount of manual data, and this has exceeded the ability that server can bear at present to the pressure that system resource causes.Therefore the present invention proposes a kind of report data and makes a report on method, solves this problem.
As shown in Figure 1, make a report on the schematic flow sheet of an embodiment of method for report data of the present invention.In the present embodiment, the report data method of making a report on comprises:
In the present embodiment, client can be downloaded the data that its selected form is associated from server end according to demand, and generates local primary data in this locality, so just can carry out the follow-up operation of making a report under the state of off-line.
Need to move report data in the client and make a report on control, this control can adopt the ActiveX control based on the C#.NET exploitation, so that the good combination of browser, and can realize that the user is to visit and the data processing function of local data.Specifically, client can be downloaded ActiveX control by the web page from server end earlier, the driver of access local database is installed by ActiveX control, and encapsulating the interactive interface of a series of database manipulations, the database interactive interface by calling ActiveX control and the method for trigger event realize local operation.
In client after this locality generates primary data, report data is made a report on the displaying that control can be realized the form editing interface according to default report form template and local primary data, make the user can browse to whole form editing interface, understanding needs amended record or revises which cell.The report form template here can be obtained from server end when downloading report data file and report parameter configuration file by client, also can obtain from server end before downloading report data file and report parameter configuration file, and be kept in this locality.
In step 102, client is made a report on control by report data and is imported local primary data, and according to default report form template described local primary data is represented the form editing interface with class Excel editing interface, and the editable cell of user carried out the differentiation of background colour, and in the data amended record process of described cell, described report data is made a report on control and in real time described cell is carried out formula verification and format check according to described report parameter configuration file.
Behind the editor of user's affirmation to the form editing interface, report data is made a report on control just can read the calculation check formula from the report parameter configuration file, and calculate and verification in according to the calculation check formula data in the form editing interface being shown, if verification failure, then will edit the position that cursor navigates to the error unit lattice, and wrong formula and control information are provided, carry out data modification with assisting users.Make a report on control by the report data of client in this course and finish, need not to carry out alternately with server end.
After verification was passed through, client can generate data file with the data of making a report on that receive, and be uploaded to server end again, and server end needs to carry out verification before preserving these data files, have only verification by just preserving.
It is bigger in the quantity that synchronization carries out upload operation that the front has been mentioned analytical reporting system, so server end can utilize the mode of formation to control the concurrency of in-stockroom operation in step 105.Server end receives the file of client upload in the mode of formation, and records the file of client upload in formation.When server end takes out record from formation, and when navigating to the file of described client upload and tables of data to be updated according to record, judge whether tables of data to be updated allows to upgrade operation, if allow, then the file to described client upload decompresses, and according to described configuration file described data file is carried out verification to described, if verification is passed through, then described data file is saved in the described report data history library, described tables of data to be updated is upgraded; If verification is not passed through, then point out described client to resend described data file and configuration file.
If the current state that is in locking of tables of data to be updated can not upgrade operation, then can be handled by a back record in the server end taking-up formation earlier.After the pending data warehouse-in was finished, server end can transmit into the prompting message of Kucheng's merit to client.In order to reduce user's operation to the pressure of server, after tables of data is finished in-stockroom operation, also can carry out manual examination and verification to making a report on data by the related personnel, just only under the situation that audit is not passed through, allow to carry out the outbound operation.
As shown in Figure 2, make a report on the schematic flow sheet of another embodiment of method for report data of the present invention.Compare with a last embodiment, the present invention also comprised before step 101:
Step 100a, server end are determined corresponding calculation check formula according to user's processing request;
Before step 100a, form in the server end can be opened the time range of the Report Operations that needs manual intervention by the higher level, generally can take the mode of unlatching in batches, finish the form initial operation simultaneously in the unlatching time limit, the preliminary work of report data before this mainly refers to handle by hand.And in set-up procedure, server end can receive the processing request that the user sends earlier, and then corresponding calculation check formula is determined in the processing request according to the user in step 100a.
The calculation check formula here includes but not limited to two kinds of four fundamental rules mathematical operation and comparison operations, and the calculation check formula also needs to carry out Formula Parsing, to form executable SQL statement, comes to carry out for calling program.This Formula Parsing process is mainly by three parts such as lexical analyzer, syntax analyzer and semantic analyzers, the Formula Parsing of input is become executable SQL statement and returns to calling program, carry out formula for routine call, by the time the execution result of formula.Accordingly, can increase the interface of resolving the associated data table at server end, by this interface, the SQL statement that can obtain all tables of data relevant with this formula and obtain the data of this tables of data, by these statements, can derive related data and use for the client calculation check.
In step 100b, server end can be executable SQL statement with the calculation check Formula Parsing, and determines corresponding data list according to executable SQL statement; And the calling program that moves on the server end is carried out executable SQL statement, to extract corresponding report data from a plurality of dimensions the report data history library.A plurality of dimensions here include but not limited to dimensions such as form code name, mechanism, date and Currency Type.
In step 100c, server end can generate text (being the TXT file) with the report data of these extractions, and be stored under the temp directory of server end, treat that server end is after all data pick-ups finish, generate corresponding extend markup language (Extensible Markup Language, be called for short XML) the report parameter configuration file of form, the report parameter configuration file can comprise corresponding relation and the versions of data information of filename of total number of files, tables of data and the text of text.
As shown in Figure 3, make a report on the schematic flow sheet of the another embodiment of method for report data of the present invention.Compare with a last embodiment, present embodiment also comprises after step 100c:
Step 100d, server end are with described report data file and described report parameter configuration file compression packing;
Step 101 is specially step 101 ', namely client is downloaded report data file and report parameter configuration file from server end, and the compressed package that forms is decompressed, and generates local primary data according to the report data file after decompressing.
Report form template can be provided by server end, and server end is carrying out data when packing, report form template and report data file and report parameter configuration file can be packed in the lump, is extracted when the decompression by client again.Not only be convenient to transmission, also can reduce the bandwidth that takies.
Server end is by the compression packing, files such as report data file and report parameter configuration file can be sent to client in the lump, same, when the user end to server end sends data file, equally make a report on data when generating data file what will receive, also generate the configuration file of described data file correspondence, and the file that data file and configuration file compression packing is obtained is uploaded to server end.
Because the data in the server end database may be former thereby change because other users' operation or system handle automatically, the report data downloaded of client is just inconsistent with the report data of server end like this, for fear of the inconsistent problem of bringing of data, can in the database of server end, safeguard a form version table, be formed by date, mechanism, three dimensions of form and versions of data information (for example version number).
Client can get access to versions of data information from server end when downloading data, and in according to described report parameter configuration file described form editing interface being shown, calculate and the operation of verification before, whether the versions of data information that client can be compared local primary data correspondence is consistent with the versions of data information of server end, if it is inconsistent, then the Client-Prompt user resubmits operation application, in order to download the report data of latest edition from server end.Before client is uploaded to described server end with the data file that generates, whether also can compare the versions of data information of local primary data correspondence by client consistent with the versions of data information of server end, if inconsistent, then the Client-Prompt user resubmits operation application.
Formula Parsing at the Formula Parsing process of client and server end is similar, but has also increased the comparison interface of versions of data information, protects all formula to move on up-to-date data basis by relatively guaranteeing client.
One of ordinary skill in the art will appreciate that: all or part of step that realizes said method embodiment can be finished by the relevant hardware of programmed instruction, aforesaid program can be stored in the computer read/write memory medium, this program is carried out the step that comprises said method embodiment when carrying out; And aforesaid storage medium comprises: various media that can be program code stored such as ROM, RAM, magnetic disc or CD.
As shown in Figure 4, make a report on the structural representation of an embodiment of system for report data of the present invention.In the present embodiment, the report data system of making a report on comprises: client 1 and server end 2, and client 1 operation has report data to make a report on control 3, and server end 2 comprises report data history library 4.
After client 1 receives the affirmation instruction of user to described form editing interface, according to described report parameter configuration file described form editing interface is shown interior calculating and verification, and after verification is passed through, the data of making a report on that receive are generated data file, and be uploaded to described server end 2.
In another embodiment, client can specifically comprise:
The file download module is used for downloading report data file and report parameter configuration file from described server end;
The local data generation module is used for generating local primary data according to described report data file;
Editing interface represents module, is used for making a report on control by described report data, represents the form editing interface according to default report form template and described local primary data, so that the user to be provided editable cell;
The calculation check module is used for after receiving the affirmation instruction of user to described form editing interface, calculates and verification in according to described report parameter configuration file described form editing interface being shown;
Data file generation module is used for after verification is passed through, and the data of making a report on that receive are generated data file;
Transmission module on the file is used for the data file that described data file generation module generates is uploaded to described server end.
In another embodiment, server end can specifically comprise:
The formula determination module is used for determining corresponding calculation check formula according to user's processing request;
The report data abstraction module is used for determining corresponding data list according to described calculation check formula, and extracts corresponding report data from described report data history library;
The report data file generating module is used for described report data is generated described report data file;
The parameter configuration files generation module is used for generating corresponding described report parameter configuration file after described report data abstraction module finishes all data pick-ups.
The report data abstraction module can be executable SQL statement with described calculation check Formula Parsing, determine corresponding data list according to described executable SQL statement, carry out described executable SQL statement by the calling program that moves on the server end again, described report data history library, to extract corresponding report data from a plurality of dimensions.
The report data file generating module can generate text with described report data, and be stored under the temp directory of described server end, and the parameter configuration files generation module is after all data pick-ups finish, generate the report parameter configuration file of corresponding extend markup language form, described report parameter configuration file comprises corresponding relation and the versions of data information of filename of total number of files, tables of data and the described text of described text.
Server end and client all can arrange tool of compression, server end can compress packing with described report data file and described report parameter configuration file by tool of compression, and client is when downloading report data file and report parameter configuration file from server end, can decompress to compressed package by tool of compression, and generate local primary data according to the described report data file after decompressing.Report form template is provided by described server end, and server end is carrying out data when packing, also described report form template and described report data file and described report parameter configuration file can be packed in the lump.
Client can also increase the version comparison module, be used for before transmission module on the described calculation check module of triggering and the file, whether the versions of data information of comparing described local primary data correspondence is consistent with the versions of data information of described server end, if inconsistent, then point out the user to resubmit operation application.
In another embodiment, editing interface represents module and can make a report on control by the report data that operates in described client and import described local primary data, according to default report form template described local primary data is represented described form editing interface with class Excel editing interface again, and the editable cell of user is carried out the differentiation of background colour.In the data amended record process of cell, report data is made a report on control and in real time described cell is carried out formula verification and format check according to described report parameter configuration file, if verification failure, then editor's cursor can be navigated to the position of error unit lattice, and wrong formula and control information are provided, carry out data modification with assisting users.
In another embodiment, client will receive makes a report on data when generating data file, also generate the configuration file of described data file correspondence, and the file that described data file and configuration file compression packing is obtained is uploaded to server end, and server end can receive the file of described client upload in the mode of formation, and in formation the record described client upload file, when described server end takes out record from formation, and when navigating to the file of described client upload and tables of data to be updated according to described record, judge whether described tables of data to be updated allows to upgrade operation, if allow, then the file to described client upload decompresses, and according to described configuration file described data file is carried out verification to described, if verification is passed through, then described data file is saved in the described report data history library, described tables of data to be updated is upgraded; If verification is not passed through, then point out described client to resend described data file and configuration file.If described tables of data to be updated is in the state of locking, then described server end can take out in the formation a back record earlier and handles.
Each embodiment all adopts the mode of going forward one by one to describe in this instructions, and what each embodiment stressed is and the difference of other embodiment that same or analogous part cross-references gets final product between each embodiment.For system embodiment, because it is similar substantially to method embodiment, so description is fairly simple, relevant part gets final product referring to the part explanation of method embodiment.
Should be noted that at last: above embodiment is only in order to illustrate that technical scheme of the present invention is not intended to limit; Although with reference to preferred embodiment the present invention is had been described in detail, those of ordinary skill in the field are to be understood that: still can make amendment or the part technical characterictic is equal to replacement the specific embodiment of the present invention; And not breaking away from the spirit of technical solution of the present invention, it all should be encompassed in the middle of the technical scheme scope that the present invention asks for protection.
Claims (15)
1. a report data is made a report on method, comprising:
Client is downloaded report data file and report parameter configuration file from server end, and generates local primary data according to described report data file;
Described client is made a report on control by the report data that operates in described client, represents the form editing interface according to default report form template and described local primary data, so that the user to be provided editable cell;
Described client is shown interior calculating and verification according to described report parameter configuration file to described form editing interface after receiving the affirmation instruction of user to described form editing interface;
After verification was passed through, the data of making a report on that described client will receive generated data file, and are uploaded to described server end;
Described server end carries out verification to the data file that receives, and verification by after be saved in the report data history library.
2. report data according to claim 1 is made a report on method, wherein before described client is downloaded report data file and report parameter configuration file from server end, also comprises:
Described server end is determined corresponding calculation check formula according to user's processing request;
Described server end is determined corresponding data list according to described calculation check formula, and extracts corresponding report data from the report data history library;
Described server end generates described report data file with described report data, and after all data pick-ups finish, generates corresponding described report parameter configuration file.
3. report data according to claim 2 is made a report on method, and wherein said server end is determined corresponding data list according to described calculation check formula, and is specially from the operation that the report data history library extracts corresponding report data:
Described server end is executable SQL statement with described calculation check Formula Parsing, determines corresponding data list according to described executable SQL statement;
The calling program that moves on the described server end is carried out described executable SQL statement, to extract corresponding report data from a plurality of dimensions described report data history library.
4. report data according to claim 3 is made a report on method, and wherein said server end generates described report data file with described report data, and after all data pick-ups finished, the operation that generates corresponding described report parameter configuration file was specially:
Described server end generates text with described report data, and is stored under the temp directory of described server end;
Described server end is after all data pick-ups finish, generate the report parameter configuration file of corresponding extend markup language form, described report parameter configuration file comprises corresponding relation and the versions of data information of filename of total number of files, tables of data and the described text of described text.
5. report data according to claim 2 is made a report on method, wherein after described server end generates described report data file and described report parameter configuration file, also comprise the operation with described report data file and described report parameter configuration file compression packing; And when described client is downloaded report data file and report parameter configuration file from server end, decompress, and generate local primary data according to the described report data file after decompressing.
6. report data according to claim 5 is made a report on method, wherein said report form template is provided by described server end, described server end is carrying out data when packing, and described report form template and described report data file and described report parameter configuration file are packed in the lump.
7. report data according to claim 1 is made a report on method, wherein in according to described report parameter configuration file described form editing interface being shown, calculate and the operation of verification before, and before described client is uploaded to described server end with the data file that generates, also comprise:
Whether the versions of data information that described client is compared described local primary data correspondence is consistent with the versions of data information of described server end, if inconsistent, then described Client-Prompt user resubmits operation application.
8. report data according to claim 1 is made a report on method, wherein said client is made a report on control by the report data that operates in described client, represent the form editing interface according to default report form template and described local primary data, specifically comprise with the operation that the editable cell of user is provided:
Described client is made a report on control by the report data that operates in described client and is imported described local primary data;
According to default report form template described local primary data is represented described form editing interface with class Excel editing interface, and the editable cell of user is carried out the differentiation of background colour;
In the data amended record process of described cell, described report data is made a report on control and in real time described cell is carried out formula verification and format check according to described report parameter configuration file.
9. report data according to claim 8 is made a report on method, and the wherein said operation of described form editing interface being shown interior calculating and verification according to described report parameter configuration file is specially:
Described client is calculated and verification in according to described report parameter configuration file described form editing interface being shown, if verification failure, then will edit the position that cursor navigates to the error unit lattice, and wrong formula and control information will be provided, carry out data modification with assisting users.
10. report data according to claim 1 is made a report on method, wherein make a report on data when generating data file what described client will receive, also generate the configuration file of described data file correspondence, and the file that described data file and configuration file compression packing is obtained is uploaded to described server end;
Described server end carries out verification to the data file that receives, and verification by after the operation that is saved in the report data history library be specially:
Described server end receives the file of described client upload in the mode of formation, and records the file of described client upload in formation;
When described server end takes out record from formation, and when navigating to the file of described client upload and tables of data to be updated according to described record, judge whether described tables of data to be updated allows to upgrade operation, if allow, then the file to described client upload decompresses, and according to described configuration file described data file is carried out verification to described, if verification is passed through, then described data file is saved in the described report data history library, described tables of data to be updated is upgraded; If verification is not passed through, then point out described client to resend described data file and configuration file.
11. report data according to claim 10 is made a report on method, if wherein described tables of data to be updated is in the state of locking, then described server end takes out in the formation a back record earlier and handles.
12. a report data is made a report on system, comprising: the client and server end, described client operation has report data to make a report on control, and described server end comprises the report data history library;
Described client, be used for downloading report data file and report parameter configuration file from described server end, and generate local primary data according to described report data file, make a report on control by described report data again, represent the form editing interface according to default report form template and described local primary data, so that the user to be provided editable cell; After receiving the affirmation instruction of user to described form editing interface, according to described report parameter configuration file described form editing interface is shown interior calculating and verification, and after verification is passed through, the data of making a report on that receive are generated data file, and be uploaded to described server end;
Described server end is used for the data file that receives is carried out verification, and verification by after be saved in the described report data history library.
13. report data according to claim 12 is made a report on system, wherein said client specifically comprises:
The file download module is used for downloading report data file and report parameter configuration file from described server end;
The local data generation module is used for generating local primary data according to described report data file;
Editing interface represents module, is used for making a report on control by described report data, represents the form editing interface according to default report form template and described local primary data, so that the user to be provided editable cell;
The calculation check module is used for after receiving the affirmation instruction of user to described form editing interface, calculates and verification in according to described report parameter configuration file described form editing interface being shown;
Data file generation module is used for after verification is passed through, and the data of making a report on that receive are generated data file;
Transmission module on the file is used for the data file that described data file generation module generates is uploaded to described server end.
14. report data according to claim 13 is made a report on system, wherein said server end specifically comprises:
The formula determination module is used for determining corresponding calculation check formula according to user's processing request;
The report data abstraction module is used for determining corresponding data list according to described calculation check formula, and extracts corresponding report data from described report data history library;
The report data file generating module is used for described report data is generated described report data file;
The parameter configuration files generation module is used for generating corresponding described report parameter configuration file after described report data abstraction module finishes all data pick-ups.
15. report data according to claim 13 is made a report on system, wherein said client also comprises:
The version comparison module, be used for before transmission module on the described calculation check module of triggering and the file, whether the versions of data information of comparing described local primary data correspondence is consistent with the versions of data information of described server end, if inconsistent, then points out the user to resubmit operation application.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2013101739872A CN103268335A (en) | 2013-05-13 | 2013-05-13 | Report data filling method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2013101739872A CN103268335A (en) | 2013-05-13 | 2013-05-13 | Report data filling method and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103268335A true CN103268335A (en) | 2013-08-28 |
Family
ID=49011964
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2013101739872A Pending CN103268335A (en) | 2013-05-13 | 2013-05-13 | Report data filling method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103268335A (en) |
Cited By (26)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103578032A (en) * | 2013-11-14 | 2014-02-12 | 中国银行股份有限公司 | Data processing system |
| CN104090767A (en) * | 2014-07-18 | 2014-10-08 | 上海斐讯数据通信技术有限公司 | Parameterized user interface development tool and method |
| CN104317600A (en) * | 2014-10-31 | 2015-01-28 | 北京思特奇信息技术股份有限公司 | Configurable graph generation method and system |
| CN104317957A (en) * | 2014-11-11 | 2015-01-28 | 中国建设银行股份有限公司 | Open platform and system for processing reports and report processing method |
| CN104331854A (en) * | 2014-11-21 | 2015-02-04 | 浙江和仁科技股份有限公司 | Implementation technique for form editor of nursing record documents |
| CN104731859A (en) * | 2015-02-02 | 2015-06-24 | 厦门市美亚柏科信息股份有限公司 | Data processing method and device |
| CN105868171A (en) * | 2015-01-21 | 2016-08-17 | 中国移动（深圳）有限公司 | Checking method and device of Excel file |
| CN106484668A (en) * | 2016-10-09 | 2017-03-08 | 山东南山纺织服饰有限公司 | A kind of clothing typesetting divides bed process and device |
| CN106535152A (en) * | 2015-09-14 | 2017-03-22 | 腾讯科技（深圳）有限公司 | Terminal-based application data processing method, device and system |
| CN106776991A (en) * | 2016-12-06 | 2017-05-31 | 济南浪潮高新科技投资发展有限公司 | A kind of method that engineering data based on internet is made a report on |
| CN106874251A (en) * | 2017-03-10 | 2017-06-20 | 中国电建集团成都勘测设计研究院有限公司 | A kind of measuring method of rock mass RBI and RQD indexs |
| 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 |
| CN107426588A (en) * | 2017-07-12 | 2017-12-01 | 深圳创维－Rgb电子有限公司 | One kind obtains configuration information of television method, system and storage device |
| CN107632971A (en) * | 2016-07-19 | 2018-01-26 | 百度在线网络技术（北京）有限公司 | Method and apparatus for generating multidimensional form |
| CN107862049A (en) * | 2017-11-08 | 2018-03-30 | 中国银行股份有限公司 | A kind of data amended record method and device |
| CN107885710A (en) * | 2017-11-10 | 2018-04-06 | 中国银行股份有限公司 | A kind of generation method and device of bank's parameter report |
| CN107967247A (en) * | 2016-10-19 | 2018-04-27 | 航天信息股份有限公司 | For generating the method, report computational methods and its device of report form formula |
| CN108039193A (en) * | 2017-11-17 | 2018-05-15 | 哈尔滨工大服务机器人有限公司 | A kind of method and device for automatically generating physical examination report |
| CN108205746A (en) * | 2016-12-19 | 2018-06-26 | 通号通信信息集团上海有限公司 | A kind of railway electrical mobile information system and its application process |
| CN109388647A (en) * | 2018-10-30 | 2019-02-26 | 成都四方伟业软件股份有限公司 | A kind of data based on WEB make a report on method and system |
| CN109683953A (en) * | 2018-12-26 | 2019-04-26 | 苏州思必驰信息科技有限公司 | A kind of method and device carrying out configuration file processing based on visualization interface |
| CN110321538A (en) * | 2019-06-20 | 2019-10-11 | 北京小笨鸟信息技术有限公司 | A kind of intelligent offline data makes a report on system |
| CN111666745A (en) * | 2020-06-03 | 2020-09-15 | 中国建设银行股份有限公司 | File downloading method, device, server and medium |
| CN112463885A (en) * | 2020-11-26 | 2021-03-09 | 北京宏景世纪软件股份有限公司 | Data synchronization implementation method and centralized data system |
| CN113239121A (en) * | 2021-06-07 | 2021-08-10 | 中国农业银行股份有限公司 | Data synchronization method and device |
| CN113761042A (en) * | 2021-08-04 | 2021-12-07 | 一汽奔腾轿车有限公司 | New vehicle announcement parameter consistency checking system and checking method |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20020103827A1 (en) * | 2001-01-26 | 2002-08-01 | Robert Sesek | System and method for filling out forms |
| CN101650710A (en) * | 2009-08-03 | 2010-02-17 | 金蝶软件（中国）有限公司 | Online software service system as well as method and device for generating report |
| CN102148833A (en) * | 2011-04-18 | 2011-08-10 | 中国工商银行股份有限公司 | Method for transmitting data report, server, client and system |
| CN102426549A (en) * | 2011-09-08 | 2012-04-25 | 新一站保险代理有限公司 | Efficient Web form validation method and framework thereof |
-
2013
- 2013-05-13 CN CN2013101739872A patent/CN103268335A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20020103827A1 (en) * | 2001-01-26 | 2002-08-01 | Robert Sesek | System and method for filling out forms |
| CN101650710A (en) * | 2009-08-03 | 2010-02-17 | 金蝶软件（中国）有限公司 | Online software service system as well as method and device for generating report |
| CN102148833A (en) * | 2011-04-18 | 2011-08-10 | 中国工商银行股份有限公司 | Method for transmitting data report, server, client and system |
| CN102426549A (en) * | 2011-09-08 | 2012-04-25 | 新一站保险代理有限公司 | Efficient Web form validation method and framework thereof |
Non-Patent Citations (1)
| Title |
|---|
| 杜军胜: "陕西地税在线申报系统的设计与实现", 《中国优秀硕士学位论文全文数据库 信息科技辑》 * |
Cited By (36)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103578032A (en) * | 2013-11-14 | 2014-02-12 | 中国银行股份有限公司 | Data processing system |
| CN104090767A (en) * | 2014-07-18 | 2014-10-08 | 上海斐讯数据通信技术有限公司 | Parameterized user interface development tool and method |
| CN104317600A (en) * | 2014-10-31 | 2015-01-28 | 北京思特奇信息技术股份有限公司 | Configurable graph generation method and system |
| CN104317600B (en) * | 2014-10-31 | 2018-02-13 | 北京思特奇信息技术股份有限公司 | A kind of configurable curve drawing generating method and system |
| CN104317957A (en) * | 2014-11-11 | 2015-01-28 | 中国建设银行股份有限公司 | Open platform and system for processing reports and report processing method |
| CN104317957B (en) * | 2014-11-11 | 2017-10-24 | 中国建设银行股份有限公司 | A kind of open platform of report form processing, system and report processing method |
| CN104331854A (en) * | 2014-11-21 | 2015-02-04 | 浙江和仁科技股份有限公司 | Implementation technique for form editor of nursing record documents |
| CN105868171A (en) * | 2015-01-21 | 2016-08-17 | 中国移动（深圳）有限公司 | Checking method and device of Excel file |
| CN104731859A (en) * | 2015-02-02 | 2015-06-24 | 厦门市美亚柏科信息股份有限公司 | Data processing method and device |
| CN104731859B (en) * | 2015-02-02 | 2018-10-12 | 厦门市美亚柏科信息股份有限公司 | Data processing method and device |
| CN106535152A (en) * | 2015-09-14 | 2017-03-22 | 腾讯科技（深圳）有限公司 | Terminal-based application data processing method, device and system |
| CN106535152B (en) * | 2015-09-14 | 2020-03-17 | 腾讯科技（深圳）有限公司 | Application data processing method, device and system based on terminal |
| CN107632971A (en) * | 2016-07-19 | 2018-01-26 | 百度在线网络技术（北京）有限公司 | Method and apparatus for generating multidimensional form |
| CN106484668A (en) * | 2016-10-09 | 2017-03-08 | 山东南山纺织服饰有限公司 | A kind of clothing typesetting divides bed process and device |
| CN107967247A (en) * | 2016-10-19 | 2018-04-27 | 航天信息股份有限公司 | For generating the method, report computational methods and its device of report form formula |
| CN106776991A (en) * | 2016-12-06 | 2017-05-31 | 济南浪潮高新科技投资发展有限公司 | A kind of method that engineering data based on internet is made a report on |
| CN106776991B (en) * | 2016-12-06 | 2020-06-16 | 浪潮通用软件有限公司 | Engineering data filling method based on Internet |
| CN108205746A (en) * | 2016-12-19 | 2018-06-26 | 通号通信信息集团上海有限公司 | A kind of railway electrical mobile information system and its application process |
| CN106874251A (en) * | 2017-03-10 | 2017-06-20 | 中国电建集团成都勘测设计研究院有限公司 | A kind of measuring method of rock mass RBI and RQD indexs |
| 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 |
| CN107426588A (en) * | 2017-07-12 | 2017-12-01 | 深圳创维－Rgb电子有限公司 | One kind obtains configuration information of television method, system and storage device |
| CN107426588B (en) * | 2017-07-12 | 2020-08-04 | 深圳创维－Rgb电子有限公司 | Method, system and storage device for acquiring television set configuration information |
| CN107862049B (en) * | 2017-11-08 | 2022-03-25 | 中国银行股份有限公司 | Data additional recording method and device |
| CN107862049A (en) * | 2017-11-08 | 2018-03-30 | 中国银行股份有限公司 | A kind of data amended record method and device |
| CN107885710A (en) * | 2017-11-10 | 2018-04-06 | 中国银行股份有限公司 | A kind of generation method and device of bank's parameter report |
| CN108039193A (en) * | 2017-11-17 | 2018-05-15 | 哈尔滨工大服务机器人有限公司 | A kind of method and device for automatically generating physical examination report |
| CN109388647A (en) * | 2018-10-30 | 2019-02-26 | 成都四方伟业软件股份有限公司 | A kind of data based on WEB make a report on method and system |
| CN109388647B (en) * | 2018-10-30 | 2020-09-29 | 成都四方伟业软件股份有限公司 | WEB-based data filling method and system |
| CN109683953A (en) * | 2018-12-26 | 2019-04-26 | 苏州思必驰信息科技有限公司 | A kind of method and device carrying out configuration file processing based on visualization interface |
| CN109683953B (en) * | 2018-12-26 | 2022-03-29 | 思必驰科技股份有限公司 | Method and device for processing configuration file based on visual interface |
| CN110321538A (en) * | 2019-06-20 | 2019-10-11 | 北京小笨鸟信息技术有限公司 | A kind of intelligent offline data makes a report on system |
| CN110321538B (en) * | 2019-06-20 | 2023-11-03 | 北京小笨鸟信息技术有限公司 | Intelligent offline data filling system |
| CN111666745A (en) * | 2020-06-03 | 2020-09-15 | 中国建设银行股份有限公司 | File downloading method, device, server and medium |
| CN112463885A (en) * | 2020-11-26 | 2021-03-09 | 北京宏景世纪软件股份有限公司 | Data synchronization implementation method and centralized data system |
| CN113239121A (en) * | 2021-06-07 | 2021-08-10 | 中国农业银行股份有限公司 | Data synchronization method and device |
| CN113761042A (en) * | 2021-08-04 | 2021-12-07 | 一汽奔腾轿车有限公司 | New vehicle announcement parameter consistency checking system and checking method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103268335A (en) | Report data filling method and system | |
| US20210174006A1 (en) | System and method for facilitating complex document drafting and management | |
| US6442714B1 (en) | Web-based integrated testing and reporting system | |
| US7698284B2 (en) | Systems and methods for deploying a tenant in a provider-tenant environment | |
| US7739348B2 (en) | Systems and methods for accessing a shared space in a provider-tenant environment by using middleware | |
| CN108037961A (en) | A kind of application program collocation method, device, server and storage medium | |
| US11379657B2 (en) | Systems and methods for automatic report generation and retaining of annotations in reporting documents after regeneration | |
| CN105359146A (en) | Automated database migration architecture | |
| US20080140766A1 (en) | Editing web pages via a web browser | |
| US20070162969A1 (en) | Provider-tenant systems, and methods for using the same | |
| US20070162452A1 (en) | Systems and methods for implementing a shared space in a provider-tenant environment | |
| US20070156650A1 (en) | Systems and methods for accessing a shared space in a provider-tenant environment | |
| CN108874409B (en) | Information updating method, device, server and system | |
| US10726040B2 (en) | Lossless conversion of database tables between formats | |
| DK2972827T3 (en) | COLLABORATIVE EDITING | |
| CN109992757A (en) | One kind making a report on method system based on report data | |
| US10747588B2 (en) | Method for updating instance-based message maps using metadata | |
| EP3296864A1 (en) | Storing and retrieving documentation | |
| CN111367975A (en) | Multi-protocol data conversion processing method and device | |
| JP2009524132A (en) | Method and system for integrating computing and presentation techniques | |
| CN116389490A (en) | Receiving device and task execution method | |
| EP1721248A2 (en) | Method and data processing device for updating computer programs by data transmission | |
| US20230385296A1 (en) | Active Data Executable | |
| CN111459943A (en) | Data processing method, device, system, equipment and storage medium | |
| CN113901120A (en) | Method and device for exporting Excel files in large data batch |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20130828 |
|
| RJ01 | Rejection of invention patent application after publication |