JP6565145B2 - Processing method, processing apparatus, and program - Google Patents

Description

  The present invention relates to a processing method, a processing apparatus, and a program.

  2. Description of the Related Art Conventionally, a technique for creating a form with a good appearance and a technique for supporting operations when classifying and counting the total content of a total table into a desired total item are known (see, for example, Patent Documents 1 and 2).

International Publication No. 2008/066142 JP 2005-251220 A

  When creating a form, tabular data may be attached. In this case, the form creator may divert existing tabular data. However, in Patent Documents 1 and 2 and the like, the case where the existing tabular data is diverted is not considered.

  In one aspect, an object of the present invention is to provide a processing method, a processing apparatus, and a program capable of outputting useful information when diverting tabular data.

In one aspect, the processing method refers to a storage unit that stores a method of outputting tabular data for displaying a result obtained by classifying and tabulating a plurality of data based on the classification items. The classification item is specified, and change information regarding the classification range when the plurality of data set in at least one of the specified plurality of classification items is classified, and the tabular data is received according to the received change information. Is a processing method in which the computer executes a process of determining whether or not the changed tabular data falls within a predetermined printing range and outputting the result of the determination.

In one aspect, the processing device stores a storage unit that stores a method of outputting tabular data that displays a result obtained by classifying and tabulating a plurality of data based on classification items, and refers to the storage unit, Change information related to a classification range when classifying the plurality of data set in at least one of the plurality of classification items specified by the specifying unit and the plurality of classification items specified by the specifying unit. A receiving unit that receives, and a determination unit that determines whether the changed tabular data falls within a predetermined print range when the tabular data is changed according to the change information received by the receiving unit; And an output unit that outputs a result determined by the unit.

In one aspect, the program refers to a storage unit that stores a method of outputting tabular data for displaying a result of classifying and tabulating a plurality of data based on classification items, and A classification item is specified, change information relating to a classification range when the plurality of data set in at least one of the specified plurality of classification items is classified, and the tabular data is converted according to the received change information. A program for causing a computer to execute a process of determining whether or not the changed tabular data falls within a predetermined print range when the change is made, and outputting the result of the determination.

  Useful information can be output when diverting tabular data.

