JPH07282162A - Data processor - Google Patents

Abstract

PURPOSE:To arrange only a record matched with the output purpose on a slip just as intended image and to output if without changing a slip processing program even in the case of a person in charge of a job who is a general user or the like. CONSTITUTION:Along with the record name of an output record and the item name, item contents as record extraction conditions, a processing object item and record output conditions are specified from an input part 1. Then, the record pertinent to the specified item contents is read from a prescribed file and an extension summing-up processing part 12 sums up the data of the specified processing object item for the respective record names of the output records. A calculation/output judgement part 14 selects only the record pertinent to the specified record output conditions from the summed-up records as an output object. The selected record is made to correspond to the specified record name and item name and outputted.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a data processing device for reading and processing record data from an accounting file, a personnel file, etc. in an office computer, a personal computer or the like.

[0002]

2. Description of the Related Art Conventionally, in an office processing device such as an office computer or a general-purpose computer, an accounting file,
Various types of files such as personnel files, sales slip files, inventory files, etc. are stored and managed, but the record structure that constitutes each file is different for each file.
The same record form (records in which each item that constitutes a record matches) is collectively managed as a separate file. By the way, a record is extracted from a predetermined file, arbitrary item data is read out from the extracted record, the record is totaled, and the form creation process for outputting the totalized result together with the form form is performed in advance by an expert such as a system engineer. Is performed according to a form processing program designed to correspond to each form 1: 1.

[0003]

As described above, in the conventional art, it is necessary to previously set an individual form processing program corresponding to each form in a one-to-one manner. As it changes with time, the form processing program may not fit in reality, and it may not be possible to obtain a form that matches the business content as it is.
In such a case, in the past, a part of the form processing program created in advance was changed to deal with it, but even if some changes are made, specialized and advanced knowledge such as programming is required. It is extremely difficult for general user business personnel to change the
In the current situation, it was necessary to ask the system engineer to change the program. In addition, if the tabulation result is output unconditionally, even unnecessary records may be output depending on the business content, etc., which may make the entire form difficult to see or may cause misunderstanding. An object of the present invention is to change the form processing program without changing
In order to obtain the form desired by the business person who is a general user, simply specify the record name of the output record and its item name, as well as the item contents as the record extraction condition, the processing target item, and the record output condition. That is, based on the specified contents, only the records suitable for the output purpose can be arranged and output on the form according to the intended image.

[0004]

The means of the present invention are as follows. (1) The specifying means specifies the record name of the output record, specifies the item content as the record extraction condition, specifies the item name of the output record, and selects which item data from the extracted record. It is a key input device or the like that specifies a processing target item to be processed and further specifies a record output condition in association with an arbitrary item name of an output record. (2) The reading means reads a record corresponding to the item content designated by the designation means from a predetermined file. (3) The processing means processes the data of the designated processing target item for each record name of the output record designated by the designating means, based on the record read by the reading means. (4) In the output records processed by the processing means, the selecting means selects only those records that satisfy the record output condition designated by the designating means in association with any item, as output targets. (5) The output means outputs the output record selected by the selecting means in association with the record name and item name designated by the designating means. The specifying unit may specify the item content in association with the record name of the output record and the record output condition. Further, the designating means may designate the record output condition by using the items of the output record, the logical operator and the constant.

[0005]

The operation of the means of the present invention is as follows. Now, in order to obtain a form desired by a person in charge of business who understands the actual business, the record name of the output record (for example, the aggregated record) and its item name, the item content as the record extraction condition, the item to be processed, etc. , Specify the record output condition in association with any item of the output record. Here, for example, a case where the item content is a positive value may be designated as the record output condition. Then, a record that matches the contents of the designated item is read from the predetermined file, and processing such as tabulation is performed on the data of the processing target item for each record name of the output record. Among the output records processed in this way, only the records that meet the output conditions are selected and output in association with the record name and item name of the output record.
Therefore, in order to obtain a form desired by a business person who is a general user without changing the form processing program, the record name of the output record and its item name, as well as the item content as the record extraction condition and the processing target item By simply specifying the record output conditions, it is possible to arrange and output only the records suitable for the output purpose on the form according to the intended image based on the specified contents.

