JPH0785176A - Data processing unit - Google Patents

Abstract

PURPOSE:To output a slip as an intended image based on a designated content by only designating record extract condition and a tabulation object item or the like in order to allow a person in charge of a job being a general user to obtain a desired slip without revision of a slip processing program. CONSTITUTION:A table structure analysis section 5 analyzes a tabulation definition table to generate various tables and configuration files and sets a print form to a print form memory 8. An expansion file generating section 9 references the content of the table to extract a predetermined record from a source file and to generate an expansion file. An expansion tabulation processing section 12 references the configuration file to generate a tabulation file from the expansion file. A print processing section 14 references the print form memory 8 to print out the content of the tabulation file.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a data processing apparatus for reading record data from an accounting file, a personnel file, etc. and totaling the data 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. An object of the present invention is to simply specify record extraction conditions, items to be totaled, etc. in order to obtain a form desired by a business person who is a general user without changing the form processing program. It is to be able to output the form according to the intended image based on the specified contents.

[0004]

The means of the present invention are as follows. (1) The designating means designates an item name output as a data item of a summary record, designates a summary item to be associated with each item name, and designates a plurality of items as condition items for record extraction. Further, it is a key input device or the like that specifies the extraction condition for each condition item. (2) The extraction unit extracts from the predetermined file a record that matches all of the plurality of extraction conditions designated by the designation unit in correspondence with each item name. (3) The reading means reads the item data corresponding to the totaling target item designated by the designating means from the records extracted by the extracting means. (4) The totaling means totals the item data read by the reading means for each item name designated by the designating means. (5) The output unit is a printer device or the like that outputs the records totaled by the totaling unit according to the arrangement order of the item names designated by the designating unit.

[0005]

The operation of the means of the present invention is as follows. Now, in order to obtain the form desired by the person in charge of business who understands the actual business, the item names that are output as the data items of the total record are specified, and the items to be totaled are associated with each item name. Along with the designation, a plurality of items are designated as condition items for record extraction, and further, extraction conditions are designated for each condition item. Then, a record that matches all of the plurality of extraction conditions specified corresponding to each item name is extracted from the predetermined file, and the item data corresponding to the item to be totalized is read from this extracted record. Records are aggregated according to the order in which the designated item names are arranged.
Therefore, without changing the form processing program, in order to obtain the form desired by the business person who is a general user, simply specify the record extraction conditions, the items to be totaled, etc. You can output the form exactly as you intended.