It is a figure showing roughly the composition of the form generation system concerning one embodiment. FIG. 2A is a diagram illustrating a hardware configuration of the server, and FIG. 2B is a diagram illustrating a hardware configuration of the user terminal. It is a functional block diagram of a server and a user terminal. It is a figure which shows an example of prefectural DB. It is a figure which shows an example of form size DB. It is a figure which shows an example of DB management table. It is a figure which shows an example of form definition DB. It is a figure which shows an example of a division pattern management table. It is a flowchart which shows the process of a server. It is a flowchart which shows the specific process of step S16 of FIG. It is a flowchart (the 1) which shows the specific process of step S18 of FIG. It is a flowchart (the 2) which shows the specific process of step S18 of FIG. It is a flowchart (the 3) which shows the specific process of step S18 of FIG. It is a figure which shows an example of a form creation screen. FIG. 15A is a diagram illustrating an example of a DB selection screen, and FIG. 15B is a diagram illustrating an example of a total key field selection screen. FIG. 16A is a diagram illustrating an example of a total value field screen, and FIG. 16B is a diagram illustrating an example of a display axis setting screen. FIG. 17A is a diagram illustrating an example of a form size selection screen, and FIG. 17B is a diagram illustrating an example of a form definition saving screen. It is a figure for demonstrating the coordinate in a form. FIG. 19A is a diagram illustrating an example of a diversion form candidate list screen, and FIG. 19B is a diagram illustrating an example of a diversion form display screen. FIG. 20A is a diagram illustrating an example of a confirmation screen, and FIG. 20B is a diagram illustrating an example of a condition setting screen. FIG. 21A is a diagram illustrating an example in which a table protrudes from the paper size, and FIG. 21B is a diagram illustrating an example of an axis change recommendation screen. FIG. 22A is a diagram illustrating an example of a display confirmation screen, and FIG. 22B is a diagram illustrating an example of a form display screen.

  Hereinafter, an embodiment of a form generation system will be described in detail with reference to FIGS.

  FIG. 1 schematically shows the configuration of a form generation system 100 according to the present embodiment. As illustrated in FIG. 1, the form generation system 100 includes a server 10 as a processing device, a user terminal 50, and a printer 70. The server 10, the user terminal 50, and the printer 70 are connected to a network 80 such as the Internet or a LAN (Local Area Network).

  The server 10 receives operation information (instruction contents) on the user terminal 50 by the user, creates various screens, and generates a form. Further, the server 10 transmits the created screen or form data to the user terminal 50 for display, or sends the generated form to the printer 70 for printing.

  FIG. 2A shows the hardware configuration of the server 10. As shown in FIG. 2A, the server 10 includes a CPU (Central Processing Unit) 90, a ROM (Read Only Memory) 92, a RAM (Random Access Memory) 94, and a storage unit (here, an HDD (Hard Disk Drive)). ) 96, a network interface 97, a portable storage medium drive 99, and the like. Each component of the server 10 is connected to a bus 98. In the server 10, the CPU 90 executes a program stored in the ROM 92 or the HDD 96, or a program read from the portable storage medium 91 by the portable storage medium drive 99, so that a form generation instruction reception unit shown in FIG. 30, functions as a form generation unit 32 and an output unit 34 are realized. 3 also shows a search target DB group 40 as a database, a form size DB 42, a DB management table 44, a form definition DB 46 as a storage unit, and a sorting pattern management table 48, which are stored in the HDD 96 or the like. However, specific data structures of these DBs and tables will be described later.

  The form generation instruction receiving unit 30 receives the form generation instruction transmitted from the user terminal 50 and transmits it to the form generation unit 32. The form generation unit 32 generates various screens based on the form generation instruction and generates a form. The output unit 34 outputs the form generated by the form generation unit 32 to the user terminal 50 or to the printer 70. Further, the output unit 34 stores the form information generated by the form generation unit 32 in the form definition DB 46.

  The user terminal 50 is a terminal such as a PC (Personal Computer), and is a terminal used by a user who creates a form in business (for example, a staff of a city hall). The user terminal 50 has a hardware configuration as shown in FIG. As shown in FIG. 2B, the user terminal 50 includes a CPU 190, a ROM 192, a RAM 194, a storage unit (HDD in this case) 196, a network interface 197, a display unit 193, an input unit 195, and a portable storage medium drive. 199 etc. The display unit 193 is a liquid crystal display or the like, and the input unit 195 is a keyboard, a mouse, a touch panel, or the like. Each component of the user terminal 50 is connected to the bus 198. In the user terminal 50, the CPU 190 executes a program stored in the ROM 192 or the HDD 196 or a program read from the portable storage medium 191 by the portable storage medium drive 199, whereby the input processing unit 52 shown in FIG. And the function as the display process part 54 is implement | achieved. The input processing unit 52 transmits information (for example, an instruction related to form generation) input by the user via the input unit 195 to the server 10. The display processing unit 54 receives the screen data and form data transmitted from the server 10 and displays them on the display unit 193.

  The printer 70 is a device that receives form data from the server 10 and prints the form on a paper medium (paper). For example, the printer 70 performs printing on a paper medium in a format designated by the user among A4 portrait, A4 landscape, postcard, B5 portrait, and the like. Note that the printer 70 may not be connected to the network 80, and may be connected to the user terminal 50 via a printer cable or a USB cable, for example.

  Next, specific data structures of various DBs and tables held by the server 10 will be described in detail with reference to FIGS.

  FIG. 4 shows the data structure of a prefectural DB that is one of the search target DB groups 40. As shown in FIG. 4, the prefectural DB is a database for storing prefectural information, and includes “prefectural ID”, “name”, “address (city / county)”, “address (city)”, “address (town).・ Character), “Address (village)”, “Address (address)”, “Gender”, “Birth date”, “Age”, “Occupation”, “Resident tax”, “Population”, etc. Have The “prefectural ID” stores identification information assigned to each prefectural. In the fields of “name”, “address”, “gender”, “birth date”, “age”, and “occupation”, information of each citizen is stored. In the “resident tax” field, the resident tax payment amount of each citizen is stored. In the “population” field, “1” is stored. In addition, as shown in FIG. 3, the search target DB group 40 includes a light car registrant DB, a caregiver DB, a tax DB, and the like in addition to the prefectural DB, but detailed description of these DBs is omitted. To do.

  FIG. 5 shows the data structure of the form size DB 42. As shown in FIG. 5, the form size DB 42 has fields of “format” and “size”. The “format” field stores the format of a paper medium (paper) such as A4 portrait or B5 portrait, and the “size” field stores a size corresponding to each format, that is, a printable range (vertical (mm)). X horizontal (mm)) is stored.

  FIG. 6 shows the data structure of the DB management table 44. As shown in FIG. 6, the DB management table 44 includes “ID” that is database identification information, “DB name” that is the name of the database, and “field ID” that is identification information and a name of each field of the database. And “field name” and “field display presence / absence” that defines whether or not to display the field name on a screen for inputting conditions at the time of DB search (a total key field screen or a total value field screen described later) to manage.

  “Field display presence / absence” stores a code for determining whether or not to display each field name on the screen in the process described later. Specifically, the field name in which the code “0” is stored is not displayed on the screen for inputting conditions at the time of DB search (total key field screen or total value field screen described later). "Is stored on the screen as a total key field (see FIG. 16B). Further, the field name in which the code “2” is stored is displayed on the screen for inputting the condition at the time of DB search as the total value field (see FIG. 16A), and the code “3” is stored. The field name is displayed on the screen as a total key field and a total value field.

  FIG. 7 is a diagram showing the data structure of the form definition DB 46. The form definition DB 46 stores form definition data generated by the server 10. As shown in FIG. 7, the form definition DB 46 includes “form ID”, “creation date”, “creator”, “form name”, “coordinates (upper left, lower right)”, “target DB”, and “counting method”. ”,“ Display Item ”, and“ Text ”fields. The “form ID” field stores the form identification information (serial number), and the “creation date” field stores the date on which the form was created. The name of the person who created the form (in the case of FIG. 7) is stored in the “creator” field, and the form name set by the user is stored in “form name”. The “coordinate (upper left, lower right)” field stores the coordinates (upper left and lower right coordinates of the range) where the text and table (table format data) are arranged, and the “target DB” field. Stores a DB to be searched in which data is searched when a table is created. The “Aggregation Method” field stores information on the search method used when searching for data in the search target DB, the search expression, and the “Display Item” field contains the vertical and horizontal axes of the table. The display item (classification item) set in is stored. The display items (category items) are also referred to as “aggregation axes” below. In the “text” field, text data of a text input by the user is stored. As described above, the form definition DB 46 stores a method of outputting a table (table format data) attached to the form.

  FIG. 8 is a diagram showing the data structure of the sorting pattern management table 48. As shown in FIG. 8, the segmentation pattern management table 48 has fields of “field name” and “selection item”, and can be selected as a field name of a table attached to the form, and corresponds to the field name. The classification pattern (how to total) is stored.

(Processing of server 10)
Next, the processing of the server 10 will be described in detail along the flowcharts of FIGS. 9 to 13 is started when the form generation instruction receiving unit 30 receives an instruction to start form generation (form generation instruction) input from the input unit 195 of the user terminal 50 by the user. It is processing. The form generation instruction is transmitted from the input processing unit 52 of the user terminal 50.

  In the process of FIG. 9, first, in step S <b> 10, the form generation unit 32 generates a form creation screen and transmits it to the user terminal 50. In this case, the display processing unit 54 of the user terminal 50 displays a form creation screen as shown in FIG. 14 on the display unit 193. In addition, on the form creation screen, as shown in FIG. 14, a “new creation” button for selecting to create a new form without diverting a past form, and creating a form by diverting a past form “Past form diversion” button for selecting to perform and “Next” button for proceeding to the next screen are provided.

  Next, in steps S12 and S14, the form generation unit 32 stands by until “new creation” is selected on the form creation screen or “past form diversion” is selected. For example, when the user selects new creation and presses the “Next” button, the determination in step S12 is affirmed and the process proceeds to step S16. When the process proceeds to step S16, a subroutine for new form creation processing is executed. On the other hand, when the user selects the past form diversion and presses the “next” button, the determination in step S14 is affirmed and the process proceeds to step S18. When the process proceeds to step S18, a form diversion process is executed. In addition, when the process of step S16 or step S18 is complete | finished, all the processes of FIG. 9 are complete | finished.

  Hereinafter, specific processing in steps S16 and S18 will be described.

(New form creation processing (S16))
FIG. 10 is a flowchart showing a specific process of the new form creation process (S16). The process in step S16 is a process for newly creating all forms including a table attached to the form.

  In the process of FIG. 10, first, in step S <b> 30, the form generation unit 32 creates a DB selection screen using the DB management table 44 and transmits it to the display processing unit 54 of the user terminal 50. Specifically, the form generation unit 32 extracts the DB name from the DB management table 44, creates a DB selection screen as shown in FIG. 15A using the extracted DB name as an option, and displays the display processing unit 54. Send to. Note that the display processing unit 54 of the user terminal 50 displays the received DB selection screen (FIG. 15A) on the display unit 193. The DB selection screen is also provided with a “next” button.

  Next, in step S32, the form generation unit 32 stands by until there is a selection on the DB selection screen in FIG. That is, the information that the user selects one DB name and presses the “Next” button as shown in FIG. 15A is transmitted from the input processing unit 52 of the user terminal 50 to the form generation instruction receiving unit 30. At the timing that has been done, the form creation unit 32 proceeds to step S34. Here, it is assumed that the user has selected the prefectural DB.

  In step S 34, the form generation unit 32 creates a total key field selection screen using the DB management table 44 and transmits it to the display processing unit 54 of the user terminal 50. Specifically, the form generation unit 32 extracts the DB field name selected in step S32 from the DB management table 44 (however, the field display presence / absence numbers are “1” and “3”), A total key field selection screen as shown in FIG. 15B using the extracted field name as an option is created and transmitted to the display processing unit 54. The display processing unit 54 of the user terminal 50 displays the received total key field selection screen (FIG. 15B) on the display unit 193. The total key field selection screen includes a “return” button and a “next” button.

  Next, in step S36, the form generation unit 32 stands by until a field name is selected on the total key field selection screen (FIG. 15B). That is, information that the user has selected one or more field names and pressed the next button as shown in FIG. 15B is transmitted from the input processing unit 52 of the user terminal 50 to the form generation instruction receiving unit 30. At the timing that has been done, the form creation unit 32 proceeds to step S38. Here, it is assumed that the user has selected an address (city), sex, and age.

  In step S <b> 38, the form generation unit 32 creates a total value field selection screen using the DB management table 44 and transmits it to the display processing unit 54 of the user terminal 50. Specifically, the form creation unit 32 extracts the DB field name selected in step S36 from the DB management table 44 (however, the field display presence / absence numbers are 2 and 3), and the extracted field name A total value field selection screen as shown in FIG. The display processing unit 54 of the user terminal 50 displays the received total value field selection screen (FIG. 16A) on the display unit 193. In the total value field selection screen of FIG. 16A, the field name (population, resident tax) of the item to be totaled and the totaling method (total, average, minimum, maximum) can be selected. The total value field selection screen includes a “return” button and a “setting” button.

  Next, in step S40, the form generation unit 32 stands by until there is a selection on the total value field selection screen (FIG. 16 (a)). That is, information indicating that the user has selected one or more field names and tabulation methods and pressed the “set” button as shown in FIG. 16A is received from the input processing unit 52 of the user terminal 50 as a form generation instruction. At the timing transmitted to the unit 30, the form generation unit 32 proceeds to step S42. Here, as an example, it is assumed that the user selects “population” and “total” as shown in FIG.

  In step S42, the form generation unit 32 creates a display axis setting screen for setting the axis of the selected field name, and transmits the display axis setting screen to the display processing unit 54 of the user terminal 50. Specifically, the form generation unit 32 selects “vertical axis”, “horizontal axis”, and “any may be used” for the field name selected on the screen of FIG. 15B (FIG. 16B). A display axis setting screen as shown in FIG. 6 is created and transmitted to the display processing unit 54. The display processing unit 54 displays the received display axis setting screen (FIG. 16B) on the display unit 193. In the display axis setting screen, a “return” button and a “next” button are provided.

  Next, in step S44, the form generation unit 32 stands by until there is an axis setting on the display axis setting screen (FIG. 16B). In other words, as shown in FIG. 16B, information that the user selects either the vertical axis or the horizontal axis for each field name and presses the “Next” button is used. The form generation unit 32 proceeds to step S46 at the timing when it is transmitted from the input processing unit 52 of the person terminal 50 to the form generation instruction reception unit 30. Here, it is assumed that the user sets the city name as “horizontal axis”, the age as “vertical axis”, and the gender as “any one”.

  In step S46, the form generation unit 32 creates a form size selection screen (FIG. 17A) using the form size DB 42 and transmits it to the display processing unit 54 of the user terminal 50. The display processing unit 54 of the user terminal 50 displays the received form size selection screen (FIG. 17A) on the display unit 193. It is assumed that a “set” button is provided on the form size selection screen.

  Next, in step S48, the form generation unit 32 waits until accepting a size selection. That is, information that the user has selected the paper size on the screen of FIG. 17A and pressed the “set” button is transmitted from the input processing unit 52 of the user terminal 50 to the form generation instruction receiving unit 30. At the same timing, the form generation unit 32 proceeds to step S50.

  If transfering it to step S50, the form production | generation part 32 will produce | generate a table | surface based on the information selected so far. Specifically, a search is performed on the DB selected in FIG. In the present embodiment, a search is performed based on the total key field selected in FIG. 15B and the total value field selected in FIG. Create a table according to the display axis set in. Then, the form generation unit 32 generates a form definition storage screen pasted on the selected size form and transmits it to the display processing unit 54 of the user terminal 50. The form definition saving screen is a screen as shown in FIG. Here, when the form generation unit 32 generates a table, if there is a field name for which “any” is selected in the display axis setting, the table when the field name is set on the vertical axis is displayed. And a table set on the horizontal axis, a table more suitable for the paper size is selected and pasted on the form. However, the present invention is not limited to this, and the form generation unit 32 may generate a screen that allows the user to select which table to paste, and paste the table on the form based on the selection by the user. It is assumed that the user can edit the form such as inputting a text on the form definition saving screen in FIG. The form definition saving screen includes a “form definition saving” button and an “end” button.

  Next, in step S52, the form generation unit 32 stands by until a save request is received. That is, at the timing when the information that the user has pressed the “save form definition” button on the screen of FIG. 17B is transmitted from the input processing unit 52 of the user terminal 50 to the form generation instruction receiving unit 30, the form generation is performed. The unit 32 proceeds to step S54.

  In step S54, the output unit 34 records the form information such as coordinates, search target DB, and tabulation method in the form definition DB 46. In this case, the user's name and the form name set by the user are also recorded. Here, the coordinates mean the upper left coordinates and the lower right coordinates of the range where the text is described and the range where the table exists, as shown in FIG.

  When the process of FIG. 10 (the process of step S16) is completed by the above process, the entire process of FIG. 9 is also terminated. Note that during the processing of FIG. 10, a “return” button may be pressed on the screens of FIGS. 15B, 16A, and 16B. In such a case, the process may be performed again to return to the screen displayed immediately before. When the “end” button is pressed on the screen of FIG. 17B, the process of FIG. 10 may be ended without performing step S54.

  Note that a “print” button may be provided on the screen of FIG. In this case, when a print instruction is issued, for example, when the “print” button is selected by the user, the output unit 34 may cause the printer 70 to print the form.

(Form diversion processing (S18))
Next, the process (form diversion process) in step S18 in FIG. 9 will be described. In FIG. 11 to FIG. 13, the specific process of step S18 is shown in a flowchart. This process is a process in the case of creating a new form by diverting the form created in step S16 in the past.

  In step S <b> 60 of FIG. 11, the form generation unit 32 creates a diversion form candidate list screen and transmits it to the display processing unit 54 of the user terminal 50. In this case, the form generation unit 32 refers to the form definition DB 46, extracts the form name of the form created in the past, and uses the extracted form name as an option as a list of diverted form candidates as shown in FIG. Create and send a screen. It is assumed that a “next” button is provided on the diversion form candidate list screen. The display processing unit 54 of the user terminal 50 displays the received diversion form candidate list screen (FIG. 19A) on the display unit 193.

  Next, in step S62, the form generation unit 32 waits until one of the form names is selected by the user. That is, information indicating that the user has selected one of the form names on the screen of FIG. 19A and pressed the “Next” button is transmitted from the input processing unit 52 of the user terminal 50 to the form generation instruction receiving unit 30. At the timing that has been done, the form creation unit 32 proceeds to step S64. Here, it is assumed that the user has selected “City by population list (2013)”.

  In step S64, the form generation unit 32 creates a diversion form display screen in which the selected diversion form and the new form are arranged, and transmits it to the display processing unit 54 of the user terminal 50. In this case, the form generation unit 32 generates a form selected with reference to the form definition DB 46. Then, as shown in FIG. 19B, a diverted form display screen is created in which the generated form (diverted form) is arranged on the left side and a new form (blank form) is arranged on the right side, and transmitted to the display processing unit 54. The display processing unit 54 displays the screen of FIG. 19B on the display unit 193.

  Next, in step S66, the form generation unit 32 waits until a table in the diverted form is selected. In this case, information that the user has right-clicked the coordinate range of the table stored in the form definition DB 46 on the screen of FIG. 19B is sent from the input processing unit 52 of the user terminal 50 to the form generation instruction receiving unit 30. At the timing of transmission, the form creation unit 32 proceeds to step S70.

  In step S <b> 70, the form generation unit 32 acquires information included in the selected coordinates from the form definition DB 46, creates a confirmation screen, and transmits the confirmation screen to the display processing unit 54 of the user terminal 50. Here, it is assumed that the confirmation screen is a screen as shown in FIG. Specifically, on the confirmation screen of FIG. 20A, information on the target DB, the aggregation method, and the division pattern is displayed, and a “change division pattern” button and a “divide without changing setting contents” button are displayed. , And a “Return” button. The display processing unit 54 displays the received confirmation screen on the display unit 193.

  Next, in steps S72 and S74, the form generation unit 32 stands by until the “change sorting pattern” button or the “divert without changing setting” button is selected. That is, for example, when the user selects the “Divert without changing the setting” button, the determination in step S74 is affirmed, and the process proceeds to step S96 in FIG. On the other hand, when the “change division pattern” button is selected by the user, the determination in step S72 is affirmed, and the process proceeds to step S76 in FIG.

  When the determination in step S72 is affirmed and the process proceeds to step S76 in FIG. 12, the form creation unit 32 creates a condition setting screen with reference to the segmentation pattern management table 48 in FIG. 8, and displays the user terminal 50. To the unit 54. The condition setting screen is a screen as shown in FIG. In this case, the form generation unit 32 extracts a selection item corresponding to each of the division patterns in FIG. 20A from the division pattern management table 48, creates a condition setting screen that displays the extracted selection items as options, and displays them. The data is transmitted to the processing unit 54. The condition setting screen also includes a “change” button and a “return” button. Upon receiving the screen of FIG. 20B, the display processing unit 54 displays it on the display unit 193.

  Next, in step S78, the form generation unit 32 stands by until the “change” button is pressed on the screen of FIG. That is, at the timing when the information that the user has selected one of the options and pressed the “change” button is transmitted from the input processing unit 52 to the form generation instruction receiving unit 30, the form generation unit 32 proceeds to step S82. Transition. Note that FIG. 20B shows a case where the age range (age) is changed from every 20 years to every 10 years.

  In step S82, the form generation unit 32 determines whether or not a table generated based on the changed division pattern protrudes from the sheet size. If the determination in step S82 is negative, the process proceeds to step S92 in FIG. On the other hand, as shown in FIG. 21A, when the generated table is out of the sheet size and the table becomes difficult to see, the determination in step S82 is affirmed, and the process proceeds to step S84. In FIG. 21A, the upper left position of the table is set to the coordinates (upper left) defined in the form definition DB 46 of FIG.

  When the process proceeds to step S84, the form generation unit 32 determines whether there is a small item on the axis in the protruding direction. In the example of FIG. 21A, since there are a large item (age) and a small item (gender) subordinate to the large item in the protruding direction (vertical direction), the determination here is affirmed and the step The process proceeds to S86. If the determination in step S84 is negative, the process proceeds to step S92 in FIG.

  When the determination in step S84 is affirmed and the process proceeds to step S86, the form generation unit 32 combines the axis change recommendation message and the changed table (the table in FIG. 21A), FIG. 21B. An axis change recommendation screen as shown in FIG. 6 is created and transmitted to the display processing unit 54 of the user terminal 50. The axis change recommendation message is a message “Because the number of rows on the vertical axis has increased” in FIG. The axis change recommendation screen is provided with buttons for “display change screen (change axis)”, “execute as it is (do not change axis)”, and “return” as shown in FIG. . The display processing unit 54 displays the received screen on the display unit 193.

  Next, in steps S88 and S90, the form generation unit 32 stands by until the “change screen display” button or the “execute as it is” button is selected. When the user selects the “change screen display” button, the determination in step S88 is affirmed, and the form generation unit 32 creates a table in which the position of the aggregation axis is changed from one of the row and column to the other in step S89. A display confirmation screen is created and transmitted to the display processing unit 54 of the user terminal 50. Here, the table after the change is a table in which the minor item (gender) is changed from the major item (age) on the vertical axis of the previous table and the minor item (gender) subordinate to it to the horizontal axis. It is. In this case, a display confirmation screen as shown in FIG. The screen of FIG. 22A is provided with a table in which the position of the aggregate axis is changed (however, the data has not been searched and is blank), a “search execution” button, and a “return” button. ing. The display processing unit 54 displays the received screen on the display unit 193. It is assumed that the user presses a “search execution” button if a table format corresponding to the setting condition is acceptable. After step S89, the process proceeds to step S94.

  On the other hand, when the user selects the “execute as is” button and the determination in step S90 is affirmative, the form creation unit 32 proceeds to step S96 in FIG.

  By the way, when the determination in step S82 or step S84 is denied and the process proceeds to step S92, the form generation unit 32 creates a table according to the setting conditions, creates a display confirmation screen, and displays the user terminal 50. To the unit 54. In this case, a display confirmation screen similar to that shown in FIG. The display processing unit 54 displays the received screen on the display unit 193. Thereafter, the process proceeds to step S94.

  After step S92 or after step S89 described above, when the process proceeds to step S94, the form generation unit 32 waits until the “execute search” button is selected. When information indicating that the user has pressed the “execute search” button is transmitted from the input processing unit 52 to the form generation instruction receiving unit 30, the form generation unit 32 proceeds to step S96. As described above, when the determination at step S74 is affirmed (when the “Divert without changing setting” button is pressed on the screen of FIG. 20A), when the determination at step S90 is affirmed. (When the “execute as it is” button is pressed on the screen of FIG. 21B) also proceeds to step S96.

  If transfering it to step S96, the form production | generation part 32 will implement DB search with the set search conditions. In the present embodiment, the prefectural DB is searched using the set total key and total value field. Next, in step S98, the form generation unit 32 creates a form display screen in which the table created from the search result is displayed on the new form, and transmits the form display screen to the display processing unit 54 of the user terminal 50. The form display screen is assumed to be a screen as shown in FIG. It is assumed that a “form definition save” button and an “end” button are provided on the screen of FIG. Note that the user can input and edit the text on the screen of FIG. 22B, and the text is displayed in FIG. 22B by the input.

  Next, in step S100, the form generation unit 32 waits until a save request is received. In this case, when the information that the user has pressed the “save form definition” button is transmitted from the input processing unit 52 to the form generation instruction receiving unit 30, the form generation unit 32 proceeds to step S102.

  If transfering it to step S102, the output part 34 will preserve | save a totaling method, search conditions, a text, etc. in form definition DB46 (FIG. 7), and will complete | finish all the processes of FIGS. In addition, during the processes of FIGS. 11 to 13, the “return” button may be pressed on the screens of FIGS. 20A, 20 B, 21 B, and 22 A. . In such a case, the process may be performed again to return to the screen displayed immediately before. When the “end” button is pressed on the screen of FIG. 22B, the processing of FIGS. 11 to 13 may be ended without performing step S102.

  Note that a “print” button may be provided on the screen of FIG. In this case, when a print instruction is issued, for example, when the “print” button is selected by the user, the output unit 34 may cause the printer 70 to print the form.

  As can be seen from the above description, in the present embodiment, the form generation unit 32 uses the form generation unit 32 to identify the aggregation axis of the table to be diverted, the reception unit that receives the change of the division pattern, and the changed table is the sheet size. Functions as a determination unit that determines whether or not to enter, an output unit that outputs a determination result, and a display unit that displays a table after the change are realized.

  As described above in detail, according to the present embodiment, the form generation unit 32 refers to the form definition DB 46 that stores how to output tabular data (table attached to the form), and stores a plurality of tables. The total axis (multiple classification items) is identified (S70), the change information regarding the classification pattern is received for at least one of the specified total axes, and the table is changed according to the received change information. It is determined whether or not the subsequent table (first table format data) falls within the sheet size (S82), and the determination result is output (S86). Thereby, in this embodiment, when a new form is created by diverting a form created in the past, it is possible to provide useful information to the user as to whether or not the table falls within the paper size. For this reason, when the user changes the sorting pattern, the user can recognize information about whether or not the changed table falls within the paper size. Based on this information, the user can create a form with an easy-to-read table attached. It becomes.

  Further, in this embodiment, when it is determined that the table after changing the sorting pattern does not fall within the paper size (S82: Yes), the form generation unit 32 arranges any of the aggregate axes in the changed table. A table whose position is changed from one of the rows or columns to the other is displayed (S89, FIG. 22A). As a result, the user can attach an appropriate table to the form. In this embodiment, the aggregation axis for changing the arrangement position is the aggregation axis for the small items subordinate to the large item (S89). As a result, it is possible to display an easy-to-read table in which the appearance and the total value from the table before the change are not greatly changed.

  In the present embodiment, since the database is searched after the table partitioning pattern is determined, it is not necessary to perform processing such as changing the partitioning pattern again after searching the database, and re-searching the database. Thereby, simplification of a process can be achieved.

  Further, in the present embodiment, since a table having an appropriate size can be attached to the form, by reducing the table that does not fit in the paper size and attaching it to the form, the font becomes smaller and the table becomes difficult to see. The occurrence of such a situation can be avoided.

  In the above embodiment, when the table does not fit in the paper size, a plurality of tables in which the positions of the aggregation axes are variously changed may be displayed in a selectable manner. By doing in this way, the user can employ an appropriate table from among a plurality of tables.

  In the above embodiment, the case where the process of step S89 is executed when the determination of step S88 is affirmed has been described, but the present invention is not limited to this. For example, returning to step S76, the user may be allowed to input again regarding the change of the division pattern.

  In the above-described embodiment, an option for making at least one of the aggregation axes unused may be provided on the condition setting screen in FIG. In the above-described embodiment, the DB to be aggregated and the aggregation item may be changed on the condition setting screen in FIG.

  In the above embodiment, the case where the server 10 and the user terminal 50 cooperate to generate a form has been described, but the present invention is not limited to this. For example, the user terminal 50 may have the function of the server 10 and the user terminal 50 may execute the processes of FIGS. 9 to 13. In this case, the search target DB group 40 may be stored in another device (such as a data server).

  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.
(Supplementary Note 1) With reference to a storage unit that stores how to output tabular data, a plurality of classification items of the tabular data are specified,
For at least one of the plurality of identified classification items, change information regarding the setting of whether to use the classification item or change information regarding the classification pattern of the classification item is received,
When the table format data is changed according to the received change information, it is determined whether or not the changed first table format data falls within a predetermined printing range;
Outputting the result of the determination;
A processing method characterized in that a computer executes the processing.
(Supplementary Note 2) When it is determined in the determination process that the data in the first tabular format does not fall within the predetermined print range,
Generating and displaying second tabular data in which at least one arrangement position of the classification item of the first tabular data is changed from one of a row and a column to the other;
The processing method according to appendix 1, wherein the computer further executes processing.
(Supplementary Note 3) The processing method according to Supplementary Note 2, wherein in the process of displaying, the first tabular data and the second tabular data are displayed in a selectable state.
(Additional remark 4) The classification item of the data of the said 1st table format which changes the said arrangement position is a classification item subordinate to another classification item in a row or a column, The additional description 2 or 3 characterized by the above-mentioned Processing method.
(Supplementary Note 5) A storage unit that stores a method of outputting tabular data;
With reference to the storage unit, a specifying unit that specifies a plurality of classification items of the tabular data;
A receiving unit that receives change information related to setting whether to use the classification item or change information related to a classification pattern of the classification item for at least one of the plurality of classification items specified by the specifying unit;
A determination unit that determines whether the changed data in the first tabular format falls within a predetermined print range when the tabular data is changed according to the change information received by the reception unit;
An output unit that outputs a result of the determination by the determination unit;
A processing apparatus comprising:
(Supplementary Note 6) When the determination unit determines that the data in the first tabular format does not fall within the predetermined print range,
Item 6. The appendix 5 further includes a display unit that generates and displays second tabular data in which at least one arrangement position of the classification items of the first tabular data is changed from one of a row and a column to the other. Processing equipment.
(Supplementary note 7) The processing device according to supplementary note 6, wherein the display unit displays the first tabular data and the second tabular data in a selectable state.
(Additional remark 8) The classification item of the data of the said 1st table format which changes the said arrangement position is a classification item subordinate to another classification item in a row or a column, The additional description 6 or 7 characterized by the above-mentioned Processing equipment.
(Supplementary Note 9) With reference to the storage unit that stores the method of outputting tabular data, a plurality of classification items of the tabular data are specified,
For at least one of the plurality of identified classification items, change information regarding the setting of whether to use the classification item or change information regarding the classification pattern of the classification item is received,
When the table format data is changed according to the received change information, it is determined whether or not the changed first table format data falls within a predetermined printing range;
Outputting the result of the determination;
A program that causes a computer to execute processing.
(Supplementary Note 10) When it is determined in the determination process that the data in the first tabular format does not fall within the predetermined print range,
Causing the computer to further execute a process of generating and displaying second tabular data in which at least one arrangement position of the classification item of the first tabular data is changed from one of a row and a column to the other; The program according to appendix 9, characterized by:
(Supplementary note 11) The program according to supplementary note 10, wherein in the process of displaying, the first tabular data and the second tabular data are displayed in a selectable state.
(Supplementary note 12) The classification item of the first tabular data for changing the arrangement position is a classification item subordinate to another classification item in a row or a column, according to Supplementary Note 10 or 11, program.

10 server (processing device)
32 Form generation part (specification part, reception part, judgment part, output part, display part)
46 Form definition DB (storage unit)
90 CPU (computer)

Claims (6)

Refer to the storage unit for storing the method of outputting the tabular data to display the result of classifying and tabulating a plurality of data based on the classification items, and identify the plurality of classification items of the tabular data,
Receiving change information related to the classification width when classifying the plurality of data set in at least one of the plurality of identified classification items;
When the tabular data is changed according to the received change information, it is determined whether the tabular data after the change is within a predetermined print range;
Outputting the result of the determination;
A processing method characterized in that a computer executes the processing. Referring to the storage unit for storing the method of outputting the tabular data for displaying the result of summing up a plurality of data, identify a plurality of classification items of the tabular data,
Accepting change information relating to data aggregation conditions for at least one of the plurality of identified classification items;
When the tabular data is changed according to the received change information, it is determined whether the tabular data after the change is within a predetermined print range;
When it is determined in the determining process that the changed tabular data does not fall within the predetermined print range, at least one arrangement position of the changed tabular data classification item is set to one of a row and a column. Generate and display tabular data changed from one to the other,
Processing how to characterized in that processing the computer executes.   In the processing to be displayed, it is possible to select tabular data in which at least one arrangement position of the changed tabular data and the changed tabular data classification item is changed from one of row and column to the other The processing method according to claim 2, wherein the processing method is displayed.   The processing method according to claim 2 or 3, wherein the classification item of the tabular data after the change is a classification item subordinate to another classification item in a row or a column. A storage unit for storing a method of outputting tabular data for displaying a result obtained by classifying and totaling a plurality of data based on classification items ;
Referring to the storage unit, a specifying unit for specifying a plurality of classification items of the tabular data;
A receiving unit that receives change information related to a classification range when classifying the plurality of data set in at least one of the plurality of classification items specified by the specifying unit;
A determination unit that determines whether the changed tabular data falls within a predetermined print range when the tabular data is changed according to the change information received by the receiving unit;
An output unit that outputs a result of the determination by the determination unit;
A processing apparatus comprising: Refer to the storage unit for storing the method of outputting the tabular data to display the result of classifying and tabulating a plurality of data based on the classification items, and identify the plurality of classification items of the tabular data,
Receiving change information related to the classification width when classifying the plurality of data set in at least one of the plurality of identified classification items;
When the tabular data is changed according to the received change information, it is determined whether the tabular data after the change is within a predetermined print range;
Outputting the result of the determination;
A program that causes a computer to execute processing.

Images