JPH11120270A - Slip data output device and storage medium - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide the output result visually easy to watch while effectively utilizing an output screen by counting the number of specified item data to be outputted for each of plural output areas and successively outputting the classified specified item data to the correspondent output areas based on a count value. SOLUTION: A slip data processing memory 4b inside a RAM 4 stores definition data, format data, print data, counters 1 to 3 and maximum print counter. In the case of performing upward-closing printing, a printing position is moved upward just for the number of lines of a difference between the value of a print counter corresponding to the item to be printed and the value of this maximum print counter by the processing of a CPU 2 and when a blank box exists above, upward-closing printing is performed. Therefore, even when outputting the same item data to the item of a different domain on plural conditions, the condition of 'superscript' can be set so as not to generate the unwanted blank area in the output result by occupying one line by the unit of a record.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

The present invention relates to a form data output device for outputting form data in a database.

[0002]

2. Description of the Related Art In recent years, a database has been used as an effective means for efficiently managing a large amount of information. The database is generally configured by having a plurality of records each including a unique key and a plurality of item data.

For example, in a database of employee information, an employee number is set as a key for each record, and name, gender, age, address, telephone number, and the like are set as item data. In such a database of employee information, when searching for the names of employees whose ages are in their thirties, the data whose age data is in their thirties is searched for.
The name data corresponding to the key (employee number) of the corresponding data is displayed on a display screen or printed by a printing device. That is, in the normal processing in the database, since the processing is always performed while referring to the key, there is a problem as in the example described below.

[0004]

For example, if a gender-specific staff table is created in a database of employee information as in the above-described example, the conventional form data output device produces a result as shown in FIG. Was output. That is, a search is performed in the order of the employee number from the data in which the gender data is female, and in the case of the thirties, the name data is output in the column of the thirties, and the name data is similarly output in the forties and fifties. When the search for the data whose gender data is female is completed, the same processing is performed for the data whose gender data is male.

In the result of FIG. 15, the employee number which is a key is output. However, regardless of whether this employee number is output or not, each row of the output data is assigned to a record corresponding to one key. Therefore, the same line does not include a plurality of name data. Therefore, FIG.
As shown in FIG. 5, blank space was increased as a whole, making it difficult to see visually, and when printing, the paper surface could not be used effectively.

SUMMARY OF THE INVENTION An object of the present invention is to provide a form data output apparatus capable of adjusting an output position by setting at the time of form data output, and obtaining an easily viewable output result while effectively utilizing an output surface. To provide.

[0007]

According to the first aspect of the present invention,
A data output device that sequentially retrieves records from a database that stores a plurality of records composed of a plurality of item data, classifies and outputs data of specific items included in the records, and outputs the specific item data according to predetermined conditions. Classification means for classifying into a plurality of sections; setting means for setting a plurality of output areas for outputting specific item data for each of a plurality of sections classified by the classification means; and a setting means for each of the plurality of output areas. A counting means for counting the number of specific item data output to the output area; and an output for sequentially outputting the specific item data classified by the classification means to a corresponding output area based on the count value of the counting means. And control means.

According to the form data output device of the present invention, records are sequentially retrieved from a database storing a plurality of records each composed of a plurality of item data, and the data of the specific items included in the records are classified. A data output device, wherein the classifying means classifies the specific item data into a plurality of categories according to predetermined conditions, and the setting means outputs the specific item data for each of the plurality of categories classified by the classifying means. A plurality of output areas for setting, the counting means is provided for each of the plurality of output areas, counts the number of specific item data output to the output area,
The output control means sequentially outputs the specific item data classified by the classification means to a corresponding output area based on the count value of the counting means.

Therefore, even when the same item data is output to different sections under a plurality of conditions, unnecessary blanks are not included in the output result by occupying one row (or column, etc.) in record units. An area is not generated, and an output result that is visually easy to see can be obtained while effectively utilizing the output surface.

[0010]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of a form data output device 1 according to the present invention will be described below in detail with reference to FIGS. First, the configuration will be described.

FIG. 1 is a block diagram showing a main configuration of a form data output device 1 according to the present embodiment. In FIG. 1, a form data output device 1 includes a CPU 2, an input device 3, a RAM 4, a display device 5, a printing device 6, a storage device 7,
And a storage medium 8, and each unit is connected by a bus 9.

CPU (Central Processing Unit) 2
Is an application program designated from among various application programs stored in the storage device 7 and corresponding to the form data output device 1, the input device 3
Are stored in the work memory 4a in the RAM 4, various processes are executed in accordance with the application program stored in the RAM 4 in accordance with the input instructions and the input data, and the processing results are stored in the RA 4.
It is stored in the work memory 4a in the M4 and displayed on the display device 5. Then, the processing result stored in the work memory 4a is stored in a storage destination in the storage device 7 which is instructed to be input from the input device 3.