[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 3 and B are structured as shown in FIG.
The table is a definition table that defines, for each aggregation level, the record name of the aggregation record and the content of items extracted as the aggregation record. Further, the table B is a definition table that defines the item names output as the data items of the totalized record and the output target items extracted as the data items corresponding to the item names, the format at the time of printing the form, the totaling conditions, and 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.
In addition to the B table join table as shown in FIG. 5B, the B table condition table as shown in FIG. 5C, the B table total item table as shown in FIG. Create a formula 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 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. It consists of 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 instruction to the print processing unit 14. The print processing unit 14 prints out the contents of the totalization file 13 from the printer 15 one record at a time in accordance with the print format set in the print format memory 8 together with the form format, thereby creating a form.

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 basic format of table A is alphabetical characters A, B, C, D, E, F, which represent the 6 levels of aggregation as the heading portion in the row direction, and a ruled line format for grouping that separates each aggregation level. Is displayed, and the ruled lines for bundling are displayed "shifted" in the column direction for each aggregation level,
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. Here, the record name of the summary record is entered in the row item of table A in association with the summary level, and
In the column direction, the file name to be totaled and the item name to be extracted as a totalized record from the file are input. A part of the basic format of the table A can be modified and changed as appropriate, and the entire table frame can be expanded or contracted.

Now, in the state in which 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. In the above example, an arbitrary record name is directly input from the input unit 1 for each aggregation level. However, if the record name to be used is predetermined, these record names to be used are stored in the table. Alternatively, when the record name is input, the table contents may be displayed in a list on the window screen, and the record name may be input by selecting an arbitrary record name from the list. Further, the record name is not limited to the name and may be a code.

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 to be extracted as summary records 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 expenses” corresponding to the aggregation level C, “Plan FI
Item code "10" corresponding to "budget item" of "LE"
"1" and "102" are entered, and "Accounting FILE"
Item code “2111” corresponding to “Account”
"2112" and "2134" have been entered, which defines that records corresponding to the item codes "101" and "102" should be extracted from the budget items constituting the plan file. Of the account items that make up the file, item codes "2111" and "211"
It is defined that records corresponding to "2" and "2134" should be extracted.

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 inputted 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. At the same time, it also makes sense that the person in charge of business confirms that the data to be extracted and aggregated is in the source file (accounting file, etc.). In addition, in the table A shown in FIG. 3, an example in which two types are input as the file name is shown, but three or more types may be input, and one item name corresponds to one file name. However, it is also possible to input two or more item names in association with one file name. 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 unit 2 reads 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” , “Condition item”, and “condition value” are fixedly set in advance, and each column item in the heading section in the column direction of table B has “A” and “B” as names indicating the item position. , “C”, ..., “G”. Similar to the table A, in the table B, a part of the basic format can be appropriately modified and changed, and the entire table frame can be expanded or contracted.

Now, in the state in which the basic format of the table B is displayed and output, the person in charge of business operations inputs from the input section 1 to the B
Enter the parameter data in the table. 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" in item position "G"
Has been entered.

In the row item of 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, a 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, a plurality of "condition items" corresponding to the column item positions B, C, D ... of Table B define extraction condition items for further narrowing down the records extracted according to the definition contents of Table A. In this embodiment, 2 for each row item.
The item name and condition value can be defined for each type of "condition item". For example, in the illustrated table B, the column item positions “B” and “C” have “plan type” entered as the first condition item name and “fiscal year” entered as the second condition item name. As the condition value of “plan type”, “1” is input to the column item position “B”, “2”, “3”, and “4” are input to the column item position “C”,
In addition, the column item position “B” is set to “1” as the condition value of “year”
"992" is input, and "1" is entered in the column item position "C".
"993" has been entered. Similarly, in the column item positions "D" and "E", "counterpart account" is entered as the first condition item name and "fiscal year" is entered as the second condition item name. As a value, “≠ 0011 (indicating that records having all other codes except 0011 should be extracted)” is input to the column item position D, and “= 0011 (is indicated to the column item position“ E ”. "Indicating that a record having a code corresponding to 0011 should be extracted)" is input, and "1992" is input to the column item position "D" as the condition value of "year". “1993” is input to “E”. As shown in FIG. 4, the condition value input area corresponding to the first condition item is divided into three lines, and the condition values can be input in a one-to-one correspondence with each line. ing. In this way, when a plurality of condition values are input to one condition item, the record extraction condition of that item means a logical sum (or condition), but the condition value of the first condition item and the second condition value The logical product (a
nd condition). In this way, if the item name and the condition value are respectively defined corresponding to a plurality of “condition items” provided for each column item in the table B, the definition contents will be set as the preprocessing for starting the record aggregation. The records to be totaled are narrowed down based on this. In other words, records that match a plurality of condition values (records that match a logical product of condition values) for each column item of table B are extracted as the aggregation target. When the table B is created in this way, the parameter setting unit 2 sets the parameter data in the parameter file 4.

After the tables A and B are created in this way, when an arbitrary form name is designated from the input section 1 and a print command is given, the table structure analysis section 5 follows the flowchart shown in FIG. Operate. Note that FIG. 6 shows the table structure analysis unit 5
In the general flow showing the outline of the overall operation of the table structure analysis unit 5, first, the table structure analysis unit 5 reads the designated form A from the parameter file 4.
The table parameter data is read to create a table A connection table (step A1) and a configuration file is created (step A2). 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 (step A3), a condition table (step A4), and a total item table (step A5). ), Formula table (step A
Create 6) respectively. Then, the format data is extracted from the parameter data in Table B and written in the print format memory 8 (step A7).

FIG. 7 shows a flow of creating the A table join table. The table structure analysis unit 5 analyzes the column direction heading portion of the A table to analyze the A table join table as shown in FIG. 5 (A). To create. Here, the A table connection table is a correspondence table that associates the file names defined in the A table with the item names. The "file name" and "sequential number SE
It consists of "Q", "item name", and "file symbol". Here, the sequential number SEQ is a code for specifying the item names defined in the same file by consecutive numbers from "01", and the "file symbol" is the file defined in the table A. It is a code for specifying "1" by a serial number. First, the table structure analysis unit 5 reads the table A parameter data of the specified form from the parameter file 4 (step B1), and specifies the initial value "1" as the file symbol (step B2). And A
The heading portion in the column direction of the table is sequentially analyzed from the beginning. That is, the table structure analysis unit 5 first specifies the first file name defined in the table A (step B3), then specifies the initial value "1" of the sequential number SEQ (step B4), and further The first item name corresponding to the first file name is designated (step B5). The file name, the sequential number SEQ, the item name, and the file symbol designated by this are written in the A table connection table (step B6). In this case, if the table A shown in FIG.
Data as shown in FIG. 5A is written in the first row of the table combination table. Next, if another item name is defined corresponding to the same file name (step B7), "1" is added to the sequential number SEQ to update the value (step B8), and next. Item name is designated (step B5), and writing to the table A connection table is performed (step B6). Hereinafter, the above operation is repeated until all the item names corresponding to the same file name are designated. As a result, when all the item names have been specified, the next step B
If there is another file name in the table A, the file symbol "1" is added under that condition and the value is updated (step B10). After that, returning to step B3, while writing the other file name from the table A and sequentially designating all the item names corresponding to the file name, writing to the table A connection table is performed.

Next, the process of creating the configuration file 7 shown in FIG. 6 (step A2) will be described in detail with reference to FIGS. 8 to 10 are flowcharts showing the operation when creating the configuration file 7, FIG. 11 is a diagram schematically showing the operation content of the table structure analysis unit 5 in this case, and FIG. 12 is It is a figure showing composition file 7 created. Note that FIG. 11A shows the record structure of the configuration file 7, and this configuration record consists of "child hood", "parent code", "end flag", and "name". And “parent code” are records showing the correspondence between the items to be totalized in the table A and the corresponding totalized records, and 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. First, the table structure analysis unit 5 specifies the first row of the A table parameter (step C1), and checks whether the totaling level of the specified row is the highest level A (step C2). here,
If the aggregation level is A, the final item work memory in the table structure analysis unit 5 for initial setting (see (B) of FIG. 11)
While clearing all the contents of (Step C3),
Aggregation level A as the level currently being focused on (current level)
Is designated (step C4). In this state,
Level line data is generated from the current level and the line number of the line of interest (current line) (step C5). For example, taking the table A shown in FIG. 3 as an example, the first row of the table A is the aggregation level A, and the row number is "01". Therefore, the level row combining the current level and the row number is shown. Data “A01” is generated. Next, the level line data “A01” and the name of the current line (record name “total” of the totalized record) are set at the position corresponding to the current level A of the final item work memory (step C6). As shown in FIG. 11B, the final item work memory is configured to store level line data and names corresponding to the aggregation levels A, B, C, D ... Is the work memory of.

Next, it is checked whether or not the management unit area of the current line is circled (step C7). Now, as shown in FIG. 3, since the first row is not marked with a circle, attention is paid to the next row of table A to check whether or not a record name is set in that row (step C8). When the setting is detected, the current line is updated and the next line is designated (step C9). When the second row of the A table is designated by this, the process then returns to step C2. In this case, the totaling level of the second row is B, and therefore step C1.
The process proceeds to 0, and an error check is performed to see if the level of the specified line exceeds the current level. If the level is exceeded, all contents below the level of the specified line are cleared in the last item memory (step C11).

Since the designated row level B is now lower than the current level A, the flow advances to step C12 to update the current level with the designated row level as the current level. Next, level line data is generated from the current level and the line number of the current line (step C13), and the level line data and the name of the current line are set at the position corresponding to the current level of the final item work memory ( Step C14). In this case, the level row data “B02” and the name “fixed cost” are set at the position corresponding to the current level B (see FIG. 11B).
Next, a symbol (•) is combined at the beginning of this level row data (step C15), and this combined data is shown in FIG.
It is set as a child code of the configuration record as shown in (step C16). Here, the symbol (•) is set when the line of the table A in which the item code is not input is the line of interest, which indicates that there is no correspondence with the source file. Then, proceeding to step C17 in FIG. 9, the level line data stored at the level position (current level + 1) is read out from the last item work memory, and the symbol (•) is combined at the beginning of this level line data. , This combined code is set as the parent code of the configuration record (step C18). Now, the current level is B, and thus the combined code in which the symbol (•) is combined with the level row data “A01” stored at the position of the final item work memory at level A becomes the parent code ((A) in FIG. 11). reference). Here, if the level of the parent code is A (step C19), "1" is set to the end flag of the configuration record (step C20). Next, the name of the parent code is read from the last item work memory and set as the name of the configuration record (step C21).
In this way, when the child code ".B02", the parent code ".A01", the end flag "1", and the name "total" are prepared as the data for one record, this configuration record is written to the configuration file 7. (Step C22).

