CN101650709B - Report generation method and report system - Google Patents
Report generation method and report system Download PDFInfo
- Publication number
- CN101650709B CN101650709B CN2009100906975A CN200910090697A CN101650709B CN 101650709 B CN101650709 B CN 101650709B CN 2009100906975 A CN2009100906975 A CN 2009100906975A CN 200910090697 A CN200910090697 A CN 200910090697A CN 101650709 B CN101650709 B CN 101650709B
- 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.)
- Active
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 by a 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 shows; Therefore form can help accessed enterprise, formatted data; And present to the user to data message with 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, this type software do not come the dynamic report data that loads because defining special structure of report; Therefore the data in this type 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 through special structure of report, and can realize the variation of statement form.But existing form software is by the Different software manufacturers produce, 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 through interface in the user plane;
Transfer the data of specifying in the voucher scope according to said form attribute information and said 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 through interface in the user plane;
Computing module is used for the form attribute information that obtains according to said acquisition module, utilizes said 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 said 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 need not 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; Obviously, the 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
To combine the accompanying drawing among the present invention below, the technical scheme among the present invention is carried out clear, intactly description, 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 that the present invention protects.
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 through 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, and is as shown in Figure 2, and the form attribute information comprises that table numbering, table name are claimed, 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 through 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 confirming 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 of profit and loss statement is different, and 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 of 2O day in January, 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 with 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, in the corresponding cells lattice, defines access mode one by one; The row formula is effective to each cell of place row; When doing the form of more complicated, 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 through interface in the user plane, and obtains to utilize the formula cell of this computing function and this computing function corresponding parameters value generation.
Particularly; Reporting system provides the user interface that report form formula is set through interface in the user plane to the user; The user can be provided with the user interface of report form formula, according to the mode (remaining sum, debit's amount, credit amount or other modes) of peek, in the user interface of report form formula is set, selects concrete computing function; Like " remaining sum at the beginning of the year ", thereby reporting system can obtain the computing function of selecting according to access mode through 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 with 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 ", promptly when defined formula, does not specify Currency Type, 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 confirm from which cover account, peek according to user's selection.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, and after obtaining computing function and computing function corresponding parameters value, reporting system can obtain to utilize the formula cell of this computing function and this computing function corresponding parameters value generation; 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 through 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 through 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, confirms 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,2000 1 day to 2000 March in 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 through 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 in Excel, open.
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 selected calculative a plurality of report files one by one.
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 need not 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 through 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; To the user user interface of newly-built form is provided,, the row title of newly-built form is set for user's newly-built form on this interface; Newly-built form can be as shown in table 2, thereby reporting system can obtain the row title of newly-built form through 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 in Excel, open.
In the present embodiment, reporting system provides user interface shown in Figure 2 through interface in the user plane to the user, and obtains the form attribute information that the user is provided with through interface in the user plane.In the present embodiment; The form attribute information that reporting system obtains can be " table numbering: 009 ", " table name is claimed: 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 through interface in the user plane to the user, supplies the user that the 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 amount all is according to corresponding accounts number peek, so subject number classifies chief series as, and 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 through interface in the user plane to the user, and 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 confirm 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 through interface in the user plane to the user equally; Supply the user that the 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 number peek of the subject of chief series formula, so 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 confirmed 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 through 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 number: 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 confirms with which kind of Currency Type to calculate, with which kind of Currency Type calculate, then can import definite Currency Type again if confirmed; 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 confirmed the B row for " the current period debit (and a,, [calculating Currency Type] ,) ".
Through identical process, reporting system can be confirmed 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 " the current period credit side (and a,, [calculating Currency Type] ,) ".
In the present embodiment, reporting system provides the user interface of accounting report through interface in the user plane to the user, and is 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, repeats no more at this.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 | | E | F | ||
| 1 | Subject number | Current period debit amount | The current |
||||
| 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 through 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 in Excel, open.
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 need not 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 need not obtain the formula of each cell, and when subject changes; Reporting system can carry out new calculating through 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 through 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 accomplished through the relevant hardware of programmed instruction; Aforesaid program can be stored in the computer read/write memory medium; This program 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 is as shown in Figure 9, and 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 through 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 need not 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; 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 through 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 the computing function of selecting according to access mode and this computing function corresponding parameters value, and obtains to utilize the formula cell of this computing function and this computing function corresponding parameters value generation;
The chief series formula obtains submodule 10012 can obtain the chief series formula, and this chief series formula comprises the subject rank and 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 confirmed 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 need not 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 need not obtain the formula of each cell; And when subject changed, reporting system can carry out new calculating through 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 embodiment of 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.
What should explain at last is: above embodiment is only in order to technical scheme of the present invention to be described but not limit it; Although the present invention has been carried out detailed explanation 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, also can not make amended technical scheme break away from the spirit and the scope of technical scheme of the present invention and these are revised or be equal to replacement.
Claims (9)
1. a report form generation method is characterized in that, comprising:
Obtain form attribute information and the report form formula that the user is provided with through interface in the user plane; Said report form formula comprises formula cell; The report form formula that the said user of obtaining is provided with comprises: obtain computing function and the said computing function corresponding parameters value selected according to access mode, and obtain to utilize the formula cell of said computing function and the generation of said computing function corresponding parameters value;
Transfer the data of specifying in the voucher scope according to said form attribute information and said report form formula and calculate, generate also output result of calculation table.
2. method according to claim 1 is characterized in that, said form attribute information comprises: table numbering, table name are claimed, numerical value unit, frequency of usage and report form type; Said report form type comprises: the time point table with during the table; Said result of calculation table is the Excel table.
3. method according to claim 1 is characterized in that, said report form formula also comprises row formula and chief series formula, and the report form formula that the said user of obtaining is provided with comprises:
Obtain the chief series formula, said chief series formula comprises the subject rank and effect line number of peek;
Obtain the row formula, the subject rank of peeking in the said row formula is subordinated to the subject rank of peeking in the said chief series formula, and the effect line number of said row formula is confirmed by the effect line number of said chief series formula.
4. according to claim 1,2 or 3 described methods, it is characterized in that, saidly transfer the data of specifying in the voucher scope according to said form attribute information and said report form formula and calculate, generate and output result of calculation table comprises:
According to the report form type in the said form attribute information, obtain computing time;
According to said formula cell, perhaps said row formula and said chief series formula are transferred from database and are specified the data of voucher scope to calculate in said computing time, generate and output result of calculation table.
5. method according to claim 4 is characterized in that, after the said output result of calculation table, also comprises: said result of calculation table is preserved in the database.
6. a 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 through interface in the user plane; Said acquisition module comprises: formula cell obtains submodule; Be used to obtain computing function and the said computing function corresponding parameters value of selecting according to access mode, and obtain to utilize the formula cell of said computing function and the generation of said computing function corresponding parameters value;
Computing module is used for the form attribute information that obtains according to said acquisition module, utilizes said 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 said computing module generates.
7. reporting system according to claim 6 is characterized in that, said acquisition module comprises:
The chief series formula obtains submodule, is used to obtain the chief series formula, and said chief series formula comprises the subject rank and 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 said row formula is subordinated to the subject rank of peeking in the said chief series formula, and the effect line number of said row formula is confirmed by the effect line number of said chief series formula.
8. reporting system according to claim 7 is characterized in that, the report form type of the form attribute information that said computing module specifically is used for obtaining according to said acquisition module is obtained computing time; And according to said formula cell, perhaps said row formula and said chief series formula are transferred from database and are specified the data of voucher scope to calculate in said computing time, generate the result of calculation table.
9. according to claim 6 or 8 described reporting systems, it is characterized in that, also comprise:
Preserve module, be used for the result of calculation table of said 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 CN101650709A (en) | 2010-02-17 |
| CN101650709B true 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) |
Families Citing this family (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 |
| CN103279889B (en) * | 2013-05-17 | 2016-04-06 | 上海市计量测试技术研究院 | The method utilizing VB to realize crystal report and WORD document to merge |
| CN103473342B (en) * | 2013-09-23 | 2018-01-16 | 北京久其软件股份有限公司 | A kind of report data generation 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 |
| CN106021355B (en) * | 2016-05-10 | 2020-07-28 | 重庆大学 | Statistical method and custom rule establishing method, device and system among multiple tables |
| CN107967247A (en) * | 2016-10-19 | 2018-04-27 | 航天信息股份有限公司 | For generating the method, report computational methods and its device of report form formula |
| 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 |
| CN109446494B (en) * | 2018-10-19 | 2024-03-15 | 国电南瑞科技股份有限公司 | Water affair calculation method based on report engine |
| 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 |
| CN114626332A (en) * | 2022-01-27 | 2022-06-14 | 北京字跳网络技术有限公司 | Content display method and device and electronic equipment |
| CN117215455B (en) * | 2023-09-25 | 2024-06-21 | 中科院成都信息技术股份有限公司 | Report calculation formula generation method and device, computer equipment and storage medium |
-
2009
- 2009-09-08 CN CN2009100906975A patent/CN101650709B/en active Active
Also Published As
| Publication number | Publication date |
|---|---|
| CN101650709A (en) | 2010-02-17 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101650709B (en) | Report generation method and report system | |
| CN104615667B (en) | A kind of basic data generation method, test data creation method and its device | |
| CN102567345A (en) | Method and device for generating bookkeeping voucher | |
| Thiem et al. | Qualitative comparative analysis with R: A user’s guide | |
| 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 | |
| CN104361018B (en) | Electronic archives information reorganization method and device | |
| CN101882266A (en) | Account making system for medium-sized and small enterprises | |
| CN101706829A (en) | Data storage method and device | |
| CN107729330B (en) | Method and apparatus for acquiring data set | |
| CN110018819B (en) | Data checking script generation method, device and equipment | |
| CN102479353A (en) | Method and device for generating reimbursement list by using credit card in enterprise resource planning (ERP) system and ERP system | |
| CN105468570B (en) | A kind of document synthesis methods of exhibiting and device | |
| CN101236637A (en) | Financial affairs system and processing method simultaneously supporting two kinds of accounting system | |
| CN101702210A (en) | ERP system as well as analysis method and device of service data in same | |
| CN114722789A (en) | Data report integration method and device, electronic equipment and storage medium | |
| CN114610801A (en) | Generation method of line and column report template | |
| CN112596806A (en) | Data lake data loading script generation method and system | |
| CN101404012A (en) | Method and apparatus for processing function interface | |
| CN101650803A (en) | Method and device for adding budget completed information and budget control system | |
| Colella et al. | Book review: Furtado, Celso (2020): The myth of economic development, Medford, MA, USA and Cambridge, UK (111 pages, Polity Press, hardcover, ISBN 978-1-5095-4013-6; softcover, ISBN 978-1-5095-4014-3; ebook, ISBN 978-1-5095-4015-0) | |
| CN117931737A (en) | Bill file splitting method and system based on multidimensional configuration | |
| CN114155071A (en) | Reimbursement receipt generation method, system and storage medium | |
| CN115794338A (en) | Service data processing method, system and storage medium for EPR system | |
| CN117350831A (en) | Data processing method and device in cross-border scene, computer equipment and storage medium |
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. |