[0006]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment will be described below with reference to FIGS. FIG. 1 is a block diagram of the data processing apparatus according to this embodiment. This data processing device constitutes an office computer, and a person in charge of business who does not have specialized knowledge can simply specify the aggregation target etc. for each aggregation level using the aggregation definition table. The records corresponding to the definition contents of the table are read from a predetermined file, the records are classified and aggregated in a hierarchical structure according to the aggregation level, and the aggregation result is printed out as form data. The input unit 1 is a key input device for inputting various data and commands, and the data input from the input unit 1 is taken into a parameter setting unit 2 and processed, and a display unit 3 is provided.
Is displayed and output. The input unit 1 gives a start command to the parameter setting unit 2 in response to a predetermined key operation.

The parameter setting unit 2 operates in response to a start command from the input unit 1, and in order to instruct any record aggregation desired by a person in charge of business operation, the record name of the aggregation record, the aggregation target, the aggregation condition, etc. A definition table (in this embodiment, two types of A table and B table) that defines is generated according to the data input from the input unit 1, is displayed and output from the display unit 3, and is set in the parameter file 4. To do.
Note that Tables A and B will be described in detail later, so
A brief explanation will be given here. For example, in order to print out the “expense record table” as shown in FIG. 2 as a desired form, tables A and B are generated in advance as a summary definition table according to the output image of this form. Here, in the form shown in FIG. 2, the record name of the totalized record is arranged in the line item, and the data item name of the totalized record is arranged in the column item, and the table A defined for obtaining this form is The tables in FIGS. 3 and B are constructed as shown in FIG. A
The table shows the record name of the summary record and the item contents as the extraction conditions to be extracted as the summary record for each summary level.
It is a definition table that defines output conditions and the like of summary records. Further, the table B is a definition table that defines the item name output as the data item of the aggregate record and the item to be aggregated corresponding to the item name, the format at the time of printing the form, the aggregate condition, or the like.

In the parameter file 4, the basic formats (ruled line data, etc.) corresponding to the tables A and B are fixedly stored in advance by the maker side, and various types are arbitrarily input from the input section 1. Table A parameter data and B table parameter data of the form, and various form names and A table parameter data arbitrarily input from the input unit 1 and B
A correspondence table that correlates with the table parameter data is stored.

The table structure analysis unit 5 operates according to a start command input from the input unit 1 when printing a form, and analyzes the A table parameter data and the B table parameter data corresponding to the form name arbitrarily designated as an output target. Then, various parameter analysis tables 6 are created according to the analysis results. In this case, in the present embodiment, as the parameter analysis table 6, the A table join table as shown in FIG.
B table combination table as shown in FIG. 5B, B table condition table as shown in FIG. 5C, B table total item table as shown in FIG. 5D, and B shown in FIG. Create a spreadsheet table. Further, the table structure analysis unit 5 analyzes the hierarchical structure or the like according to the aggregation level defined in the table A, and creates the configuration file 7 as shown in FIG. 7 based on the analysis result. The configuration file 7 will be described in detail later, but various configuration records representing the correspondence between the items to be aggregated in the table A and the corresponding aggregate records, the vertical relation (parent-child relation) in the hierarchical structure of the aggregation level, and the like. If necessary, the record output condition defined in the table A is also included in this configuration record. Further, the table structure analysis unit 5 reads out the item names of the respective fields defined in the header position of the table B, for example, "expense item", "initial plan" ..., and sets them in the print format memory 8. , B, the print format of each column defined in the format position of the table is read and set in the print format memory 8. After that, the table structure analysis unit 5 gives a start command to the expansion file creation unit 9. The print format memory 8 stores, in addition to the item names and print formats defined in the table B, data for generating a form format according to the aggregation level.

The expansion file creating unit 9 refers to various table contents in the parameter analysis table 6 to specify a file to be totalized from various source files constituting the data file 10 or extract from the file to be totalized. The expansion record is sequentially generated one by one based on the record and is written in the expansion file 11. When the expansion file 11 is created in this way, the expansion file creation unit 9 gives a start command to the expansion aggregation processing unit 12.

The expansion totalization processing unit 12 refers to the configuration file 7 and sequentially creates an aggregate record for each record based on the contents of the expansion file 11 and writes it to the aggregate file 13. When the totalization file 13 is created in this way, the expansion totalization processing unit 12 gives a start command to the calculation / output determination unit 14.

