JP3489138B2 - Form output device - Google Patents

Description

Description: BACKGROUND OF THE INVENTION 1. Field of the Invention
Accounts and personal computers.
And record data read from personnel files, etc.
And a form output device for outputting a form based on the form. [0002] Conventionally, office computers and general-purpose computers have been used.
For business processing devices such as computers, accounting files,
HR files, sales slip files, inventory files, etc.
We store and manage a variety of files.
The record structure to configure is different for each file,
Same record format (each item of the record matches
Records) and manages them as separate files.
ing. By the way, extract records from a given file
And reads any item data from this extracted record.
And summarizes the records.
The form creation process to be output together with the system
Experts such as Zinnia set up each report in a one-to-one correspondence.
It is performed according to the form processing program
You. [0003] As described above, in the prior art
Individual form processing that corresponds to each form 1: 1
It is necessary to set the program in advance, but
Since business tasks change over time, the form processing program
Ram no longer fits in reality,
It may not be possible to obtain a matched form.
In such a case, conventionally,
Change a part of the form processing program to deal with it
But if you make some changes,
General users because they require specialized and advanced knowledge such as
It ’s extremely difficult for those who
I have to ask a system engineer to change the program
That was the current situation. The object of the present invention is to
General user without changing the processing program
Output items to obtain the desired form
By simply specifying attributes such as shading with
Output a form as intended based on the specified content
It is to be able to power. SUMMARY OF THE INVENTION [0004] The present invention provides a tallying record.
Are displayed on the vertical axis.
Multiple summary item names are arranged on the horizontal axis, and each summary record
Summary book that outputs summary data for each summary item name
A form output device that creates and outputs a form,
Form frame vertical image to define the vertical output format of the form
Display the first format in the
Change the position and size of the mat in the vertical direction.
Arbitrarily defined by the
Aggregate record of the aggregate record that forms the vertical axis on the mat
Line location and the line qualification information for that line,
File name and the target file
Of records to be aggregated from each record in the file
First definition means for defining conditions, and the side of the above summary form
By the form frame horizontal image to define the output format of the orientation
Displays the second format, and displays the second format.
The position and size of the table frame in the horizontal direction
More arbitrarily defined and in its second format
Column layout position of the summary item name of the summary target items that make up the horizontal axis
And the column qualification information of that column,
Items to be summarized in the records extracted
The second definition means for defining the eye name and the first definition means
Based on the defined file name and the extraction conditions for each
From the target file
Extracting means for extracting records to be aggregated for each
Data item name for each total item defined by the second definition means
Is extracted for each totaled record by the extraction means based on
Read the data of the above data item name in the specified record
Then, the read data is totaled for each of the above totaling items.
By doing so, the aggregation of the data for each of the above aggregation items
The record is a summary record corresponding to each of the above summary record names.
Total record creation means created for each password, and the first definition
Each summary record name defined by the
Is output in the direction of the vertical axis of the tabulation report.
Collects the totals defined in the column according to their definitions.
In addition to outputting the report in the horizontal axis direction of the
Based on each summary record created by the code creation means,
The summary data for each summary item in each summary record is
Output position corresponding to each summary record name and each summary item name
And output each line defined by the first definition means.
Qualify each row according to the row qualification information of
Modify each column according to the column qualification information for each column defined by the
Form creation means for creating a decorated totals form
It is characterized by the following. An embodiment will be described below with reference to FIGS. 1 to 25.
I will tell. FIG. 1 is a block diagram of a data processing apparatus according to the present embodiment.
FIG. This data processing device is
Computers that do not have specialized knowledge.
The subject, etc., for each tabulation level, using the tabulation definition table
Can be specified arbitrarily in the definition of this aggregation definition table.
Reads the applicable records from the specified file and collects them.
Records are classified and summarized in a hierarchical structure according to the total level.
Prints out the aggregation result of
You. The input unit 1 is a key for inputting various data and commands.
-The data input from the input unit 1 is
The data is taken into the data setting unit 2 and processed, and the display unit 3
Is displayed and output. In addition, the input unit 1 performs predetermined key operations.
In response, a start command is given to the parameter setting unit 2.
You. The parameter setting unit 2 is activated from the input unit 1
Operate in response to an instruction, and
Record name of summary record to indicate record summary
Definition table that defines the data to be aggregated or the aggregation conditions, etc.
In the embodiment, two types of tables A and B) are input from the input unit 1.
Generated according to the input data and displayed on the display unit 3
Output and set in parameter file 4.
Note that Table A and Table B will be described in detail later,
Here, a brief description will be given. For example, desired
Print out "Expense record" as shown in Fig. 2
Collection according to the output image of this form
Tables A and B are generated as total definition tables. here
In the form shown in FIG. 2, the record name of the summary record
And the data item name of the summary record as a column item
Is defined in order to obtain this form
Table A is configured as shown in FIG. 3 and Table B is configured as shown in FIG.
The table shows the record names and collections of summary records for each summary level.
Definition that defines the item contents extracted as a total record
It is a table. Table B is a data item of the total record.
Names that are output and data corresponding to the item names
Output target items extracted as items or when printing forms
This is a definition table that defines the format, totaling conditions, and the like. Also, A
Tables and Tables B have a net as an attribute when printing a form for each item.
In addition, the line type of the ruled line can be arbitrarily defined. [0008] The parameter file 4 contains a table A and a table B.
The basic format (ruled line data, etc.)
Besides being permanently stored by the
Table A parameter data of various forms arbitrarily input from the unit 1
Data, table B parameter data and any input from input unit 1
Form name and A table parameter data, B
Correspondence table that associates with table parameter data is stored
Have been. [0009] The table structure analysis unit 5 is the input unit 1 when printing a form.
It operates according to the start command input from the
A table parameter corresponding to the form name specified arbitrarily
Data and table B parameter data are analyzed and the analysis result
Creates various parameter analysis tables 6 according to
You. In this case, in this embodiment, the parameter analysis table
Table 6 as shown in FIG.
Table B join table as shown in FIG. 5 (B) and FIG. 5 (C)
Table B condition table as shown, Table B as shown in FIG. 5 (D)
In addition to the total item table, not shown in the table B formula table
Create a file. The table structure analysis unit 5 is defined in Table A.
Analyze the hierarchical structure etc. according to the aggregation level
The configuration file 7 is created based on the analysis result. The structure
File 7 will be described in detail later.
And the aggregation level of the corresponding
Represents the hierarchical relationship (parent-child relationship) in the hierarchical structure of files
File. Further, the table structure analysis unit 5 adds the table A and the table B
To the defined attributes such as shading and the header position of Table B
Read the item name of each defined column and print the memo
8 and read the print format defined in Table B.
The data is set in the print format memory 8. Then the table structure
The analysis unit 5 gives a start command to the development file creation unit 9. [0010] The expanded file creation unit 9 is a parameter analysis template.
Refer to the contents of various tables in
From the various source files that compose file 10
Specify the target file or extract from this target file.
Expanded records one record at a time based on the issued records
Are sequentially generated and written to the development file 11. This
To create an expansion file 11
The unit 9 gives a start command to the development and aggregation processing unit 12. The development and tallying unit 12 refers to the configuration file 7.
1 record based on the contents of the development file 11
Totals records are created one by one, and the totals
Write out. This creates the tally file 13
Then, the development tabulation unit 12 sends a start instruction to the print processing unit 14.
give. The print processing unit 14 stamps the contents of the tally file 13
According to the print format set in the print format memory 8
Printer 15 with record format for each record
The form is created by printing out the data. Next, the operation of this embodiment will be described. First,
Creation of tables A and B from the input unit 1 to obtain the desired form
Is instructed, the parameter setting unit 2 responds
Make. First, the parameter setting unit 2 sets the parameters when creating Table A.
Basic format of Table A read from meter file 4
Display and output the table frame and the like according to the Now, in Table A
With the basic format displayed and output,
The operator inputs the parameter data of Table A from the input unit 1.
Power. Here, in the heading section in the row direction of Table A,
A record whose name is an aggregation record with any name corresponding to the level
Is entered as the first name. For example, as shown in FIG.
"01" is the record name "Total" corresponding to the aggregation level A
Is input, and the row No. “02” corresponds to the aggregation level B.
Accordingly, the record name “fixed cost” and the row No. “03”
Record name "personnel cost" ... is entered in response to Bell C
ing. Note that in the above example, an arbitrary record
Although the code name is input directly from the input unit 1,
If the record name to be
Record the name of the record to be used in the table,
List the contents of this table on the window screen when entering the window name
Display and select any record name from them
May be used to input a record name. Ma
The record name is not limited to the name, but may be a code.
No. An arbitrary file is included in the table A heading section.
Name and item name are entered. For example, as shown in FIG.
In Table A, there are two types of file names, "plan FILE",
"Accounting FILE" has been entered
The file from which the records should be extracted
File name is defined. In addition, file name "plan FIL
E, the item name "Budget Item" is entered.
The item name corresponding to the file name "Accounting FILE"
"Account" has been entered.
A target item name to be extracted as a code is defined. Change
, Composed of the row and column headings of Table A
Each input area in a matrix form
The specific item content (item code) of the eye is entered
You. For example, row No. "03", that is, corresponding to the aggregation level C
For the record name "personnel cost" to be
E ”, the item code“ 101 ”corresponding to the“ budget item ”,
"102" is entered, and "Accounting File"
Item codes “2111” and “211” corresponding to “regular subjects”
2 "and" 2134 "have been entered,
Item code “1” of the budget items constituting the image file
01 and 102 should be extracted.
Are defined and account items that make up the accounting file
Among the item codes “2111”, “2112”, “2”
134 "should be extracted.
Have been. In the table A, the management unit corresponding to each row No.
An area is provided, and an arbitrary line can be specified and
By entering a circle at the corresponding position, the line
Indicates that this is the area where the code is input. This is Table A
When analyzing the definition contents for each line,
Rows are analyzed and other rows are excluded from the analysis.
This is to improve the processing speed. same
Sometimes, the data to be extracted and aggregated by
It is also meaningful to confirm that it is in
You. In this embodiment, a part of the form is emphasized.
In the table A, use the record name
The ruled line that wraps records by level, whether or not to apply
Can be arbitrarily defined as
I have. For example, the records of row No. “02” and row No. “05”
The heading column is shaded.
Thus, when printing a form, the second and fifth lines
It defines what should be modified by shading the whole.
In addition, the record name of row No. “02” and row No. “05”
In the entry item column, add a vertical ruled line that matches the aggregation level.
Is a bold line, so that depending on the aggregation level
As a line type in a ruled line format for grouping record data
A bold line is specified, and the corresponding record should be enclosed with this bold line.
Is defined. Create table A in this way
And the parameter setting unit 2
Set in meter file 4. Next, the parameter setting section 2 sets the parameter
Reads and displays the basic format of Table B from file 4.
Output. Here, as shown in FIG.
In the output section, "Format", "Target"
FILE "," total item "," calculation formula "," condition item "
Eyes and condition values are fixedly set in advance.
In addition, each column item in the heading section in the column direction of Table B is
As names indicating eye positions, “A”, “B”, “C”,...
It is associated with “G”. Now, the basic format of Table B is displayed and output.
In this state, the person in charge of operation
Enter the parameter data for the table. Here, the column of table B
In the heading part of the direction, the data item of the summary record is used.
The name of the item to be printed out is entered. For example, the term
Eye position "A" is "Expense item", Item position "B" is
“Early plan”, item position “C” is “Revision plan”, item
Positions “D” and “E” are “Shared Items” and “Shared Items”
The item position “D” and its subordinate items
Expense ", item position" E "has" Distribution cost ", and item position
"F" is "actual meter", item position "G" is "planned difference"
Is entered. Also, in the present embodiment, the form
Column items using the heading section of Table B to highlight the section
Shading can be arbitrarily defined for each case.
ing. For example, items at column item positions "C" and "G"
The columns are shaded, so that when printing forms
The entire third and seventh columns should be shaded for modification.
Is defined. In addition, it is applied to the line item of table A
Shading and shading applied to column items in Table B are indicated by diagonal lines.
The directions are opposite, so that you can distinguish them.
I'm trying. In the line item of Table B, "Format"
Is the column width and character for each column item as the print format of the item data
Type, character size, etc. are entered. In addition, the following "
"FILE" corresponds to column item positions "B" and "C".
"Plan FILE" is input, and column item position "D",
“Accounting FILE” is input corresponding to “E”.
In addition, the following “total items” are the
Define which field data should be aggregated from the code
Corresponding to the column item positions "B" and "C"
Amount + ”is entered, and column item positions“ D ”and“ E ”
Correspondingly, "debit amount +" and "credit amount-" are entered.
Have been. Here, the plus / minus sign is the record
It defines the addition or subtraction aggregation at the time of aggregation.
You. Next, at column item positions B, C, D,.
In the corresponding “Calculation Formula” columns, the totaled record to be output is displayed.
The calculation formula for processing the code has been entered. Where
To define that the item data should be output as is
Describes the calculation formula in the column corresponding to the item position
Not required, but defines that certain item data should be processed
If you want to change the
A calculation formula indicating the contents is described. Calculation formula is optional
Position as a variable, this column position, a constant, a simple
It is described using operators. Column position is Table B
Column item position, but the result of other formulas
If you should refer to the line where the formula is entered
No is added to the column item position. Note that the description of the calculation formula
The calculation formula "D + E" shown in FIG.
That the field data in the corresponding summary record should be added
Define. The calculation formula "B / 1000" is the column item position.
Divide the item data corresponding to B by "1000" and get the value
Is to be output in units of “thousands”. In addition,
Is the formula "CF" the item data corresponding to column item position C?
Of the formula "D + E" entered in the field position F1
Is defined to be subtracted. On the other hand, the following "condition item" is the definition content of Table A.
Extraction rules to further narrow down the records extracted by
Define the condition item, and the item name of the "condition item"
And column item positions "B" and "C"
Is entered, and the column condition is
"B" is "1", column item position "C" is "2",
"3" and "4" are input, and similarly, "condition item"
The column names “D” and “E” are “
"Check account" is input, and column item position as "Condition value"
"D" indicates "$ 0011 (all other characters except 0011)
Indicates that the code should be extracted)), column item position
“0011” is input to “E”. One
If multiple condition values are defined for the condition item of
The record extraction condition for that item is a logical sum (or condition).
I taste. In this way, Table A and Table B were created.
Then, an arbitrary form name is specified from the input unit 1 and the print command is issued.
, The table structure analysis unit 5 sets the flow chart shown in FIG.
Works according to the FIG. 6 shows the table structure analysis unit 5.
In the general flow that outlines the overall operation of
The structure analysis unit 5 reads the A of the designated form from the parameter file 4.
Reads the table parameter data and creates the A-table connection table
(Step A1) and create a configuration file.
(Step A2). Next, the table structure analysis unit 5
Reads table B parameter data of the specified form from data file 4.
And create a join table for Table B (step
A3), condition table (step A4), total item table
Table (Step A5), calculation formula table (Step A
6) is created respectively. After that, the parameter
Format data from the data
Write to the memory 8 (step A7). FIG. 7 shows a flow of creating the A-table connection table.
In the table structure analysis unit 5, the column heading of the table A in the column direction
To create an A-table binding table as shown in FIG.
To achieve. Here, the A table join table is defined in the A table.
Table that associates file names with item names
In the "File name", "Sequential number SE"
Q "," item name ", and" file symbol ". here
And the sequential number SEQ is set in the same file.
Identified item names by serial numbers starting from "01"
And the “file symbol” is specified in Table A.
Files defined by serial numbers starting from "1"
This is the code for First, the table structure analysis unit 5 sets parameters
Read parameter data of table A of specified form from file 4
At the same time (step B1).
A value "1" is designated (step B2). And A
Analyze the column headings in the table sequentially from the beginning.
Good. That is, the table structure analysis unit 5 first defines the table A
After specifying the first file name (step B3),
Specify the initial value “1” for the quenchal number SEQ
Step B4), and the first file name corresponding to this first file name
Is specified (step B5). With this finger
Fixed file name, sequential number SEQ, section
Write the item name and file symbol in the table A
Step B6). In this case, if the table A shown in FIG.
The first row of the table join table contains data as shown in FIG.
Data is written. Next, another file corresponding to the same file name
If the item name is defined (step B7), the seek
Add "1" to the initial number SEQ and update the value
(Step B8) and specify the next item name (Step B8).
Step B5) Write to the A-table connection table
(Step B6). Hereafter, all files corresponding to the same file name
The above operation is repeated until all the item names are specified. This
As a result, when all the item names are specified, the next step B
Go to 9 and if there is another file name in Table A, condition it
Adds the file symbol "1" to, and updates the value
(Step B10). Hereinafter, returning to step B3, the table A
Specify the other file name from
Table A while sequentially specifying all item names corresponding to the file name
Write to the merge table. Next, creation of the configuration file 7 shown in FIG.
The processing (step A2) will be described in detail with reference to FIGS.
You. 8 to 10 show the operation when creating the configuration file 7.
FIG. 11 is a flow chart showing
Schematically shows the operation contents of the table structure analyzing unit 5 in the case of
FIG. 12 is a diagram showing the created configuration file 7.
It is. FIG. 11A shows a record of the configuration file 7.
This configuration record shows the child
"", "Parent code", "End flag", "Name"
"Child food" and "Parent code" are tabulated in Table A
The correspondence between the target item and the corresponding summary record
Hierarchy in the hierarchical structure of representing or summarizing levels
This is a record representing (parent-child relationship). Also, "End file
Lag "means that the parent code contains aggregation level A
This flag is set to “1”, and the end flag is set to “1”.
Record to a higher level if
This indicates that no tally is performed. "Name" is in Table A
This is the record name of the defined summary record. Destination
The table structure analysis unit 5 specifies the first row of the table A parameter.
(Step C1), the aggregation level of the specified row is the highest level
Then, it is checked whether or not the file is A (step C2). here,
If the aggregation level is A, analyze the table structure for initial setting
The last item work memory in the section 5 (see FIG. 11B)
Is cleared (step C3),
Aggregation level A as the currently focused level (current level)
Is specified (step C4). In this state,
The row number of the current level and the current row (current row)
Then, level row data is generated (step C5). example
For example, taking Table A shown in FIG. 3 as an example, the first row of Table A is a collection.
The total level is A and the row number is "01"
Is the level row data that combines this current level and row No.
A “A01” is generated. Next, this level row data
"A01" and the name of the current row (record name of the totals record
"Total") to the current level A of the last item work memory
The corresponding position is set (step C6). The final
The item work memory has a total level as shown in FIG.
.. Corresponding to level A, B, C, D,.
It is configured to store the name, and when creating the configuration record
Work memory. Next, a circle is added to the management unit area of the current line.
It is checked whether or not it has been performed (step C7). I
Also, as shown in FIG. 3, the first line is not circled.
Attention is paid to the next row of table A, and the record name is set in that row.
It is checked whether or not it has been performed (step C8). here
When the setting is detected, the current line is updated and the next line
Specify (step C9). This gives two rows in table A
When the eye is specified, the process returns to step C2.
In this case, the aggregation level of the second row is B, and therefore, step C1
Proceeds to 0 and determines if the level of the specified line has exceeded the current level
Error check, and if it exceeds, note the last item
Clear all contents below the level of the specified line in the library
(Step C11). Now, the designated row level B is not the current level A
Since it is full, the process proceeds to step C12, where the designated line level is
Update the current level as the current level. Then, now
Generate level row data from level and row number of current row
(Step C13), the level row data and the name of the current row
Is the position corresponding to the current level of the last item work memory.
(Step C14). In this case, the level
Row data "B02", name "fixed cost" is now level B
It is set to the corresponding position (see FIG. 11B).
Next, connect the symbol (•) to the beginning of this level row data.
(Step C15), the combined data is stored in FIG.
Set as a child code of the configuration record as shown in
(Step C16). Here, the symbol (•) in Table A
When the line where the item code is not input is taken as the line of interest
This is set by the
This indicates that there is no response. Then, the step shown in FIG.
Proceed to step C17, and from the last item work memory (currently
Level row data stored at the level position of level +1)
Data at the beginning of this level row data.
(•) and combine this code with the parent
(Step C18). Now and now
Level is B, therefore the level of the last item work memory
To the level row data “A01” stored at the position of A
The combined code combining the symbols (•) becomes the parent code (Fig.
11 (A)). Here, the parent code level is A
If there is (step C19), the end flag of the configuration record
Is set to "1" (step C20). Next, parent
Read the name of the code from the last item work memory and configure
It is set as the name of the record (step C21).
In this way, child code as data for one record
".B02", parent code ".A01", end flag
When "1" and the name "total" are completed, this composition record is composed
The data is written to the file 7 (step C22). Next, returning to step C7 in FIG.
In the case, the management unit area of the current line is not circled
Therefore, the third line of the next line is specified (step C9).
Thereafter, the above-described steps C12 to C14 are executed.
As a result, the level row data is stored in the level C of the last item work memory.
"C03" and the name of the current line "Personnel cost" are set.
(See FIG. 11B). And this level row data
The join code with the symbol (•) is the child code of the constituent record.
(Steps C15 and C16). Next
Next, the position of level B in the last item work memory (up one level)
Level row data "B0" read from the
2) with a symbol (•) attached to the constituent record
Set as parent code (step C1 in FIG. 11)
7, C18). In this case, the last item corresponding to the parent code
The name "fixed cost" in the work memory is the name of the constituent record
(Step C21). Thus one record
The child code ".C03" and the parent code "."
B02 "and the name" fixed cost "
Is written to the configuration file 7 (step C22). Subsequently, at step C7 in FIG.
When it is detected that the logical unit area has a circle,
The process proceeds to step C23 in FIG.
Is set to "1". Then, type in the current line
From the beginning (step C)
24), combining the file symbol with the item code
Set the combined code as a child code of the constituent record
(Steps C25 and C26). In this case, the file symbol
Since "1" and item code "101" are combined, child code
-Is "1101". Next, the final item work memo
At the beginning of the level line data of the current level in the
Are combined (step C27), and this combined data is
Set as the parent code of the code (step C2)
8). Then, enter the name of this parent code "personnel expenses" in the last section.
Read from the work memory and use it as the name of the configuration record
(Step C29). (C) of FIG.
FIG. 14 shows a configuration record in the case where
1 ", parent code is" .C03 ", name is" personnel cost "
Is written to the configuration file 7
(Step C30). Next, another item code is added to the current line.
Check whether it has been entered (step C31), and
If so, the process returns to step C24 to specify the next item code.
Hereinafter, the above operation is repeated. As a result, the third line term
Configuration record when eye code "102" is specified
Indicates that the child code is "1102" and the parent code is ".C0
3 "and the name is" personnel expenses ". Thereafter, in step C31, there is no item code.
Is detected, the process proceeds to step C32, and another file is detected.
Check if the file name is defined in table A, but
In Table A, "Accounting FILE" is used as the next file name.
Is defined, the process proceeds to step C33, and the file
After adding “1” to the symbol and updating the value,
Return 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 constituent record is “22111” and the parent code
-Is ".C03" and the name is "personnel cost". Now
If no other file is specified in step C32,
8, the process returns to step C8.
Until a configuration record is created and a configuration file is created
The process of writing data to the record 7 is repeated one record at a time. to this
Thus, a configuration file 7 as shown in FIG. 12 is created.
Refer to Table A in FIG. 3 for the contents of this configuration file 7.
It was generated by In this way, the configuration file 7 is created and the
Then, the table structure analysis unit 5 determines the join table of the B table, the B table condition
In addition to tables and summary item tables, create formula tables
To achieve. Among them, the table B connection table, the condition table,
The aggregation item table is a flowchart shown in FIGS. 13 and 14.
Created according to charts. Here, the table B connection table
(See FIG. 5 (B)) are "file name", "seek"
Original number SEQ ", condition item" item name ",
File symbol ". Table B condition table (Fig.
5 (C)) is “file name”, “column position of table B”
, “Condition value”, and “negative flag”. here
The “negative flag” is a condition value of “≠ (equal
) Is set. Ma
In addition, the tabulation item table (see FIG.
Name "," column item position of table B "," item name "of total item,
"Minus sign". Here, "
"In" is a total item such as "credit amount-".
Indicates that the eye name has a minus sign. First, the table structure analysis unit 5 sets the parameter file
Read parameter data of table B of designated form from file 4
(Step D1), specify the second column (item position B)
(Step D2). Next, the target file of the specified column
Name (step D3) and the file name
The file symbol corresponding to the table from the A table connection table
(Step D4). Then, in the next step D5,
The initial value of quenchal number SEQ was set to "1"
That is, the item name is set focusing on the condition item in the specified column.
Check if it is set (step D6), and if it is set
The condition item name is specified (step D9). This
File name, sequential number SE obtained
Generate a combined record from Q, condition item name and file symbol
After that (Step D10), the combined record is stored in Table B.
Set in the join table,
In order to avoid duplicate settings, the same record
Under the condition that the mode is not set (step D1
1) Set the generated join record in the B table join table.
(Step D12). Next, focusing on the condition value of the designated column, the condition
A value is specified (step D13), and
If “≠” is added (step D14), the negative flag
A lag is set (step D15). Like this
The obtained file name, column name indicating the item position of the specified column,
A condition record is generated from the condition value and the negative flag (step
(Step D16), set in the condition table of Table B (Step
D17). Here, multiple condition values are defined for the specified column.
If it is, to generate a condition record for each condition value,
In step D18, it is checked whether there is another condition value
If there is, return to step D13 and specify the next condition value.
To generate a condition record corresponding to the condition table
Set to. Then, in the next step D19, the designated column
Check if there are other condition items in the
Proceed to Step D20 and enter the sequential number SEQ
After adding “1” and updating the value, step D9
Return to and specify the next condition item.
Generate joined records or condition records to create
Set on the table. No other condition item is detected in step D19
Then, the process proceeds to step D21, where the condition item of the designated column is set.
Specified, and a minus sign is added to the condition item.
(Step D22), setting of minus sign flag
(Step D23). The file obtained in this way
File name, column item position of specified column, column name, summary item,
Generate summary item record from the minus sign flag
(Step D24), set in total item table
(Step D25). As described above, the definition contents of one column of the table B are analyzed.
Table B join table, condition table, and aggregate item for one column
After creating the eye table, proceed to step D7,
Check if data is specified in the next column, and if so,
The line is designated (step D8), and thereafter, step D3
And analyze the definition contents of table B line by line
Repeat the file creation operation. Next, the table structure analysis unit 5 performs
B table join table, B table condition table, total item table
After creating the file, analyze the parameter data in Table B and calculate
Create a formula table.
The formula is associated with the column item position. Next, the table structure
The structure analysis unit 5 converts the table A and table B parameter data into
Data in the print format memory
Set to 8. FIG. 15 shows the operation of analyzing the print format.
FIG. 16 is a flowchart, and FIG.
Table A shows the print format of Table A and Table B shows the print format
I have. First, the table structure analysis unit 5 stores the A table in the print format memory 8.
Specify Table A parameters to set the print format of
(Step E1), and designate the first line.
(Step E2). Next, the specified line in the record name
, The type of the ruled line is determined, and the determination result is represented by A
Set as a table print format (step E3) and
Determine the presence or absence of a call and set the determination result (Step
E4). And if there is another row (step E5),
Specify the next line (step E6), and then go to step E3
Return, the ruled line defined in the record name heading of Table A
Print format memory by analyzing line type and shaded line by line
8 is set as the print format of Table A. As a result,
In the print format memory 8 corresponding to the table A of FIG.
Such a table A print format is set. In this case, the line number
For the type of ruled line corresponding to "2", "bold line"
“Yes” is set. In this way, the A-table printing format
Once set, the table structure analysis unit 5 then changes the print format of table B
Set. First, specify the table B parameters and
(Step E7), the first column is designated (step E)
8). Next, paying attention to the item name heading,
Detect and set the dot position and field width (step
E9) Read out the heading name entered in the designated field
(Step E10), and further, determine whether or not to shade.
Then, the determination result is set (step E11). Next
, Read and set the print format in the designated field (step
E12). If there is another column (step E1)
3) Specify the next field (step E14), and
Return to Step E9, analyze the contents of Table B one by one and print
It is set in the formula memory 8 as a table B print format. This result
As a result, the print format memory 8 corresponding to the table B in FIG.
Is set as shown in Table B. When such a table creation process is completed, the table
The structure analysis unit 5 activates the expanded file creation unit 9. You
Then, the expanded file creation unit 9 is shown in FIG. 17 and FIG.
Create a deployment file according to the flowchart
Do. The expansion file 11 is the output data of the form.
Generated by the time the tally file 13 is created
File. Here, FIG. 19 shows that the source file is
1st to 4th records in the case of a plan file
Indicates a deployment record created according to the contents of
FIG. 20 shows the case where the source file is an accounting file.
Created according to the contents of the first to third records of
Shows the expanded record that was created. Furthermore, FIG.
Shows the contents of the expanded file 11 created by
You. Now, FIG.
Various tables with contents as shown in (D) are set.
Shall be. First, the expansion file creation unit 9 sets the parameters
Refer to the analysis table 6 and check the file
When you retrieve the file name (the first file name of the first record)
In both cases (step F1), the file symbol is specified.
(Step F2). Then, corresponding to this file name
Specify the source file (step F3)
Specify the first record in the file (step F
4). As a result, the first file in Table A is
The first record of the "plan file" defined in
Is determined. Next, from the A table join table, item names (initially
Item name of the first record) (Step F5),
Enter the item value corresponding to this item name in the specified file in the specified file.
Retrieve from code (initial first record) (step
F6). Then, link this item value with the specified file symbol.
(Step F7), the combined data is expanded
(Step F8). Now
As shown in FIG. 19, the budget starts from the first record of the plan file.
The item value “101” of the item is extracted, and the item value “1” is obtained.
01 "and the designated file symbol" 1 "are combined.
The combined data "1101" is the first record of the development record
This is the key to classification. Next, in the first record of this plan file,
The output target item is the extraction condition defined in Table B.
First, expand to find out if the record matches
The file creating unit 9 refers to the table B connection table, and
Check if the specified file symbol exists in the cable
(Step F9). Here, the condition item name is
If defined in the B table, the B table join table
File name, condition item name, file symbol, etc. are set
I have. Therefore, if the file symbol is not set
This means that the condition items are not defined in Table B (that is,
And the extraction condition of the output target item is not set
Case). Now, the specified file is
Since the file symbol “1” has been set, step F1
0, and the result is
Read condition item name and file name from merged record
Then, the item value (item data) corresponding to this condition item name is
Retrieve from specified record. In this case, the first record
Then, the item value “1” of the plan type is extracted. And the same
Table B shows the condition value corresponding to this item value in one file name
Search from the table (step F11) and find a matching article
It is checked whether there is a case value (step F12). I
Also, the item value of the plan type included in the first record
“1” exists in the first record in the table B condition table
Therefore, the process proceeds to the next step F13, and the corresponding B table
Whether the negative flag is set in the case table
Check that in this case the negation flag is set
Since there is no such condition, the process proceeds to step F19, where the matched condition value is set.
The corresponding position value (in this case, B) is stored in the B table condition table.
, And the value of the item position that matches this is calculated
Search in the table (step F20), and
Then, an item name is designated (step F21). Where tally
In the item table, item position B is set in the first record.
The item name “budget amount” corresponding to the
And the item value “800,00” corresponding to this item name
"0" from the designated record (step F2).
2) In the total item table corresponding to the item position B,
Check if the minus sign flag is set
(Step F23). Next, proceed to step F24.
Field value "800,00" extracted from the specified record.
"0" is added to the corresponding position "B" of the expanded record.
In the case of
Is negative, the minus sign flag is set.
Those that are not set are added up. This
The first record as shown in FIG.
Is done. Next, the same item position in the total item table
Check whether the other device (in this case, B) is set.
(Step F25), as shown in FIG.
For the accounting file, the item names "debit amount" and "credit
There are no two places in the summary item table corresponding to the amount
The same item positions D and E are set, but the
File does not have the same item position
Therefore, the process proceeds to step F14, and the item in the table B condition table is set.
Check if there is another condition value that matches the eye value. I
In the table B condition table, the condition value “1” is 1
Since only the line exists, the process proceeds to step F15 and the designated
Condition that the next record exists in the
Next, the next record is designated (step F18). Thus, the second record of the plan file
Is specified, and the process returns to step F5.
Repeated. In this case, the file symbol "1" and two records
Second record based on the budget item value “102” of the first node
Generated classification key "1102"
(Steps F5 to F8). Also, the first record
Similarly, the item value corresponding to the plan type in the second record
The condition value that matches this item value “1” is “1”
Negative flag that exists in the case table and correspondingly
Has not been set, the process proceeds to step F19, and B
Extract item position "B" from the table condition table,
Enter the value of item name “budget amount” corresponding to eye position “B”
From the second record of the file (step F20-
F22). In this case, as shown in FIG.
"200,000" from the item of budget amount in the second record of
Is extracted and the corresponding position of the expanded record (the second record)
The value is added to the value "B" (step F24). Next, the third record of the plan file is specified.
(Step F18), the development record (3 records
The classification key “1103” of the (d) is generated. This place
If the third record read from the plan file
The item value of the type is "2", and the condition value that matches this item value
Is set in the table B condition table.
The item value that matches the value is “C”. Therefore, plan
Of the "budget amount" extracted from the third record of the file
Item value "400,000" is expanded record (3 records
The total is added to the corresponding position “C” in the eye. Further, the fourth record of the plan file is designated.
Then, the expanded record (4
Record item 4) in the plan file
The item value "50,00" of the budget amount extracted from the code
“0” is added up. Note that this expansion record
The type key is “1104”. Hereafter, similarly,
Parameters while sequentially specifying files one by one.
Join table of table A and join table of table B in analysis table 6
File, condition table, and summary item table, and
Create file expansion records one by one
Good. It is to be noted that, in step F9, the table B
The specified file symbol is not set in
Unconditional items for which no conditional items are defined
Therefore, the process proceeds to step F28, where the table B condition table
In the summary item table directly, without referring to the definition contents
Search for the same file name as the specified file.
Return to Step F21. This operation is performed one record at a time.
As a result, all records in the specified file are specified, and
If no next record is detected in step F15, step F
Proceed to step 16 and define another file in the A table join table
Check if it is done. Now, A table join table
Within the accounting file is defined as another file
Return to the first step F1, and
Generation records corresponding to the total file sequentially
Perform processing. That is, the file name and the
Then, "account FILE" is taken out (step F1).
"2" is specified as the file symbol of
F2). Then, the source file corresponding to this file name
Specify the accounting file as the file (step F
3) Specify the first record (step F)
4). In this state, the “account” of the designated record
Item value “2111” of the “Course” and the file symbol “2”
Merge, classification key of expanded record in the first record
“22111” is generated (steps F5 to F8). So
Then, the process proceeds to step F9.
Since the file symbol "2" is stored in the
Item value corresponding to the item name "counter account" in the table join table
From the first record of the accounting file (step
F10). Now, from the first record of the accounting file
"0011" is extracted as the item value of "counter account"
Therefore, the condition value that matches this item value is
(Step F11). In this case,
Condition values are set in the fifth and sixth rows of the table, respectively.
Has been detected, a match is detected in step F12.
Proceeding to step F13, first focusing on the first fifth line,
Whether the negation flag is set at the corresponding position
Check Now, in the fifth row of the table B condition table,
Since the negative flag has been set, the process proceeds to step F14.
In the table B condition table, this item value "0011"
Check if there is another matching condition value.
The condition value "0011" exists in the sixth row of the table condition table
Therefore, the process returns to step F13. Now, corresponding to this condition value
The negation flag is not set at the position
Proceeding to step F19, corresponding to the table B condition table
Extract item position "E" and match this item position "E"
Specify the item name in the summary item table to be
F20, F21), in this case, 5 of the total item table
Item positions set in the second and sixth lines
The position corresponding to the first item position of “E”, that is, the fifth line
Specify the item name "Debit amount". And the accounting file
Item value "5" corresponding to the specified item name from the first record of the
"0000" as the first record for the accounting file
To the corresponding position "E" of the expanded record
(Steps F22 to F24). Then, the process proceeds to step F25.
In this case, in the summary item table, in the sixth row in addition to the fifth row
Since the same item position “E” also exists in step F21,
And returns to the corresponding item position in the summary item table.
Specify the item name "Credit Amount" and
Item values from the first record of the accounting file
(Step F22). In this case, one record of the accounting file
-"0" is taken out as the item value of the credit amount from
At the corresponding position "E" of the first record of the deployment record.
However, at this time, the sixth line of the summary item table
Minus sign is set because the minus sign is set.
Aggregation, that is, (previous debit amount "50,000"-now
Total calculation of credit amount "0" is performed (step)
F24). After that, steps F25, F14, F15
Goes to step F18 and proceeds to the second record of the accounting file.
Is specified. Thus, the second record of the accounting file is obtained.
The corresponding expanded record is generated.
In this case, the item value of the account is also "2111" and the first record
Similarly, the classification key is "22111". In addition, 2
The counter account of the code is also “0011”, which is the same as the item condition value.
The debit amount "0" is the item number in the development record
And the credit amount is “40,00”
“0” is negatively counted in the item position E. Because of this,
The item position of the expanded record of the second record is "-40,
000 "is written. Next, the third record of the accounting file is designated.
However, the item value of this counter account is “0010” and B
The corresponding condition value is set in the table condition table.
Since it has not been performed, the process goes from step F12 to step F26.
Proceed and deny corresponding to the specified file in the table B connection table
Check if the flag is set. Now, Table B
In the condition table, the fifth line corresponds to the accounting file.
Since the negative flag has been set in step F27,
To “D” at the position where the negative flag is set.
From the table B condition table,
Is searched from the total item table (step F2).
0), the item value “80” corresponding to the item name “debit amount”
"000" from the third record,
The total is added to the corresponding position D of the key. Then, step F
From 25, the process returns to step F21, and the next item is
Item value "0" of name "Credit amount" is the position of the expanded record
It is negatively counted to "D". Hereafter, the next record is specified
Each time a mismatch is detected in step F12,
The same operation is repeated one record at a time. By this
Value of the condition item "counter account"
Unfolded records are sequentially generated. After that, all the records of the accounting file are designated.
At the end, no next record is detected in step F15.
Then, the process proceeds to step F16, and another table is stored in the A table connection table.
Check if the file exists.
Is detected, the process proceeds to step F17,
The record is edited. That is, the classification keys are the same
Extract each of the expanded records of
Together with each deployment record according to the classification key.
-Sort the nodes in ascending order. For example, as shown in FIG.
The development records of the first record and the second record are classified.
Since the keys are the same, they are put together in one development record.
The value of the item position “E” is “10,000”.
You. FIG. 21 shows the expanded file 1 created as described above.
1 is shown. In other words, plan files, accounting files
File 11 created according to the contents of the file
And the record structure is the items of A, B, C, D, E, F
, And the first item A is a classification key. In this way, the development file creation unit 9
After creating the open file 11, the development tally processing unit 12
Start. Then, the development tabulation processing unit 12
Create tally file 13 according to the chart
You. FIG. 23 shows the operation contents of the development tabulation processing unit 12.
It is a figure for explaining physically. The expanded file creation unit 9
Based on the contents of the development file 11 and the contents of the configuration file 7
File 13 according to the component development method
To achieve. First, the development tally processing unit 12 generates the development file 11
Read one record of data from the beginning of the
G1). Then, in the next step G2, whether the data is over or not
That is, all records from the top of the development file 11 are
Check whether it has been read. The first is the expanded file
When data for one record is read from the beginning of 11
Therefore, the process proceeds to the next step G3, and the configuration file 7
Search the contents of the
The held configuration record is searched from the configuration file 7. I
Also, as shown in FIG.
Is “1101”, and the configuration file 7
Has a child code that matches this as shown in FIG.
Therefore, this is detected in step G3 and step G4
To the record of the tally file 13 (tally record)
Generate That is, in the specific example of FIG.
The open tabulation processing unit 12 corresponds to the child code “1101”.
The parent code is read from the configuration file 7 and the parent code is read.
Do “· C03” is replaced by row No. “03” in table B and other “
C ", and the line No." 03 "
In the first item of the first record of
".C" is placed after it. And this child code
Is read from the configuration file 7, and the
Place in the next item in the code. Following this, the deployment file
Total data of data item "800,000" of file 11
It is arranged sequentially after the next item. This aggregation record is table A
Record name "person" defined in the row No. "03" of
Expenses ”and a totaling record of totaling level“ C ”.
Codes for tabulation defined in Table A corresponding to code names
This is the total of the data corresponding to the code. By this
The data of the first record of the tally file 13 is generated
Then, the generated record is written to the tally file 13.
However, at this time, the same classification key is already
If there is a record that has
And write it in the aggregation file 13
If no record exists, the record created this time
Mode is newly added to the tally file 13 (step G
5). Next, the corresponding record position in the configuration file 7
Check whether the end flag is set in the
(Step G6). Here, the end in the configuration file 7
The flag is "1" when the aggregation level of the parent code is "A"
When the end flag is "1",
Returning to step F3, if the end flag is not "1"
Generate new expansion record and write to expansion file 11
A start is performed (step G7). In this case, FIG.
A new expansion record as shown in FIG.
Return to file 11. In other words, it ’s the total record generated this time.
If a record name at a higher level is defined in table A,
If the summary result of the summary record generated this time is
In order to aggregate to the total record of the record name in the file,
Generate new expansion record and write to expansion file 11
Make a start. Here, the corresponding parent in the configuration file 7
Place the code ".C03" in the first item, followed by
By sequentially arranging the data read from the development file 11,
Is written to the development file 11. The figure
In the expanded file 11 indicated by 21, the broken line in the figure
The record you placed in shows this returned record.
You. Then, the process returns to step G3, and the configuration file
Searched all contents of 7 and found no corresponding record
The above operation is repeated until it is. As a result, step G
In 3 it is detected that there is no corresponding record, and it ends in a mismatch.
Then, the process returns to step G1, and the next
Read the code. Such an operation is performed by the expansion file 11
For all records in Then, step G1
, The end of data is detected, and the process proceeds to step G8, where
The contents of the first item of each record that constitutes the file 13
In ascending order according to. Sort in this way
Each record in the aggregated file is printed when the form is output
Sorted in order. In this way, the tally file 13 is created.
Then, the development tally processing unit 12 activates the print processing unit 14.
Let Then, the print processing unit 14 stores in the print format memory 8
Take in the contents and follow the printing format of Table A and Table B
Preparing the contents of the aggregation file 13 together with the form format
Print output from the printer 15. FIG. 24 shows the print processing unit 14.
5 is a flowchart showing the operation of the first embodiment. First, the printing process
The unit 14 is a table B print document set in the print format memory 8.
B mark to print the item heading according to the formula
The heading item names are sequentially extracted from the printing format and
Inserted into the corresponding column position of the mat,
It is arranged together with the ruled line in the page memory (not shown).
Step H1). And each column of this item heading section is shown in Table B
Modify based on the shading set in the print format
(Step H2). Next, the first of the A-table printing formats is designated (S
Step H3), type of ruled line of designated line number and shaded
The absence state is stored as a flag (step H).
4). Then, one record from the top of the tally file 13
Read (step H5), included in the record
(Step H6) and determine the aggregation level
To generate a ruled line format for consolidation (step H
7). That is, as shown in FIG.
The shape of the left end part is different according to A, B, C
This shape shows the upper and lower relationship of the aggregation level.
ing. In order to generate this ruled line format,
Data is input in advance from the input unit 1 and the print format
It is set in the memory 8 and based on this setting
The print processing unit 14 has a ruled rule in which the shape of the left end portion is different for each level.
Generate a line format. Also, each ruled line format
Are set in Table B printing format corresponding to the column numbers.
Specified based on the starting point position and field width
You. In this manner, the ruled line format for one record is obtained.
When the mat is generated, the print processing unit 14
Refer to the status flag of Table A print format stored in H4
The ruled line corresponding to this flag and the ruled line
Qualify the entire format and place it in page memory
(Step H7). Next, in step H5 described above,
Term corresponding to each field data in the calculated summary record
Placed in the eye column, at that time, set in each column of Table B print format
And the B mark
Based on the shaded state set in each column of the printing format,
The item field is modified (step H8). Then, the process returns to step H9, and
It checks whether there is another record in the file 13 and if so, the
Proceed to Step H10 and specify the next line number
Thereafter, the process returns to step H4, and the above operation is repeated.
And records the records in the aggregation file 13 one record at a time.
Printing. As a result, a form as shown in FIG. 2 is obtained.
It is. This form is shown in Tables A and B shown in FIGS.
The line item has a header
The record name of the record is printed and the column heading
The name of the tally record is printed on the tab.
The field data of the record matches the record name and item name.
It will be printed in response. Also aggregated by level
Arbitrarily specified ruled lines are bold lines
Printed and can be arbitrarily specified for each line or column item
Items are shaded and printed, and a part of the form is
It will be emphasized according to the image shown. As described above, in this embodiment, the general user
In order to obtain the desired form,
Simply define Table A and Table B according to the force image
Only, the records to be summarized
When read from a specified file and classified and aggregated,
In addition, the tally results are arranged in the order defined, and the tally
Printed in a hierarchical structure according to the level,
Some forms are emphasized and printed depending on the type and shading.
You. For this reason, even the business person in charge
Form can be easily obtained. In the above embodiment, a part of the form is emphasized.
Added thick line and thin line as rule line type
May be a dashed line, a double line, etc.
Not only for types and shading, but also for specifying print colors and
It may be specified. In addition, the above-described embodiment
Although the case of performing tallying has been described,
By setting only A to
Simply perform record extraction, array, in-item calculation, etc.
May be used. On the other hand, in the above embodiment, Table A and Table B
Are defined separately and independently.
You may make it define simultaneously on a screen. Ma
Further, in the above-described embodiment, the configuration is made by the heading of Table A.
Item code at any intersection on the matrix to be generated
Was entered, but entered the item name
Is also good. According to the present invention, when defining a summary form,
Is the first format with the form frame vertical image and the form
Separately from the second format based on the horizontal frame image
In the form, the definition of the form vertically and horizontally
Are defined separately and separately, so the entire form
Instead of defining them at the same time, the form should be
It can be defined while considering individually from the perspective of direction.
I will be able to. In particular, from the viewpoint of the vertical direction of the form
Defines the form of the vertical table frame as a summary form
In both cases, the aggregation unit in the vertical axis direction of the aggregation
Pay particular attention to each element of file and record extraction conditions
Can be defined while considering
Consideration from the perspective of the horizontal table frame as a summary form
Define the form and place it in the horizontal axis direction of the summary form
Focusing on the data items to be totaled for each
It can be defined while considering the elements, and it is
The data to be tabulated for each tabulation unit
How to extract, aggregate, and output files from
While checking the vertical format image of the summary form,
Simplify while checking the horizontal format image of the summary form
Definition can be set.