Next, returning to step C7 of FIG. 8, in this case, since the management unit area of the current row is not marked with a circle, the third row of the next row is designated (step C9).
After that, as a result of the above steps C12 to C14 being executed, the level line data is stored in the level C of the last item work memory.
The data “C03” and the name “personnel cost” of the current line are set (see (B) of FIG. 11). Then, the join code in which a symbol (•) is added to this level line data is the child code of the configuration record.
Is set as a mode (steps C15 and C16). Next, the level row data "B0" read from the level B position (the level position one step higher) in the last item work memory.
The combination code with the symbol (.) Attached to "2" is set as the parent code of the configuration record (step C1 in FIG. 11).
7, C18). In this case, the name "fixed cost" in the last item work memory corresponding to the parent code becomes the name of the constituent record (step C21). In this way, child code ".C03" and parent code ".
When "B02" and the name "fixed cost" are available, this configuration record is written to the configuration file 7 (step C22).

Subsequently, when it is detected in step C7 in FIG. 8 that the management unit area on the third line is circled,
In step C23 of FIG. 10, "1" is set as the initial value of the file symbol. Next, specify the item code entered in the current line from the beginning (step C
24), the file symbol and the item code are combined and this combined code is set as a child code of the constituent record (steps C25 and C26). In this case, since the file symbol "1" and the item code "101" are combined, the child code becomes "1101". Next, a symbol (•) is added to the beginning of the level line data of the current level in the last item work memory.
Are combined (step C27), and this combined data is set as the parent code of the constituent record (step C2).
8). Then, the name "personnel cost" of the parent code is read from the last item work memory and set as the name of the constituent record (step C29). FIG. 11C shows a configuration record in this case, in which the child code is "110".
1 ", the parent code is" .C03 ", and the name is" personnel expenses "is written to the configuration file 7 (step C30). Next, it is checked whether another item code is entered in the current line (step C31), and if there is, the process returns to step C24, the next item code is designated, and the above operation is performed. repeat. As a result, when the item code "102" in the third line is specified, the constituent code is "1102" for the child code and ".C0" for the parent code.
3 ”and the name is“ Personnel expenses ”.