The calculation / output determination unit 14 uses the totalization file 13
The table B calculation formula table is referred to for the records in the table, and the calculation processing according to the calculation formula table is performed between the record items. Then, the calculation / output determination unit 14 determines whether or not the calculated record matches the output condition of the aggregated record defined in the table A by referring to the configuration file 7, and matches the output condition. Only the record to be written is written to the output file 15 as an output target. After performing such processing on all the records in the totalization file 13, the calculation / output determination unit 14 sets the print processing unit 1
6 is given a start command. The print processing unit 16 creates a form by printing out the contents of the output file 15 from the printer 17 together with the form format record by record according to the print format set in the print format memory 8.

Next, the operation of this embodiment will be described. First,
When the input unit 1 gives an instruction to create the tables A and B in order to obtain a desired form, the parameter setting unit 2 operates in response to this. First, when creating the A table, the parameter setting unit 2 displays and outputs a table frame and the like according to the basic format of the A table read from the parameter file 4. Here, FIG.
As shown in, the alphabet letters A, B, C, D, E, and F representing the 6 levels of aggregation and the ruled line format for grouping that separates each level of aggregation are displayed. Is displayed in the column direction "offset",
This "deviation" expresses the hierarchical structure of the aggregation level. The hierarchical structure in this case has a relationship of A>B>C>D>E> F.

Now, in the state where the basic format of the table A is displayed and output, the person in charge of business inputs from the input section 1 to A.
Enter the parameter data in the table. Here, in the row heading portion of the table A, an arbitrary name is input as the record name of the totalized record corresponding to each totaling level. For example, in row No. “01”, the record name “total” is input corresponding to the aggregation level A, and in row No. “02”, the record name “fixed cost” and row No. corresponding to the aggregation level B. "03"
The record name "personnel cost" corresponds to the aggregation level C ...
Has been entered.

Further, an arbitrary file name and item name are entered in the heading section of table A. For example, in the table A shown in FIG. 3, two types of file names “plan FIL
"E" and "accounting file" are entered, and the target file name from which the total record should be extracted is defined by this. Further, the item name "budget item" is entered corresponding to the file name "plan FILE", and the item name "account item" is entered corresponding to the file name "accounting file". Target item names extracted as summary records from this file are defined. Further, specific item contents (item codes) of the items to be totaled are entered in each matrix-shaped input area formed by the heading portions in the row direction and the column direction of the table A. For example, for line No. “03”, that is, for the record name “personnel cost” corresponding to the aggregation level C, the item codes “101” and “102” are input corresponding to the “budget item” of the “plan FILE”. ,Also,
Item codes “2111”, “2112”, and “2134” are entered corresponding to the “accounting item” of “accounting FILE”. With this, the item code “101” among the budget items constituting the plan file, It is defined that records corresponding to “102” should be extracted, and the item code “211” is included in the account items that make up the accounting file.
It is defined that records corresponding to "1", "2112", and "2134" should be extracted.

Further, in the table A, condition areas are provided corresponding to the respective row numbers. In this condition area, the record output condition is input corresponding to the record name of the lowest record among the record names of the totalized records defined in the table A. This record output condition specifies the condition under which the record is selected when the calculation / output determination unit 14 selectively writes each record in the totalization file 13 to the output file 15. Is defined by the column name (alphabetic character) of table B indicating the data item position of the totalized record, comparison, logical operator, and constant (numerical value, character). When the item data of the totalized record specified by the column name of the B table matches the record output condition, the record including the item is output.
Here, the record output condition “G> =” defined in the table A
"0" indicates that when the content of the data item of the totalized record indicated by the column name G of table B is "0" or more (positive), the record including the item is the output target.

Further, the table A has a management unit area corresponding to each row No. By designating an arbitrary row and inputting a circle mark at a position corresponding to the row, an item code is input to the row. Indicates that this is an area to be covered. This is because, when the definition contents of the table A are analyzed line by line, the line marked with the circle becomes the analysis target, and the other lines are excluded from the target to improve the processing speed.
When the table A is created in this way, the parameter setting unit 2
Sets the parameter data in the parameter file 4.

Next, the parameter setting section 2 reads out the basic format of the table B from the parameter file 4 and outputs it for display. Here, as shown in FIG. 4, in the heading portion in the row direction, as the label of the row item, “format”, “target FILE”, “total item”, “calculation formula”, “condition item”, “condition value” Is fixedly set in advance, and each column item in the heading section in the column direction of the table B has “A”, “B” as names (column names) indicating its item position,
It is associated with "C", ... "G". Now, in the state where the basic format of table B is displayed and output, the person in charge of business inputs the parameter data of table B from the input unit 1. Here, in the heading portion in the column direction of table B, the item name to be printed out as the data item of the total record is input. For example, the item position "A" is "expense item", the item position "B" is "initial plan", the item position "C" is "corrected plan", the item positions "D", "E" are As a shared item, “actual product” and its subordinate items are “department expense” at item position “D”, “replacement expense” at item position “E”, and “actual volume total” at item position “F”. , "Plan difference" is entered in the item position "G".