The CPU 2 performs print data creation processing (see FIG. 9) and form printing processing (see FIG. 10) in accordance with an instruction input from the user via the input device 3. FIG. 2 is a diagram functionally showing a flow of a series of these processes performed by the CPU 2. In the following description, an example in which an employee information database as shown in FIG. 3 is stored in the storage device 7 and processing is performed based on data registered in the employee information database will be described. In the example shown in FIG. 3, the unique key “employee number”, “name”, “gender”, “age”,
A record is formed by associating each item data of “address” and “telephone number”, and an employee information database is formed by having a plurality of records.

The input device 3 is operated by an instruction input from a user.
When a form definition process is instructed by the CPU 2, the CPU 2 reads the form editor program from the storage device 7 and displays a form definition screen as shown in FIG. In the example shown in FIG. 4, according to the input from the user,
In the first column from the left of the table to be printed, “sex” is set as item data, and in the second column, “age” is set to 3 as a condition.
It is set to be in the 0s, and "Name" is used as item data.
Is set. In the third and fourth columns, "age" is set in the forties and fifties or more as conditions, respectively, and "name" is set as item data.

Although not shown, the output conditions (character size, top justification, etc.) of each data are also set on the screen shown in FIG. 4, and these various settings are registered, so that the form print data The definition data for storing the creation information and the format data for storing the layout information of the form data to be printed are created and stored in the form data processing memory 4b in the RAM 4.

FIG. 5 is a diagram showing an example of definition data stored in the form data processing memory 4b in the RAM 4. FIG. 6 shows an example of format data stored in the form data processing memory 4b in the RAM 4. FIG. As shown in FIG. 5, the definition data created when the settings as shown in FIG. 4 are made on the form definition screen, specify the database file to be referred to as “employee information”, and set item 0 to “gender”. But,
The items 1a, 1b, and 1c are respectively associated with “names”, and the items 1a, 1b, and 1c are also associated with the conditions for extracting “names”. That is, “sex” is always printed in the print area of item 0 for each record, but “name” is printed in one of the print areas of items 1a, 1b, and 1c, depending on which condition each record satisfies. Printed on

As shown in FIG. 6, the format data corresponding to the definition data shown in FIG. 5 includes, for each of the items 0, 1a, 1b, and 1c, "coordinates" for designating an area and "coordinates" such as a character size. In addition to "Format", various output conditions are associated. For example, in FIG. 6, item 0 is associated with an output condition of “omitting the same data”. This avoids that the data of item 0 is “sex” and that the same data of either “female” or “male” is output continuously for a plurality of records to make the table difficult to see. Is set for. Also, by setting the “sorting key”, it is set to perform sorting using the data of item 0 as a key, and all records are set to “sex”.
For example, after printing all the records of “female”, the result is such that the record of “male” is printed.

Further, an output condition of "top-up" is set for the items 1a, 1b, and 1c, and the present invention is realized by enabling this condition to be set. That is, in the form printing process (see FIG. 10) described below, if there is a blank box at the top of the printing in the form printing process (see FIG. 10) described below, the blank box is printed with respect to the item for which "top justified" is set. It will be. In the following description, each cell in a table in which an area for printing a value, a format, and the like are set is called a box.

After the above-described definition data shown in FIG. 5 and the format data shown in FIG. 6 have been created, if there is an input from the user to instruct printing, the CPU 2 receives an instruction from the input device 3 and The print data creation engine stored in the storage device 7 is read and started, and based on the definition data file and the employee information database specified as the database file to be referred to in the definition data, a print data creation process (described later) is performed. 9), and
The print data as shown in FIG. 7 is created.

In FIG. 7, print data includes a print key, which is a key unique to each record to be printed, and items 0, 1a, 1b, and 1 based on the definition data.
Each item data of c is associated with each other.

When the print data is created,
The CPU 2 reads and activates the form print engine stored in the storage device 7 and sends a control signal for performing a form data printing process based on the format data shown in FIG. 6 and the print data shown in FIG. The print data is output to the printing device 6 to control the printing process of the printing device 6, and a form printing process (see FIG. 10) described later is performed.

The input device 3 includes a keyboard having cursor keys, numeric input keys, various function keys, and the like, and a mouse as a pointing device. The input device 3 outputs to the CPU 2 a signal indicating a key pressed by the keyboard. And outputs an operation signal from the mouse to the CPU 2.

A RAM (Random Access Memory) 4 includes a work memory 4a for storing a designated application program, input instructions, input data, processing results, and the like.
It has a form data processing memory 4b for storing various processing data when printing form data read from the storage medium 8 in the storage device 7.

FIG. 8 is a diagram showing the structure of data stored in the form data processing memory 4b in the RAM 4. In FIG. 8, the form data processing memory 4b stores definition data, format data, print data, counter 1, counter 2, counter 3, and a maximum print counter.

The definition data is, as exemplified in FIG. 5, item data to be output to each item when a user sets data extraction conditions and outputs various tables based on form data in a database. This is data that stores definitions such as names and conditions.

As shown in FIG. 6, the format data is data storing various output conditions in addition to "coordinates", "format" (character size, etc.) of items set by the definition data. Items for which the “top-justified” condition is set in the format data are printed in the uppermost blank box in the uppermost row if a blank box exists in the upper row.

As shown in FIG. 7, the print data is data created by assigning a unique key to each record extracted from the database based on the definition data.

Counter 1, Counter 2, and Counter 3
Is a print counter that is incremented when the item data for which “top justified” is set is printed.
Corresponds to item 1a, counter 2 corresponds to item 1b, and counter 3 corresponds to item 1c.

The maximum printing counter holds the maximum value among the values of the counter 1, the counter 2, and the counter 3. When performing top-up printing, the printing position is moved upward by the number of lines corresponding to the difference between the value of the printing counter corresponding to the item to be printed and the value of the maximum printing counter, thereby forming a blank box at the top. Is present, top-up printing is performed. The initial values of the counter 1, the counter 2, the counter 3, and the maximum print counter are 0.

The display device 5 is a CRT (Cathode Ray Tub).
e) It is constituted by a liquid crystal display device or the like, and displays display data input from the CPU 2.

The printing device 6 prints data created by various application programs corresponding to the form data output device 1.

The storage device 7 has a storage medium 8 in which programs, data and the like are stored in advance, and this storage medium 8 is constituted by a magnetic or optical recording medium or a semiconductor memory. The storage medium 8 is fixedly provided in the storage device 7 or is detachably mounted. The storage medium 8 includes various application programs, menu display programs, and printing programs corresponding to the form data output device 1. A processing program and data processed by each processing program are stored.

The program, data, and the like stored in the storage medium 8 may be configured to be received and stored from another device connected via a communication line or the like. The storage medium 8 is stored in another connected device.
May be provided, and a program, data, and the like stored in the storage medium 8 may be used via a communication line.

Next, the operation will be described. First, a print data creation process executed by the CPU 2 of the form data output device 1 will be described with reference to FIG.

As described above with reference to FIG. 2, after the form editor creates the definition data shown in FIG. 5 and the format data shown in FIG. 6 based on the employee information database as shown in FIG. When a print instruction is input from the input device 3 via the input device 3, the CPU 2 reads out and starts the print data creation engine stored in the storage device 7,
The print data creation process shown in the flowchart of FIG. 9 starts.

First, the CPU 2 retrieves the data of the first record from the employee information database designated as the database file to be referred to in the definition data (step S1), and makes a condition judgment by referring to the definition data (step S2). . In other words, when processing is performed based on the definition data shown in FIG. 5, conditions regarding “age” are set in items 1a, 1b, and 1c as conditions. It is determined whether or not the condition is satisfied.

Next, the CPU 2 determines which item data is to be output for each output section based on the information on the items in the definition data and the condition determination in step S2 (step S3). That is, in the example shown in FIG. 5, it is determined that “sex” data is output for item 0 and “name” data is output for items 1a, 1b, and 1c based on the condition determination in step S2. I do.

Then, the CPU 2 writes each output target data into the form data processing memory 4b in the RAM 4 based on the result of the classification item judgment in the step S3 (step S4), and if there is a next record in the step S5. If determined, the same processing is repeated to sequentially write the output target data into the form data processing memory 4b to create print data as shown in FIG. 7. If it is determined in step S5 that there is no next record, the print data is determined. The print data creation processing ends.

Next, a form printing process executed by the CPU 2 of the form data output device 1 will be described with reference to FIGS.
This will be described with reference to FIG. FIG. 10 is a flowchart illustrating the form printing process. FIG. 11 to FIG. 13 are diagrams illustrating a state in which printing is sequentially performed by the form printing process. FIG. 14 is a diagram illustrating an example of a gender-specific age-specific staff table printed by the form printing process.

First, the CPU 2 prints "person table by gender and age" as the title of the table, shifts the print position one line down, and displays the vertical and horizontal ruled lines as item names "gender alias" and "30". After outputting a control signal to the printing device 6 so as to print the “prints”, “40s” and “50s”, one record is obtained from the print data shown in FIG. 7 created by the print data creation process described above. Eye print key = "1"
Of each item of the record (step S1)
1). Then, if it is determined in step S12 whether or not the last box of one record has been printed, immediately after shifting from step S11, the printing of the last box has not been completed, so the flow shifts to step S13.

In step S13, the CPU 2 determines whether or not “top-up” is set for the box to be printed (here, the box of item 0 which is the first box). In the format data shown in FIG. 6, since “top-justified” is not set in the box of item 0, the CPU 2 moves the box to be printed to the next box of item 1a (step S1).
7).

Then, in step S12, it is determined again whether or not the last box of one record has been printed. Since the printing of the last box has not been completed at this point, the flow shifts to step S13. In the format data shown in FIG. 6, the box of item 1a has "top-up"
Is set, the CPU 2 determines whether or not item data exists in this box (step S1).
4). In the print data shown in FIG.
Since there is no item data of item 1a of "1", only the vertical ruled line is printed (step S16), and the box to be printed is moved to the next box of item 1b (step S17).

Further, it is determined again in step S12 whether or not the last box of one record has been printed.
Since the printing of the last box has not been completed at this time, the process proceeds to step S13. In the format data shown in FIG. 6, "boxed up" is set in the box of item 1b, but since there is no item data in this box, the same processing as in the case of item 1a is performed. . Then, similarly, step S17, step S1
After Step 2 and Step S13, since the item data “Source Shizuka” is present in the item 1c of the print data shown in FIG. 7, it is determined in Step S14 that the item data is present, and (Maximum Print Counter−Counter 3 The print position is moved upward by the number of lines calculated by the calculation of (3) to print the item data and the vertical and horizontal ruled lines, and the value of the counter 3 is incremented (step S15). Here, since the values of the maximum print counter and the counter 3 are both initial values (= 0), the print position does not actually move, and the counter 3 is incremented to "1".

Then, in step S17, processing for moving the box to be printed to the next box is performed.
Since the processing of the last box has been completed by printing, a flag indicating that the next box does not exist is set, and the process proceeds to step S12. This allows step S
In step 12, it is determined that the last box of one record has been printed, and the process shifts to the printing process (step S18) for a box for which the upper-bound printing condition has not been set. In the example based on the format data shown in FIG. 6 and the print data shown in FIG. 7, in step S18, the item data of the box of item 0 is printed. In the print data shown in FIG. 7, since the item data of item 0 with the print key = "1" is "female", "female" is printed in a predetermined area based on "coordinates" stored in the format data. Both vertical and horizontal lines are printed.

Next, the CPU 2 determines whether or not any one of the counter 1, counter 2, and counter 3 has changed the maximum print counter (step S).
19) Here, the value of the counter 3 which is the print counter of the item 1c is "1", and the maximum print counter is "0".
Has changed from “1” to “1”.
It is shifted by a line (step S20). FIG. 11 shows the result of printing by the processing up to this point.

Then, the CPU 2 determines whether or not the next record exists (step S21). At this point, since the next record exists, the process returns to step S12. Thereafter, by repeating the same processing, the result of the print processing for the record of the print key = “2” of the print data shown in FIG. 7 is as shown in FIG.
The item data "Junko Nakayama" is printed in the box in the first row of the "0s" column. This is what was printed in the box one row below in the conventional print result shown in FIG. FIG. 13 shows the result of the printing process performed on the record of the print key “3” of the print data shown in FIG.

The above processing is repeated, and step S2
In step 2, if it is determined that there is a next record, each item data of the next record is read, and if it is determined that there is no next record, the form printing process is terminated. And
When all the print data shown in FIG. 7 is processed, the form shown in FIG. 14 is printed.

The present invention is not limited to the above-described contents, and can be arbitrarily changed without departing from the gist of the present invention. For example, in the above-described embodiment, the case where the output result is printed has been described. However, another output method such as displaying on the display screen of the display device 5 may be used.

In the above-described embodiment, the CPU 2 operates the printing device 6 based on the print data and the format data.
Is controlled while printing is performed. However, a configuration may be adopted in which print data generated while the CPU 2 performs the upper-up processing in advance and is output to the printing device 6 to perform printing.

Furthermore, in the above-described embodiment, the case where the item data is sequentially output in the vertical direction has been described. Therefore, the upper-justification processing is performed. However, left-justification, right-justification, etc. are performed according to the format of the output table. Processing may be performed.

As described above, according to the form data output device 1 of this embodiment, the form data processing memory 4b in the RAM 4 stores the definition data, the format data, the print data, the counter 1, the counter 2, the counter 2, 3, and a maximum print counter. Among these data, the counter 1, the counter 2, and the counter 3 are "up-justified".
Is a print counter that is incremented when the item data in which is set is printed, and the counter 1 is added to the item 1a.
Counter 2 is item 1b, and counter 3 is item 1c.
Respectively, and the maximum print counter holds the maximum value among the values of the counter 1, the counter 2, and the counter 3. When performing top-up printing, the CPU 2 moves the print position upward by the number of lines corresponding to the difference between the print counter corresponding to the item to be printed and the value of the maximum print counter. ,
When there is a blank box above, top-up printing is performed.

Therefore, even when the same item data is output to items of different categories according to a plurality of conditions, an unnecessary blank area is generated in the output result because one line is occupied by each record. Since the condition of “top justification” can be set so as not to be lost, it is possible to obtain an output result that is visually easy to see while effectively utilizing the output surface.

[0053]

According to the first aspect of the present invention, even when the same item data is output to different sections according to a plurality of conditions, one row (or column, etc.) is used for each record.
Occupation of the information does not cause an unnecessary blank area in the output result, and it is possible to obtain an visually easy-to-view output result while effectively utilizing the output surface.

According to the second aspect of the present invention, even when the same item data is output to different sections under a plurality of conditions, one row (or column, etc.) is occupied in record units. As a result, an unnecessary blank area is not generated in the output result, and the form data output program capable of obtaining a visually easy-to-view output result while effectively utilizing the output surface can be executed by the computer.

[Brief description of the drawings]

FIG. 1 is a block diagram illustrating a main configuration of a form data output device 1 according to an embodiment of the present invention.

FIG. 2 is a diagram functionally showing a flow of a series of processes performed by a CPU 2 shown in FIG.

FIG. 3 is a diagram showing an employee information database as an example of a database stored in a storage device 7;

FIG. 4 is a view showing a form definition screen displayed on the display screen of the display device 5 shown in FIG. 1 when the form definition processing is executed.

5 is a diagram showing an example of definition data stored in a form data processing memory 4b in a RAM 4 shown in FIG.

6 is a diagram showing an example of format data stored in a form data processing memory 4b in a RAM 4 shown in FIG.

7 is a diagram showing an example of print data stored in a form data processing memory 4b in a RAM 4 shown in FIG.

8 is a diagram showing a configuration of data stored in a form data processing memory 4b in a RAM 4 shown in FIG.

FIG. 9 is a flowchart illustrating print data creation processing executed by CPU 2 of form data output device 1.

FIG. 10 is a flowchart illustrating a form printing process executed by a CPU 2 of the form data output device 1.

FIG. 11 is a first diagram illustrating a state in which printing is sequentially performed by the form printing process illustrated in FIG. 10;

FIG. 12 is a second diagram following FIG. 11;

FIG. 13 is a third diagram following FIG. 11;

FIG. 14 is a diagram showing an example of a gender-specific age-specific staff list printed by the form printing process shown in FIG.

FIG. 15 is a diagram illustrating an example of a gender-specific age-specific staff list printed by a conventional form printing process.

[Explanation of symbols]

 Reference Signs List 1 form data output device 2 CPU 3 input device 4 RAM 4a work memory 4b form data processing memory 5 display device 6 printing device 7 storage device 8 storage medium 9 bus

Claims (2)

[Claims] 1. A data output device which sequentially retrieves records from a database storing a plurality of records composed of a plurality of item data and classifies and outputs data of specific items included in the records, comprising: Classifying means for classifying data into a plurality of categories according to predetermined conditions; setting means for setting a plurality of output areas for outputting specific item data for each of a plurality of categories classified by the classifying means; A counting means provided for each area and counting the number of specific item data output to the output area; and an output area corresponding to the specific item data classified by the classification means based on the count value of the counting means. Output control means for sequentially outputting the data to the data output device. 2. A storage medium storing a program for sequentially taking out records from a database storing a plurality of records composed of a plurality of item data, classifying and outputting data of specific items included in the records, A computer-executable program code for classifying specific item data into a plurality of sections according to predetermined conditions; and a plurality of output areas for outputting the specific item data for each of the plurality of classified sections. A computer-executable program code, for each of the plurality of output areas, a computer-executable program code for counting the number of specific item data output to the output area, A computer-executable program for sequentially outputting classified specific item data to corresponding output areas. A storage medium storing a program including a gram code and a program.