After that, since no item code is detected in step C31, the flow advances to step C32 to check whether another file name is defined in the A table. File name of "accounting FILE"
Is defined, the process proceeds to step C33, "1" is added to the file symbol to update the value, and then the process returns to step C24. In this case, the file symbol is "2",
Since the first "2111" is specified as the item code,
The child code of the configuration record is "22111", the parent code is ".C03", and the name is "personnel expenses". Now
If no other file is specified in step C32, the process returns to step C8 in FIG. 8 and the process of creating a configuration record and writing it to the configuration file 7 is repeated until one setting is detected in step C8. -Repeat each one. As a result, the configuration file 7 as shown in FIG. 12 is created.
The contents of the configuration file 7 are generated by referring to the table A in FIG.

When the construction file 7 has been created in this way, the table structure analysis unit 5 creates the formula table in addition to the join table of the B table, the B table condition table, the total item table. To do. Of these, B table connection table, condition table,
The total item table is created according to the flowcharts shown in FIGS. Here, B table connection table
The bull (see FIG. 5B) is composed of a “file name”, a “sequential number SEQ”, a condition item “item name”, and a “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. In addition, the total item table (see FIG. 5D) includes “file name”, “column item position of table B”, “item name” of total item,
It consists of "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-".

First, the table structure analysis unit 5 reads the B table parameter data of the specified form from the parameter file 4 (step D1) and specifies the second column (item position B) thereof (step D2). Next, the target file name in the designated column is called (step D3), and the file symbol corresponding to this file name is called from the table A connection table (step D4). Then, in the next step D5, the initial value "1" of the sequential number SEQ is set, and then it is checked whether or not the item name is set by paying attention to the condition item in the designated column (step D6), and it is set. If so, the condition item name is designated (step D9). File name and sequential number SE obtained by this
After generating a join record from Q, the condition item name, and the file symbol (step D10), this join record is set in the B table join table. At that time, in order to avoid duplicate setting of the same record, the B table join table On condition that the same record is not set (step D1
1) The generated join record is set in the B table join table (step D12).

Next, paying attention to the condition value of the designated column, the condition value is specified (step D13), and if "≠" is added to this condition value (step D14), a negative flag is set. (Step D15). The file name obtained in this way, the column name indicating the item position of the specified column,
A condition record is generated from the condition value and the negative flag (step D16) and set in the condition table of table B (step D17). Here, if multiple condition values are defined in the specified column, a condition record is generated for each condition value.
In step D18, it is checked whether or not there is another condition value, and if there is another condition value, the process returns to step D13, the next condition value is designated, a corresponding condition record is generated and set in the condition table. Then, in the next step D19, it is checked whether or not there is another condition item in the designated column, and if there is another condition item, the process proceeds to step D20, where "1" is added to the sequential number SEQ to update the value. , Step D9
Then, the next condition item is designated, and thereafter, the corresponding join record is generated, or the condition record is generated and set in the correspondence table.

If no other condition item is detected in step D19, the flow advances to step D21 to specify a condition item in the designated column, and if a minus sign is added to the condition item (step D22), a minus sign. The flag is set (step D23). The file name and the column item position of the designated column thus obtained are generated from the column name, the tabulation item and the minus sign flag (step D24) and set in the tabulation item table (step D25).

After the definition contents for one column of the B table are analyzed and the B table connection table, the B table condition table and the total item table for one column are created in this way, the process proceeds to step D7
It is checked whether data is specified in the next column of the table, and if there is, the line is specified (step D8), and then the process returns to step D3 to create the table while analyzing the definition contents of table B line by line. repeat.