Further, in the row item of the table B, the column width, the character type, the character size, etc. are input for each column item as the print format of the item data in "Format". Further, in the next "target FILE", "planned FILE" is input corresponding to the column item positions "B" and "C", and the column item position "D",
"Accounting FILE" is entered corresponding to "E".
Further, the next “total item” defines which item data should be totaled from the records extracted as the total target, and corresponds to the column item positions “B” and “C”, “budget amount + Is entered, and "debit amount +" and "credit amount-" are entered corresponding to the column item positions "D" and "E". Here, the plus / minus sign defines the addition total or the subtraction total when the records are totaled.

Next, in each column of the "calculation formula" corresponding to the column item positions B, C, D, ... In the table B, the calculation formula for processing the output aggregate record is input. Here, when defining that certain item data should be output as it is, it is not necessary to describe the calculation formula in the column corresponding to that item position, but when defining that certain item data should be processed. In, a calculation formula indicating the processing content is described in the column corresponding to the item position. The calculation formula uses an arbitrary column position as a variable, and is described by using this column position, a constant, and a simple operator. The column position is represented by the column item position in Table B. If the result of another formula should be referred to, the line in which that formula is entered.
No is added to the column item position. As the description of the calculation formula, the calculation formula “D + E” shown in FIG. 4 defines that the item data in the aggregation record corresponding to the column item positions D and E should be added. Further, the calculation formula "B / 1000" defines that the item data corresponding to the column item position B should be divided by "1000" and the value should be output in the unit of "thousands". Further, the calculation formula "C-F" defines that the result of the calculation formula "D + E" input to the column position F1 should be subtracted from the item data corresponding to the column item position C.

On the other hand, the plurality of "condition items" corresponding to the column item positions B, C, D ... In the table B define extraction condition items for further narrowing down the records extracted according to the definition contents of the table A. For each column item, its item name and condition value are defined corresponding to the "condition item". For example, in the illustrated table B, the column item positions “B” and “C” are the condition item name “plan type”, and the condition value of this “plan type” is “1” in the column item position “B”. , "2", "3", and "4" are input in the column item position "C".
Similarly, the column item positions “D” and “E” have “counter account” as the item name, and the column item position D as the condition value of this “counter account” has “≠ 0011 (all other codes except 0011). Is input), and the column item position “E” is “= 0011”.
(Indicating that a record having a code corresponding to 0011 should be extracted) "is input. When the table B is created in this way, the parameter setting unit 2 sets the parameter data in the parameter file 4.

Now, after creating the tables A and B, the input unit 1
If you specify an arbitrary form name from and give the print command,
First, the table structure analysis unit 5 reads the A table parameter data of the specified form from the parameter file 4 to create an A table connection table and a configuration file. Next, the table structure analysis unit 5 reads the B table parameter data of the specified form from the parameter file 4 to create a combined table of the B table, and also creates a condition table, a total item table, and a calculation formula table. Then, the format data is extracted from the parameter data in the table B and written in the print format memory 8. That is, the table structure analysis unit 5 analyzes the column heading portion of the A table and creates the A table join table as shown in FIG. Here, the A table connection table is a correspondence table that associates the file names defined in the A table with the item names, such as "file name", "sequential number SEQ", "item name", and "file symbol". Consists of. Where the sequential number SE
Q is "01" for the item name defined in the same file
It is a code to specify by serial number from, and "File symbol" is "1" for the file defined in Table A.
It is a code for specifying from the serial number.

Next, the table structure analysis unit 5 analyzes the contents of the A table parameter from the first line and creates the configuration file 7. FIG. 7 shows the record structure of the configuration file 7. This configuration record includes "child code", "parent code",
It consists of "end flag", "name", and "condition". The “child code” and the “parent code” are records that represent the correspondence between the items to be totaled in the table A and the corresponding totalized records, or the vertical relationship (parent-child relationship) in the hierarchical structure of the totaling level. Further, the "end flag" is a flag that becomes "1" when the parent code includes the aggregation level A, and when the end flag is set to "1", it is set to a higher level than that. It indicates that record aggregation is not performed. “Name” is the record name of the totalized record defined in table A. The "condition" is the content of the record output condition defined in the table A.

