CN101650709A - Report generation method and report system - Google Patents
Report generation method and report system Download PDFInfo
- Publication number
- CN101650709A CN101650709A CN200910090697A CN200910090697A CN101650709A CN 101650709 A CN101650709 A CN 101650709A CN 200910090697 A CN200910090697 A CN 200910090697A CN 200910090697 A CN200910090697 A CN 200910090697A CN 101650709 A CN101650709 A CN 101650709A
- Authority
- CN
- China
- Prior art keywords
- formula
- report
- user
- report form
- reporting system
- 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
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a report generation method and a report system. The report generation method comprises the following steps: obtaining report attributes information and a report formula set bya user through a user plane interface; and transferring data in the specified certificate scope for calculating according to the report attributes information and the report formula, and generating and outputting a calculating result table. The embodiment of the invention transmits the data in the specified certificate scope for calculating according to the report attributes information and the report formula set by the user, generates and outputs the calculating result table, provides the usable report generation method and the report system, can lead new contact users to fast use without study for a long time, and is convenient to popularize and use.
Description
Technical field
The embodiment of the invention relates to technical field of data processing, particularly a kind of report form generation method and reporting system.
Background technology
Form is the basic measures and the approach of business administration, is the basic service requirement of enterprise.The fundamental purpose of form is with not intelligible data, utilize systematized arrangement, according to different demands, so that the mode of understanding presents, therefore form can help accessed enterprise, formatted data, and data message presented to the user in reliable and safe mode, and deeply see clearly the enterprise operation situation, be the powerful driving force of enterprise development.Briefly, form is exactly to come dynamic video data with forms such as form, charts.
After computing machine occurs, can utilize the function of computer processing data and INTERFACE DESIGN to generate and show that form, prior art mainly utilize software for editing, database software or form softwares such as Excel, Word to generate form.
Software for editing such as Excel, Word can make very complex report form form, but because this class software does not define special structure of report and loads report data dynamically, therefore the data in this class software all define, and are static, can not dynamic change;
Database software can have the data of dynamic change, but database software generally can only provide the simplest form to come video data, and display format is single;
Form software comes dynamic loading data by special structure of report, and can realize the variation of statement form.But existing form software is produced by different software vendors, and the general degree of every kind of form software is lower, and the user of new contact need spend long time study, is unfavorable for promoting the use of.
Summary of the invention
The embodiment of the invention provides a kind of report form generation method and reporting system, uses with the handled easily person, and the user of new contact is suitable for fast, is beneficial to and promotes the use of.
The embodiment of the invention provides a kind of report form generation method, comprising:
Obtain form attribute information and the report form formula that the user is provided with by interface in the user plane;
Transfer the data of specifying in the voucher scope according to described form attribute information and described report form formula and calculate, generate also output result of calculation table.
The embodiment of the invention also provides a kind of reporting system, comprising:
Acquisition module is used for obtaining form attribute information and the report form formula that the user is provided with by interface in the user plane;
Computing module is used for the form attribute information that obtains according to described acquisition module, utilizes described report form formula to transfer the data of specifying in the voucher scope and calculates, and generates the result of calculation table;
Output module is used to export the result of calculation table that described computing module generates.
The data that the embodiment of the invention is transferred in the appointment voucher scope according to the form attribute information and the report form formula of user's setting are calculated, generate and output result of calculation table, a kind of report form generation method easy to use is provided, can make the user of new contact not need to spend more time study, just can be suitable for fast, be convenient to promote the use of.
Description of drawings
In order to be illustrated more clearly in the present invention or technical scheme of the prior art, to do to introduce simply to the accompanying drawing of required use in embodiment or the description of the Prior Art below, apparently, accompanying drawing in describing below only is some embodiments of the present invention, for those of ordinary skills, under the prerequisite of not paying creative work, can also obtain other accompanying drawing according to these accompanying drawings.
Fig. 1 is the process flow diagram of an embodiment of report form generation method of the present invention;
Fig. 2 is provided with the synoptic diagram of an embodiment of user interface of form attribute information for the present invention;
Fig. 3 is provided with the synoptic diagram of an embodiment of user interface of report form formula for the present invention;
Fig. 4 is provided with the synoptic diagram of an embodiment of user interface of computing function corresponding parameters value for the present invention;
Fig. 5 is the synoptic diagram of an embodiment of the user interface of accounting report of the present invention;
Fig. 6 is the process flow diagram of another embodiment of report form generation method of the present invention;
Fig. 7 is provided with the synoptic diagram of another embodiment of user interface of computing function corresponding parameters value for the present invention;
Fig. 8 is provided with the synoptic diagram of another embodiment of user interface of computing function corresponding parameters value for the present invention;
Fig. 9 is the structural representation of an embodiment of reporting system of the present invention;
Figure 10 is the structural representation of another embodiment of reporting system of the present invention.
Embodiment
Below in conjunction with the accompanying drawing among the present invention, the technical scheme among the present invention is clearly and completely described, obviously, described embodiment only is the present invention's part embodiment, rather than whole embodiment.Based on the embodiment among the present invention, the every other embodiment that those of ordinary skills are obtained under the prerequisite of not making creative work belongs to the scope of protection of the invention.
Fig. 1 is the process flow diagram of an embodiment of report form generation method of the present invention, and as shown in Figure 1, this embodiment comprises:
In the present embodiment, reporting system provides the user interface that the form attribute information is set by interface in the user plane to the user, Fig. 2 is provided with the synoptic diagram of an embodiment of user interface of form attribute information for the present invention, as shown in Figure 2, the form attribute information comprises that table numbering, table name claim, numerical value unit, frequency of usage and report form type, after the user was provided with the form attribute information, reporting system can obtain the form attribute information that the user is provided with by interface in the user plane.Wherein, the table numbering claims to be used to distinguish different forms with table name, and the user can be provided with arbitrarily according to the needs of oneself; Numerical value unit is used for determining the unit of every form, in the present embodiment, reporting system provides unit, ten yuan, hundred yuan, thousand yuan, ten thousand yuan, 100,000 yuan, 1,000,000 yuan, 10,000,000 yuan, hundred million yuan, 1,000,000,000 yuan these ten kinds of amount of money units, and the user can select in the numerical value unit of the user interface that the form attribute information is set according to the needs of oneself; Frequency of usage can not set, and the form of not setting frequency of usage can " irregularly " use, if set frequency of usage, in the present embodiment, reporting system provides daily sheet, weekly return, ten days report table, month form, quarterly report table and year these six kinds of selections of form; The setting of frequency of usage, major decision reporting system notion of " phase " when relating to this form.
For example: when calculating balance sheet on January 12nd, 2000, get the profit and loss statement data of the same period, the frequency of usage difference of profit and loss statement, form same period form pointed is just different, as shown in table 1:
Table 1
| Frequency of usage | The implication that show the same period |
| Daily sheet | The form on January 12nd, 2000 |
| Weekly return | The form on January 16th, 2000 |
| The ten days report table | The form on January 20th, 2000 |
| Month form | The form on January 31st, 2000 |
| The quarterly report table | The form on March 31st, 2000 |
| Year form | The form on Dec 31st, 2000 |
Report form type in the form attribute information comprise the time point table and during the table.
Wherein, report form formula comprises formula cell, row formula and chief series formula.Formula cell is modal formula type, promptly according to the Chinese character explanation, defines access mode one by one in the cell of correspondence; The row formula is effective to each cell of column; When comparing complex report form, can use a plurality of row formula, the chief series formula is the index commander between row formula and the row formula.
Present embodiment is that formula cell is that example describes with the report form formula.
In the present embodiment, reporting system can obtain computing function and the computing function corresponding parameters value of selecting according to access mode by interface in the user plane, and obtains to utilize the formula cell of this computing function and the generation of this computing function corresponding parameters value.
Particularly, reporting system provides the user interface that report form formula is set by interface in the user plane to the user, the user can be provided with the user interface of report form formula, mode (remaining sum, debit's amount, credit amount or other modes) according to peek, in being set, the user interface of report form formula selects concrete computing function, as " remaining sum at the beginning of the year ", thereby reporting system can obtain the computing function of selecting according to access mode by interface in the user plane.Fig. 3 is provided with the synoptic diagram of an embodiment of user interface of report form formula for the present invention, and Fig. 3 is that remaining sum is that example describes in the mode of peek.
After obtaining computing function, reporting system provides the user interface that computing function corresponding parameters value is set to the user, and this computing function corresponding parameters value comprises subject number, multidimensional code, Currency Type and set of books.Wherein, subject is a required item number when getting " remaining sum, debit's amount or credit amount "; When subject has multidimensional code, can be detailed to the numerical value of getting the combination of a certain multidimensional code or several multidimensional code, can not fill out yet; Currency Type is defaulted as " calculating Currency Type ", does not promptly specify Currency Type when defined formula, and reporting system selected Currency Type when calculating is as the criterion; If but specified Currency Type, and select which kind of Currency Type when then no matter calculating, this cell is still according to former appointment Currency Type peek; When the account of cover more than having, reporting system can determine peek according to user's selection from which cover account.Fig. 4 is provided with the synoptic diagram of an embodiment of user interface of computing function corresponding parameters value for the present invention, Fig. 4 with the beginning of the year remaining sum be that example describes.
Reporting system can repeatedly obtain computing function and computing function corresponding parameters value, after obtaining computing function and computing function corresponding parameters value, reporting system can obtain to utilize the formula cell of this computing function and the generation of this computing function corresponding parameters value, in the formula cell that obtains, connect with sign of operation between each computing function, for example: the formula cell that reporting system obtains can for: " beginning of the year remaining sum (101;; [calculating Currency Type] ;)+beginning of the year remaining sum (102,, [calculating Currency Type] ;) ", this formula cell is presented in the formula bar of the user interface that report form formula is set shown in Figure 3.
In the present embodiment, reporting system makes the user can change computing function and increase and decrease computing function at any time, and obtains corresponding report form formula by user interface that report form formula is set and the user interface that computing function corresponding parameters value is set are provided to the user.
In the present embodiment, reporting system provides the user interface of accounting report by interface in the user plane to the user, selects to calculate Currency Type, the voucher scope of computing time and setting is set for the user.Fig. 5 is the synoptic diagram of an embodiment of the user interface of accounting report of the present invention, the user interface when Fig. 5 showed for the computing interval, the user interface during calculating time point table is similar with it, just do not have " Start Date " this.
Reporting system obtains the Currency Type of this calculating, and according to the report form type in the form attribute information that obtains, obtains computing time when calculating, and for the time point table, be the cut-off date computing time; For during the table, be the time range that defines start time and closing time computing time.Then, reporting system can be transferred according to report form formula and specify the data of voucher scope to calculate in computing time, generates the result of calculation table.Wherein, the voucher scope comprises: keep accounts, examined and all; Keep accounts: only, do not consider not bookkeeping voucher from the account book peek; Examine: from the account book peek, calculating is participated in the audit before the cut-off date simultaneously not bookkeeping voucher; All: from the account book peek, all simultaneously not bookkeeping voucher full entries calculate.
In the present embodiment, the computation rule of reporting system normally requires a cut-off date, for during table, reporting system can be according to each formula cell, determines automatically to calculate Start Date.For example: when formula cell was got 101 section's purpose this month debit amounts, the cut-off date was on March 26th, 2000, and reporting system can calculate the debit amount total of 101 subjects from March 26,1 day to 2000 March in 2000 automatically.
The result of calculation table that reporting system generates is a form of preserving data, and the default name of result of calculation table is for calculating the cut-off date in the reporting system, and present embodiment is not limited in this certainly, can also other name nominating result of calculation tables.After generating the result of calculation table, reporting system can be exported the result of calculation table, shows this result of calculation table with the user interface by correspondence to the user, and reporting system can be saved to this result of calculation table in the database according to user's selection.
In the present embodiment, reporting system can connect and embedding (Object Linking andEmbedding by object; Hereinafter to be referred as OLE) mode calling excel, the form that the result of calculation table of generation can Excel is preserved, and can open in Excel.
In the present embodiment, reporting system is also supported the function of accounting report in batches, and reporting system can calculate according to the report form formula in each form one by one to selected calculative a plurality of report files.
In the foregoing description, reporting system calculates according to the data that the form attribute information and the report form formula of user's setting are transferred in the appointment voucher scope, generate and output result of calculation table, a kind of report form generation method easy to use is provided, can make the user of new contact not need to spend more time study, just can be suitable for fast, be convenient to promote the use of.And, in the foregoing description, reporting system makes the user can change computing function and increase and decrease computing function at any time, and obtains corresponding report form formula by user interface that report form formula is set and the user interface that computing function corresponding parameters value is set are provided to the user; And according to the form attribute information that reporting system obtains, the result of calculation table that reporting system generates can be supported numerical value units such as unit, thousand yuan, ten thousand yuan or hundred million yuan automatically.
Fig. 6 is the process flow diagram of another embodiment of report form generation method of the present invention, and this embodiment is that row formula and chief series formula are that example describes with the report form formula.As shown in Figure 6, this embodiment comprises:
In the present embodiment, reporting system passes through interface in the user plane, the user interface of newly-built form is provided to the user, for user's newly-built form on this interface, the row title of newly-built form is set, newly-built form can be as shown in table 2, thereby reporting system can obtain the row title of newly-built form by interface in the user plane.
Table 2
In the present embodiment, reporting system can OLE mode calling excel, and the form that newly-built form can Excel is preserved, and can open in Excel.
In the present embodiment, reporting system provides user interface shown in Figure 2 by interface in the user plane to the user, and obtains the form attribute information that the user is provided with by interface in the user plane.In the present embodiment, the form attribute information that reporting system obtains can be " table numbering: 009 ", " table name claims: new form ", " numerical value unit: unit ", " frequency of usage: month form " and " report form type: during show ", it more than is an example of the form attribute information that obtains of reporting system, present embodiment is not limited in this, and the particular content of form attribute information does not influence the realization of present embodiment.
In the present embodiment, reporting system provides user interface shown in Figure 3 by interface in the user plane to the user, for the user chief series formula is set, and at this moment the formula type among Fig. 3 is the chief series formula, and computation sequence is 1.Present embodiment is that debt-credit side's amount is that example describes with the access mode, because debt-credit side's amount all is according to corresponding accounts number peek, therefore subject number is classified chief series as, promptly the A in the table 2 is listed as, after reporting system receives the information of user's selection "-certain grade Code of Account (getting certain grade of Code of Account) of encoding " this computing function, reporting system provides the user interface that this computing function corresponding parameters value is set by interface in the user plane to the user, Fig. 7 is provided with the synoptic diagram of another embodiment of user interface of computing function corresponding parameters value for the present invention, among Fig. 7, subject number can be empty or " % ", and the subject rank is " 1 ".After obtaining computing function and this computing function corresponding parameters value, reporting system can determine that the chief series formula is " certain grade of Code of Account (%, 1) ", and the subject rank that this chief series formula comprises is " 1 ".
In the present embodiment, reporting system at first obtains the row formula of B row in the table 2.Reporting system provides user interface shown in Figure 3 by interface in the user plane to the user equally, for the user row formula is set, at this moment the formula type among Fig. 3 is the row formula, because the row formula need be according to the subject number peek of chief series formula, therefore computation sequence is 2, the subject rank of i.e. row formula peek is subordinated to the subject rank of chief series formula peek, and the effect line number of row formula is determined by the effect line number of chief series formula.
Present embodiment is that example describes with the computing function of B row for " current period debit (getting the current period debit amount of prescribed course) ", after reporting system receives the information of user's selection " amount-current period debit (getting the current period debit amount of prescribed course) " this computing function, reporting system provides the user interface that this computing function corresponding parameters value is set by interface in the user plane to the user, Fig. 8 is provided with the synoptic diagram of another embodiment of user interface of computing function corresponding parameters value for the present invention, among Fig. 8, " subject: @a " expression subject number is got the value of A row corresponding row; Multidimensional code and opposite account are defaulted as all for empty expression; When selecting " calculating Currency Type " expression to calculate, Currency Type determines with which kind of Currency Type to calculate, with which kind of Currency Type calculate, then can import definite Currency Type again if determined; When many covers account, select concrete set of books, otherwise can be sky.After obtaining computing function and this computing function corresponding parameters value, the row formula that reporting system can be determined the B row for " current period debit (@a,, [calculating Currency Type] ,) ".
By identical process, reporting system can be determined the row formula of the row of C in the table 2, in the present embodiment, the row formula of supposing the C row for " current period credit side (@a,, [calculating Currency Type] ,) ".
In the present embodiment, reporting system provides the user interface of accounting report by interface in the user plane to the user, as shown in Figure 5, selects to calculate Currency Type, the voucher scope of computing time and setting is set for the user.
The process that the computation process of reporting system and step 103 are described is similar, does not repeat them here.In the present embodiment, the result of calculation table that reporting system generates can be as shown in table 3.
Table 3
| ??A | ??B | ??C | ??D | ??E | ??F | |
| ??1 | Subject number | Current period debit amount | The current period credit amount | |||
| ??2 | ??101 | ??10941776.61 | ??10959505.61 | |||
| ??3 | ??102 | ??4449982788 | ??3687769808 | |||
| ??4 | ??103 | ??698459.37 | ??698459.37 | |||
| ??5 | ??104 | ??0 | ??0 | |||
| ??6 | ??105 | ??9460315.54 | ??2343109.67 | |||
| ??7 | ??109 | ??0 | ??0 | |||
| ??8 | ??111 | ??0 | ??0 | |||
| ??9 | ??112 | ??327400000 | ??673490166 | |||
| ??10 | ??113 | ??0 | ??0 | |||
| ??11 | ??114 | ??1950000 | ??1950000 | |||
| ??12 | ??115 | ??12750000 | ??58300000 | |||
| ??13 | ??116 | ??480000 | ??100000 | |||
| ??14 | ??117 | ??0 | ??0 | |||
| ??15 | ??118 | ??243755023.8 | ??258932280.6 | |||
| ??16 | ??120 | ??16721070 | ??15850235.9 | |||
| ??17 | ??132 | ??0 | ??0 | |||
| ??18 | ??144 | ??0 | ??50000 | |||
| ??19 | ??151 | ??0 | ??20000 | |||
| ??20 | ??152 | ??0 | ??0 | |||
| ??21 | ??161 | ??0 | ??0 |
After generating the result of calculation table, reporting system can be exported the result of calculation table, shows this result of calculation table with the user interface by correspondence to the user, and reporting system can be saved to this result of calculation table in the database according to user's selection.
In the present embodiment, reporting system can OLE mode calling excel, and the form that the result of calculation table of generation can Excel is preserved, and can open in Excel.
In the foregoing description, reporting system calculates according to the data that the form attribute information and the report form formula of user's setting are transferred in the appointment voucher scope, generate and output result of calculation table, a kind of report form generation method easy to use is provided, can make the user of new contact not need to spend more time study, just can be suitable for fast, be convenient to promote the use of.And, in the foregoing description, reporting system calculates according to the chief series formula and the row formula that obtain, thereby do not need to obtain the formula of each cell, and when subject changes, reporting system can carry out new calculating by obtaining amended row formula and chief series formula, has simplified the operation of obtaining report form formula greatly; And reporting system makes the user can change computing function and increase and decrease computing function at any time, and obtains corresponding report form formula by user interface that report form formula is set and the user interface that computing function corresponding parameters value is set are provided to the user; And according to the form attribute information that reporting system obtains, the result of calculation table that reporting system generates can be supported numerical value units such as unit, thousand yuan, ten thousand yuan or hundred million yuan automatically.
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.
Fig. 9 is the structural representation of an embodiment of reporting system of the present invention, and the reporting system of present embodiment can be realized the flow process that the present invention is embodiment illustrated in fig. 1, and as shown in Figure 9, this reporting system comprises: acquisition module 91, computing module 92 and output module 93.
Wherein, acquisition module 91 can obtain form attribute information and the report form formula that the user is provided with by interface in the user plane; The form attribute information that computing module 92 can obtain according to acquisition module 91 utilizes report form formula to transfer the data of specifying in the voucher scope and calculates, and generates the result of calculation table; Output module 93 is used to export the result of calculation table that computing module 92 generates.
Above-mentioned reporting system calculates according to the data that the form attribute information and the report form formula of user's setting are transferred in the appointment voucher scope, generate and output result of calculation table, a kind of reporting system easy to use is provided, can make the user of new contact not need to spend more time study, just can be suitable for fast, be convenient to promote the use of.
Figure 10 is the structural representation of another embodiment of reporting system of the present invention, the reporting system of present embodiment can be realized Fig. 1 of the present invention or flow process embodiment illustrated in fig. 6, as shown in figure 10, this reporting system comprises: acquisition module 1001, computing module 1002, output module 1003 and preservation module 1004.
Wherein, acquisition module 1001 can obtain form attribute information and the report form formula that the user is provided with by interface in the user plane; The form attribute information that computing module 1002 can obtain according to acquisition module 1001 utilizes report form formula to transfer the data of specifying in the voucher scope and calculates, and generates the result of calculation table; Output module 1003 is used to export the result of calculation table that computing module 1002 generates.
In the present embodiment, acquisition module 1001 can comprise: formula cell obtains submodule 10011, the chief series formula obtains submodule 10012 and the row formula obtains submodule 10013.
Formula cell obtains submodule 10011 can obtain computing function and this computing function corresponding parameters value of selecting according to access mode, and obtains to utilize the formula cell of this computing function and the generation of this computing function corresponding parameters value;
The chief series formula obtains submodule 10012 can obtain the chief series formula, and this chief series formula comprises the subject rank and the effect line number of peek;
The row formula obtains submodule 10013 can obtain the row formula, and the subject rank of peeking in this row formula is subordinated to the subject rank of peeking in the chief series formula, and the effect line number of this row formula is determined by the effect line number of chief series formula.
In the present embodiment, the report form type in the form attribute information that computing module 1002 specifically can obtain according to acquisition module 1001 is obtained computing time; And according to formula cell, perhaps row formula and chief series formula are transferred from database and are specified the data of voucher scope to calculate in computing time, generate and output result of calculation table.
Above-mentioned reporting system calculates according to the data that the form attribute information and the report form formula of user's setting are transferred in the appointment voucher scope, generate and output result of calculation table, a kind of report form generation method easy to use is provided, can make the user of new contact not need to spend more time study, just can be suitable for fast, be convenient to promote the use of.And, above-mentioned reporting system calculates according to the chief series formula and the row formula that obtain, thereby do not need to obtain the formula of each cell, and when subject changes, reporting system can carry out new calculating by obtaining amended row formula and chief series formula, has simplified the operation of obtaining report form formula greatly.
It will be appreciated by those skilled in the art that accompanying drawing is the synoptic diagram of a preferred embodiment, module in the accompanying drawing or flow process might not be that enforcement the present invention is necessary.
It will be appreciated by those skilled in the art that the module in the reporting system among the embodiment can be distributed in the reporting system of embodiment according to the embodiment description, also can carry out respective change and be arranged in the one or more reporting systems that are different from present embodiment.The module of the foregoing description can be merged into a module, also can further split into a plurality of submodules.
It should be noted that at last: above embodiment is only in order to technical scheme of the present invention to be described but not limit it, although the present invention is had been described in detail with reference to preferred embodiment, those of ordinary skill in the art is to be understood that: it still can make amendment or be equal to replacement technical scheme of the present invention, and these modifications or be equal to replacement and also can not make amended technical scheme break away from the spirit and scope of technical solution of the present invention.
Claims (10)
1, a kind of report form generation method is characterized in that, comprising:
Obtain form attribute information and the report form formula that the user is provided with by interface in the user plane;
Transfer the data of specifying in the voucher scope according to described form attribute information and described report form formula and calculate, generate also output result of calculation table.
2, method according to claim 1 is characterized in that, described form attribute information comprises: table numbering, table name claim, numerical value unit, frequency of usage and report form type; Described report form type comprises: the time point table and during the table; Described result of calculation table is the Excel table.
3, method according to claim 1 is characterized in that, described report form formula comprises formula cell, and the report form formula that the described user of obtaining is provided with comprises:
Obtain computing function and the described computing function corresponding parameters value selected according to access mode, and obtain to utilize the formula cell of described computing function and the generation of described computing function corresponding parameters value.
4, method according to claim 3 is characterized in that, described report form formula also comprises row formula and chief series formula, and the report form formula that the described user of obtaining is provided with comprises:
Obtain the chief series formula, described chief series formula comprises the subject rank and the effect line number of peek;
Obtain the row formula, the subject rank of peeking in the described row formula is subordinated to the subject rank of peeking in the described chief series formula, and the effect line number of described row formula is determined by the effect line number of described chief series formula.
5, according to claim 2,3 or 4 described methods, it is characterized in that, describedly transfer the data of specifying in the voucher scope according to described form attribute information and described report form formula and calculate, generate and output result of calculation table comprises:
According to the report form type in the described form attribute information, obtain computing time;
According to described formula cell, perhaps described row formula and described chief series formula are transferred from database and are specified the data of voucher scope to calculate in described computing time, generate and output result of calculation table.
6, method according to claim 5 is characterized in that, after the described output result of calculation table, also comprises: described result of calculation table is preserved in the database.
7, a kind of reporting system is characterized in that, comprising:
Acquisition module is used for obtaining form attribute information and the report form formula that the user is provided with by interface in the user plane;
Computing module is used for the form attribute information that obtains according to described acquisition module, utilizes described report form formula to transfer the data of specifying in the voucher scope and calculates, and generates the result of calculation table;
Output module is used to export the result of calculation table that described computing module generates.
8, reporting system according to claim 7 is characterized in that, described acquisition module comprises:
Formula cell obtains submodule, is used to obtain computing function and the described computing function corresponding parameters value of selecting according to access mode, and obtains to utilize the formula cell of described computing function and the generation of described computing function corresponding parameters value;
The chief series formula obtains submodule, is used to obtain the chief series formula, and described chief series formula comprises the subject rank and the effect line number of peek;
The row formula obtains submodule, is used to obtain the row formula, and the subject rank of peeking in the described row formula is subordinated to the subject rank of peeking in the described chief series formula, and the effect line number of described row formula is determined by the effect line number of described chief series formula.
9, reporting system according to claim 8 is characterized in that, described computing module specifically is used for the report form type of the form attribute information that obtains according to described acquisition module, obtains computing time; And according to described formula cell, perhaps described row formula and described chief series formula are transferred from database and are specified the data of voucher scope to calculate in described computing time, generate the result of calculation table.
10, according to claim 7 or 9 described reporting systems, it is characterized in that, also comprise:
Preserve module, be used for the result of calculation table of described output module output is preserved into database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2009100906975A CN101650709B (en) | 2009-09-08 | 2009-09-08 | Report generation method and report system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2009100906975A CN101650709B (en) | 2009-09-08 | 2009-09-08 | Report generation method and report system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN101650709A true CN101650709A (en) | 2010-02-17 |
| CN101650709B CN101650709B (en) | 2012-02-08 |
Family
ID=41672948
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2009100906975A Active CN101650709B (en) | 2009-09-08 | 2009-09-08 | Report generation method and report system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101650709B (en) |
Cited By (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103136167A (en) * | 2011-12-05 | 2013-06-05 | 英顺源（上海）科技有限公司 | Sheet capturing system used in paging of spreadsheet and method thereof |
| CN103279889A (en) * | 2013-05-17 | 2013-09-04 | 上海市计量测试技术研究院 | Method for merging crystal report and WORD document by using VB (Virtual Basic) |
| CN103473342A (en) * | 2013-09-23 | 2013-12-25 | 北京久其软件股份有限公司 | Report data generating method and system |
| CN105045576A (en) * | 2015-06-29 | 2015-11-11 | 用友优普信息技术有限公司 | Management method and apparatus for calculation formulae in business document |
| CN106021355A (en) * | 2016-05-10 | 2016-10-12 | 重庆大学 | Statistics method among plurality of tables, user-defined rule building method, device and system |
| CN106406835A (en) * | 2015-07-30 | 2017-02-15 | 大唐软件技术股份有限公司 | Report generation method and report generation apparatus |
| CN107784063A (en) * | 2017-07-27 | 2018-03-09 | 平安科技（深圳）有限公司 | The generation method and terminal device of algorithm |
| CN107832279A (en) * | 2017-09-12 | 2018-03-23 | 北京中燕信息技术有限公司 | A kind of method, equipment and computer-readable recording medium for generating form |
| CN107967247A (en) * | 2016-10-19 | 2018-04-27 | 航天信息股份有限公司 | For generating the method, report computational methods and its device of report form formula |
| CN109446494A (en) * | 2018-10-19 | 2019-03-08 | 国电南瑞科技股份有限公司 | A kind of water utilities calculation method based on Report Engine |
| CN105843785B (en) * | 2016-03-22 | 2019-03-19 | 南京大学 | A kind of data self accounting report generation method of embedded organization and administration level |
| CN111460778A (en) * | 2020-03-31 | 2020-07-28 | 山东浪潮通软信息科技有限公司 | Method for processing data between reports |
| CN113051881A (en) * | 2021-04-02 | 2021-06-29 | 北京神州数字科技有限公司 | Report display method based on parameter configuration |
| WO2023143071A3 (en) * | 2022-01-27 | 2023-09-14 | 北京字跳网络技术有限公司 | Content display method and apparatus, electronic device and storage medium |
| CN117215455A (en) * | 2023-09-25 | 2023-12-12 | 中科院成都信息技术股份有限公司 | Report calculation formula generation method and device, computer equipment and storage medium |
-
2009
- 2009-09-08 CN CN2009100906975A patent/CN101650709B/en active Active
Cited By (19)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103136167A (en) * | 2011-12-05 | 2013-06-05 | 英顺源（上海）科技有限公司 | Sheet capturing system used in paging of spreadsheet and method thereof |
| CN103279889A (en) * | 2013-05-17 | 2013-09-04 | 上海市计量测试技术研究院 | Method for merging crystal report and WORD document by using VB (Virtual Basic) |
| CN103279889B (en) * | 2013-05-17 | 2016-04-06 | 上海市计量测试技术研究院 | The method utilizing VB to realize crystal report and WORD document to merge |
| CN103473342A (en) * | 2013-09-23 | 2013-12-25 | 北京久其软件股份有限公司 | Report data generating method and system |
| CN105045576A (en) * | 2015-06-29 | 2015-11-11 | 用友优普信息技术有限公司 | Management method and apparatus for calculation formulae in business document |
| CN106406835A (en) * | 2015-07-30 | 2017-02-15 | 大唐软件技术股份有限公司 | Report generation method and report generation apparatus |
| CN105843785B (en) * | 2016-03-22 | 2019-03-19 | 南京大学 | A kind of data self accounting report generation method of embedded organization and administration level |
| CN106021355A (en) * | 2016-05-10 | 2016-10-12 | 重庆大学 | Statistics method among plurality of tables, user-defined rule building method, device and system |
| CN107967247A (en) * | 2016-10-19 | 2018-04-27 | 航天信息股份有限公司 | For generating the method, report computational methods and its device of report form formula |
| CN107784063A (en) * | 2017-07-27 | 2018-03-09 | 平安科技（深圳）有限公司 | The generation method and terminal device of algorithm |
| WO2019019702A1 (en) * | 2017-07-27 | 2019-01-31 | 平安科技（深圳）有限公司 | Algorithm generation method and device, terminal device and storage medium |
| CN107784063B (en) * | 2017-07-27 | 2020-03-17 | 平安科技（深圳）有限公司 | Algorithm generation method and terminal equipment |
| CN107832279A (en) * | 2017-09-12 | 2018-03-23 | 北京中燕信息技术有限公司 | A kind of method, equipment and computer-readable recording medium for generating form |
| CN109446494A (en) * | 2018-10-19 | 2019-03-08 | 国电南瑞科技股份有限公司 | A kind of water utilities calculation method based on Report Engine |
| CN111460778A (en) * | 2020-03-31 | 2020-07-28 | 山东浪潮通软信息科技有限公司 | Method for processing data between reports |
| CN111460778B (en) * | 2020-03-31 | 2023-11-14 | 浪潮通用软件有限公司 | Method for processing data between reports |
| CN113051881A (en) * | 2021-04-02 | 2021-06-29 | 北京神州数字科技有限公司 | Report display method based on parameter configuration |
| WO2023143071A3 (en) * | 2022-01-27 | 2023-09-14 | 北京字跳网络技术有限公司 | Content display method and apparatus, electronic device and storage medium |
| CN117215455A (en) * | 2023-09-25 | 2023-12-12 | 中科院成都信息技术股份有限公司 | Report calculation formula generation method and device, computer equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN101650709B (en) | 2012-02-08 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101650709B (en) | Report generation method and report system | |
| CN102567345A (en) | Method and device for generating bookkeeping voucher | |
| CN104615667B (en) | A kind of basic data generation method, test data creation method and its device | |
| Adelman | World petroleum market | |
| US6397195B1 (en) | System for managing accounting information in a multi-dimensional database | |
| CN101430661B (en) | Method, system and apparatus for test data batch generation | |
| CN101504672B (en) | Method and system for dynamically configuring physical data table | |
| CN109815228A (en) | Creation method, device, computer equipment and the readable storage medium storing program for executing of database table | |
| CN101308490A (en) | Dynamic report generation method and platform | |
| CN109325055A (en) | The screening of business association tables of data and checking method, device, electronic equipment | |
| CN109829001A (en) | For generating the method and device of invoice data | |
| CN103020227A (en) | Data processing method and system in computer equipment | |
| CN104615637A (en) | Data exchange method and data exchange intermediate device | |
| CN107808334A (en) | A kind of method that accounting voucher is automatically generated from business paper | |
| CN107729330B (en) | Method and apparatus for acquiring data set | |
| CN110018819B (en) | Data checking script generation method, device and equipment | |
| CN110162540A (en) | Querying method, electronic device and the storage medium of block chain account book data | |
| CN102866985B (en) | For data formatter and the method for on-line analysing processing system | |
| CN114936154A (en) | Test case and test data generation method and device | |
| CN110968679A (en) | Data query method and device | |
| CN115310944A (en) | Online ledger management method, system, device and medium | |
| CN112214983B (en) | Data record duplicate checking method and system | |
| CN114265842A (en) | Audit data processing method, device, equipment and storage medium based on ERP system | |
| CN112950345A (en) | Business and financial data processing method and device and computer equipment | |
| CN114553954B (en) | Information pushing method, nonvolatile storage medium and electronic equipment |
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 | ||
| C56 | Change in the name or address of the patentee | ||
| CP02 | Change in the address of a patent holder |
Address after: 100086, No. 11, building 2, building No. 43, West Third Ring Road, Haidian District, Beijing Patentee after: Beijing NineStar Technology Joint-Stock Co., Ltd. Address before: 100082, A9, International Building, Shougang Road, 60 North Main Street, Haidian District, Beijing, Xizhimen Patentee before: Beijing NineStar Technology Joint-Stock Co., Ltd. |