JPH07175870A - Slip preparing method - Google Patents

Abstract

PURPOSE:To provide the method for preparing the special line of a sum or an average from table data in a relational form, changing the display layout of this special line and displaying it at a fixed position designated in a slip. CONSTITUTION:Table data 300 in the relational form are displayed on a screen 204 based on a slip arrangement information table (101), the special line for paragraphing, paging(102) or displaying the summed-up result is generated corresponding to the value of data (103), a sum-up line arrangement information table is generated to separately manage the layout of the special line, the layout is changed to this separately managed information, and suitable display is performed to the special line provided with the same attribute. Therefore, the special line data of the total or the average can be arranged at the fixed position in the slip while changing its layout by the special method for directly operating the image on the screen, and the slip to be clearly observed and easily comprehended by a user can be prepared by the simple operation.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a method for creating a form using a computer, and particularly, for creating a form for arranging and displaying a data portion having a special meaning such as total, subtotal, average or number of items in the form of a table. Regarding the method.

[0002]

2. Description of the Related Art When creating a form using a computer,
Create a data part with a special meaning such as total, subtotal, average or number on the form from tabular data, and place this special data part in a fixed position on the form separately from other data parts. It is being displayed. In Japanese Patent Application No. 4-58366, a word consisting of data that can be accumulated is read from the record storage means,
It shows a form creation device that calculates the total data value of specified words in page units and outputs it to the specified position of the output device. In the above conventional technique, a desired coordinate value for arranging the total value is designated in advance, and then the word and the total value are output to an output device.

[0003]

In the above-mentioned conventional method, when the layout of the total rows such as totals and averages included in the relational table data is changed, the total rows can be edited by a direct operation. Cannot be placed in a fixed position. On the contrary, with the method that can be arranged at a fixed position in the form, the user cannot directly change the layout of the summary line on the screen.

As described above, the conventional method does not have a sufficient function for efficiently creating a form that is easier to see and understand, and the user can directly operate on the screen to display the total line in the table data. You cannot place summary lines such as the average line and the average line in a fixed position in the form.

The object of the present invention is to solve the above problems by
It is an object of the present invention to provide a method in which total lines and average lines generated from table data can be arranged at fixed positions in a form and a desired form can be created. In other words, total rows such as total rows and average rows are generated from the relational table data displayed on the screen, and the user can change the layout by direct operation on the screen so that the rows can be placed at fixed positions in the form. It is an object to provide a method that can be arranged and can create a desired form.

[0006]

In order to achieve the above-mentioned object, the present invention outputs relational table data to an output device in the same layout format and designates specific items on the displayed table data. Information is input from the input device, and information for performing column breaks, page breaks, or tabulation is input on the screen in the line where the item value of the designated item changes.

Further, a totalization line for displaying the totalization result is inserted. Information for performing column breaks, page breaks, or tabulations, and layout information for tabulation lines are stored in the storage device, and the main layout information stored in the storage device is applied to all locations where the item value of a specified item changes. Display it again on the output device. In addition, by inputting the information that specifies a specific summary line on the displayed tabular data from the input device, you can change the arrangement of the specified line and arrange the information on the screen at a fixed position in a row or block on the screen. input. In addition to this, by changing the layout information of the summary row and the layout information of the normal table data that was changed due to the influence of the summary row and storing it in the storage device, the form that was initially displayed, or the column breaks and page breaks Alternatively, it is held as arrangement information that is different from any of the forms that have been subjected to the aggregation processing. Then, the layout of the form is changed by applying the main arrangement information stored in the storage device to each location where the item value of the designated item changes and displaying it again on the output device.

[0008]

[Function] By outputting the relational format table data to the output device in the same layout format, it becomes possible to present the table in the format normally used by the user on the screen, and the specific items can be displayed on the displayed table data. Input the information that specifies the number from the input device on the screen, and perform a column break or page break when the value of this item is different from the value of the line immediately before this item, or display the total, average, etc. By inputting the information specifying the insertion of the summary line on the screen from the input device, the user can place the summary line specified on the screen at a fixed position in the row or page of the form. Becomes Further, by changing the layout information and storing it in the storage device, it is possible to store the layout information as layout information different from the layout information in the format initially displayed. Then, at each position where the item value of the specified item changes, the arrangement position stored in the storage device is applied and displayed again on the output device, and the arrangement position is changed in conjunction with the remaining rows. Can be displayed.

[0009]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS The present invention relates to a form creation method using a computer, and an object thereof is to convert relational table data into a form format that is easy to see and understand.

The relational table is a format that is easy to process because of its simple structure, and is easy to see and handle from the user's point of view. Therefore, it is used as basic data in many data processing systems. In these systems, it is often seen that the final processing result is output from the printing device in the form of a form, but in this case, the relational table is not output as it is, but the user can see it more easily. There is a request to print after converting to the format.

A typical process for relational table data is to obtain a totaling result such as a total or an average. As one of the modes of the aggregation processing for the relational table, there is a case where the segmented aggregation is sequentially executed and the aggregation result is inserted into the original relational table itself. In order to emphasize the total lines such as totals and averages created in this way and to make the form easy to understand, there is a demand to display the forms separately from other general lines.

Another method for making the relational table easy to see is to display rows in which the values of certain items are the same as one group and distinguish them from other rows. As a unit for gathering a plurality of lines on a form, there is a stage, that is, a block configured by collecting pages or lines.

The present invention adopts the following method in order to solve the above requirements. First, directly specify the items that the user will use as a key on the relational table displayed on the screen,
A block break or page break is executed on the screen image at the place where the value of the same item changes, and the visibility of the data content is increased. After that, key aggregation is performed for the same key, and the aggregation result is added as an aggregation row at the row position where the block or page break is performed on the screen image. The total row thus created is directly specified on the screen image and the position is moved to be displayed at a fixed position in a block or page in the form. According to the present invention, the form desired by the user can be created by the above method.

The embodiments of the present invention will be described below. FIG. 1 is a flowchart showing an embodiment of the processing procedure of the present invention. FIG. 2 shows the hardware configuration of a computer apparatus that implements the present invention. FIG. 3 shows the structure of relational table data stored in the storage device 203.

In FIG. 2, a display 204 is a menu for displaying table data in a relational format, a final form during or after the change, and a user for executing various functions of this system. It is an output device for displaying etc. The keyboard 205 is an input device for inputting data represented by characters and numerical values to this system. The mouse 206 is a pointing-type input device for designating and inputting a position on the display 204 where data is desired to be displayed or a position of an execution menu on the screen. The printer 207 is an output device for printing the form of the final processing result on paper. The processing device 201 internally holds a storage device 203 for storing and holding the relational table data 300 and data necessary for various processes in the present system, and further, the present storage device 203 and the keyboard 205. The input / output devices of the mouse 206 and the display 204 are controlled, the input data from each device is accepted, the data is inspected, and the data is output to each device. Program 2 stored in processing device 201
02 controls the operation of each of these devices.

The table shown in FIG. 3 shows the structure of relational table data stored in the storage device 203. Reference numeral 307 represents an item name of data, and the area below the item name is an area for storing specific data. In the example shown in the figure, specific item names are "grade" 301 and "class" 30.
2, "Name" 303, "Japanese Language Score" 304, "Mathematics Score" 30
5, "English score" 306. For example, when interpreting the contents shown in the data 308 in the first row of the table data, "Tanaka of the 1st year group A has 80 points in national language, 82 points in mathematics, 76 points in English.
It means "point". Note that it is assumed here that the relational table data to be processed by the present system has already been sorted using one or more items as key items.

The operation of each unit in FIG. 2 will be described below with reference to the flowchart in FIG.

First, the relational table data 30
0 is output and displayed on the display 204 (101). In this processing, since the form arrangement information table 400 is referred to,
The structure of this table will be described with reference to FIG.

401, 402, 403, and 404 will be described later, and the table structure below them will be described first. This table stores the data to be displayed on the display 204 in association with the display position and the display content, and one row of data is a unit of one display data. Here, 405, 406, and 407 each form one row. Each display data has an area 408 indicating the identification number of the display data, whether the data to be displayed is a line, or table data 300 in the relational format.
Area 409 for distinguishing the type of variable character or numerical value indicating, and area 410 storing the corresponding item name when indicating relational table data 300, and a display for displaying lines, characters, and numerical values Regions X0 (411) and Y0 (41
2), X1 (413) and Y1 (414). Here, display positions 411, 412, 413, and 4 are shown.
In the case where the display data is a line, reference numeral 14 indicates the coordinate values of the start point and the end point of the line are (X0, Y0), (X1, Y
In the case of character or numerical data, the upper left and lower right points of the rectangular area for displaying the data correspond to (X0, Y0) and (X1, Y1), respectively. For example, the display data of the row 405 is for representing the value of the item of “school year” of the relational table data 300.
This means that the characters are output in the rectangle with the upper left coordinates (X0, Y0) and the lower right coordinates (X1, Y1). y margin 40
1 stores a value indicating how much the display position is sequentially shifted downward on the display 204 (the positive direction of the y-axis) when the display data is repeatedly displayed. ym
The ax (403) stores the maximum value of the y-coordinate value of the position that can be displayed on the display 204 when the display data is repeatedly displayed. Similarly, x margin 402
Stores a value indicating how far the screen is shifted in the right direction (the positive direction of the x-axis) sequentially, and xmax (404) stores the maximum value of the x-coordinate of the displayable position.

Here, when the display data is repeatedly arranged, the priority direction is the y-axis direction, and when the y-coordinate value of the display position of the data to be displayed exceeds ymax (403), the direction is again changed to the x-direction. Repeated arrangement is continued from the coordinate position of y = 0 shifted by the x margin. When the x coordinate value of the data to be displayed exceeds xmax (404), the repeated arrangement is restarted from the position where the X coordinate value and the Y coordinate value on the next page are 0.

The form arrangement information table 400 described above
In step 101, the form is displayed on the display 204 in the same layout as the relational format using the table data 300 in the relational format. This detailed procedure will be described with reference to the flowchart of FIG.

First, the screen for displaying the form is displayed on the display 20.
4 is output and displayed (501). Output example of display screen
Shown in. The screen of FIG. 6 includes a command menu area 610 for executing each function of the present system and a form display area 611. When step 501 is executed, the form display area 611 is in a state where nothing is displayed. Here, the form display area 611 is 620
Is the coordinate origin (0, 0), the right direction is the positive direction of the X axis,
The downward direction is the positive direction of the Y axis.

Next, a position on the screen where the display of the table data is to be started is designated and input using the mouse 206.
In the output example of FIG. 6, the coordinate value (XS, YS) of the point 621 is the display start position designated and input.

Subsequently, 1 is set to the program variable i and 0 is set to each of the program variables y and x (503). Variable i
Indicates which row of the relational table data 300 is to be displayed. The first line at the beginning is set as the initial value. The variable y relates to the display position when the table data is repeatedly displayed, and is for correcting the position in the y-axis direction, and the value obtained by adding this value indicates the coordinate value of the actual display position. The x will be described later.

Next, the relational table data 30
It is checked whether or not data exists in the i-th row of 0 (50
4) If there is no more data, this processing step 10
When 1 is completed and data exists, the form arrangement information table 400 is referred to, the data described in this table is taken out and output to the form arrangement area 611 (505).
The value obtained by adding the value of the variable y to the values of the Y-axis coordinates Y0 (412) and Y1 (414) is used as the actual display coordinate position. For example, line 40 of the form arrangement information table 400
Reference numeral 5 indicates that variable characters, which are the item values of the item name "grade", are displayed in the rectangles (X0, Y0) and (X1, Y1) on the form arrangement area 611. Similarly, in line 408, the item names "Japanese language grade" are placed in rectangles (X0, Y0) and (X1, Y1).
This means that the numerical value that is the item value of is displayed in the form of a character string.
0, Y0), and (Y1, Y1) rectangular lines are displayed.

When the coordinate value (XS, YS) of the point 621 is designated in the processing step 502, the rectangular areas (X0, Y0), (X1 corresponding to all the identification numbers 408 in the form arrangement table 400 are designated. , Y1) of the form arrangement table 400 such that the upper left end of the smallest rectangular area that includes all of these rectangular areas matches the coordinate value (XS, YS) of the point 621.
The coordinate values of Y0, X1, and Y1 are set again.

When the value of the type 409 is "variable character" or "numerical value", the data specifically brought from the relational table data 300 is the number of rows of the value indicated by the variable i, and the item name. It is for the item indicated by the value of 410. Next, the variable i is incremented by 1, the row to be arranged is advanced to the next row of the relational table data 300, and the value of the y margin 401 is added to the variable y (506). Then, the process returns to step 504. Thus, the values of the relational table data can be sequentially displayed on the screen.

Specifically, the row 405 of the form arrangement table 400 is for displaying the data of the items of the grade 301, and in step 505, the data "1" in the first row is (X0 , Y0) and (X1, Y1) are displayed in the rectangle, and in the second time, the data "1" on the second line is (X0,
(Y0 + y), (X1, Y1 + y) is displayed in the rectangle. FIG. 6 shows an example of screen output in a state in which the display of the data of the first line of the relational table data is completed.
The coordinate position of (X0, Y0), (X1, Y1) is point 6
Actual data values 623 corresponding to Nos. 21 and 622 are displayed.

Ym in the form layout information table 400
The ax (403) indicates the maximum value of the Y coordinate of the coordinate position where the table data can be arranged on the form arrangement area 611. As a result of continuing the table data arranging process sequentially according to the above process, when the value of YS + y exceeds ymax (50
7) The coordinate position when displaying the following table data is set to a position where the value of x margin 402 is added in the X-axis direction and the value of y is returned to 0 (508).

In the following, a series of blocks displayed on the form layout area 611 by repeating the display layout of the table data from y = 0 to y = 0 will be referred to as a "block". In the display example of FIG. 7, 711 is an example of the block, and the first arrangement data after the first modified block is executed in step 508 is 710.

The variable x is for correcting the position in the X-axis direction regarding the display position when the table data is repeatedly displayed in this way, and the value obtained by adding this value is the coordinate value of the actual display position. Is shown. After this, while continuously displaying the table data in the Y-axis direction, while shifting the display coordinate position of the table data in the X-axis direction so that the display position of the table data does not exceed the Y-coordinate value ymax of the repeated display lower limit. Output the table data on the screen.

In the above processing, with respect to the repeating direction of the table data, the Y-axis direction is the preferential direction with respect to the X-axis direction. However, in the above description, the description about the X-axis direction and the Y-axis direction is replaced with the right direction. The same processing can be performed even when is the priority repeat direction of the table data.

Xm in the form layout information table 400
The ax (404) indicates the maximum value of the X coordinate of the coordinate position where the table data can be arranged on the form arrangement area 611. As a result of continuing the above processing, in the form arrangement area 611,
Next, the Y coordinate value YS + y of the coordinate position where the table data should be displayed.
Value exceeds ymax (403) and X coordinate value XS +
When the value of x exceeds xmax (404), an empty “page” which has the same structure as the current form arrangement region and which has not been displayed yet is present in the current form arrangement region 611. Create a new one, set the values of variables x and y to 0,
The repeated display of the table data is started again from the coordinate position (XS, YS). Here, a variable p is prepared as a page counter, and the value of p is incremented by 1 each time a page break is executed. This variable p is used for managing the page position currently displayed on the screen.

FIG. 7 shows an example of screen output after the execution of step 101, and it can be seen that the relational form is displayed in a format that is easy for the user to understand. In FIG. 7, 7
01 represents the x margin (401), and 702 represents the y margin (402).

After the relational form is displayed on the screen, the user directly uses the mouse 206 to designate and input items to be used as keys for page breaks, block breaks, and key aggregation. (102). Corresponding to the data of the relational table data 300 and the form arrangement information table 400, the item name designated by the user is obtained.

In the display example of FIG. 7, the item 3 with the item name "class" in the relational table data 300.
If you want to use 02 as a key item, the form layout area 611
Area 7 in the first line where the data corresponding to this item is placed
03 is directly designated on the screen by the mouse 206. A rectangular area (X0 + XS, Y0 + Y obtained from the coordinate values input at this time and the coordinate values of the line 407 corresponding to the item "class" 302 in the form layout information table 400.
S) and (X1 + XS, Y1 + YS) are associated with each other to recognize that the user has designated the item "class" (302).

Subsequently, when the page break and the block break are executed using the item designated in the processing step 102 as a key, after the step 102, the screen command menu: page break 601 or the screen command menu: block break 602. Is executed by selecting and designating with the mouse 203.

The process (103) for executing a page break and a block break will be described with reference to the flowchart of FIG. As a premise, it is assumed that only one item can be designated as a break block key and a page break key, and the same item cannot be designated as both a break block key and a page break key. In addition, when designating key items, specify sequentially from the lower key to the higher key.In the case of a block break and page break, consider the page break key to be a key higher than the block break key. First, an item to be a page break key is specified, and then an item to be a page break key is specified.
Therefore, if an item to be a page break key has already been specified, it is no longer possible to specify an item to be a block key.

First, in step 801, it is checked with reference to the key break information table 1200 of FIG. 12 whether or not the selected key item is already registered as a page break or block key (801).

Here, the key break information table 120
The purpose of putting 0 is to register the item designated by the user as a key for page break, block break, or total for future reference. The key number 1201 is a number assigned to each key item in the order specified by the user, and the item name 1202 is the name of the key item acquired from the relational table data 300. Previous item value 1
203 will be described later. The value in the 1204 column is
If the key item is a block break key or a page break key, it becomes "break block" and "page break", respectively.
The total row attribute 1205 will be described later.

If the item designated as the key by the user is already registered as the page break key or block break key in step 801, step 103 is ended. If not, the process proceeds to step 802, and also refers to the column 1202 to check whether another page break key and block break key are registered.

If neither the page break key nor the block break key is registered, the process proceeds to step 803. Here, the user selects the screen command menu: break block 60.
When 2 is selected, the process proceeds to step 806, and the selected item is registered in the key break information table 1200 as a modified block key. If the user has selected the screen command menu: page break 601, the process proceeds to step 804.

In step 802, if either the page break key or the block break key has already been registered, the item to be the block break key can no longer be newly specified based on the above premise. Step 804
Proceed to. If the user has selected the screen command menu: page break 601 in step 802, step 8
The column 1202 is referred to in 04 to check whether or not a page break key has already been registered. If the page break key has already been registered, step 103 ends. If it is not registered, it goes through step 805 and then step 807.
Then, the selected item is registered in the key break information table 1200 as a page break key.

For one key item, step 80
If the block break key or page break key is registered in the key break information table 1200 in 6 or 807, the form is redisplayed in step 1400 to immediately reflect this change in the form arrangement area 611. To do. Step 1400 will be described later.

The processing of step 103 will be described with reference to the display example of FIG. In the form arrangement area 611, the display area 703 of “A” arranged in the first line of the display data corresponding to the item “class” is directly designated on the screen by using the mouse 206. Subsequently, the screen command menu: break block 602 is similarly selected with the mouse 206. Then, the layout of the display data on the form layout area 611 changes as shown in FIG.

Subsequently, key aggregation is executed. Step 10
When the key item is selected in 2 and the screen command menu: total 603 is selected and designated on the screen using the mouse 206, step 104 is activated. Hereinafter, description will be made using the flowchart shown in FIG. First,
It is checked with reference to the key break information table 1200 whether or not the key item selected in step 102 has already been registered as an aggregate key (1001). If it has already been registered, step 104 ends. Next, the form arrangement information table 400 and the key break information table 1
Referring to 200, it is not registered as a key yet,
In addition, it is checked whether or not there is at least one item whose type is numeric (1002). If it does not exist, step 104 ends. When the screen command menu: total 603 is selected, the actual total processing is started (1003).
First, the item selected in step 102 is registered in the key break table 1200 and the total row arrangement information table 1300 as the total key (1004).

Total row arrangement information table 1 shown in FIG.
The reference numeral 300 is provided for the purpose of displaying the total row separately from other general table data. The number of the totalized row attribute 1301 is included in the key break information table 1200 and corresponds to the number of the column of the totalized row attribute 1205. Placement attribute 1
The value 302 has two values, "normal arrangement" and "fixed arrangement". "Normal layout" is the relational table data 30
It is shown that they are arranged in the form arrangement area 611 in the same format as 0. The “fixed arrangement” and the number of cases 1303 will be described later. The number 1306 is a number assigned to the data included in the total row. The number 1307 in the form arrangement table indicates the number 408 of the data in the form arrangement information table 400 which has a correspondence relationship with each data. Here, in the total row arrangement table 1300, only the data of the number (408) whose value of the type 409 is “numerical value” and “line” is acquired from the form arrangement table 400. Type 130
Reference numeral 8 indicates the type of each data whether it is a numerical value or a line. The item name 1309 has, as a value, the item name corresponding to the total line item of the relational table data. Total attribute 131
0 indicates the content of totaling for each data. Only the data whose value of type 1308 is "numerical value" is the total attribute 13
There are three possible values of the total attribute 1310 having a value of 10, “total”, “average”, and “number of cases”, and “total” is given as an initial value. The sum 1311 will be described later. In step 104, X0 (1312) and Y0 (131
3), X1 (1314), and Y1 (1315) columns are not used.

Subsequently, in step 1400, the form is displayed again. The processing of step 103 up to this stage will be described using the display example of FIG. 11. On the form arrangement area 611 in the state of FIG. 9, the display area 70 of "A" arranged in the first line of the display data corresponding to the item "class"
3 is designated directly on the screen using the mouse 206. Then, on the screen command menu: total 603, similarly use mouse 2
When the selection is made according to 06, the arrangement of the display data on the form arrangement area 611 changes as shown in FIG. It can be seen that the summary lines shown in lines 1101 and 1102 have been added. In the example shown in the figure, at each place indicated by 1103, 1104, and 1105, for the data in which the value of the item "class" is "A", "national score", "mathematical score", "English score" The tabulation result of each item value, here the total value, is the form arrangement area 61.
It is displayed above 1.

Here, regarding step 1400, FIG.
This will be described using the flowchart of FIG. Step 501
After outputting the form display screen in step 1402,
The following initialization process is executed. The value of the variable i is set to 1, and the values of the variables x, y, and p are set to 0, respectively. In the variable n, the number of key items specified by the user in the processing step 102 is set to the key break information table 1200.
Get from and set. Further, referring to the key break information table 1200, the total row arrangement information table 1 corresponding to each key item having a value in the total row attribute 1205
In 300, the value of the number of cases 1303 is set to 0, and for each data in which the value of the type 1308 is “numerical value”, all the values in the column of sum 1311 are set to 0.

The display arrangement of the tabular data including the aggregated data in the form arrangement area 611 will be described below. First,
Step 504 is as described above. Then, in step 1403, the relational table data 30
This is an exceptional process because the value cannot be compared with the previous line at the time when only the data of the 0th to 1st lines are fetched, and in this case, the key break process is not performed.

The processing of steps 1404 and 1405 will be described later. In step 1406, the aggregated row attribute 120 is referred to by referring to the key break information table 1200.
In the total row arrangement information table 1300 corresponding to each key item having 5, the value of the number of cases 1303 is incremented by 1, and at the same time, for each data whose value of the type 1308 is "numerical value", the value of the sum 1311 is set to the relational value. The i-th row value of the corresponding item in the format table data 300 is sequentially added.

The processing of the subsequent step 505 is as described above. In step 1408, the value of the i-th row of the item designated by the user as the key item in the relational table data 300 is recorded in the column of the previous item value 1203 of the key break information table 1200. Hereinafter, steps 506 to 510 have been described above.

Next, the processing of step 1404 will be described with reference to the flowchart of FIG. In step 1501, the value of the variable k is set to 1. Hereinafter, by adding the conditional statement in step 1502 and the variable k in step 1512, the processing from step 1503 onward is looped n times. Here, the variable k indicates the value of the key number (1201) in the key break information table 1200.

In step 1503, by referring to the key break information table 1200, it is determined whether or not the item having the key number (1201) k is the total key, the total row attribute 1205.
Look up. If it is not the aggregation key, step 15
Return to 02. On the other hand, if it is the total key, step 15
Go to 04.

In step 1504, the value of the i-1th row and the value of the ith row of each key item in the relational table data 300 is referred to by referring to the value in the column of the previous item value 1203 of the key break information table 1200. Are compared, and if they are different, the process proceeds to step 1505.

In step 1505, the total row data is displayed with reference to the total row arrangement information table 1300. This process is performed by the same process as step 505, but differs from step 505 in that the data to be displayed is the sum 1311 and the line. In step 1506, k
Total row arrangement information table 13 corresponding to the th key item
The value of each column of the number of cases 1303 and the sum 1311 in 00 is initialized to 0.

Next, the processing of step 1405 will be described with reference to the flowchart of FIG. The meanings of the variables k and n are as described above. Steps 1601 to 1
In 608, the key break information table 1200 is referred to, and if at least one page break key is registered, the variable Fl
If the value of ag is "page break" and only the break block key is registered, the value of the variable Flag is the value of the variable Flag if neither "break block", page break nor break break key is registered. "No".

Hereinafter, when the Flag value is "break block", each of the steps 508, 509 and 510 is executed to perform the break block, and when the Flag value is "break page", 1611 is executed. Steps 510 and 510 are executed to perform a page break, and if the value of Flag is "No", nothing is executed.

Here, the description returns to the flowchart of FIG. Step 1005 relates to the edit processing of the total row element after the key total is completed. Step 1005 will be described with reference to the flowchart of FIG. First, on the form arrangement area 611, the user uses the mouse 206 to select an unnecessary total row element by direct designation on the screen (1701). Then, the operation content for the selected target is selected on the screen. When the user selects the screen command menu: edit 604 using the mouse 206,
The system has a sub-command menu 180 as shown in FIG.
Since 0 is displayed, any menu item is selected from this submenu using the mouse 206. If Delete 1801 is selected from this submenu, Step 170
2 is started, and the description regarding the corresponding data in the total row arrangement table 1300 is deleted.

The above processing will be described with reference to the output example of the form layout screen shown in FIG. In the form arrangement area 611, it is considered that the data of the line indicated by 1106 displayed in the total row 1101 is considered unnecessary and is deleted. When the processes of steps 1701 and 1702 are applied to the line data 1106, the data having the numbers (1306) in the total row arrangement table 1300 of 1, 2, and 3 are deleted from the total row arrangement table 1300. Then, in step 1400, the form is displayed again.

Then, in the same manner as in step 1701,
The display data of the total line item whose total attribute is to be changed is designated on the screen (1704). Then, when the user selects the screen command menu: edit 604 using the mouse 206, the system displays the submenu 1800.
The attribute 1802 is selected and designated by the mouse 206 from this submenu. Then, an interactive operation screen 190 as shown in FIG.
Since the system displays 0, the desired total attribute is selected from the menu 1903 with the mouse 206, and the screen command: OK 1904 is selected with the mouse 206.
Then, in the total row arrangement information table 1300, the value of the total attribute (1310) of the number (1306) corresponding to the total row item designated and selected in step 1704 is changed to the value selected in the menu 1903 (1705). Here, the screen displays of 1901 and 1902 are displayed by the system for guide to the user based on the information held in the total row arrangement information table 1300 and the key break information table 1200. Then step 1
The form is displayed again at 400.

The above process will be described with reference to the output example of the form layout screen shown in FIG. In the form arrangement area 611, the total line item 110 displayed in the total line 1101
3, 1104, 1105, step 1704,
FIG. 20 shows an output example of the form layout screen as a result of applying 1705 to change the total attribute (1310) to “average”. The total line items 2001, 2002 and 2003 are shown in FIG.
It corresponds to the total line items 1103, 1104, and 1105 in 1. In FIG. 20, the editing process performed through step 1005 is reflected, and nothing is displayed in the portion 2004 where the line data was originally displayed.

FIG. 21 shows an output display example of a processing result obtained by further performing page break processing with a key in addition to the form output display example of FIG. The area 2101 on the form arrangement area 611 in which the first line of the display data corresponding to the item name "school year" in the relational table data 300 is arranged is specified on the screen with the mouse 206, and then the screen command menu: Select the total 603 with the mouse 206 on the screen, generate a total line with "Grades" as a key item on the screen, apply processing step 1005 to this total line, delete unnecessary line data, and then total The result of changing the data aggregation attribute to "average" and selecting the screen command menu: page break 601 with the mouse 206 on the screen is displayed in the form layout area 611 in the form output display example of FIG. The data.

In the illustrated example, the totalized row data having the item "class" in the relational table data 300 as the key item is displayed in 2103 to 2106,
The totalized row data having “school year” as a key item is displayed in 2107 and 2108.

Here, the explanation will be returned to the flowchart of FIG. 1 again. Hereinafter, the position fixing process of the total row in the form arrangement area 611 will be described. When the tabulation row is selected on the screen with the mouse 206 (106), the system identifies which item in the relational table data 300 is the key item (107). Next, when the screen command menu: start fixed layout 605 is selected on the screen with the mouse 206, the value of the layout attribute 2201 of the summary row layout information table 1300 shown in FIG. 22 changes from "normal layout" to "fixed layout". . In addition, when the summary line arranged on the screen is directly specified on the screen with the mouse 206,
In the selected state, the display position on the screen can be changed within the range of the form layout area 611 while directly selecting with the mouse 206 (108).

In the form output display example of FIG.
After selecting 07 with the mouse 206 on the screen and selecting the screen command menu: fixed placement start 605 with the mouse 206, the command menu area 610 is displayed as shown in FIG.
It changes like 3. When the total row 2107 of FIG. 21 is selected by the mouse 206, the cursor is directly moved to the position of the total row 2107 of FIG. 23, and the screen command menu: page fixing 2322 is selected by the mouse 206 on the screen. X0 (1312), Y0 (1313), X1 (13
14) and Y1 (1315) columns store absolute coordinate values with the page coordinate origin 2311 as the coordinate origin (1
09). For example, the total line item corresponding to the item "national grade" in the relational table data is point 2314 (X
0, Y0) and the point 2315 (X1, Y1) are arranged in the rectangular area, and therefore 131 of the row whose number (1306) is 1 in the total row arrangement information table 1300.
The values in the columns of 2, 1313, 1314, and 1315 are the values of X0, Y0, X1, and Y1. Here, as described above, the value of the placement attribute 2201 has already been changed to "fixed placement".

In this state, when the screen command menu: fixed layout end 606 is selected with the mouse, the values of X0, Y0, X1, and Y1 in the total row layout information table 1300 are confirmed, and the form is redisplayed in step 111. The display of the command menu area 610 returns to the state of FIG. The in-page position fixing process performed on the totalization row 2107 is also propagated and displayed on the totalization row of another page, here 2108. This operation can perform the position fixing process at any position on the form arrangement area 611 as long as it is the total line generated by the same key item, and when the position fixing process ends. Positions of other summary lines are fixed similarly.

In the above description, the process of fixing the position of the total line in the page has been described. However, when the position of the block is fixed, that is, the screen command menu: fix in page 23
When screen command menu: fixed in block 2321 is selected instead of selecting 22 with the mouse 206, X0 and Y in the total row arrangement information table 1300 are selected.
The values of 0, X1, and Y1 are based on the block origin, that is, the arrangement area of the arrangement data of the first row of each block in the form arrangement area 611, where the X coordinate value and the Y coordinate value are both minimum. Use relative coordinate values. In the example of FIG. 23, points 2312 and 2313 on the form arrangement area 611 are block coordinate origins.

In FIG. 24, the processing is further advanced from the form output display example of FIG. 23 to obtain the relational table data 30.
Aggregation line 241 generated with 0 item "class" as a key
1 shows a state in which the positions of 1, 2414, 2415, and 2416 are fixed in the block. Looking at the total row 2411, the total row arrangement information table 1300 corresponding to this is shown.
For each value of X0, Y0, X1, Y1 registered in
Relative coordinate values of 412 and point 2413 from the block coordinate origin 2312 of the block to which the total row 2400 originally belongs are set.

FIG. 14 is a flow chart of the fixed arrangement of counting lines.
Based on the flowchart shown in FIG. 25, the part corresponding to step 1404 is replaced with the flowchart shown in FIG. The difference from step 1404 is that in the case of "normal arrangement", when the arrangement row data is output and arranged in the form arrangement area 611 in step 1505, the value of the arrangement attribute 1302 in the arrangement row arrangement information table 1300 is referred to. Arranges the summary lines in the same manner as in step 1404, and in the case of "fixed arrangement", arranges the summary lines based on the page coordinate origin and the block coordinate origin.

Below, with respect to step 110, FIG.
Description will be made based on an output example of the form screen of FIG. In the display example of FIG. 24, the total row 2411 is arranged in the form arrangement area 611 by fixing the position in the block. FIG. 26 shows a display example in which the result of repositioning the main totalization row to another position is fixed. Consider a case where the weekly row 2411 is to be arranged at the position 2611. If it is displayed at position 2611 as it is, it will overlap with other general data. Therefore, like the display example of 2601, in order to prevent the fixedly arranged summary row and the repeated display area of other general data from overlapping each other, the repetition limit ymax (403) of the display data in the form arrangement information table 400. The value of is updated to a value smaller than the upper limit y coordinate value of the display area of the total row, and then the form display screen is displayed again.

In the display example of 2401, the unit in which the block is changed by the value of the key item is the form layout area 611.
Although it is displayed as one block above, in the example of 2601, it is divided into two blocks because the repeated display interval of the table data becomes small. In this case,
Within the set of total rows in which the value of the key item for which the block is changed is the same, the block internal position fixing process is performed based on the display position of the block displayed last. In this process, the display position of the total row 2616 is also changed on the form arrangement area 611 following the total row 2614.

In this embodiment, the output is displayed on the display 204. However, by selecting the printer 207 as the output device, the final form can be easily printed out on paper by the same processing procedure. .

[0074]

As described above, according to the present invention,
For the relational table data displayed on the screen, the user creates special row data such as totals and averages by a simple method that directly manipulates the image on the screen,
The layout can be changed and the layout can be changed and displayed at a fixed position in the stage or block in the form. As a result, a form that is easy for the user to see and understand can be created by a simple operation.

[Brief description of drawings]

FIG. 1 is a flowchart showing a processing procedure for realizing an embodiment of the present invention.

FIG. 2 is a hardware configuration of a computer device that realizes an embodiment of the present invention.

FIG. 3 is relational table data.

FIG. 4 is a form arrangement information table.

FIG. 5 is a flowchart showing a procedure for displaying an initial form.

FIG. 6 is a diagram showing an output example of a form processing screen.

FIG. 7 is a diagram showing an output example of a form processing screen.

FIG. 8 is a flowchart showing a processing procedure of a block break and a page break.

FIG. 9 is a diagram showing an output example of a form processing screen after the modified block processing is performed.

FIG. 10 is a flowchart showing a processing procedure of key aggregation.

FIG. 11 is a diagram showing an output example of a form processing screen after key summation processing is performed.

FIG. 12 is a key break information table.

FIG. 13 is a summary row arrangement information table.

FIG. 14 is a flowchart showing a procedure for redisplaying a form after a key break is designated.

FIG. 15 is a flowchart showing a procedure for displaying a total row.

FIG. 16 is a flowchart showing a procedure for displaying a new block and a new page.

FIG. 17 is a flowchart showing a procedure of edit processing for a total row.

FIG. 18 is a diagram showing an output example of an interactive screen for editing total line items.

FIG. 19 is a diagram showing an output example of an interactive screen for changing the total attribute of total line items.

FIG. 20 is a diagram showing an output example of the form processing screen after the edit processing is performed on the totalized rows.

FIG. 21 is a diagram showing an output example of a form processing screen in which a block change, a page break, and a key tabulation process are used together.

FIG. 22 is a summary row arrangement information table.

FIG. 23 is a diagram showing an output example of the form processing screen after the in-page position fixing process has been performed on the total rows.

FIG. 24 is a diagram showing an output example of the form processing screen after the position fixing process in the block is performed on the total row.

FIG. 25 is a flowchart showing a procedure for redisplaying a form after the fixed totalization layout processing is performed.

FIG. 26 is a diagram showing an output example of a form processing screen when the repetition range of display data changes.

[Explanation of symbols]

201 ... Processor, 202 ... Storage program, 203 ...
Storage device, 204 ... Display device, 205 ... Keyboard input device, 206 ... Mouse input device, 207 ... Printer device.

 ─────────────────────────────────────────────────── ─── Continuation of front page (72) Inventor Tetsuya Maruoka 1099, Ozenji, Aso-ku, Kawasaki-shi, Kanagawa Hitachi Ltd. System Development Laboratory (72) Inventor Koichi Shimazaki 5030, Totsuka-cho, Totsuka-ku, Yokohama-shi, Kanagawa Hitachi, Ltd. Software Development Division (72) Inventor Yoshimasa Kanamori 6-81 Onoe-cho, Naka-ku, Yokohama-shi Kanagawa Hitachi Software Engineering Co., Ltd.

Claims (5)

[Claims] 1. A method of creating a form using a computer having an input device, an output device and a storage device, wherein in the case of creating a form based on table data stored in the storage device, (1) the output device Output the table data to
(2) Inputting information for specifying an item of the table data from the input device, (3) identifying a line in which the value of the entered item changes, and (4) data aggregation according to the identified line Perform processing and processing to change the output area, (5)
Re-outputting the table data on the output device so as to insert the result of the tabulation process into a changed row of the table data,
(6) Furthermore, the information for displaying the inserted tabulation result in a fixed place on the output device is input from the input device, and (7) the input fixed place information is stored in the storage device, 8) A form creating method characterized in that, based on the stored fixed place data on the storage device, the totalized result on the output device is output again so as to be arranged at the fixed place. 2. The form creating method according to claim 1, wherein the process of changing the output area in the step (4) includes a page break process in a printing process. 3. The form creating method according to claim 1, wherein the process of changing the output area in the step (4) includes a multi-column printing step. 4. The information input for displaying the totalized result in the step (6) at a fixed place is moved by directly pointing the totalized result on the output device using the pointing device input device which is the input device. 2. The form creation method according to claim 1, wherein the form creation is performed by performing the above. 5. The form creation method according to claim 4, wherein the size of the display area of the table data is changed according to the position of the moved totalization result.