The table structure analysis unit 5 analyzes the contents of the A table parameter from the first row and creates the configuration file 7, and at that time, the level currently being focused on (current level) and the current level of attention. Level line data is generated from the line No. of the line (current line). For example, in the table A shown in FIG. 3, the first row of the table A is the aggregation level A and the row number is “01”.
Therefore, the level row data “A01” that combines the current level and the row No is generated, the symbol “•” is combined with this level row data “A01”, and this combined data is the parent of the first component record. Along with the code, the name of the current line (record name “total” of totalized record) is imported. Here, the symbol “·” is set when the line in the table A in which the item code is not input is set as the line of interest, which indicates that there is no correspondence with the source file. Then, paying attention to the next line, if it is the lower level, the symbol "." Is combined with the level line data "B02", and this is used as the child code of the first component record.
In this way, when the child code “· B02”, the parent code “A01”, the end flag “1”, and the name “total” are prepared as data for one record, this configuration record is written to the configuration file 7.

When the management unit area is circled as in the third line of Table A, the item code entered in the current line is specified from the beginning, and the file symbol and item This code is combined with the code and is used as the child code of the configuration record. In this case, file symbol "1"
And the item code “101” are combined, the child code becomes “1101”. In this case, the child code "1
101 ”, parent code“ · C03 ”, name“ personnel cost ”, condition“ G> = 0 ”, and the configuration record is the configuration file 7
Written out. Next, it is checked whether or not there is another item code in the current line, and if there is, the next item code "102" is designated. The configuration record in this case is child code "11.
02 ”, parent code“ · C03 ”, name“ personnel cost ”, and condition“ G> = 0 ”. On the other hand, if there is no other item code in the current line, the file symbol becomes "2" by adding "1" to the file symbol and updating the value. When the first "2111" is specified as the item code, the child code of the configuration record becomes "22111",
The parent code is “· C03”, the name is “labor cost”, and the condition is “G> = 0”.

When the construction file 7 has been created in this way, the table structure analysis unit 5 creates the join table of the B table, the B table condition table, and the total item table. Here, the B table connection table (see FIG. 5B) is the "file name",
It consists of "sequential number SEQ", "item name" of condition item, and "file symbol". The table B condition table (see FIG. 5 (C)) includes a "file name", "column position of table B", "condition value", and "negative flag". Here, the "negative flag" is a flag indicating that "≠ (not equal)" is set as the condition value. The total item table (see FIG. 5D) is composed of "file name", "column item position of table B", total item "item name", and "minus sign". Here, the "minus sign" indicates that the item name is attached with a minus sign in the total item, such as "credit amount-".

Next, the table structure analysis section 5 creates a calculation formula table. Here, the calculation formula table stores a plurality of sets of data having one set of "variable name", "calculation formula", and "value" as shown in FIG. At the same time as being set, the calculation formulas defined in Table B are set according to the execution order. Here, the variable name is a combination of the column item position of table B and the row number of the calculation formula input area in which the calculation formula is defined.

Upon completion of such table creation, the table structure analysis unit 5 activates the expanded file creation unit 9. Then, the expansion file creation unit 9 performs the expansion file creation process. The expansion file 11 is a file that is intermediately generated until the total file 13 that is the output data of the form is created. Here, FIG. 8 shows expanded records created according to the contents of the first record to the fourth record when the source file is the plan file. Also, FIG. 9 shows the expanded file 1 created by this.
The contents of 1 are shown. First, the expansion file creation unit 9 refers to the parameter analysis table 6, retrieves the file name from the A table connection table, and specifies the first record in the source file corresponding to this file name. Next, A
The item name (first item name of the first record) is fetched from the table connection table, and the item value corresponding to this item name is fetched from the designated record (first record) in the designated file. Then, this item value and the designated file symbol are combined, and this combined data is set as the classification key of the expanded record. Now, as shown in FIG. 8, the item value “101” of the budget item is extracted from the first record of the plan file, the item value “101” and the designated file symbol “1” are combined, and the combined data “1101” is obtained. Is the classification key in the first record of the expanded record.