BRIEF DESCRIPTION OF THE DRAWINGS FIG. 1 is a block diagram of a data processing device according to an embodiment. FIG. 2 is a diagram illustrating a print output example of a form. FIG. 3 is a diagram specifically showing the contents defined in Table A. FIG. 4 is a diagram specifically showing contents defined in a table B. FIG. 5 is a table joined table, a table joined table obtained by analyzing the tables A and B shown in FIGS. 3 and 4,
This table specifically shows the contents of a table B condition table and a table B total item table, where (A) is a table A connection table and (B)
Is a B table join table, (C) is a B table condition table,
(D) is a diagram showing a table B total item table. FIG. 6 is a general flowchart showing an outline of the entire operation of the table structure analysis unit 5; FIG. 7 is a flowchart showing details of the A-table connection table creation processing shown in FIG. 6; FIG. 8 is a flowchart showing in detail a part of the configuration file creation processing shown in FIG. 6; FIG. 9 is a flowchart showing a part of a configuration file creation process following FIG. 8; FIG. 10 is a flowchart showing a part of a configuration file creation process following FIG. 8; FIGS. 11A and 11C are diagrams specifically showing the operation contents of a configuration file creation process, wherein FIGS. 11A and 11C are configuration records, and FIG. 11B is a diagram showing the contents of a last item work memory; FIG. 12 is a diagram showing specific contents of a configuration file. FIG. 13 is a flowchart showing a part of a table creation process for the table B shown in FIG. 6; FIG. 14 is a flowchart showing a part of a table creation process following FIG. 13; FIG. 15 is a flowchart showing details of the print format analysis processing shown in FIG. 6; 16A and 16B show the contents of a print format memory, where FIG. 16A shows a table B print format and FIG. 16B shows a table A print format. FIG. 17 is a flowchart showing a part of a development file creation process. FIG. 18 is a flowchart showing a part of a development file creation process following FIG. 17; FIG. 19 is a diagram showing an expanded record created based on the record contents of a plan file. FIG. 20 is a diagram showing an expanded record created based on the record contents of an accounting file. FIG. 21 is a diagram specifically showing the contents of a development file 11; FIG. 22 is a diagram showing a development tabulation process performed by a development tabulation processing unit 12; 23A and 23B are diagrams specifically showing the operation contents of the development and aggregation processing, in which FIG. 23A illustrates a state in which a summary record is generated from a development file and a configuration file, and FIG. The figure which showed the expansion record. FIG. 24 is a flowchart showing the operation of the print processing unit 14; FIG. 25 is a diagram showing a ruled line format generated for each aggregation level. [Description of Signs] 1 input unit 2 parameter setting unit 3 display unit 4 parameter file 5 table structure analysis unit 6 parameter analysis table 7 configuration file 8 print format memory 9 expansion file creation unit 10 data file 11 expansion file 12 expansion aggregation processing unit 13 aggregation file 14 print processing unit 15 printer