In this case, in the B table join table shown in FIG. 5B, the first record and the second record thereof are join records obtained by analyzing the definition contents of the column item position B of the B table. , That is, this column item position B
Since two types of condition item names are defined in, the combined record is generated correspondingly. In this case, the first record of the sequential number SEQ is "01",
The second record is "02", and the condition item name is 1
The record number is "plan type" and the second record is "fiscal year". Although two types of condition item names are defined in the column item position C in the B table, the combined record obtained by analyzing this is the same as the first record and the second record, and the duplicate setting In order to avoid the above, the table B join table is not set. Similarly, the third record and the fourth record of the B table combination table are the combined records obtained by analyzing the column item position D of the B table. On the other hand, in the B table condition table shown in FIG. 5C, the first record and the second record are condition records obtained by analyzing the definition contents of the column item position B of the B table, and 3 records. The sixth to sixth records are condition records obtained by analyzing the definition content of the column item position C in the B table. Further, the seventh record and the eighth record are column item positions D, the ninth record and the tenth record are Column item position E
It is a condition record obtained by analyzing the definition content of. In this case, since "≠" is added to the condition value of the condition item name "counter account" at the column item position D, "1" is set to the negative flag in that record.

Next, when the table structure analysis unit 5 finishes creating the B table join table, the B table condition table, and the total item table as described above, it analyzes the B table parameter data and creates a calculation formula table. However, in this calculation formula table, each calculation formula is associated with the column item position. Further, the table structure analysis unit 5 reads out the format data from the B table parameter data in association with the column item position and sets it in the print format memory 8.

Upon completion of such table creation processing, the table structure analysis unit 5 activates the expanded file creation unit 9. Then, the expansion file creating unit 9 performs the expansion file creating process according to the flowcharts shown in FIGS. 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. 17 shows the expansion record created according to the contents of the first record to the fourth record when the source file is the plan file, and FIG. 18 shows the one record when the source file is the accounting file. The expanded record created according to the contents of the third to third records is shown. Further, FIG. 19 shows the contents of the expanded file 11 created by this. Now, in the parameter analysis table 6, FIG.
It is assumed that various tables having the contents shown in (D) are set.

First, the expansion file creating section 9 refers to the parameter analysis table 6 to extract the file name (first file name of the first record) from the A table connection table (step E1) and designates the file symbol. (Step E2). Next, the source file corresponding to this file name is designated (step E3), and the first record in this source file is designated (step E).
4). As a result, the top record of the "plan file" first defined in the table A is designated as the file to be totaled. Next, the item name (initially, the item name of the first record) is fetched from the table A connection table (step E5),
The item value corresponding to this item name is fetched from the designated record (first record) in the designated file (step E6). Then, this item value and the designated file symbol are combined (step E7), and this combined data is set as the classification key of the expanded record (step E8). Now
As shown in FIG. 17, the item value "101" of the budget item is extracted from the first record of the plan file, and the item value "1"
01 "and the designated file symbol" 1 "are combined, and this combined data" 1101 "becomes the classification key in the first record of the expanded record.

Next, in order to check whether or not the output target item in the first record of this plan file is a record that meets the extraction conditions defined in the B table, first, the expansion file creating section 9 joins the B table. The table is referred to, and it is checked whether or not the designated file symbol is present in this table (step E9). Here, if the condition item name is defined in the B table as described above, the file name, condition item name, file symbol, etc. are set in the B table connection table. Therefore, the fact that the file symbol is not set means that the condition item is not defined in the table B (that is, the extraction condition of the output target item is not set). Since the designated file symbol "1" is set in the B table connection table, step E1
Go to 0 and read the first condition item name (condition item name with sequential number SEQ "01") and file name from the combined record in which this specified file symbol is set, and correspond to this condition item name. Retrieve the item value (item data) to be specified from the specified record. In this case, the item value “1” of the “plan type”, which is the first condition item name, is extracted from the first record. Then, the condition value that matches the item value with the same file name is searched from the table B condition table (step E11), and it is checked whether there is a matching condition value (step E12). Since the item value "1" of the plan type included in the first record exists in the first record in the B table condition table, the process proceeds to the next step E13 and the negative flag in the corresponding B table condition table. Check if is set.

In this case, since the negative flag is not set, the routine proceeds to step E19, where the second condition item name corresponding to the designated file symbol from the table B connection table (condition item having the sequential number SEQ "2") Name) and the file name, and the item value corresponding to this conditional item name is retrieved from the specified record. In this case, the item value “1992” of the second condition item name in the year from the first record
Is taken out. Then, with the same file name, a condition value that matches this item value is searched in the table B condition table (step E20), and it is checked whether there is a matching condition value (step E21). Since the year item value “1992” contained in the first record exists in the second record in the table B condition table, the process proceeds to step E22, and the value at the position corresponding to the matched condition value (in this case, B) to B
The value is fetched from the table condition table, and the value at the item position matching this is searched in the tabulation item table (step E2
3) Specify the item name corresponding to this (step E2)
4). 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,000" corresponding to this item name is specified. At the same time as taking out from the record (step E25), it is checked whether or not the minus sign flag is set in the total item table corresponding to this item position B (step E26). Next, in step B27, the item value “800,000” extracted from the designated record is set to the corresponding position “B” in the expansion record.
In this case, in the case where the minus sign flag is set, the minus aggregation is performed, and in the case where the minus sign flag is not set, the plus aggregation is performed. As a result, the first expanded record as shown in FIG. 17 is created. Thus, the first and second
If the record matches the condition value of the condition item name, the data of the item to be totaled is read from that record and totaled at the corresponding position of the expanded record.

Next, it is checked whether another same item position (B in this case) is set in the total item table (step E28), but as shown in FIG.
For the accounting file, the same item positions D and E are set in two places in the tabulation item table in correspondence with the item names "debit amount" and "credit amount", respectively, but the plan file has a plurality of the same item positions. Since it has not been set, the routine proceeds to step E14, where it is checked whether or not there is another condition value of the same file name that matches the record item value corresponding to the first or second condition item name in the table B condition table. Since there is no other record in the table B condition table, the process proceeds to step E15, and the next record is specified on condition that the next record exists in the specified plan file (step E18).

As a result, the second record of the plan file is designated, the process returns to step E5, and the above operation is repeated. In this case, the file code "1" and the budget item value "102" of the second record generate the classification key "1102" of the expanded record in the second record (steps E5 to E8). Further, as in the case of the first record, the item value corresponding to the plan type of the first condition item name is also “1” in the second record, and this item value “1”
Since the condition value that matches with exists in the table B condition table, and the negative flag is not set correspondingly,
Go to step E19. In this case, the item value corresponding to the year of the second condition item name is "1992", and the condition value matching this item value also exists in the B table condition table.
The item position "B" corresponding to these is taken out from the table condition table, and the value of the item name "budget amount" corresponding to this item position "B" is taken out from the second record of the plan file (steps E22 to E25). In this case, as shown in FIG. 17, “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). Step E27).

Next, the third record of the plan file is designated (step E18). As a result, the classification key “1103” of the expansion record (third record) is generated. In this case, the item value of the plan type of the third record read from the plan file is "2", the item value of the fiscal year is "1993", and the condition value that matches each item value is the B table condition. Each is set in the table,
The item value that matches this condition value is “C”. Therefore, the item value “400,000” of “budget amount” extracted from the third record of the plan file is the expanded record (3
It is added up to the corresponding position "C" in the (record).

Further, when the fourth record of the plan file is designated, the expanded record (4
In the item position “C” of (record record), the item value “50,00” of the budget amount extracted from the fourth record of the plan file
"0" is added up. The classification key of this expansion record is "1104". Similarly, while sequentially designating the plan file one record at a time, referring to the A table join table, the B table join table, the condition table, and the total item table in the parameter analysis table 6, the expansion record of the plan file is set to 1 Create records one by one.

If it is detected in step E9 that the designated file symbol is not set in the B table join table, the condition item is an unconditional item that is not defined, so the process proceeds to step E34. Without referring to the definition contents of the B table condition table, the same file name as the designated file is directly searched in the tabulation item table, and thereafter, the process returns to step E24.

As a result of performing such an operation one record at a time, when all the records in the designated file have been designated, and no next record is detected at step E15, step E
Proceed to step 16 and check whether another file is defined in the table A join table. Now, since the accounting file is defined as another file in the table A combination table, the process returns to the first step E1 and the processing for sequentially generating the expanded records corresponding to the accounting file is performed as described above. . That is, "accounting file" is taken out as a file name from the table A combination table (step E1), and "2" is designated as the file symbol (step E2). Then, the accounting file is specified as the source file corresponding to this file name (step E
3) Specify the top record (step E)
4).

In this state, the item value "2111" of the "account title" of the designated record and the file symbol "2" are combined to generate the classification key "22111" of the expanded record in the first record (steps E5 to E5). E8). Then, the process proceeds to step E9. In this case, since the file symbol "2" is stored in the B table connection table, B
The item value corresponding to the item name "counterpart" of the table combination table is taken out from the first record of the accounting file (step E10). Since "0011" is taken out as the item value of "counter account" from the first record of the accounting file, the condition value matching this item value is retrieved from the B table condition table (step E11). In this case, since the corresponding condition values are set on the 7th and 9th lines in the table, a match is detected at step E12 and the process proceeds to step E13. Attention is paid to the first 7th line. Then
Check whether the negative flag is set in the corresponding position. Now, since the negative flag is set in the 7th line of the B table condition table, the process proceeds to step E14, and there is another condition value in the B table condition table that matches this item value "0011". I will check if there is, but now, B
Since the condition value "0011" is present on the ninth line in the table condition table, the process returns to step E13. Now, since the negative flag is not set at the position corresponding to this condition value, the routine proceeds to step E19. In this case, the item value corresponding to the year of the second condition item name is "1993", and the condition value matching this item value also exists in the B table condition table. The item position "E" corresponding to these is taken out, and the item name in the total item table which matches this item position "E" is designated (steps E22, E24). In this case, the total item table Of the item positions "E" set on the fifth and sixth lines, the first item position, that is, the item name "debit amount" corresponding to the fifth line is designated. Then, the item value "50,000" corresponding to the designated item name from the first record of the accounting file is added up to the corresponding position "E" of the expansion record in the first record of the accounting file ( Steps E25 to E2
7).

Then, the process proceeds to step E28. In this case, since the same item position "E" exists on the sixth line as well as the fifth line in the totalized item table, step E24.
Then, the item name "credit amount" corresponding to the item position in the total item table is designated, and the item value corresponding to the designated item name is taken out from the first record of the accounting file (step E25). . In this case, "0" is taken out as the item value of the credit amount from the first record of the accounting file, and is aggregated in the corresponding position "E" of the first record of the expansion record. Since the minus sign flag is set in the sixth line of the total item table, negative total, that is, (previous debit amount "50,000" -current credit amount "0") is calculated. It is performed (step E27). Then, the process proceeds from step E28, E14, E15 to step E18, and the second record of the accounting file is designated.

As a result, the expansion record is generated corresponding to the second record of the accounting file. In this case, the item value of the account item is also "2111" and is the same as the first record. The classification key is “22111”. Also, the counter account for the second record is "0011", and the item value for the year is "1993", which matches the item condition values, so the debit amount "0" is the expansion record. Item position E is added up and the credit amount is "40,00".
"0" is negatively added up to the item position E. Therefore,
The item position of the expansion record of the second record is "-40,
000 ”is written.

Next, the third record of the accounting file is specified. The item value of this counter account is "0010", and B
Since the condition value corresponding to this is not set in the table condition table, the process proceeds from step E12 to step E2 to check whether the negative flag is set corresponding to the specified file in the B table connection table. To check. Now, since the negative flag is set in the B table condition table corresponding to the accounting file on the 7th line, the process proceeds to step E30, where the second table corresponding to the designated file symbol from the B table connection table is set. The condition item name and the file name are read, and the item value corresponding to this condition item name is extracted from the specified record. In this case, the item value of the year from the first record is "199
2 "is taken out. Then, with the same file name, a condition value that matches this item value is searched in the table B condition table (step E31), and it is checked whether there is a matching condition value (step E32). Now, since a match is detected, the routine proceeds to step E33, where the value "D" at the position where the negative flag is set is fetched from the B table condition table,
The position corresponding to this value is searched from the tabulation item table (step E23), the item value "800,000" corresponding to the item name "debit amount" is retrieved from the third record, and the expansion record is obtained. Add to the corresponding position D of D. After that, the process returns from the step E28 to the step E24, and the item value "0" of the next item name "credit amount" is negatively added to the expansion record position "D" as in the above. After that, the next record is designated, and the same operation as described above is repeated one record each time a mismatch is detected in step E12. As a result, the condition value “≠ 0” of the condition item “counterpart”
The expansion records according to "011" are sequentially generated.

Then, when all records of the accounting file have been designated and no next record is detected in step E15, the process proceeds to step E16, and there is another file in the table A connection table. In this case, since the absence of a file is detected, the process proceeds to step E17, and the expansion record editing process is performed. That is, the development records having the same classification key are extracted, and these are extracted as one record.
Each development record is sorted in ascending order according to the classification key. For example, as shown in FIG.
The development records of the first record and the second record have the same classification key, so they are combined into one development record, and the value of the item position "E" is "10,000". It will be. FIG. 19 shows the expansion file 1 created as described above.
The contents of 1 are shown. That is, the expansion file 11 created according to the contents of the plan file and the accounting file
The record structure has items A, B, C, D, E, and F, and the first item A is a classification key.

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. 21. FIG. 21 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 F1). Then, in the next step F2, 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. First, since the data for one record is read from the beginning of the expansion file 11, the process proceeds to the next step F3, 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. 21, the classification key in the first record of the expanded file 11 is “1101”, and the configuration file 7 has a child code matching this as shown in FIG. 12, so in step F3 When that is detected, step F4
Proceed to and the record of the total file 13 (total record)
To generate. That is, in the specific example of FIG. 21, first, the expansion totalization processing unit 12 reads the parent code corresponding to the child code “1101” from the configuration file 7, and reads this parent code “· C03” from the row No. “03” of the B table. And other
C ”and decompose this line No.“ 03 ”into tabulation file 13
Is placed in the first item of the first record of, and the other ".C" is placed following it. Then, the name corresponding to this child code is read from the configuration file 7 and placed in the next item of the tabulation record. Following this, the data item “800,000” of the expansion file 11 is sequentially arranged after the next item of the totalized record. This aggregate record is an aggregate record of record name "personnel expenses" and aggregate level "C" defined in row No. "03" of table A, and aggregates defined in table A corresponding to this record name. This is a summary of the data corresponding to the target code. 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 F
5).