Next, the item value corresponding to the item name of the B table connection table is extracted from the designated record. Then, the condition value corresponding to this item value is searched from the B table connection table to check whether there is a matching condition value. As a result, the position value (B in this case) corresponding to the matched condition value is set to B
The value is fetched from the table condition table, and the value of the item position matching this is searched for in the total item table. Here, since the item position B is set in the first record in the total item table, the item name “budget amount” corresponding to it is taken out, and the item value “800,00” corresponding to this item name is taken out.
"0" is taken out from the designated record, and is aggregated at the corresponding position "B" of the expansion record. In this case, if the minus sign flag is set, minus aggregation is performed, and if the minus sign flag is not set, It is added up. As a result, the first expanded record as shown in FIG. 8 is created.

Next, like the first record, the item value corresponding to the plan type of the second record is also "1", and the condition value matching this item value "1" exists in the B table condition table. , The item position “B” is fetched from the table B condition table, and the value of the item name “budget amount” corresponding to this item position “B” is fetched from the second record of the plan file. In this case, as shown in FIG. 8, “200,000” is extracted from the budget amount item of the second record of the plan file and added to the corresponding position “B” of the expanded record (second record). In the same manner, A in the parameter analysis table 6 is designated while sequentially designating the plan file record by record.
Table join table, B table join table, condition table,
The expansion record of the plan file is sequentially created one by one by referring to the tabulation item table. Next, similarly to the above, the process of sequentially generating the expansion records corresponding to the accounting file is performed.

In this way, the expansion file creating section 9 creates the expansion file 11 and then activates the expansion aggregation processing section 12. Then, the development totalization processing unit 12 creates the totalization file 13 according to the flowchart of FIG. Note that FIG. 11 is a diagram for specifically explaining the operation content of the expansion totalization processing unit 12. The expansion file creation unit 9 generates the totalization file 13 according to the parts expansion method based on the contents of the expansion file 11 and the contents of the configuration file 7. First, the expansion totalization processing unit 12 uses the expansion file 11
The data for one record is read from the beginning of (step A1). Then, at the next step A2, is the data end?
That is, it is checked whether or not all the records have been read from the beginning of the expanded file 11. At first, since the data for one record is read from the beginning of the expansion file 11, the process proceeds to the next step A3, and the configuration file 7
Is searched, and a configuration record having a child code matching the classification key is retrieved from the configuration file 7. Now, as shown in FIG. 11, the classification key in the first record of the expanded file 11 is "1101", and since the configuration file 7 has a child code matching this as shown in FIG. 7, in step A3 When that is detected, step A4
Proceed to and the record of the total file 13 (total record)
To generate. That is, in the specific example of FIG. 11, first, the expansion aggregation processing unit 12 reads the parent code corresponding to the child code “1101” from the configuration file 7, and the parent code “· C03” is the first record of the aggregation file 13. Of the child code is read from the configuration file 7 and placed in the next item of the totalized record. Following this, the data item "1,000,000" of the expanded file 11 is sequentially arranged after the next item of the totalized record. This tabulation record is row No. "0" of table A.
It is an aggregated record with the record name "personnel cost" and aggregation level "C" defined in "3", and aggregates the data corresponding to the aggregation target code defined in table A corresponding to this record name. Is. When the data of the first record of the totalization file 13 is generated by this, the generated record is written to the totalization file 13, but at this time, if a record having the same classification key already exists in the totalization file 13, It is totalized into one record and written in the totalization file 13, and if there is no record with the same classification key, the record generated this time is newly added to the totalization file 13 (step A5).

Next, it is checked whether the end flag is set at the corresponding record position in the configuration file 7 (step A6). Here, the end flag in the configuration file 7 is "1" when the aggregation level of the parent code is "A".
If the end flag is "1", the process directly returns to step A3. If the end flag is not "1", a new expansion record is generated and written in the expansion file 11 (step A7). In this case, a record as shown in FIG.
Return to. That is, if a record name at a higher level than the total record generated this time is defined in the table A, in order to aggregate the totalized result of the total record generated this time to the total record having the record name at the higher level, A new expansion record is generated and written to the expansion file 11. Here, the corresponding parent code “・ in the configuration file 7
C03 ”is arranged in the first item, and subsequently, a record formed by sequentially arranging the data read from the expansion file 11 is written to the expansion file 11. In the expanded file 11 shown in FIG. 9, the record arranged below the double line in the drawing shows the returned record. After that, the process returns to step A3, and thereafter, all the contents of the configuration file 7 are searched, and the above operation is repeated until the corresponding record is not detected. As a result, when no corresponding record is detected in step A3 and the mismatch ends, the process returns to step A1 to read the next record from the expanded file 11. Such an operation is performed for all the records of the expanded file 11. As a result, the data corresponding to the aggregation target code is aggregated in the aggregate record of the corresponding record name in table A, and if a record name at a higher level than this aggregate record is defined in table A, this aggregate record The aggregation result of is aggregated to the aggregation record of the record name at the higher level.

When the totalization file 13 is created in this way, the expansion totalization processing unit 12 activates the calculation / output determination unit 14. The calculation / output determination unit 14 operates according to the flowchart shown in FIG. First, the calculation / output determination unit 14 reads data for one record from the beginning of the totalization file 13 and designates it as a processing target (step B1). At that time, if there is no totalization record, that is, for all totalizations. When the processing of the record is completed, it is detected in step B2, and the calculation / output determination unit 1
The operation of 4 ends at this point. Now, aggregate file 1
Since the first record is read from No. 3, the calculation formula table in the parameter analysis table 6 is referenced, the calculation process is performed between the items of the record, and a new record supplemented with the necessary item values is written in the totalization file 13 ( Step B3).

FIG. 13 shows the contents of the totalization file 13 before the calculation / output determination unit 14 is activated.
The output determination unit 14 sets the value in each field of this aggregate record in the calculation formula table as the value of the corresponding variable name in the calculation formula table (see FIG. 6). As a result, in the calculation formula table shown in FIG. 6, the variable names B, C, and
D and E are set respectively. Next, each calculation formula in the calculation formula table is sequentially executed. That is, first, the values corresponding to the variable names D and E are added according to the calculation formula “D + E”, and the result is set as the variable name F1 in the calculation formula table. Next, the value of the variable name F1 is subtracted from the value of the variable name C according to the formula "C-F1", and the result is set in the formula table as the value of the variable name G2. Hereinafter, similarly, the arithmetic processing according to each calculation formula is executed to obtain each variable name B3, C3 ... G3. Then, the calculation / output determination unit 14 uses the variable names B3, C3, D3, and E.
Substituting the values corresponding to 3, F3, G3 into the corresponding fields B, C, D, E, F, G of the aggregate record to create a new record, and write this at the original position in the aggregate file 13. . As a result, the contents (first record) of the totalization file 13 shown in FIG. 12 (1) become as shown in FIG. 14 after the calculation processing.

Next, the code ".C03" placed in the first item of the totalized record just calculated is taken out as a key (step B4), and the constituent record having the corresponding parent code is constituted by the constituent file 7 To search (step B5). Since the output condition exists in this configuration record, the content of the condition is extracted (step B
6) The contents of the condition are analyzed (step B7), and it is determined whether the total record is to be output (step B8). Specifically, the true / false judgment is performed by substituting the value of the corresponding item into the conditional expression according to the reverse Polish notation. As a result, if it is "false", the process returns to step B1 to exclude this aggregated record as a processing target, and the next aggregated record is designated as a processing target. If "true", this aggregated record is output to the output file 15. It is written as an output target record (step B9).

As described above, the calculation / output determination unit 14 sequentially reads one record from the totalization file 13 and performs the calculation process and the output determination process, and outputs only the records that meet the record output conditions defined in the table A. 15
Write in. In this case, the record output condition is "B>="
0 ”, and only the aggregate record whose value is“ positive ”in the item name“ plan difference ”of the aggregate record defined in the column item position“ G ”of table B is selected and output file 1
Written to 5. This kind of operation is summarized file 13
When all the records are processed, the end of data is detected in step B2, and therefore the calculation / output determination unit 14 sorts each record in the output file 15 in ascending order according to the contents of the first item (step B10). The records of the output file 15 sorted in this way are rearranged in the print order when the form is output. Then, the calculation / output determination unit 14 activates the print processing unit 16.

Then, the print processing unit 16 takes in the contents of the print format memory 8 and, according to the print format, the contents of the output file 15 together with the form format to the printer 1.
The form is created by printing out from 7. In this case, the print processing unit 16 prints 1 from the beginning of the output file 15.
The total record is read for each record, the total level included in this total record is determined, and the name and data in the total record are printed out one by one together with the corresponding ruled line format for bundling, and the print format memory Each item name stored in 8 is sequentially taken out and printed out at the position corresponding to the form format. FIG. 2 shows an example of printing a form in this case. In the row direction, the record name of the total record is printed together with the hierarchical structure format according to the total level, and the item name of the total record is printed in the column direction. Further output file 15
The content of is printed out for each record.

As described above, in the present embodiment, in order to obtain the form desired by the person in charge of business, the table A and the table B, which are the total definition tables, are arbitrarily defined according to the output image. The contents of any record item are read from the specified file according to the contents and classified and aggregated, and the aggregated results are printed in the order of the definition and in the hierarchical structure according to the aggregation level. Even the person in charge can easily obtain the desired form. In particular, since only the totalized records that match the record output conditions defined in the table A are output as the form, it is possible to obtain the form that is suitable for the output purpose. In this case, if the record output conditions are finely defined, the output records can be narrowed down finely.

In the above embodiment, "G> = 0" is taken as an example of the record output condition, but the record output condition may be defined by a logical sum, a logical product or a range specification. Further, the record output condition may be defined in association with a plurality of items. On the other hand, in the above embodiment, the tables A and B are defined separately and independently, but the tables A and B may be defined simultaneously on the same screen. Further, in the above embodiment, the item code is input at an arbitrary intersection position on the matrix constituted by the heading section of the table A, but the item name may be input.

[0040]

According to the present invention, in order to obtain a form desired by a business person who is a general user without changing the form processing program, record extraction is performed together with the record name of the output record and its item name. By simply specifying the item contents as the condition, the process target item, and the record output condition, only the records that match the output purpose based on the specified contents are arranged and output on the form as intended image Therefore, it is not necessary to ask a specialist such as a system engineer to create a program as in the conventional case, and anyone can easily obtain a desired form, which is extremely practical.

[Brief description of drawings]

FIG. 1 is a block configuration diagram of a data processing device according to an embodiment.

FIG. 2 is a diagram showing a printout example of a form.

FIG. 3 is a diagram specifically showing the contents defined in table A.

FIG. 4 is a diagram specifically showing the contents defined in table B.

5 is a table A join table, a table B join table obtained by analyzing the tables A and B shown in FIG. 3 and FIG.
The contents of the B table condition table and the B table total item table are concretely shown. (A) is the A table join table, (B)
Is a B table join table, (C) is a B table condition table,
FIG. 6D is a diagram showing a B-table tabulation item table.

FIG. 6 is a diagram showing a calculation formula table obtained by analyzing Table B.

FIG. 7 is a diagram showing the specific contents of a summary file 13.

FIG. 8 is a diagram showing an expansion record created based on the record contents of the plan file when the source file is the plan file.

FIG. 9 is a diagram concretely showing the contents of a development file 11.

FIG. 10 is a flowchart showing a deployment tabulation process by a deployment tabulation processing unit 12.

11A and 11B are diagrams specifically showing the operation contents of the development and aggregation processing, in which FIG. 11A shows a development file, and a diagram showing how aggregation records are generated from a configuration file, and FIG. The figure which showed the expansion record.

FIG. 12 is a flowchart showing calculation / output determination processing by the calculation / output determination unit 14.

FIG. 13 is a diagram showing the contents of a summary file 13 before the calculation / output determination unit 14 is activated.

FIG. 14 is a diagram showing the contents of a summary file 13 after calculation processing is performed by a calculation / output determination unit 14.

FIG. 15 is a diagram showing the contents of an output file 15 created by a calculation / output determination unit 14.

[Explanation of symbols]

 1 Input Section 2 Parameter Setting Section 3 Display Section 4 Parameter File 5 Table Structure Analysis Section 6 Parameter Analysis Table 7 Configuration File 8 Print Format Memory 9 Expanded File Creation Section 10 Data File 11 Expanded File 12 Expanded Aggregation Processing Section 13 Aggregated File 14 Calculation / Output determination unit 15 Output file 16 Print processing unit 17 Printer

Claims (1)

[Claims] 1. A record name of an output record is specified, an item content as a record extraction condition is specified, an item name of an output record is specified, and which item data is to be processed from the extracted record. Whether or not to specify the item to be processed, and further to specify a record output condition in association with an arbitrary item name of the output record, and a record corresponding to the item content specified by the specifying unit. Reading means for reading from the file; and processing means for processing the data of the designated processing target item for each record name of the output record designated by the designating means on the basis of the record read by the reading means. Of the output records processed by the processing means, the records designated by the designation means in association with any item Selecting means for selecting only records corresponding to the output condition as output targets, and outputting means for outputting the output record selected by the selecting means in association with the record name and item name designated by the designating means. A data processing device comprising: