JP6221625B2 - Data output program, data output method, and data output device - Google Patents

Description

  The present invention relates to a data output program, a data output method, and a data output device.

  2. Description of the Related Art Conventionally, when outputting tabular data, a technique is known in which, when an item at the end of a table deviates from the output screen, the off-item is moved to the next row of the table (see, for example, Patent Document 1). ).

JP-A-10-187856

  Even in record format data having a plurality of items, depending on the number of items, the length of each item, and the like, not all items may fit in a print medium such as a screen or printing paper. In this case, the user needs to scroll the screen in the direction in which the items are arranged, change the reduction ratio when displaying or printing, or print over multiple sheets, which may make it difficult to see the record format data. .

  However, in the above-mentioned Patent Document 1, it is not assumed until a record format data having a plurality of items is output.

  In one aspect, an object of the present invention is to provide a data output program, a data output method, and a data output device that can output record-format data in an easily viewable manner.

In one aspect, the data output program extracts a plurality of items included in data in a record format, including a plurality of records including values of a plurality of items, and stores information related to items whose contents are related to each other , It is determined whether or not two or more items whose contents are related to each other are included in the extracted plurality of items, and when two or more items whose contents are related to each other are included, Arrange two or more items in the first direction, arrange the two or more items arranged in the first direction and items other than the two or more items in a second direction different from the first direction, and output the data A data output program for causing a computer to execute processing.

In one aspect, a data output method includes a plurality of records including a plurality of items including values of items, the plurality of items included in data in a record format, and a storage unit that stores information related to items whose contents are related to each other , It is determined whether or not two or more items whose contents are related to each other are included in the extracted plurality of items, and when two or more items whose contents are related to each other are included, Arrange two or more items in the first direction, arrange the two or more items arranged in the first direction and items other than the two or more items in a second direction different from the first direction, and output the data This is a data output method in which a computer executes processing.

In one aspect, the data output device stores information related to items whose contents are related to each other , and an extraction unit that extracts a plurality of items included in data in a record format, including a plurality of records including values of a plurality of items A determination unit that determines whether or not two or more items whose contents are related to each other are included in the extracted plurality of items, and two or more items whose contents are related to each other If included, the two or more items are arranged in a first direction, and the two or more items arranged in the first direction and items other than the two or more items are arranged in a second direction different from the first direction. And an output unit that outputs the data side by side.

  Record format data can be output easily.

It is a figure which shows schematically the structure of PC concerning one Embodiment. It is a functional block diagram of PC. 3A is a diagram showing the data structure of the trigger (print) management DB, FIG. 3B is a diagram showing the data structure of the trigger (screen) management DB, and FIG. It is a figure which shows the data structure of column item management DB. It is a flowchart which shows a display process. It is a figure which shows the data of a record format. It is a flowchart which shows the specific process of step S22 of FIG. FIG. 7A is a flowchart showing a specific process of step S40 in FIG. 6, and FIG. 7B is a flowchart showing a specific process of step S58 in FIG. FIG. 8A and FIG. 8B are diagrams for explaining the automatic column processing, and FIG. 8C is a flowchart showing the specific processing of step S62 in FIG. It is a figure which shows the output example of the data of the record format after a column. It is a figure which shows the example of an output of the data of a record format when a column is not performed. It is a flowchart which shows a printing process. It is a figure which shows the column item management DB used in the modification 1. It is a flowchart which shows the process of step S22 of the modification 1. It is a figure which shows the item type management DB used in the modification 2.

  Hereinafter, an embodiment will be described in detail with reference to FIGS.

  FIG. 1 shows a hardware configuration of a PC (Personal Computer) 10 as a data output device. The PC 10 of the present embodiment is an information processing apparatus used for operations such as creation and browsing of record format data such as forms. In response to an instruction from the user, the PC 10 outputs (displays) record format data (see FIG. 5 and the like) on the screen of the display unit 93 and outputs (prints) it to the printer 20. The PC 10 processes the data based on the record format data, the size of the screen of the display unit 93 and the size of the print medium (print target paper, etc.) set in the printer 20, and then the display unit 93 or In some cases, the data is output to the printer 20.

  As shown in FIG. 1, a PC 10 includes a CPU (Central Processing Unit) 90, a ROM (Read Only Memory) 92, a RAM (Random Access Memory) 94, a storage unit (HDD (Hard Disk Drive)) 96, and an interface unit. 97, a portable storage medium drive 99, and the like. Each component of the PC 10 is connected to a bus 98. A display unit 93 and an input unit 95 are connected to the interface unit 97. The display unit 93 includes a liquid crystal display or the like, and the input unit 95 includes a keyboard and a mouse. In the PC 10, the CPU 90 executes a program (including a data output program) stored in the ROM 92 or the HDD 96, or a program (including a data output program) read from the portable storage medium 91 by the portable storage medium drive 99. Thus, the function of each unit in FIG. 2 is realized.

  In addition to the display unit 93 and the input unit 95, the printer 20 is connected to the interface unit 97 of the PC 10. It is assumed that the PC 10 and the printer 20 are connected via a printer cable, a USB (Universal Serial Bus) cable, a LAN (Local Area Network) cable, or the like. However, the present invention is not limited to this, and the PC 10 and the printer 20 may be connected by a wireless LAN. A printer such as an inkjet printer or a laser printer is an example of the printer 20.

  FIG. 2 shows a functional block diagram of the PC 10. When the CPU 90 executes the program, the PC 10 functions as an output instruction acquisition unit 30, a record acquisition unit 32, an extraction unit, a determination unit, an output unit, and an output processing unit 34 as a determination unit. 2 also shows a record DB 40, a trigger (printing) management DB 42, a trigger (screen) management DB 44, and a column item management DB 46 stored in the HDD 96 or the like.

  The output instruction acquisition unit 30 instructs to output (display) record format data on the screen of the display unit 93 input by the user via the input unit 95 or output (print) the record format data using the printer 20. The instruction is acquired and transmitted to the record acquisition unit 32.

  The record acquisition unit 32 acquires data in a record format corresponding to the output instruction received from the output instruction acquisition unit 30 from the record DB 40. In the present embodiment, record format data refers to data in which values for a plurality of items are included in one record and a plurality of such records are included. In addition, the items included in each record have a parallel relationship, and information such as column designation when outputting as a table is not included. As an example of data stored in the record DB 40, data managed in a table format as shown in FIG. Here, in the data example of FIG. 5, a list of customers is shown as an example of record format data. One record shown in the list of customers includes a plurality of items such as a store number, a customer number, a full name, and a full name. The plurality of items are not in a so-called column state in which one item is stored in one column in the table, and the values of the plurality of items are stored in one column. The record acquisition unit 32 may acquire record format data from another computer such as a data server via a network or the like.

  The output processing unit 34 specifies two or more items for executing the column from among a plurality of items (items such as “store number” and “customer number” shown in FIG. 5) included in the record format data. Here, “column” means that two or more items are arranged in the same column (vertical direction) if a plurality of items included in one record are arranged in the horizontal direction as shown in FIG. (Refer to the column “Name Full Name” in FIG. 9). The output processing unit 34 refers to the trigger (printing) management DB 42, and records a record format when the acquired data items do not fit in one direction (for example, the horizontal direction) of the print target paper set in the printer 20. Two or more items are specified from a plurality of items included in the data. Alternatively, the output processing unit 34 refers to the trigger (screen) management DB 44, and if the data items acquired in one direction (for example, the horizontal direction) of the screen of the display unit 93 cannot be entered, Two or more items are specified from a plurality of included items. Here, when specifying two or more items, the output processing unit 34 refers to the column item management DB 46.

  Further, the output processing unit 34 arranges the two or more specified items in the first direction (for example, the vertical direction), and arranges the two or more items arranged in the first direction and the other items in the second direction (for example, the horizontal direction). The data in the record format is output to the display unit 93 and the printer 20. That is, the data in the record format is output to the display unit 93 and the printer 20 in a state where two or more specified items are arranged.

  3A shows the data structure of the trigger (print) management DB 42, and FIG. 3B shows the data structure of the trigger (screen) management DB 44. As shown in FIG. FIG. 3C shows the data structure of the column item management DB 46. Here, although the data structures in any of FIGS. 3A to 3C show examples in which data is managed in a table format, the data management method is not necessarily limited to this. Data may be stored in any format as long as the relationship between the field data stored in association with each other in FIGS. 3A to 3C is maintained.

  As shown in FIG. 3A, the trigger (printing) management DB 42 has fields of “print target paper, direction” and “appropriate amount of horizontal size”. The “print target paper, direction” field stores information indicating the combination of the print target paper size (A3, A4, B4, etc.) and the print direction (vertical or horizontal). In the “appropriate amount horizontal size” field, the horizontal size of data in a record format suitable for printing on each print target paper is stored. The appropriate amount of horizontal size is determined in consideration of the left and right margins at the time of printing.

  Further, the trigger (screen) management DB 44 has fields of “display amount (Pixel)” and “appropriate amount horizontal size” as shown in FIG. In the “display amount (Pixel)” field, the display amount of the screen of the display unit 93 is stored. In the “appropriate amount horizontal size” field, the horizontal size of data in a record format suitable for display on the screen of each display amount is stored.

  In addition, as a unit of the above-described display amount and appropriate amount horizontal size, pixel, point, inch, and other unit system specific to the application software that generates the record to be processed can be used. Whatever unit is used, it is sufficient if the total width of each field of the record to be processed can be compared with the width of the paper or screen to be output. It can be set. Note that the unit representing the horizontal width of each field of the record and the unit representing the horizontal width of the paper or screen to be output can be converted to each other.

  As shown in FIG. 3C, the column item management DB 46 has fields of “column item name 1”, “column item name 2”, and “continuity”. The “column item name 1” and “column item name 2” fields store combinations of items that can be columned among the items included in the record. It can be said that the combination of items that can be arranged is a combination of items in which the contents indicated by the data items are related to each other, such as a kanji name item and a reading kana item. In the “continuity” field, either “1” or “0” is stored as flag data. “1” is set when the item names stored in the “column item name 1” and “column item name 2” fields are items output at consecutive positions in one record. Indicates that the assembly is performed. “0” indicates that a column is set if it exists in a record even if it is not an item that is output at consecutive positions in one record. Note that “*” stored in the column item name 1 or the column item name 2 means a wild card (arbitrary character). Therefore, the item name “Kana *” includes item names such as “Kana address” and “Kana name”.

  Next, specific processing (display processing and printing processing) of the PC 10 (particularly, the record acquisition unit 32 and the output processing unit 34) will be described with reference to the flowcharts of FIGS. 4, 6, 7, and 8C. Details will be described with reference to other drawings as appropriate.

(About display processing)
FIG. 4 shows processing executed when the user inputs an instruction to display record format data on the screen of the display unit 93 via the input unit 95. That is, the process executed when the output instruction acquisition unit 30 acquires an instruction to display record format data on the screen is shown.

  In the process of FIG. 4, first, in step S <b> 10, the record acquisition unit 32 acquires data in a record format designated by the user from the record DB 40. Here, the record acquisition part 32 shall acquire the data of a record format as FIG. 5 as an example.

  Next, in step S11, the output processing unit 34 acquires a display amount, that is, a horizontal display amount of the display screen. Here, as an example, it is assumed that 1024 (pixels) has been acquired as the display amount of the display unit 93.

  Next, in step S12, the output processing unit 34 acquires the horizontal size when outputting all items included in one record of the record format data acquired in step S10. The horizontal size is, for example, the total cell width of all items. It is assumed that the output processing unit 34 knows in advance which line should be used to obtain the horizontal size among a plurality of lines included in the record format data, that is, records.

  Next, in step S14, the output processing unit 34 searches the trigger (screen) management DB 44 in FIG. 3B using the acquired display amount value as a key, and extracts an appropriate amount horizontal size of the screen. When the display amount of the display unit 93 is 1024 (pixels), “1152” is extracted as the appropriate amount horizontal size. Next, in step S16, the output processing unit 34 compares the extracted appropriate amount horizontal size with the horizontal size of all items acquired in step S12.

  Next, in step S18, the output processing unit 34 determines whether or not the horizontal size acquired in step S12 is larger than the appropriate amount horizontal size extracted in step S14. In step S18, when the record format data is displayed as it is, it can be determined whether or not the record format data protrudes from the screen. For example, it can be said that it is determined whether or not the customer list in FIG. 5 which is data in the record format protrudes from the screen when items are displayed side by side as shown in FIG. If the determination is negative (step S18: No), the process proceeds to step S24. If the determination is positive (step S18: Yes), the process proceeds to step S20.

  When the process proceeds to step S20, the output processing unit 34 initializes a column insertion row insertion flag. For example, the column row insertion flag is reset to 0. Next, in step S22, the output processing unit 34 executes a column determination subroutine. In this column determination subroutine, the output processing unit 34 executes processing according to the flowchart of FIG.

  In the process of FIG. 6, first, in step S <b> 30, the output processing unit 34 extracts all items included in one record of the record format data to be output, and sets the total number to N. All items are ordered in the output order in the horizontal direction, and the order is stored in association with the items. It is assumed that the output processing unit 34 knows in advance in what row and what column from which column the item name is input in the record format data. Next, in step S32, the output processing unit 34 sets a parameter n indicating the order of items to be processed to 1.

  Next, in step S34, the output processing unit 34 determines whether or not the nth item is already assembled. If the determination here is affirmative (step S34: Yes), that is, if it is already set, it is not necessary to perform any further processing for the processing of that item, and the routine proceeds to step S64. If the determination is negative (step S34: No), that is, if it is not already assembled, the process proceeds to step S36.

  In step S36, the output processing unit 34 searches for the column item name 1 and the column item name 2 in the column item management DB 46 using the nth item. For example, when the n-th item is “name”, it is searched whether “name” exists in the column item name 1 and the column item name 2 of the column item management DB 46. For example, when the nth item is “name”, the record in the first line from the top of the column item management DB 46 is searched.

  Next, in step S38, the output processing unit 34 determines whether there is a matching item in the search in step S36. When the determination here is negative (step S38: No), that is, when the n-th item does not exist in the column item management DB 46, the process proceeds to step S40, and the output processing unit 34 A subroutine for column button installation processing is executed. In step S40, the output processing unit 34 executes the process of FIG.

  In the process of FIG. 7A, first, in step S70, the output processing unit 34 installs a column button object on the nth item (see reference numeral 60 in FIG. 9).

  Next, in step S72, the output processing unit 34, with respect to the installed column button object, “the item of the button pressed first when the two column button objects are pressed, and the button pressed later. Embed a macro process that causes the computer to execute the process of “lining items up and down”. Also, a macro process for causing the computer to execute a process of “installing a column release button object on the columned item after the column process is performed” is embedded. In this way, by embedding the macro processing in the column button object, it is possible to accept an input of an instruction to column arbitrary two items from the user.

  After the process in FIG. 7A is completed as described above, the process proceeds to step S64 in FIG.

  On the other hand, if the determination in step S38 of FIG. 6 is affirmative (step S38: Yes), that is, if it is determined that the nth item exists in the column item management DB 46, the process proceeds to step S42. Then, the output processing unit 34 extracts the value of the “continuity” field in the record retrieved from the column item management DB 46. For example, in the case of the record in the first row from the top of the column item management DB 46 in FIG. 3C, the continuity is “0”. In this case, the column item name 1 “name name reading” and the column item name 2 “name” may be arranged even if the output positions of the items are not continuous in one record. Means. On the other hand, in the case of the record in the second row from the top, the continuity is “1”, so the “work phone number” of the column item name 1 and the “work name kanji” of the column item name 2 are This means that the column may be set only when the output positions of the items are continuous in one record.

  Next, in step S44, the output processing unit 34 determines whether or not the extracted continuity is “1”. When it is “0”, the determination here is denied (step S44: No), and the process proceeds to step S52. If the determination is affirmative (step S44: Yes), the process proceeds to step S46.

  When the process proceeds to step S46, that is, when the value of the field “continuity” is “1”, the output processing unit 34 includes the n + 1-th item and the (n−1) -th item that are items adjacent to the n-th item, Of the column item names 1 and 2, the column item name that does not match the n-th item is compared. For example, if the nth item is “work phone number” and there is a matching value in “column item name 1” in the column item management DB 46, the n + 1th item, the (n−1) th item, and “ The value of “column item name 2” is compared with “workplace name kanji”. Depending on the value of n, either the (n + 1) th item or the (n-1) th item may not exist.

  Next, in step S48, the output processing unit 34 determines whether or not they match as a result of the comparison in step S46. If the determination here is negative (step S48: No), the process proceeds to step S40, and a column button installation process is performed as described above. If the determination is affirmative (step S48: Yes), the process proceeds to step S50.

  When the process proceeds to step S50, the output processing unit 34 sets the n-th item and the matching adjacent item as the column target n1 and the column target n2. When the nth item is “work phone number”, the column item name 1 “work phone number” in the column item management DB 46 is set as the column target n1, and the column item name 2 “work name kanji”. Is a column target n2. Thereafter, the process proceeds to step S58. In step S50, the nth item may be the column target n1, and the adjacent adjacent item may be the column target n2.

  If the determination in step S44 is negative, that is, if the value of the field “continuity” is “0”, the output processing unit 34 proceeds to step S52, where the column item name 1, Among N items, N items are searched using items other than the nth item as keys. For example, when the n-th item is “name”, the “name reading” stored in the column item name 1 of the column item management DB 46 in association with “name” is included in the N items. Search whether or not

  Next, in step S54, the output processing unit 34 determines whether there is a match (is included). If the determination here is negative (step S54: No), the process proceeds to step S40, and the column button installation process is performed as described above. If the determination is affirmative (step S54: Yes), the process proceeds to step S56. In step S56, the output processing unit 34 sets the n-th item and the item searched in step S52 as the column target n1 and the column target n2. Thereafter, the process proceeds to step S58.

  When the process proceeds to step S58 through step S50 or step S56, the output processing unit 34 executes a subroutine for automatic column processing. In this automatic column processing subroutine, the output processing unit 34 executes processing in accordance with the flowchart of FIG.

  In the process of FIG. 7B, the output processing unit 34 reads the column-insertion row insertion flag in step S80. Immediately after step S20, “0” is read as the column insertion row insertion flag.

  Next, in step S82, the output processing unit 34 refers to the column row insertion flag and determines whether or not the column row insertion flag is 1, that is, whether or not a row has been inserted. . When judgment here is affirmed (step S82: Yes), it transfers to step S88. If the determination is negative (step S82: No), the process proceeds to step S84.

  When the process proceeds to step S84, the output processing unit 34 inserts one line in each record format data to be displayed, that is, in each record line (see the broken line portion in FIG. 8A). Next, in step S86, the output processing unit 34 sets the column insertion row insertion flag to “completed” (= 1). Thereafter, the process proceeds to step S88.

  In step S88, the output processing unit 34 moves the data of the column target n2 directly below the column target n1 (refer to the item “Name Name” in FIG. 8B). That is, the output positions of the data of the column target n1 and the data of the column target n2 are set in the same column. Thereafter, the process proceeds to step S60 in FIG. The output processing unit 34 deletes the column in which the column target n2 existed (the column of “name” in FIG. 8A) after moving the data of the column target n2 directly below the column target n1. This should be done (see FIG. 8B).

  If transfering it to step S60, the output process part 34 will be set as the column completed about the item made into the column target n1 and the column target n2. Next, in step S62, the output processing unit 34 executes a subroutine for column release button installation processing. In the subroutine for the column release button installation process, the output processing unit 34 executes the process according to the flowchart of FIG.

  In the process of FIG. 8C, first, in step S90, the output processing unit 34 installs a column release button object on the columned item (see reference numeral 62 in FIG. 9).

  Next, in step S92, the output processing unit 34 embeds in the installed column release button object a macro process that causes the computer to execute a process of “canceling the column when the button is pressed”. When this column release button object is pressed by the user, for example, a new column is inserted on the right side of the column that has been columned, and the item name portion and the data portion of the column that has been columned are divided. Move the items and data that were located below the set to the newly inserted column. If a blank line is generated due to data movement, the blank line is deleted. In this way, by embedding the macro processing in the column release button object, it is possible to receive an input from the user to release the column of the column items.

  When the column release button installation processing subroutine is completed as described above, the process proceeds to step S64 in FIG.

  When the process proceeds to step S64 in FIG. 6 through the above processing, the output processing unit 34 increments n by 1 (n = n + 1). Next, in step S66, the output processing unit 34 determines whether n is larger than N. When the determination here is negative (step S66: No), that is, when the processing of steps S34 to S62 is not executed for all items, the process returns to step S34, and steps S34 to S62 for the remaining items. Execute the process. On the other hand, if the determination in step S66 is affirmative (step S66: Yes), the entire process in FIG. 6 is terminated and the process proceeds to step S24 in FIG.

  After the determination in step S18 is denied or the determination in step S18 is affirmed, and after passing through steps S20 and S22, when the process proceeds to step S24, the output processing unit 34 performs the above-described processing on the display unit 93. The data in the record format after output is output.

  In addition, when the process of step S24 is performed after the determination of step S18 is denied, the record format data in which items are arranged in the horizontal direction is displayed on the screen of the display unit 93. That is, items are displayed side by side in the row direction as shown in FIG. On the other hand, when the processing in step S22 is performed after the processing in step S22 is performed, some items are columned on the screen of the display unit 93 and the column button object is displayed. For example, a screen as shown in FIG. 9 is displayed as data in the record format in which the column release button object is installed. If the column determination process of step S22 is performed but the automatic column processing of step S58 has never been performed, a column button object as shown in FIG. 10 is placed on each item. Displayed.

  Here, as described above, the record format data as shown in FIG. 9 is displayed on the screen of the display unit 93 so that the user can view all the items included in one record. It is possible to suppress a reduced display and to scroll the screen horizontally. As a result, it is possible to display the record format data in an easy-to-view state. In addition, the user can manually set two items that are not automatically set by pressing two column button objects, and automatically or automatically by pressing a column release button object. It is possible to cancel the column setting of manually set items.

(About print processing)
Next, the printing process will be described. FIG. 11 is a flowchart showing processing executed by the record acquisition unit 32 and output processing unit 34 of the PC 10 in particular. The process of FIG. 11 is a process executed at the timing when the output instruction acquisition unit 30 acquires a print instruction for data in the record format input by the user via the input unit 95. Note that the user specifies data to be printed in the print property instruction, and also specifies the size and printing direction of the print target paper.

  In the process of FIG. 11, first, in step S <b> 110, the record acquisition unit 32 acquires data of a specified record format from the record DB 40.

  In step S <b> 111, the output processing unit 34 acquires information on the size of the print target paper and the print direction from the information included in the print properties. Here, as an example, it is assumed that the output processing unit 34 acquires “A4” as the size of the print target paper and “horizontal” as the printing direction.

  Next, in step S112, as in step S12, the output processing unit 34 acquires the horizontal size when outputting all items included in one record of the data in the record format acquired in step S110. The horizontal size is, for example, the total cell width of all items. It is assumed that the output processing unit 34 knows in advance which line should be used to obtain the horizontal size among a plurality of lines included in the record format data, that is, records.

  Next, in step S114, the output processing unit 34 searches the trigger (printing) management DB 42 in FIG. 3A using the acquired print target paper and direction information as keys, and displays an appropriate amount of horizontal size in the print property. To extract. For example, when the combination of the print target paper and the direction is “A4 landscape”, “1060” is extracted as the appropriate amount of landscape size. Next, in step S116, the output processing unit 34 compares the extracted appropriate amount horizontal size with the horizontal size of all acquired items.

  Next, in step S118, the output processing unit 34 determines whether or not the horizontal size acquired in step S112 is larger than the appropriate amount horizontal size extracted in step S114. When judgment here is denied (step S118: No), it transfers to step S124. If the determination is affirmative (step S118: Yes), the process proceeds to step S120.

  When the process proceeds to step S120, the output processing unit 34 initializes a column insertion row insertion flag. For example, the column row insertion flag is reset to 0. Next, in step S122, the output processing unit 34 executes a column determination subroutine. Note that, in this column determination subroutine, the output processing unit 34 executes processing according to the flowchart of FIG. 6 as in the case of display processing. However, since it is not necessary to install a column button object or column release button object at the time of printing, steps S40 and S62 in FIG. 6 are omitted.

  After the determination in step S118 is denied or the determination in step S118 is affirmed and the process proceeds to step S124 after passing through steps S120 and S122, the output processing unit 34 performs the above-described processing on the printer 20. Output the data in the later record format.

  Note that if the process of step S124 is performed after the determination of step S118 is denied, record-format data in which items are arranged in the horizontal direction as shown in FIG. 5 is printed on the print target paper. . On the other hand, when the process of step S122 is performed after the process of step S122 is performed, the record format data in which some items are stacked is printed on the print target paper. become. That is, the part excluding the column button object and the column release button object from FIG. 9 is printed.

  In the present embodiment, as described above, by printing the record format data after the column setting, it is possible to suppress the occurrence of a situation in which the horizontal direction of the record cannot fit into one sheet of paper.

  In the present embodiment, the print preview screen may be displayed on the display unit 93 before executing the printing process. In this case, as shown in FIG. 9, a screen in which column button objects and column release button objects are placed on record format data may be displayed. As a result, the user can perform printing on the print target paper after processing the data in the record format using the column button object, the column release button object, or the like.

  As described above in detail, according to the present embodiment, the output processing unit 34 extracts a plurality of items included in the record format data (S30), and among the extracted items, a predetermined 2 It is determined whether or not two items are included (S46, S48, S52, S54), the two specified items are arranged in the vertical direction (column direction), and the two items arranged in the column direction and other than the two items Are arranged in the horizontal direction (row direction) and data is output (S58, S24). Thereby, it is possible to suppress the protrusion of a part of the item from the screen and the protrusion from the print target paper, which are generated when the data items in the record format are output in the horizontal direction. Therefore, according to the present embodiment, the user does not need to scroll the screen in the direction in which the items are arranged, change the reduction ratio when displaying or printing, or print over multiple sheets. It can be said that the data is easily output.

  Further, in the present embodiment, when specifying two items, the output processing unit 34 refers to the column item management DB 46 that stores information related to combinations of items that can be columned, and stores them in the column item management DB 46. Since two items are specified from among a plurality of items based on the information that has been set, it is possible to specify the two items to be arranged in a simple process.

  When displaying record format data on the screen, the output processing unit 34 displays a column button object and a column release button object together with the data display. As a result, the user can issue an instruction to cancel the column setting of the automatically arranged items or an instruction to set the two items that are not arranged to the PC 10. Therefore, the user can manually process the data in the record format.

  Also, in the present embodiment, whether or not to perform columnar printing based on the horizontal size of the screen and the horizontal size of the print target paper when record format data is displayed or printed on the screen. Is determined (S18, S118). Thereby, it is possible to perform the column setting only when the column setting is necessary.

  In the above embodiment, the case where two items are specified and arranged is described, but the present invention is not limited to this. For example, m items satisfying m ≧ 2 may be specified and the m items may be grouped. In that case, m item names are stored in association with each other in the column item management DB 46 shown in FIG. 3C, and in step S46 and step S52, a search is performed for m items to be column-targeted. Just do it.

(Modification 1)
In the above embodiment, the case where the output processing unit 34 refers to the column item management DB 46 as shown in FIG. 3C when specifying two items to be columned has been described. It is not limited. For example, a column item management DB 46 ′ as shown in FIG. 12 may be referred to. In the column item management DB 46 ′ of FIG. 12, the item type “DATE” indicating a date, the item type “NUMBER” indicating a number, the item type “CHAR” indicating a name, and the like are defined as types of items to be columned. Has been.

  Hereinafter, the column determination process (step S22 in FIG. 4) when referring to the column item management DB 46 'in FIG. 12 will be described with reference to the flowchart in FIG. Note that the description of the same or equivalent processing as that in FIG. 6 is simplified or omitted. In FIG. 13, processing different from that shown in FIG. Hereinafter, a “display process” for displaying data on the screen of the display unit 93 will be described as an example.

  In the process of FIG. 13, the output processing unit 34 first extracts all items of one record in step S30, and sets the total number to N. In addition, items are stored in the order of appearance in the horizontal direction. In step S31, the data type of each item is referred to and the item type, that is, the data type of the item is determined. In this case, the output processing unit 34 may determine the item type from the cell format of all items. The item type includes an item type “DATE” indicating a date, an item type “NUMBER” indicating a number, an item type “CHAR” indicating a name, and the like.

  Next, after setting n to 1 in step S32, the output processing unit 34 determines whether or not the nth item has been set in step S34. If the determination here is affirmed (step S34: Yes), the process proceeds to step S64. If the determination is negative (step S34: No), the process proceeds to step S36 '.

  In step S36 ', the output processing unit 34 searches for the column item type in the column item management DB 46' (FIG. 12) using the item type of the nth item. For example, if the item type of the nth item is “DATE”, the output processing unit 34 searches the column item management DB 46 ′ for the item type “DATE” in step S 36 ′.

  Next, in step S38, the output processing unit 34 determines whether or not there is an item type of the nth item in the columnar item management DB 46 '. If the determination here is negative (step S38: No), after performing the column button installation process in step S40, the process proceeds to step S64. On the other hand, if the determination in step S38 is affirmative (step S38: Yes), the process proceeds to step S42 '.

  In step S42 ', the output processing unit 34 searches for item types of items other than the n-th item using the matched column item type. In the next step S48, the output processing unit 34 determines whether there is a matching item. When judgment here is denied (step S48: No), it transfers to step S40. If the determination is affirmative (step S48: Yes), the process proceeds to step S50 '.

  In step S50 ', the output processing unit 34 sets the nth item as the column target n1, and sets the items other than the nth item that match as a result of the search in step S42' as the column target n2. Thereafter, steps S58, S60, and S62 are executed in the same manner as in the above embodiment. There may be a plurality of items with matching item types. In this case, any one item among items having the same item type may be set as a column target. As one of the items, an item having the same or most similar data length as the n-th item can be selected. When there are a plurality of items with the same item type, all items with the same item type may be set as the column target.

  Thereafter, when the process proceeds to step S64, the output processing unit 34 increments n by 1, and then determines whether n is larger than N in step S66. When judgment here is denied (step S66: No), it returns to step S34. If the determination is affirmative (step S66: Yes), all the processes in FIG. 13 are terminated.

  As described above, according to the first modification, even when the column item management DB 46 ′ as shown in FIG. Can be assembled.

  Note that when the processing of FIG. 13 is executed in the printing processing, the processing in steps S40 and S62 may be omitted as in the above embodiment.

(Modification 2)
Note that an item type management DB 48 as shown in FIG. 14 may be used in place of the column item management DB 46 ′ of the first modification. The item type management DB 48 of FIG. 14 has fields of “item name”, “item type”, and “item length”. The “item name” field stores the item name used in the record format data, and the “item type” field stores the item type of the item. The “item length” field stores the data length of data stored in the field indicated by the item. The item type management DB 48 is created in advance by a user or the like.

  The output processing unit 34 determines the item type and item length of the nth item with reference to the item type management DB 48 of FIG. 14 when specifying two (or two or more) items to be arranged. Then, it searches whether there is an item that matches the item type and item length of the nth item in the items other than the nth item, and if there are such items, the items are grouped. I decided to. For example, in the item type management DB 48 of FIG. 14, the item names “phone number” and “work phone number” coincide with each other because the item type and the item length match.

  Even in this case, as in the above-described embodiment and the first modification, two (or two or more) items can be specified and a column can be formed. Further, in the second modification, two (or two or more) items having the same data length are specified as items to be arranged, so that the record format is compared with the case where items having different data lengths are arranged. It is possible to efficiently reduce the entire width (horizontal width) of data.

  In the second modification, the case where items with the same item type and the same data length are stacked has been described. However, the present invention is not limited to this, and the item types match and the data lengths are approximate. The items (included in the predetermined error range) may be grouped.

  In the above-described embodiment and the modification, the case where the data items in the record format are output in the horizontal direction (row direction) has been described, but the present invention is not limited to this. For example, record format data items may be arranged in the vertical direction (column direction) and output. In this case, two or more items to be arranged may be arranged in the row direction and output.

  The above processing functions can be realized by a computer. In that case, a program describing the processing contents of the functions that the processing apparatus should have is provided. By executing the program on a computer, the above processing functions are realized on the computer. The program describing the processing contents can be recorded on a computer-readable recording medium (except for a carrier wave).

  When the program is distributed, for example, it is sold in the form of a portable recording medium such as a DVD (Digital Versatile Disc) or a CD-ROM (Compact Disc Read Only Memory) on which the program is recorded. It is also possible to store the program in a storage device of a server computer and transfer the program from the server computer to another computer via a network.

  The computer that executes the program stores, for example, the program recorded on the portable recording medium or the program transferred from the server computer in its own storage device. Then, the computer reads the program from its own storage device and executes processing according to the program. The computer can also read the program directly from the portable recording medium and execute processing according to the program. Further, each time the program is transferred from the server computer, the computer can sequentially execute processing according to the received program.

  The above-described embodiment is an example of a preferred embodiment of the present invention. However, the present invention is not limited to this, and various modifications can be made without departing from the scope of the present invention.

In addition, the following additional remarks are disclosed regarding description of the above embodiment.
(Appendix 1) Extracting the plurality of items included in the record format data, including a plurality of records including values of a plurality of items,
Determining whether or not two or more predetermined items are included in the plurality of extracted items;
When two or more of the predetermined items are included, the two or more items are arranged in a first direction, and the two or more items arranged in the first direction and items other than the two or more items are arranged in the first direction. The data is output in a second direction different from the direction,
A data output program for causing a computer to execute processing.
(Supplementary Note 2) In the determination process, a storage unit that stores two or more items in association with each other is referred to, and the predetermined two or more items are included in the plurality of items based on information stored in the storage unit. The data output program according to appendix 1, wherein it is determined whether or not the item is included.
(Supplementary Note 3) In the determination process, based on whether the two or more items stored in the storage unit are data stored in a sequential order in the data of the record format, the predetermined two or more The data output program according to appendix 2, wherein it is determined whether or not the item is included.
(Additional remark 4) In the said determination process, it is determined whether the said 2 or more predetermined item is contained in the said several item based on the kind of each of these multiple items. The data output program described in 1.
(Additional remark 5) In the said determination process, based on the data length of each of these items, it is determined whether the predetermined two or more items are included in the items. The data output program according to any one of appendices 1 to 4.
(Additional remark 6) The process to output is a process to display on a screen,
In addition to the display of the data, means for receiving an input of an instruction to rearrange the two or more items arranged in the first direction in the second direction, and / or any two or more arranged in the second direction 6. The data output program according to any one of appendices 1 to 5, wherein means for receiving an input of an instruction to rearrange items in the first direction is displayed.
(Supplementary note 7) The process to be output is a process for displaying on a screen or a process for printing.
Based on the size of the screen in the second direction or the size of the medium to be printed in the second direction, it is determined whether to execute the extraction process, the determination process, and the output process. The data output program according to any one of appendices 1 to 6, further causing the computer to execute processing.
(Supplementary Note 8) Extracting the plurality of items included in the record format data including a plurality of records including values of a plurality of items,
Determining whether or not two or more predetermined items are included in the plurality of extracted items;
When two or more of the predetermined items are included, the two or more items are arranged in a first direction, and the two or more items arranged in the first direction and items other than the two or more items are arranged in the first direction. The data is output in a second direction different from the direction,
A data output method characterized in that a computer executes processing.
(Supplementary Note 9) In the determination process, a storage unit that stores two or more items in association is referred to, and the predetermined two or more items are included in the plurality of items based on information stored in the storage unit. 9. The data output method according to appendix 8, wherein it is determined whether or not the item is included.
(Additional remark 10) In the said determination process, based on whether the said 2 or more item memorize | stored in the said memory | storage part is the data memorize | stored in the sequential order in the data of the said record format, the said predetermined 2 or more The data output method according to appendix 9, wherein it is determined whether or not the item is included.
(Additional remark 11) In the determination process, it is determined whether or not the predetermined two or more items are included in the plural items based on the types of the plural items. The data output method described in 1.
(Additional remark 12) In the said determination process, based on the data length of each of the said several item, it is determined whether the said 2 or more predetermined item is contained in the said several item, It is characterized by the above-mentioned. The data output method according to any one of appendices 8 to 11.
(Supplementary Note 13) The output process is a process of displaying on a screen.
In addition to the display of the data, means for receiving an input of an instruction to rearrange the two or more items arranged in the first direction in the second direction, and / or any two or more arranged in the second direction The data output method according to any one of appendices 8 to 12, wherein means for receiving an input of an instruction to rearrange items in the first direction is displayed.
(Supplementary Note 14) The output process is a process of displaying on a screen or a process of printing.
Based on the size of the screen in the second direction or the size of the medium to be printed in the second direction, it is determined whether to execute the extraction process, the determination process, and the output process. 14. The data output method according to any one of appendices 8 to 13, wherein the computer further executes the process.
(Additional remark 15) The extraction part which extracts the said some item contained in the data of a record format containing the plurality of records containing the value of several items,
A determination unit that determines whether or not two or more predetermined items are included in the plurality of extracted items;
When two or more of the predetermined items are included, the two or more items are arranged in a first direction, and the two or more items arranged in the first direction and items other than the two or more items are arranged in the first direction. An output unit that outputs the data in a second direction different from the direction;
A data output device comprising:
(Supplementary Note 16) A storage unit that stores two or more items in association with each other,
The determination unit refers to the storage unit, and determines whether or not the predetermined two or more items are included in the plurality of items based on information stored in the storage unit. The data output device according to Supplementary Note 15, which is characterized in that.
(Additional remark 17) The said determination part is based on whether the said 2 or more item memorize | stored in the said memory | storage part is the data memorize | stored in the sequential order in the data of the said record format. Item 17. The data output device according to item 16, wherein it is determined whether or not an item is included.
(Supplementary note 18) The supplementary note 15, wherein the determination unit determines whether or not the two or more predetermined items are included in the plurality of items based on a type of each of the plurality of items. The data output device described.
(Additional remark 19) The said determination part determines whether the said predetermined 2 or more item is contained in these several items based on the data length of each of these several items. The data output device according to any one of 15 to 18.
(Additional remark 20) The said output part performs the process displayed on a screen,
In addition to the display of the data, means for receiving an input of an instruction to rearrange the two or more items arranged in the first direction in the second direction, and / or any two or more arranged in the second direction The data output device according to any one of appendices 15 to 19, wherein means for receiving an input of an instruction to rearrange items in the first direction is displayed.
(Supplementary Note 21) The output unit executes a process of displaying on a screen or a process of printing,
Judgment whether or not to execute processing by the extraction unit, the determination unit, and the output unit based on the size of the screen in the second direction or the size of the medium to be printed in the second direction The data output device according to any one of supplementary notes 15 to 20, further comprising a unit.

10 PC (data output device)
34 Output processing unit (extraction unit, determination unit, output unit, determination unit)
46 Column item management DB (storage unit)
60 column button object (means to accept input)
62 Column release button object (means for receiving input)
90 CPU (computer)

Claims (8)

Extracting the plurality of items included in the record format data, including a plurality of records including the values of the plurality of items,
Referring to a storage unit that stores information related to items whose contents are related to each other, and determining whether or not two or more items whose contents are related to each other are included in the extracted items;
When two or more items whose contents are related to each other are included, the two or more items are arranged in a first direction, and the two or more items arranged in the first direction and items other than the two or more items are arranged. Arranging the data in a second direction different from the first direction and outputting the data;
A data output program for causing a computer to execute processing. Extracting the plurality of items included in the record format data, including a plurality of records including the values of the plurality of items,
Determining whether or not two or more predetermined items are included in the plurality of extracted items;
When two or more of the predetermined items are included, the two or more items are arranged in a first direction, and the two or more items arranged in the first direction and items other than the two or more items are arranged in the first direction. The data is output in a second direction different from the direction,
Let the computer execute the process,
In the determination process, the storage unit that stores two or more items in association with each other is referred to, and the two or more items stored in the storage unit are stored in sequential order in the data in the record format. based on whether the data output program characterized judges that whether include the predetermined two or more items. Extracting the plurality of items included in the record format data, including a plurality of records including the values of the plurality of items,
Determining whether or not two or more predetermined items are included in the plurality of extracted items;
When two or more of the predetermined items are included, the two or more items are arranged in a first direction, and the two or more items arranged in the first direction and items other than the two or more items are arranged in the first direction. The data is output in a second direction different from the direction,
Let the computer execute the process,
Wherein in determining process, data output program characterized the predetermined determines whether includes two or more items, that in said plurality of items based on the type of each of the plurality of items. 4. The determination process according to claim 1, wherein whether or not the two or more items are included in the plurality of items is determined based on a data length of each of the plurality of items. 5 . The data output program as described in any one of Claims. The output process is a process of displaying on a screen.
In addition to the display of the data, means for receiving an input of an instruction to rearrange the two or more items arranged in the first direction in the second direction, and / or any two or more arranged in the second direction The data output program according to any one of claims 1 to 4 , wherein means for receiving an input of an instruction to rearrange items in the first direction is displayed. The output process is a process for displaying on a screen or a process for printing.
Based on the size of the screen in the second direction or the size of the medium to be printed in the second direction, it is determined whether to execute the extraction process, the determination process, and the output process. data output program according to any one of claims 1 to 5, characterized in that process, to further to a computer running. Extracting the plurality of items included in the record format data, including a plurality of records including the values of the plurality of items,
Referring to a storage unit that stores information related to items whose contents are related to each other, and determining whether or not two or more items whose contents are related to each other are included in the extracted items;
When two or more items whose contents are related to each other are included, the two or more items are arranged in a first direction, and the two or more items arranged in the first direction and items other than the two or more items are arranged. Arranging the data in a second direction different from the first direction and outputting the data;
A data output method characterized in that a computer executes processing. An extraction unit for extracting the plurality of items included in the record format data, including a plurality of records including the values of the plurality of items;
A determination unit that determines whether or not two or more items whose contents are related to each other are included in the plurality of extracted items with reference to a storage unit that stores information on the items whose contents are related to each other ;
When two or more items whose contents are related to each other are included, the two or more items are arranged in a first direction, and the two or more items arranged in the first direction and items other than the two or more items are arranged. An output unit that outputs the data in a second direction different from the first direction;
A data output device comprising:

Images