Next, it is checked whether or not the end flag is set at the corresponding record position in the configuration file 7 (step F6). 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 F3. If the end flag is not "1", a new expansion record is generated and written in the expansion file 11 (step F7). 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. 19, the record arranged below the broken line in the drawing shows the returned record. After that, the process returns to step F3, 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 F3 and the mismatch ends, the process returns to step F1 to read the next record from the expanded file 11. Such an operation is performed for all the records of the expanded file 11. Then, the end of data is detected in step F1 and the process proceeds to step F8, where the totalization file 13
The records that make up are sorted in ascending order according to the contents of the first item. The records in the totalized file sorted in this way are rearranged in the print order when the form is output.

When the totalization file 13 is created in this way, the expansion totalization processing unit 12 activates the print processing unit 14. Then, the print processing unit 14 takes in the content of the print format memory 8 and prints out the content of the totalization file 13 together with the form format from the printer 15 according to the print format to create the form. in this case,
The print processing unit 14 reads the totalized records one by one from the beginning of the totalization file 13, determines the totalization level included in the totalization record, and determines the name and data in the totalization record together with the corresponding ruled line format for bundling. Is printed out one record at a time, and each item name stored in the print format memory 8 is sequentially taken out and printed out at a position corresponding to the form format. Figure 2
Is a form printing example in this case. In the row direction, the record name of the totalized record is printed together with the hierarchical structure format according to the totaling level, and the item name of the totalized record is printed in the column direction. The contents of the file 13 are 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, and the definition is defined. 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, the first condition item and the second condition item can be defined for each column item of the B table in the condition item of the B table, and a plurality of condition values are logically ORed in the first condition item. Since the condition values of the first and second condition items can be defined by the logical product, it is possible to finely define the record extraction condition. By defining the record extraction conditions in this way, it is possible to effectively narrow down the records to be totaled as a preprocessing for totaling the records.

In the above embodiment, one condition value is defined in the second condition item, but a plurality of condition values may be defined in the same manner as in the first condition item. Further, although the conditional value is defined in the above embodiment, a conditional expression using a logical operator may be defined. Further, in the above embodiment, two types of condition items can be defined, but three or more types may be defined. On the other hand, in the above embodiment, the table A and the table B were defined separately and independently.
The table and the table B may be simultaneously defined 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.

[0057]

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, the record extraction conditions, the items to be totaled, etc. are simply designated. By simply setting it, you can output the form as intended based on the specified contents, so you do not need to ask a specialist such as a system engineer to create a program as in the past. However, it can be easily obtained and 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 general flowchart showing an outline of the overall operation of the table structure analysis unit 5.

FIG. 7 is a flowchart showing in detail the table A join table creation process shown in FIG.

FIG. 8 is a flowchart showing in detail a part of the configuration file creation processing shown in FIG.

9 is a flowchart showing a part of a configuration file creation process following FIG.

10 is a flowchart showing a part of a configuration file creation process following FIG.

FIG. 11 is a diagram specifically showing the operation contents of a configuration file creation process, in which (A) and (C) are configuration records and (B) is a diagram showing the contents of the final item work memory.

FIG. 12 is a diagram showing specific contents of a configuration file.

FIG. 13 is a flowchart showing a part of table creation processing relating to table B shown in FIG. 6.

FIG. 14 is a flowchart showing a part of the table creation processing continued from FIG.

FIG. 15 is a flowchart showing a part of a development file creation process.

16 is a flowchart showing a part of expanded file creation processing subsequent to FIG.

FIG. 17 is a diagram showing a development record created based on the record contents of a plan file.

FIG. 18 is a diagram showing a developed record created based on the record contents of an accounting file.

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

FIG. 20 is a diagram showing a deployment tabulation process by a deployment tabulation processing unit 12.

21A and 21B are diagrams specifically showing the operation contents of the expansion and aggregation processing, in which FIG. 21A shows the expansion file, and how the aggregation record is generated from the configuration file, and FIG. 21B is newly generated. The figure which showed the expansion record.

[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 Expansion File Creation Section 10 Data File 11 Expansion File 12 Expansion Aggregation Processing Section 13 Aggregation File 14 Printing Processor 15 Printer

Claims (1)

[Claims] 1. A name of an item to be output as a data item of a total record is specified, an item to be totaled is specified in association with each item name, and a plurality of items are specified as condition items for record extraction. Specifying means for specifying the extraction condition for each condition item, and extracting means for extracting from the predetermined file a record that matches all of the plurality of extraction conditions specified corresponding to each item name by the specifying means Read means for reading out item data corresponding to the item to be totalized specified by the specifying means from the records extracted by the extracting means; and each item data read by the reading means by the specifying means. A totaling means for totaling for each designated item name, and a record totalized by this totaling means for each item name designated by the designating means. A data processing device comprising: an output unit that outputs according to the order of arrangement.