JP2004078375A - Information processing apparatus, business form processing method, computer-readable storage medium, and program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To confirm a calculation equation for a defined numerical value input field and directly define a calculation equation intended by a user for an undefined numerical value input field, in a state in which numerical value data is inputted in the numerical value input fields by utilizing a template. <P>SOLUTION: While the data is inputted in the numerical value input fields defined by the selected and read template, a CPU 11 discriminates any undefined numerical value input field among the plurality of numerical value input fields, defines the specified calculation equation based on a script language and buries the equation in the undefined numerical value input field of the template for the numerical value input field discriminated as undefined, and reflects the results of the calculations based on the specified calculation equations based on the buried script language in the input data of the applicable numerical value input field. <P>COPYRIGHT: (C)2004,JPO

Description

[0001]
TECHNICAL FIELD OF THE INVENTION
The present invention relates to an information processing apparatus, a form processing method, a computer-readable storage medium, and a program that enable an input form to be automatically generated from output form data, and reduce the load of creating an input form on a user. It is.
[0002]
[Prior art]
2. Description of the Related Art Conventionally, there has been known a printing system that merges postscript data describing a variable data portion with an output form created in advance, such as a form, and prints it.
[0003]
Generally, in this type of printing system, since the quality of printing is emphasized, an output form for printing is first created on the information processing apparatus, and post-installation data is created for this output form by some method, and Combine with output form.
[0004]
Here, regarding the input and creation of variable data corresponding to the output form, the user of the system has constructed a unique input system in accordance with the task.
[0005]
As the number of forms to be processed on such a system increases, developing a data input form for each form becomes a burden on the user.
[0006]
At the same time, the operability of the input form is also required to be improved, and the load involved in developing the input form is only increasing.
[0007]
Further, as described in Japanese Patent Application Laid-Open No. 2001-101327, an apparatus using a template has been proposed to reduce such a burden.
[0008]
When the template is used, there is a type having a function of setting a calculation formula to be calculated in advance in each field and automatically inputting a calculation result with respect to an input numerical value.
[0009]
[Problems to be solved by the invention]
However, even when using a template, there are cases where it is desired to perform some modification or editing, such as creating a new spreadsheet field. In such a case, the template itself must be newly created from the beginning. In such cases, it is necessary to perform operations such as direct calculation by a user and inputting a numerical value as text, and it has been pointed out that such a new calculation item cannot be easily edited.
[0010]
SUMMARY OF THE INVENTION The present invention has been made to solve the above problems, and an object of the present invention is to provide a method of inputting a plurality of numerical values during data input to each numerical value input field defined in a template which is selected and read. Any undefined numeric input field in the field is determined, and a predetermined formula based on a scripting language is defined for the determined undefined numeric input field to define the undefined value of the template. By embedding in the numerical input field of the definition, and reflecting the calculation result based on the predetermined calculation formula based on the embedded script language in the input data of the corresponding numerical input field, the numerical data is stored in the numerical input field using the template. While entering a value, check the formula for the defined numeric input field. A calculation formula intended by the user for an undefined numeric input field was directly defined in the script language, and the numeric input data input to the numeric input field in which the defined calculation formula was embedded was reflected. An object of the present invention is to provide an information processing apparatus, a form processing method, a computer-readable storage medium, and a program, which are excellent in convenience and operability that can perform form processing freely.
[0011]
[Means for Solving the Problems]
A first invention according to the present invention comprises storage means for storing a form printing template in which a plurality of numerical input fields can be defined, and each numerical input field defined by the template selected and read from the storing means. An information processing apparatus for performing a form printing process by synthesizing predetermined data input with respect to the form data of the template and form data of the template, wherein each numerical value defined in the template selected and read from the storage means Determining means for determining any of the undefined numeric input fields among the plurality of numeric input fields during data input to the input fields (a form processing performed by CPU 11 shown in FIG. 1 read from external storage device 14 or the like); (Corresponding to a configuration in which the determination process is performed based on a program)). Calculation formula embedding means for defining a predetermined calculation formula based on the script language for the determined numeric input field and embedding it in the undefined numeric input field of the template (the CPU 11 shown in FIG. Etc.) and a calculation result based on a predetermined calculation formula based on a script language embedded by the calculation formula embedding means into input data of a corresponding numerical value input field. A form control means for reflecting (corresponding to a configuration in which the CPU 11 shown in FIG. 1 performs reflection processing based on a form processing program read from the external storage device 14 or the like).
[0012]
A second invention according to the present invention is a calculation formula confirming means for displaying a calculation formula defined in a numerical value input field determined to have been defined by the determination means in a predetermined calculation formula based on the script language. (Corresponding to a configuration in which the CPU 11 shown in FIG. 1 performs a confirmation process based on a form processing program read from the external storage device 14 or the like).
[0013]
According to a third aspect of the present invention, there is provided an instruction unit for instructing execution of printing after reflecting input data input to a corresponding numerical value input field by the form control unit, and based on an instruction from the instruction unit. A print control means for synthesizing the input data and the form data of the template to output a form printing process from a printing unit (the CPU 11 shown in FIG. 1 performs print control based on a form processing program read from an external storage device 14 or the like) (Corresponding to the configuration described above).
[0014]
A fourth invention according to the present invention comprises storage means for storing a form printing template in which a plurality of numerical input fields can be defined, and each numerical input field defined by the template selected and read from the storing means. A form processing method in an information processing apparatus for performing form printing processing by synthesizing predetermined data input to the form and form data of the template, the form processing being defined by a template selected and read from the storage unit. A discriminating step (not shown) for discriminating any of the undefined numeric input fields among the plurality of numeric input fields during the data input to each of the numerical input fields. For a numeric input field that has been determined to be A calculation formula embedding step (step S11-7 shown in FIG. 12) for defining a formula and embedding it in an undefined numerical value input field of the template, and a predetermined calculation formula based on the script language embedded by the calculation formula embedding step. A control step (not shown) of reflecting the calculation result based on the input data of the corresponding numerical value input field.
[0015]
A fifth invention according to the present invention is a calculation formula confirming step of displaying a calculation formula defined in the numerical value input field determined to have been defined in the determination step by a predetermined calculation formula based on the script language. (Not shown).
[0016]
A sixth invention according to the present invention is based on an instruction step of instructing print execution after reflecting input data input to a corresponding numerical value input field by the form control step, and based on an instruction by the instruction step. A print control step (not shown) of combining the input data and the form data of the template to output a form printing process from a printing unit.
[0017]
A seventh invention according to the present invention is characterized in that a program for realizing the form processing method according to any one of the fourth to sixth inventions is stored.
[0018]
An eighth invention according to the present invention is a program for realizing the form processing method according to any one of the fourth to sixth inventions.
[0019]
BEST MODE FOR CARRYING OUT THE INVENTION
Hereinafter, preferred embodiments of the present invention will be described in detail with reference to the accompanying drawings.
[0020]
FIG. 1 is a block diagram illustrating a configuration of an information processing apparatus according to an embodiment of the present invention.
[0021]
In FIG. 1, reference numeral 11 denotes a CPU, which executes various processes in the system. A ROM 12 stores a control program executed by the CPU 11 and various data. A RAM 13 stores a control program executed by the CPU 11 and provides a work area for the CPU 11. Reference numeral 14 denotes an external storage device, which includes a flexible disk, a hard disk, a CD-ROM, and the like. The external storage device 14 stores a control program for causing the CPU 11 to implement the control of the present embodiment described later with reference to FIG. The control program stored in the external storage device 14 is appropriately loaded into the RAM 13 and executed by the CPU 11.
[0022]
Reference numeral 15 denotes a display, which performs various displays under the control of the CPU 11. Reference numeral 16 denotes a keyboard, and 17 denotes a pointing device (mouse in this example), which performs various operation inputs to the device. Reference numeral 18 denotes an interface to which a printer 20 is connected in the present embodiment. Reference numeral 19 denotes a bus that connects the above-described components. In FIG. 1, the external storage device 14, the printer 20, and the like may be connected via a network.
[0023]
FIG. 2 is a diagram illustrating an example of a template of a printing form managed by the external storage device 14 of the information processing apparatus illustrated in FIG.
[0024]
Creating such a form template is performed in the same manner as a normal drawing tool. However, since it is necessary to combine with the retrofit data (to be described later with reference to FIG. 3) at the time of printing, the area for loading the retrofit data is clearly shown.
[0025]
In FIG. 2, portions indicated by XXXXXX such as 102, 103, 104, and 105 are fields (variable data fields) in which variable data is to be displayed. Each variable data field is given a name. In this example, the variable data field 102 has “Sheet_No”, the variable data field 103 has “Cust_Name”, the variable data field 104 has “Cust_Adr”, and the variable data field has 105 is given a name such as “Code 1”.
[0026]
This is a fixed field for a display object other than the variable data field such as the portion indicated by 101, and is a fixed portion in the form.
[0027]
FIG. 3 is a diagram showing a configuration example of post-install data to be combined with the form template shown in FIG. In this example, for example, “12345” is displayed in the variable data field 102 (Sheet_No field) and “ABC Company” is displayed in the variable data field 103 (Cust_Name field) on the form template, and printed.
[0028]
FIG. 4 is a diagram showing an outline of a format example of the form template data stored in the external storage device 14 (hard disk in this example) shown in FIG. An identifier 301 specifies each display object. Reference numeral 302 denotes an attribute of each display object, which indicates the type of the object (for example, a display object such as a character string, a line, a Box, or an image, or a variable data field). Reference numeral 303 denotes a position of the object on the form template (form). Reference numeral 304 designates the data content of each object, for example, if it is a character string, the actual character string, and if it is variable data, the name as shown in FIG. 3 is assigned. In addition, in 305, necessary items for each object are shown in detail. This detailed item 305 stores, for example, information indicating the size of each display object or variable data field, and information indicating whether the input data is a character string or a numerical value for the variable data field.
[0029]
Next, a method of creating an input form according to the present embodiment will be described with reference to FIGS.
[0030]
FIG. 5 is a diagram showing a display example of an input form creation window displayed on the display 15 shown in FIG.
[0031]
In FIG. 5, reference numeral 401 denotes an entire window for creating an input form, and the window 401 is displayed on the display 15. A menu bar 402 has a plurality of menu buttons. An output form area 403 displays an output form template 404. Reference numeral 405 denotes an input form area for displaying and editing the input form 406.
[0032]
As shown in FIG. 5, an input form 406 is automatically generated based on the output form template 404 displayed in the output form area 403. Here, the variable data field included in the output form template 404 is replaced with a data input box. For example, in FIG. 5, the variable data field 407 has been replaced by a data entry box 408.
[0033]
Reference numeral 409 denotes a boundary between the output form template display area and the input form creation area, and can be resized.
[0034]
Next, a procedure for generating an input form according to the present embodiment will be described.
[0035]
A file reading button is arranged in the menu button group of the menu bar 402. When this button is selected, a selection panel for selecting a general file is displayed. On this file selection screen, the user selects a file of the output form template that has already been created.
[0036]
In this example, it is assumed that a file in the file format shown in FIG. 4 is read and the output form template 404 is reproduced in the output form area 403 as shown in FIG. Note that the output form area 403 is a display-only area and cannot perform operations such as editing. The input form is automatically generated at the same time as the output form template is reproduced, and is displayed as the input form 406 in the input form area 405 as shown in FIG. The above operation will be described with reference to FIG.
[0037]
FIG. 6 is a flowchart illustrating an example of a first data processing procedure in the information processing apparatus according to the present invention, and corresponds to an input form generation procedure according to the present embodiment. Note that (S501) to (S509) indicate each step, and the CPU 11 executes the form creation processing program stored in the external storage device 14 shown in FIG.
[0038]
In FIG. 6, in step S501, the output form template file is read again. Then, in step S502 and thereafter, each record of the output form template file is analyzed.
[0039]
First, in step S502, records are read one by one from file data as shown in FIG. Then, in step S503, it is determined whether the record is a variable data input field. This determination is made by checking the item of the attribute 302 in FIG.
[0040]
If the record is a variable data input field, the process advances to step S504 to generate a text field for the record. Then, in step S505, the generated text field is stored in the memory (RAM 13) as an input field record.
[0041]
FIG. 7 is a diagram showing an example of holding text field information corresponding to the variable data field shown in FIG.
[0042]
On the other hand, the record as shown in FIG. 7 is held by the storage processing in step S505.
[0043]
On the other hand, if it is determined in step S503 that the field is not a variable data input field, the process advances to step S506. In step S506, objects (lines, character strings, images, etc.) similar to the display objects defined in the output form are generated.
[0044]
In step S507, the text field generated in step S504 or the object generated in step S506 is displayed on the input form. In step S508, it is determined whether all records in the output form template file have been processed. If there is an unprocessed record, the process returns to step S502, and the above process is repeated. On the other hand, if all records have been processed, this processing ends.
[0045]
In this way, as shown in FIG. 5, an input form corresponding to the output form template is generated, and both are displayed. At this point, the created input form has the same arrangement as the output form template. However, the input form does not need to be the same as the output form, and an input form that is more suitable for input, that is, has high input efficiency, is required.
[0046]
Thus, in the present embodiment, the generated text field and other objects can be edited.
[0047]
FIG. 8 is a diagram showing an example of an input field editing process on the form creation screen shown in FIG.
[0048]
8, the positions of the text field and the character string object in the input field shown in FIG. 5 are changed to improve the input operability. That is, the generated text fields are moved and aligned, and the contents of the display object (character string) are changed (in FIG. 8, “NO” → “number”, “sama” → “customer name”, “ Address) → "address".
[0049]
Here, if the input form becomes a desired one, this file is once saved by the operation of the operator (in this example, by instructing a “save” button on the menu bar 402) (in this example, Stored in the external storage device 14). In the above, the procedure for generating an input form based on the read output form file and editing the input form has been described. However, it is of course possible to read an existing input form file and edit the input form file.
[0050]
As described above, when the input form is completed and the data is saved, the mode can be changed from the edit mode to the execution mode 901 (see FIG. 9) by operating the mode change button 701. Creation and editing of the input form described above are operations in the edit mode.
[0051]
On the other hand, when data is actually input using the created input form and the data is printed, the mode is shifted to the execution mode. The transition to the execution mode is possible after reading the input form file in the file reading operation or after saving the created or edited input form.
[0052]
By the way, in the execution mode, a menu bar 402A is displayed in the window as shown in FIG. In the menu bar 402A, a print button 902 is added, and a print process can be selected. Note that the print button does not function in the edit mode, and thus cannot be selected (in this example, the print button itself is not displayed as shown in FIG. 5).
[0053]
In the execution mode, actual data can be input to the created input form, and data can be input from the keyboard 16 to the generated text field.
[0054]
FIG. 9 shows a state in which data is input to a text field in the input form in the execution mode. Here, when the print button 902 is selected, the data input to the text field is merged with the data indicating the text field shown in FIG. 7 (that is, the name of the text field is associated with the input data), So-called postscript data that describes a key-value pair in the format shown in FIG. 3 is created. The attached data is merged with the output form template and printed by the printer 20, thereby obtaining a form.
[0055]
In the above-described embodiment, the movement of the text field is shown as the editing work related to the text field on the output form, but the editing work is not limited to this. For example, the attributes (numerical value, character string) of the text field on the output form, the size of the box, and the like can be changed.
[0056]
FIG. 10 is a diagram for explaining the automatic calculation field creation and editing state for the form shown in FIG. 8, and corresponds to the automatic calculation formula setting processing state for the total button 1001 in the form shown in FIG.
[0057]
In FIG. 10, when a total button 1001 for displaying the total of the columns of the table is selected and indicated, an attribute sheet 1002 is displayed on the edit screen of the display 15, and a list of the attributes of the total button 1001 is displayed. In the present embodiment, as the attribute list, the type is “TextField”, the name is “TextField1”, the X coordinate is “351”, the Y coordinate is “435”, the width is “71”, and the height is “27”. It is shown that.
[0058]
In such a display state, when the calculation formula editing menu is selected from the menu with a mouse or the like, a calculation formula confirmation panel for defining the operation related to the button is displayed on the display 15.
[0059]
FIG. 11 is a diagram showing an example of a calculation formula confirmation panel displayed on the display 15 shown in FIG.
[0060]
In FIG. 11, reference numeral 10-1 denotes a field name list, which displays all field name lists described in the read print template. A column name list 10-2 displays a list of all column names of the table described in the read print template.
[0061]
Reference numeral 10-3 denotes a calculation formula setting button. Numeric buttons "0" to "9", calculation buttons "+", "-", "*", "/", and calculation formula control buttons "(", ")" , An erasing button “CE” for erasing a set numeral, etc., a decimal point button “.” For inputting a decimal point, a calculation button “Sum” for calculating synthesis, and a calculation button “Avg” for calculating an average. Have.
[0062]
A field name 10-4 indicates the name of the selected field. Since the total button 1001 shown in FIG. 10 is currently selected, “TextField1” is displayed as a selected state in the field name 10-4 in the display example of FIG.
[0063]
10-5 is a calculation formula. If there is a calculation formula described in the printing template, the calculation formula is displayed. If there is no calculation formula, text indicating the calculation formula is not displayed. In the example illustrated in FIG. 11, a set including the calculation formula 10-5 and the field name 10-4 indicates that the sum of the values of the table column indicated by the name “ColumnName5” is calculated and assigned to the field “TextField1”. ing.
[0064]
When there is a calculation formula described in the printing template, the calculation formula cannot be edited. If there is no calculation formula described in the printing template, a desired calculation formula can be edited with respect to the calculation formula 10-5, and the field name 10-1 or the table column name 10-2 can be changed. When selected, the selected character string is added to the text 10-5, and when each button in the calculation formula setting button 10-3 is selected, the operation corresponding to each button is reflected in the text 10-5.
[0065]
When the calculation formula 10-5 is displayed and the check button (Check) 10-6 is selected, the grammar of the displayed calculation formula is checked, and the true / false result is displayed in the result 10-9. In the example illustrated in FIG. 11, it is determined that the calculation formula is grammatically correct, and the result 10-9 corresponds to a state in which “The Expression is Valid” is displayed.
[0066]
Then, when the calculation formula is appropriate, when the set button (Set) 10-7 is selected, a new calculation formula set by the user displayed in the calculation formula 10-5 can be executed in the input form using the script. It is converted into a language calculation formula and embedded in the input form (calculation formula editing process). When the selection button (OK) 10-8 is selected, the calculation formula confirmation panel shown in FIG. 11 is closed.
[0067]
Hereinafter, with reference to the flowchart shown in FIG. 12, a description will be given of a process of converting a script language into a calculation formula executable in the input form shown in FIG.
[0068]
FIG. 12 is a flowchart showing an example of the second data processing procedure in the information processing apparatus according to the present invention, which is set on the total button 1001, that is, set by the user displayed in the calculation formula 10-5. The new calculation formula corresponds to a processing procedure for converting into a script language calculation formula that can be executed in the input form. (S11-1) to (S11-8) indicate each step.
[0069]
In step S11-1, when the check button 10-6 is instructed to be selected, in step S11-2, the CPU 11 reads the calculation formula set in the calculation formula 10-5, and interprets the grammar of the calculation formula as described later. A check is performed according to the checklist, and if the grammar of the calculation formula is valid, the field names in the calculation formula and the column names of the table are cut out in step S11-3.
[0070]
In step S11-4, the extracted field names and column names of the table are converted into a format used in a script language. Next, in step S11-5, the terms and operators in the calculation formula are converted into the corresponding terms and operators in the script language, respectively, to generate executable script language functions.
[0071]
Next, in step S11-6, an attribute for executing the script language is assigned to the corresponding field of the input form. Then, in step S11-7, the script language generated in step S11-4 is embedded, and in step S11-8, the process ends.
[0072]
Note that the calculation formula editing panel can be opened and changed by operating the mouse or the like at any time during editing, not only when buttons are arranged.
[0073]
Hereinafter, an example of a grammar used for checking the grammar of the calculation formula in step S11-2 shown in FIG. 12 will be described.
[0074]
{Circle around (1)} Computational formula (Production)
The entire calculation formula is composed of formulas obtained by substituting the calculation formula into variables.
[0075]
(2) Calculation formula (Expression)
The formula consists of parentheses, numerical values, variables, operators, and formulas.
[0076]
(3) Parenthesis
In the calculation formula, two kinds of parentheses "(", ")" are used. The set of open parenthesis "(" and close parenthesis ")" must match in pairs. A set of parentheses can enclose the entire calculation. If the parentheses do not match, a syntax error occurs.
[0077]
(4) Numerical value (Number)
The numbers are numbers that can be used in scripting languages.
[0078]
For example, when the JavaScript language is used as the script language, the numeric values are the same as the positive or floating-point numeric values that can be used in the JavaScript language. Positive numbers are in the form of octal, decimal, and hexadecimal numbers in the Java (registered trademark) Script language. If there is an error in the numeric format, an error occurs in the syntax check.
[0079]
(5) Variable (Variable)
There are two types of variables that can be used: field names and table column names.
[0080]
Table column names cannot be set for table cells. Variable names can be alphanumeric and "_". Variable names cannot start with a number.
[0081]
(6) Operator
The operator is composed of a unary operator or a binary operator. Unary operators are “_”, “Sum”, and “Avg”. Note that the "_" operator inverts the sign of a variable. The "Sum" operator is applied to table column variables to calculate the sum of table columns. The "Avg" operator is applied to table column variables to calculate the average of the table columns. Binary operators are four arithmetic operations "+", "-", "*", and "/".
[0082]
Unary operators have the highest precedence. Unary operators associate from right to left. The binary operators “*” and “/” have higher precedence than other “+” and “−”. Binary operators combine from left to right. If divided by the variable "0", an error occurs in the grammar check.
[0083]
Hereinafter, an example of the execution mode processing of a form created by operating the calculation formula confirmation panel shown in FIG. 11 will be described.
[0084]
Here, when the input form becomes a desired one, this file is temporarily saved in the memory by the operation of the operator. In the menu bar shown in FIG. 9, means for changing the execution mode are arranged. The work performed so far is the edit mode, in which the input form is created and edited.
[0085]
On the other hand, the mode can be changed to the execution mode. In the execution mode, the print button 902 shown in FIG. 9 is in a selectable state. Note that the print button 902 does not function in the edit mode, and thus cannot be selected. In the execution mode, actual data input can be performed on the created input form. Input data to the generated text. This situation is shown in FIG.
[0086]
FIG. 13 is a diagram for explaining a form processing state in the information processing apparatus according to the present invention, and corresponds to a data input state to the input form in the execution mode on the display 15 shown in FIG.
[0087]
In FIG. 13, the first row 12-1 of the table includes data of code “110”, product name “EOS (product name)”, unit price “520”, quantity “1”, and subtotal “520”. Has been entered. Similarly, in the second row 12-2 of the table, data of code “111”, product name “IXY (product name)”, unit price “400”, quantity “1”, and subtotal “400” are input. Have been. When this input is performed, the total amount “920” of the subtotal “520” of the first row 12-1 and the subtotal “400” of the second row 12-2 is calculated by executing the script, and "920" is automatically displayed in the total field 12-3 for displaying the total.
[0088]
When the print button 12-4 is selected after inputting all the data, the data is merged with the data indicating the text field shown in FIG. 7, and so-called postscript data of a key-value pair in the format shown in FIG. 3 is created. Is done.
[0089]
At this time, the result automatically calculated by the script language is discarded, and the postscript data is merged with the output form template, so that the print data is recalculated from the postscript data using a calculation formula, and a printed form is obtained. Can be
[0090]
According to the above-described embodiment, a form in which a calculation formula intended by the user is defined in the data input stage with respect to the undefined feel of the input form created in advance, and the calculation formula result is reflected in the input data. Can be printed.
[0091]
Therefore, when changing the definition of one field as in the past, it is necessary to modify and edit in a timely manner and customize the input form intended by the user by a simple operation without performing definition processing of all the fields. it can.
[0092]
Hereinafter, the configuration of a data processing program readable by the information processing apparatus according to the present invention will be described with reference to a memory map shown in FIG.
[0093]
FIG. 14 is a diagram illustrating a memory map of a storage medium that stores various data processing programs that can be read by the information processing device according to the present invention.
[0094]
Although not shown, information for managing a group of programs stored in the storage medium, for example, version information, a creator, and the like are also stored, and information dependent on the OS or the like on the program reading side, for example, a program is identified and displayed. Icons and the like may also be stored.
[0095]
Further, data dependent on various programs is also managed in the directory. In addition, a program for installing various programs on a computer or a program for decompressing a program to be installed when the program to be installed is compressed may be stored.
[0096]
The functions shown in FIGS. 6 and 12 in this embodiment may be performed by a host computer by a program installed from the outside. In this case, the present invention is applied even when a group of information including a program is supplied to the output device from a storage medium such as a CD-ROM, a flash memory, or an FD, or from an external storage medium via a network. Things.
[0097]
As described above, the storage medium storing the program codes of the software for realizing the functions of the above-described embodiments is supplied to the system or the apparatus, and the computer (or CPU or MPU) of the system or the apparatus stores the storage medium in the storage medium. It goes without saying that the object of the present invention is also achieved by reading and executing the program code thus obtained.
[0098]
In this case, the program code itself read from the storage medium implements the novel function of the present invention, and the storage medium storing the program code constitutes the present invention.
[0099]
As a storage medium for supplying the program code, for example, a flexible disk, hard disk, optical disk, magneto-optical disk, CD-ROM, CD-R, magnetic tape, nonvolatile memory card, ROM, EEPROM, or the like may be used. it can.
[0100]
When the computer executes the readout program code, not only the functions of the above-described embodiments are realized, but also an OS (Operating System) running on the computer based on the instruction of the program code. It goes without saying that a part or all of the actual processing is performed and the functions of the above-described embodiments are realized by the processing.
[0101]
Further, after the program code read from the storage medium is written into a memory provided on a function expansion board inserted into the computer or a function expansion unit connected to the computer, the function expansion is performed based on the instruction of the program code. It goes without saying that a CPU or the like provided in the board or the function expansion unit performs part or all of the actual processing, and the processing realizes the functions of the above-described embodiments.
[0102]
According to the above embodiment, it is possible to automatically generate an input form from output form data, thereby reducing the load of input form creation on the user, and to automatically generate an input form from print form data. Can be edited, and creation of an appropriate input form with high data input efficiency can be facilitated.
[0103]
【The invention's effect】
As described above, according to the present invention, during data input for each numeric input field defined in the selected and read template, any of the undefined A numeric input field is determined, and a predetermined calculation formula based on a script language is defined for the numeric input field determined to be undefined and embedded in the undefined numeric input field of the template. Since the calculation result based on the predetermined calculation formula based on the script language is reflected in the input data of the corresponding numeric input field, the defined numeric input is performed while the numeric data is input in the numeric input field using the template. Check the formula for fields, or enter a value for undefined numeric input fields. Can directly define a calculation formula intended in a script language, and can freely perform a form processing reflecting numerical input data input to a numerical input field in which the defined calculation formula is embedded. It works.
[Brief description of the drawings]
FIG. 1 is a block diagram illustrating a configuration of an information processing apparatus according to an embodiment of the present invention.
FIG. 2 is a diagram showing an example of a template of a printing form managed by an external storage device 14 of the information processing apparatus shown in FIG.
FIG. 3 is a diagram showing a configuration example of post-install data to be combined with the form template shown in FIG. 2;
4 is a diagram showing an outline of a format example of form template data stored in an external storage device shown in FIG. 1;
FIG. 5 is a view showing a display example of an input form creation window displayed on the display shown in FIG. 1;
FIG. 6 is a flowchart illustrating an example of a first data processing procedure in the information processing apparatus according to the present invention.
FIG. 7 is a diagram showing an example of holding text field information corresponding to the variable data field shown in FIG. 4;
8 is a diagram showing an example of an input field editing process on the form creation screen shown in FIG.
FIG. 9 is a diagram showing an example of an input field editing process in an execution mode on the form creation screen shown in FIG. 5;
FIG. 10 is a diagram for explaining an automatic calculation field creation / edit state for the form shown in FIG. 8;
11 is a diagram showing an example of a calculation formula confirmation panel displayed on the display shown in FIG.
FIG. 12 is a flowchart illustrating an example of a second data processing procedure in the information processing apparatus according to the present invention.
FIG. 13 is a diagram illustrating a form processing state in the information processing apparatus according to the present invention.
FIG. 14 is a diagram illustrating a memory map of a storage medium that stores various data processing programs that can be read by the information processing apparatus according to the present invention.
[Explanation of symbols]
11 CPU
12 ROM
13 RAM
14 external storage device 15 display 16 keyboard 17 mouse 20 printer

Claims (8)

A storage means for storing a form printing template in which a plurality of numerical input fields can be defined; and predetermined data to be input for each numerical input field defined in the template selected and read from the storing means. An information processing apparatus for performing a form printing process by synthesizing the form data of the template,
Discriminating means for discriminating any of the undefined numeric input fields among the plurality of numeric input fields during data input for each numeric input field defined in the template selected and read from the storage means; When,
A calculation formula embedding unit that defines a predetermined calculation formula based on a script language and embeds it in the undefined numerical input field of the template for the numeric input field determined to be undefined by the determining unit,
Form control means for reflecting a calculation result based on a predetermined calculation formula based on a script language embedded by the calculation formula embedding means in input data of a corresponding numeric input field,
An information processing apparatus comprising: 2. A calculation formula confirming means for displaying a calculation formula defined in a numerical value input field determined to have been defined by said determination means in a predetermined calculation formula based on said script language. An information processing apparatus according to claim 1. Instruction means for instructing print execution after reflecting the input data input to the corresponding numeric input field by the form control means,
Based on an instruction from the instruction unit, a print control unit that combines the input data and the form data of the template to output a form printing process from a printing unit,
The information processing apparatus according to claim 1, further comprising: A storage means for storing a form printing template in which a plurality of numerical input fields can be defined; and predetermined data to be input for each numerical input field defined in the template selected and read from the storing means. A form processing method in an information processing apparatus that performs form printing processing by combining processing with form data of the template,
A determination step of determining any of the undefined numeric input fields among the plurality of numeric input fields during data input to each numeric input field defined in the template selected and read from the storage unit; When,
For a numeric input field determined to be undefined by the determining step, a formula embedding step of defining a predetermined formula based on a script language and embedding the formula in an undefined numeric input field of the template,
A control step of reflecting a calculation result based on a predetermined calculation formula based on a script language embedded by the calculation formula embedding step in input data of a corresponding numerical value input field,
A form processing method comprising: 5. The method according to claim 4, further comprising the step of: displaying a calculation formula defined in the numerical value input field determined to have been defined in the determination step by a predetermined calculation formula based on the script language. Form processing method described. After reflecting the input data input to the corresponding numeric input field by the form control step, an instruction step to instruct print execution,
A print control step of combining the input data and the form data of the template and outputting a form printing process from a printing unit based on the instruction by the instruction step;
5. The form processing method according to claim 4, comprising: A computer-readable storage medium storing a program for implementing the form processing method according to any one of claims 4 to 6. A program for realizing the form processing method according to any one of claims 4 to 6.

Images