────────────────────────────────────────────────── ─── Continuation of the front page (56) References JP-A-4-62662 (JP, A) JP-A-6-309199 (JP, A) Yoichi Nakayama, Automatic data processing equipment for office work ADPS theory and technology, Nikkei Computer, Japan, January 1, 1990, No. 216, p. 137-p. 146 (58) Field surveyed (Int.Cl. ⁷ , DB name) G06F 19/00 G06F 17/60 G06F 17/21 G06F 12/00

Claims (1)

(57) [Claims] [Claim 1] A plurality of tally record names of tally records are arranged on a vertical axis, and a plurality of tally item names of tally target items are arranged on a horizontal axis. A form output device for creating and outputting a tally form that outputs tally data for each tally item name, and displays a first format based on a form frame vertical image for defining a vertical output format of the tally form. , The first format is arbitrarily defined by appropriately changing the position of the table frame in the vertical direction and the size of the table frame, and the row arrangement position of the total record name of the total record constituting the vertical axis in the first format And a row qualifying information of the row, a file name to be read, and an extraction condition of a record to be tabulated among records in the target file for each of the tabulated records. Means for displaying a second format based on a form frame horizontal image for defining a horizontal output format of the tabulation form, and appropriately changing the second format in the horizontal table frame position and the table frame size. Arbitrarily defined in the second format, the column arrangement position of the aggregation item name of the aggregation target item constituting the horizontal axis in the second format, the column decoration information of the column, and the record extracted as the aggregation target for each aggregation item name Second definition means for defining a data item name to be tabulated in the file, and the file name and the extraction condition for each tabulated record defined by the first definition means. Extracting means for extracting a record to be tabulated for each record; and, based on the data item name for each tabulated item defined by the second defining means, the extracting means extracts each record. By reading the data of the above data item name from among the records extracted for each total, and summing the read data for each of the total items, a total record in which the data is totaled for each total item is obtained. A totaling record creating means for creating each totaling record corresponding to each of the totaling record names, and arranging and outputting each totaling record name defined by the first definition means in a vertical axis direction of the totaling form according to the definition contents; Each summary item name defined by the second definition means is arranged and output in the horizontal axis direction of the summary form according to the definition contents, and
Based on each of the tally records created by the tally record creation means, the tally data of each tally item in each tally record is arranged and output at an output position corresponding to each of the tally record names and tally item names, A form creation means for qualifying each row according to the row qualification information of each row defined by the first definition means and creating a totalized form in which each column is qualified according to the column qualification information of each column defined by the second definition means A form output device, comprising: