JP2005284960A - Business report summarization management system and method thereof - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a business report summarization management system wherein a report format and a summarization format can be easily set and operability in a report summarization job is improved. <P>SOLUTION: The business report summarization management system is composed of: a report format selection means in which a picture S46 is displayed for selecting a report format out of a list of report formats and which includes an input picture S47 for the number of rows and the number of columns of said report format; a cell attribute setting means including a display picture for a setting start button in each cell of an input table comprised of the number of rows and the number of columns; a cell attribute selecting means in which a list of cell attributes of "no attribute setting" S49a, "item name" S49b, "single row character string" S49c, "multiple row character string" S49d, "numerical value" S49e, "formula" S49f, and "selection item list" S49g is displayed and which includes a selection picture for one of said attributes; an attribute addition condition setting means including an input display picture of an additional attribute for the selected cell attribute; and a storage means for storing the report format in which attribute setting is generated by the setting means. <P>COPYRIGHT: (C)2006,JPO&NCIPI

Description

  The present invention relates to various business reports performed between a plurality of organizations or departments using the Internet or other networks, and their aggregation work, in particular, creation of various types of report forms, report deadline management, or The present invention relates to a business report aggregation management system and method for performing a report aggregation operation.

  Conventionally, in organizations such as headquarters, branch offices, and sales offices that consist of several levels, such as a company or office, sales, inventory status, etc. for each product handled between different levels or different departments A variety of reports, reports, and tabulations are carried out regularly or from time to time, such as daily or monthly reports. These reports and information exchanges have recently been enhanced in the construction of the Internet. From the multiple terminals installed at the headquarters and sales offices, using the simultaneous delivery by e-mail and the bulletin board function on the homepage, the Management Center Alternatively, transmission / reception to / from a server in a higher hierarchy section is generally performed.

  In addition, the management center and higher-level management departments usually process the data of transmitted reports using commercial spreadsheet application software, and use it as a basis for grasping business conditions and managing management data. It is.

  In addition, there is now an automatic counting system that processes the received data of report contents sent simultaneously from various places using an automatic counting program that uses commercially available spreadsheet software, and there are many types of reports. Or, when the format becomes complicated, special application counting software is created and tabulation is often performed.

  In large-scale companies or public corporations vs. other organizations, the reporting work performed between departments at different levels or between departments within the same hierarchy, or their aggregation work, when there are many products or services handled, There are a variety of reporting formats. Therefore, even when using spreadsheet software for these operations, specialized knowledge and experience are required, and there is a limit to the use of those who do not have such knowledge and experience. In particular, it was necessary to depend on the person in charge of spreadsheet software and the person in charge of software development to create a wide variety of reporting forms and compilation forms.

  Therefore, in view of the conventional problems as described above, the object of the present invention is to perform reporting / aggregation work including preparation of a report format or a tabulation format even for a person who is not familiar with the operation of spreadsheet software. It is an object of the present invention to provide a report / tabulation system that can be easily performed by interactive operation and can improve work efficiency.

  In order to achieve the above object, the business report aggregation management system of the present invention inputs at least one of the report name, the reporting deadline, the reporting period, the report target person, and the aggregation / viewing person who aggregates / views the report. A report condition input means including a display screen displaying each input field and a screen for selecting the desired report format from the report format list are displayed, and the number of rows and columns of the selected report format are entered. A report format selection means including an input field to be input, an input table having a grid-like cell composed of the number of rows and columns of the selected report format input by the report format selection means, and a cell in each cell of the input table. A cell attribute setting unit including an input table layout screen on which a setting start button for setting an attribute is displayed, and a setting start button for each cell in the input table layout screen of the cell attribute setting unit is turned on. By doing so, "No attribute setting", "Item name", "Single line string", "Double line string", "Numeric value", "Formula", and "Selected item list" are displayed as a list. Cell attribute selection means including a display screen for selecting one of the displayed cell attributes, and for the cell attribute selected by the cell attribute selection means, “number of characters”, “number of rows”, “integer digits” Attribute additional condition setting means including a display screen for inputting additional attributes such as “decimal digits”, “formula” or “selection item”, and attributes for each cell of the input table layout screen by the setting means A storage means for storing a report format generated by setting is provided.

In addition, the business report total management system of the present invention includes a report name, a report deadline, a report period, a report target person, and an input field for inputting at least one of the totals / viewers for totaling / viewing reports. A report condition input means including a display screen with a display and a screen for selecting a desired aggregation format from the aggregation format list, and an aggregation table showing the aggregation name of the selected aggregation format and the number of aggregation items Totaling form selection means including an input field for inputting the number of columns, and totaling including cells arranged in a grid consisting of the number of columns of the selected totalization form input by the totalization style selection means and a predetermined number of rows A column attribute setting unit including a table and a summary table layout screen in which a setting activation button for setting a column attribute is displayed for each column of the summary table, and the column attribute setting unit includes the summary table layout. screen By turning on the setting start button for each column, the column attribute list of "Item name", "No aggregation setting", "Input data", "Four arithmetic operations", and "Total" is displayed in a list. Column attribute selection means including a display screen for selecting one of the displayed column attributes;
Aggregation attribute condition setting means for inputting the aggregation attribute displayed in the column attribute list selected by the column attribute selection means into the cell of each row belonging to each column, and the aggregation table layout screen by each means. And a tabulation style registration means for storing a tabulation style in which attributes are set for each cell. Furthermore, the report form storing the report form that identifies and stores the report name in the report form storage means is searched under a predetermined condition for the report deadline or report acceptance period, Provided is a feature of automatically requesting a report of the report name at a predetermined time by e-mail or web posting via a network.

  Furthermore, after the reporting deadline entered and set in the report form, the reporter of the report notified of the report form is compared with the report target person set and entered by the report condition setting means of the report form, and the previously reported report A report is provided which automatically sends a report prompting a report of the report name to a report target person other than the reporter by e-mail or web posting via the network.

  In addition, according to the method for managing and managing business reports of the present invention, the report name, the report deadline, the report period, the report target person, and the input fields are displayed for at least one of the totals / viewers for totaling / viewing the reports. A report condition input step to be entered on the display screen and a screen for selecting a desired report format from the report format list are displayed, and a report in which the number of rows and columns of the selected report format are entered in the input fields on the screen A setting activation button is displayed in the input table having a grid cell composed of the number of rows and columns of the selected report format entered in the format selection step and the number of rows and columns of the selected report format, and in each cell of this input table. A cell attribute setting step for setting cell attributes on the input table layout screen, and a setting activation button for each cell in the input table layout screen in the cell attribute setting step are turned on. In the screen that lists "No attribute setting", "Item name", "Single line string", "Double line string", "Numeric value", "Formula", and "Selected item list" A cell attribute selection step for selecting one of the cell attributes displayed in the list, and for the cell attribute selected by the cell attribute selection step, “number of characters”, “number of rows”, “integer digits”, “ On the display screen of additional attributes such as “decimal digits”, “math formula” or “selection item”, an attribute additional condition setting step for inputting these additional attributes, and the above-described setting steps, the input table layout screen A storage step for storing a report format generated by setting attributes for each cell is provided.

  In addition, according to the method for managing and managing business reports of the present invention, the report name, the report deadline, the report period, the report target person, and the input fields are displayed for at least one of the totals / viewers for totaling / viewing the reports. The report condition input step to be entered on the display screen and the screen for selecting the desired aggregation form from the summary form list are displayed, and the summary name of the selected summary form and the number of summary table columns that are the number of summary items A tabulation table including cells arranged in a grid consisting of the number of columns of the selected tabulation format input by the tabulation style selection means and a predetermined number of rows. And a column attribute setting step including a summary table layout screen in which a setting start button for setting a column attribute is displayed for each column of the summary table, and the summary table layout by the column attribute setting means By turning on the setting start button for each column in the screen, the column attribute list of “Item name”, “No aggregation setting”, “Input data”, “Four arithmetic operations”, and “Total” is displayed in a list. A column attribute selection step including a display screen for selecting one of the column attributes displayed in a list, and the aggregate attribute displayed in the column attribute list selected by the column attribute selection means belong to each column A total attribute condition setting step for inputting into the cells of each row, and a total form registration step for storing a total form for which attribute setting has been performed for each cell of the total table layout screen by each means. Provide what you want.

  According to the present invention, since various report forms and their summary forms can be created interactively in reporting / aggregation work between headquarters, branch offices, sales offices and other departments, knowledge and experience of spreadsheet software can be obtained. There is an effect that even a person who is not in charge can easily and efficiently carry out reporting and counting work.

  In addition, according to the present invention, report request, report deadline management, report tabulation, and the like can be performed by bulletin board display and reminder mail via the network, and there is an effect of making the reporting work known and thorough.

  Hereinafter, embodiments of a business report totaling management system of the present invention will be described with reference to the drawings.

  In the hierarchical organization shown in FIG. 1, reports are made to different departments, and the reported contents are totaled. The embodiment of the present invention is applied to such a corporate organization, and as shown in FIG. 2, the in-office LANs 13a to 13c laid in the head office 11a and the branch offices 11b and 11c, and a report aggregation Web server connected thereto. 14a, 14b, mail servers 15a, 15b, LAN terminal PCs 16a-16g, databases 19a-19c, routers 17a-17c for connecting this in-house LAN to the Internet 18, and the Internet 18 of the sales offices 12a-12n. This system is composed of connected terminal PCs 16j to 16n.

  FIG. 3 is a flowchart of the operation of this system. This flowchart is roughly divided into steps S1 to S3 surrounded by a dotted line. In step S1, a report format and a count format are created. In step S2, reports are made from each business site / department using the created report format, and in step S3, the reports are tabulated using the tabulation format created in step S1. These step S1 and step S3 are performed in the reportable business establishment / department for which the report is requested, and step S2 is performed in the sales department that performs the report.

  Next, each roughly divided step will be described.

  FIG. 4 is a flowchart showing details of a procedure for creating and editing a report format / format by interactive operation according to the screen display in step S1 of the present embodiment. 5 to 8 show examples of display screens displayed for conversational operations. The preparation of the report format is explained using these figures.

  First, a person in charge of a department who wants to receive a report on the status of work from each sales office or department department accesses this work report aggregation management system from the terminal PC of his department via the Internet or via a LAN connection. . By this access, various menu items provided by the business report totaling management system are displayed, and “Create report format” is selected. By this selection, the “report format details (registration / edit)” screen shown in FIG. 5 is displayed, and the procedure shown in the flowchart of FIG. 4 can be started.

  The procedure for creating the report format is to first perform steps S11 to S15 of step S1 described above in order to set various conditions for the requested report. In this procedure, in step S41 of FIG. 4, the name of the report is entered in the report name column 41 of the “report format details (registration / edit)” screen shown in FIG. In addition, the department in charge of creating this report (reported department), the designated business department, etc. are also set.

  In step S42, the month, week, day of the week for which a report is requested or a specified date is set and input in the report deadline column 42 on the same screen. Further, in step S43, the start and end periods for posting the report requesting the report of the report name on the WEB bulletin board (displayed on the screen display example shown in FIG. 12 for each sales office / department) are reported. The number of days before and after is entered into the posting start / end date column 43 and designated.

  In step S44, the partner sales office or department requesting this report (browsing the bulletin board), for example, from all stores / store condition area designation / individual designation as exemplified in the tabulation / browser column 44 Select with the radio button (only one item can be selected), and with “Store condition area designation”, check type (overlapping selection is possible) and store type, prefecture division or group division specially set by those skilled in the art Specify and select. This option is set by the department or person in charge who operates this business report totaling management system in accordance with each business condition, and may be set with a predetermined category and category name when the system is set. In addition, in order to carry out complicated classification and perform detailed tabulation, a choice is determined by a combination of a radio button and a check box. Further, in step S45, the department in charge of the summary compilation (aggregation) is input to the aggregation person display column 45, and the department in charge of the final correspondence of the reported data is specified. If there is a corresponding item in the other setting items, it is set and input. When this is completed, the “input screen creation” icon 46 is clicked to finish setting the report conditions.

  When the “input screen creation” icon 46 is clicked, an “input screen (registration / edit)” window shown in FIG. In step S46, the name of the report being created is displayed in the report name column 51 of the “input screen (registration / edit)” screen in FIG. 6A, and is already registered in the report format database D1 in the report list 52. The report form that is being displayed is displayed. When creating and registering a new report format, set the number of rows and columns of the report table in the report table setting field 53, and the title of the table to be registered does not overlap with the registered report table of the report list 52 And click the “new registration” icon button 53a to register. By this new registration, the new report format name is added and displayed as “Table 1” in the report list 52. If you use an already registered report form, you can click the radio button to select the report form. Further, when deleting a report form of the report list 52, the name of the report form to be deleted can be selected with a radio button, and the table can be deleted by clicking the “delete table” icon button.

  In order to edit / create a new report format, in step S47, the “table layout” icon button 54 shown in FIG. 6A is clicked, and “input table layout (registration / edit)” shown in FIG. Open the window screen. On this screen, a format for writing data to be reported in the report format (report entry table) 56 is set for each cell, each column, and each row.

  In step S48, a cell, row, or column “setting” icon 56a, 56b, or 56c for setting the report table format is selected and clicked. By this icon button, a screen for selecting a setting format shown in FIG. 7A is displayed. Further, the pull-down button 61 on the displayed screen is clicked, and “no setting” (FIG. 7A), “item” (FIG. 7B), “character (single line)” (same as above) in steps S49a to 49g. (Fig. (C)), "Character (multiple lines)" (Fig. (D)), "Numeric value" (Fig. 8 (a)), "Formula" (Fig. (B)), "Selection item" (Fig. (C)) Move to a screen for selecting a format to be set. If there are additional setting items 62 and 72 on the selected format screen, enter those settings and conditions, and click the “Register” icons 61 and 71 on the same screen to specify the format of the specified cell, row, or column. Confirm and register.

  Clicking on the “Register” icon returns to the “Input Table Layout (Registration / Edit)” screen 56 shown in FIG. 6B again. In Step S50, “Set” / “Register” for unset cells, rows, and columns. ”Repeatedly. After all cells have been set and registered, when you return to the “Input Table Layout (Registration / Edit)” screen, click the “Register Table Layout” icon (not shown) at the bottom of this screen to display the report format. The new registration of the form is stored and saved in the report form database D1, and the creation of the report form is completed.

  In addition, when changing a part of the existing report form and registering with a new report form name, “Table n” is shown in the report list 52 of FIG. The radio button of the existing report form to be corrected is turned on, and the “table layout” icon 54 is clicked. As a result, in step S47, an already set “input table layout (registration / edit)” screen (FIG. 5B) of the existing report format (table n) is opened. On this screen, one of the “setting” icons 56a, 56b, and 56c of the cell, column, or row to be changed or modified is selected and clicked, and any of steps S49a to 49g is selected. Then, return to the original “Input Table Layout (Registration / Edit)” screen, click the “Register Table Layout” icon (not shown), and report with the new report format name set by the changed / modified report format. It is stored and saved in the format database D1.

  As described above, the report format that is interactively set according to the display screen of the present embodiment can be set by operating the pull-down switch, radio button, check button displayed on the screen, or input to the input field. Can be set. Therefore, even a person who is not familiar with the ruled line operation of spreadsheet software or word processor can easily create it, which has the effect of improving the efficiency of reporting work and maintaining the accuracy of the report format setting.

  Next, the editing / creation of the tabulation style performed in step S1 will be described with reference to the flowchart shown in FIG. 9 and the display screen examples shown in FIGS.

  To edit and create the total form, click the “Create Total Screen” icon 47 on the “Report Format Details (Registration / Edit)” screen shown in FIG. 5 to set the total form as shown in the flowchart of FIG. To start.

  Steps S81 to S85 shown in FIG. 9 are the same as Steps S41 to S45 described above, and after setting the conditions for the report performed in “Create report format”, click the “Create total screen” icon 47. Then, an “input screen (registration / edit)” window shown in FIG. 10A is opened (step S86).

  In the tabulation list 92 of the “tabulation screen (registration / editing)” screen shown in FIG. 10A opened in step S86, the existing tabulation styles already registered in the tabulation style database D3 are displayed. The total form to be newly created / registered is set the total number of columns 93b in the total setting field 93, and the title of the total to be registered is set in the total title field 93c with a name that does not overlap with the registered total in the total list 92 Then, registration is performed by clicking the “new registration” icon button 93a. By this registration, a new total name is added and displayed as “Table 1” in the total list 92.

  Next, in step S87, the “total table layout” icon button is clicked to open the “total table layout (registration / edit)” screen in FIG. The tabulation table 96 of the screen shown in FIG. 10B is composed of a plurality of cells arranged in a grid of 3 rows and n columns, and each row of # 1 to # 3 rows in each column has “total item name” ( (# 1 line), “total attribute and report cell data” (# 2 line), and “total 爛” (# 3 line) are set.

    This setting is performed by sequentially selecting and clicking the “setting” setting buttons 96a to 96n in each column in step S88. For example, when the setting button 96a in the first column in FIG. 10B is clicked, the row setting screen shown in FIG. 11A is displayed, and formatting is performed for each of the rows # 1 to # 3 in the first column. . This format setting is performed by clicking the pull-down buttons 101a and 103a displayed in the # 2 and # 3 lines on the line setting screen shown in FIG. 11A, and the setting items listed in the pull-down menu that appears. This is done by selecting one. For example, when the pull-down button 101a is clicked, “item” is set for the # 1 row. For the # 2 line, as shown in FIGS. 11B to 11D, “no setting”, “input data”, “+ − × ÷ (four arithmetic operations)”, “cumulative” Four types of setting items are prepared in advance, and one of them is selected and set. For this “input data”, the number of decimal places, the presence or absence of commas, etc. are additionally set. Here, the meaning of “no setting” means that nothing is displayed in this cell as described above. In addition, when a specific calculation is performed using these input data, a mathematical expression is additionally set, and when a total for a certain period is obtained, a type period is additionally set.

  For the # 3 line on the line setting screen, any one of “total”, “average”, and “none” is selected and set by clicking a pull-down button displayed on the same line. Here, “none” means blank.

  When these settings are completed, the “registration” icon 102 on the same screen is clicked, and the setting of aggregation of the designated column is completed.

  When the “Register” icon 102 is clicked, the screen returns to the “Aggregate Table Layout (Register / Edit)” screen shown in FIG. 10B again, and “Set” for the unset column is repeated (Step S90). When all columns have been set and the screen returns to the “Aggregate Table Layout (Registration / Edit)” screen, click the “Register Total Layout” icon (not shown) to create a new aggregation style / format that has been edited and created. The registration format is stored and stored in the total database D3, and the total format editing procedure is completed.

  If you want to change a part of the existing tabulation form and register it with a new tabulation name, open the existing tabulation format in step S86 and change it to The correction contents are set, and the new total name is stored and stored in the total database D3.

  The tabulation format that is interactively set according to the display screen of this embodiment is set by the input to the pull-down switch or input field displayed on the screen, and the target tabulation format is used to set the four arithmetic operations and the total tabulation format. it can. Therefore, even a person who is not familiar with spreadsheet software can easily set up a tabulation format and create a tabulation result by summarizing reports from each department. There is an effect that you can count without relying on it.

  According to the above-described procedure, a report format for requesting a report and a count format for performing the aggregation can be prepared. In step S2 of the present embodiment, the report target business site / department set / designated in step S44 (or step S84) is displayed on a bulletin board screen via the Internet on the Web, for example, as shown in FIG. Display a report request on a web bulletin board. In the posting screen shown in FIG. 12, the report name column 113 is informed that “customer complaint information” is reported daily in the report period column 111, and further, by the respective dates shown in the report deadline 112, It is notified that there are three report requests (report requests) of “hay fever goods sales status”, “spring color color opinions”, and “sales results by product” displayed in the report name 114. In addition, since the department in charge of creation is displayed in the creation columns 115 and 116, it is also clarified to which department the request is made.

  The person in charge of the department who has requested the report looking at these bulletin board displays retrieves the designated report form from the “report form list” in the menu provided by the present system. For example, FIG. Open the report input screen for the target report name shown in (1), and turn on the “Report” icon switch on this screen. As a result, the input table 122 shown as an example of the display screen in FIG. 4B is displayed on the screen. Data to be reported is input to this input table, and transmitted to the reportee (department) via the Internet and answered.

  In step S3 of the present embodiment, the report data sent via the Internet and received by the terminal PC of the present system of the reportee (department) in step S31 is tabulated.

  In this tabulation, the tabulation format stored and stored in the tabulation format database D3 in step S17 of step S1 is retrieved in step S32 from the transmitted report format, and the target tabulation format name is shown, for example, in FIG. Display on the screen. When the “total” icon 131 on this screen is clicked, a total result list 132 as shown in FIG. Further, in step S34, the data of the report content that has been designated for the designated purpose can be output as list data in CSV format as necessary.

  On the other hand, the status of the report response is displayed in step S31. In step S35, the report request destinations that have not received the report are displayed in a list 141 on the “not received / report deadline” screen shown in FIG. In step S36, a reminder mail stating “Report has not yet been submitted” is created and delivered simultaneously to these report request destinations that have not yet arrived, for example, in the “Create reminder mail” field 142 of FIG.

  According to the above-described embodiment, a report format is set in advance by the operation and procedure of this system, and the report request and the format are transmitted to the report format via a bulletin board or the like via the web. The report data reported via is aggregated in a preset aggregation format and the result is displayed. Furthermore, the reported data can be output as a data list in CSV format and used for other spreadsheet data. It is also possible to display a list for sending a report prompting a report request to an unreported report request destination. The report counting work does not require a complicated operation, and the management of the reporting work is shown on the display screen, so that the person in charge can easily deal with it.

The figure which shows the structure of the organization body to which the business report totaling management system of this invention is applied. The block block diagram which shows embodiment of the work report total management system of this invention. The system flow figure which shows the operation method of the business report totaling management system of this invention. The flowchart which creates a report style by the business report total management system of this invention. The example of a screen display which inputs the detail of the report format in the business report total management system of this invention. The report format input and table layout screen display example in the business report total management system of the present invention. The example of a setting screen display of the report format in the business report total management system of this invention. The example of a report style setting screen display in the business report total management system of the present invention. The flowchart which creates the total form in the business report total management system of this invention. The example of total form input and the total table layout screen display in the business report total management system of this invention. The example of a setting screen of the total form in the business report total management system of this invention. 6 is a display example of report requests and tabulations on a web bulletin board in the business report tabulation management system of the present invention. The example of the screen display of selection of the report format in the business report total management system of this invention, and a report table. The example of the screen display of selection of the total form in the business report total management system of this invention, and a total result. The example of a screen display of a list of unreported persons and transmission of a reminder mail in the business report totaling management system of the present invention.

Explanation of symbols

11a: Head office
11b, 11c ... branch offices,
12a-12n ... Sales office,
13a to 13c: LAN in the workplace,
14a, 14b ... Report totaling Web server,
15a, 15b ... mail server,
16a to 16g: LAN terminal PC,
16j to 16n ... terminal PC,
17a-17c ... router,
18 ... Internet,
19a to 19c: Database.

Claims (6)

Report condition input means including a display screen on which each input field for inputting at least one of report name, report deadline, report period, report target person, summary / viewer for summarizing / viewing reports is displayed,
A screen for selecting a desired report format from the report format list is displayed, and a report format selection means including input fields for inputting the number of rows and columns of the selected report format,
An input table having grid-like cells consisting of the number of rows and columns of the selected report format entered by this report format selection means and a setting activation button for setting cell attributes are displayed in each cell of this input table Cell attribute setting means including an input table layout screen;
By turning on the setting activation button of each cell in the input table layout screen of the cell attribute setting means, "no attribute setting", "item name", "single line string", "double line string", “Numeric Value”, “Formula”, and “Selected Item List” are listed, and a cell attribute selection means including a display screen for selecting one of the listed cell attributes;
Additional attributes such as “number of characters”, “number of rows”, “integer digits”, “decimal digits”, “formula” or “selection item” are input to the cell attributes selected by the cell attribute selection means. Attribute additional condition setting means including a display screen to be displayed;
A business report totaling management system comprising: a report form registration means for storing a report form generated by setting attributes for each cell of the input table layout screen by each setting means. Report condition input means including a report name, a report deadline, a report period, a report target person, a total to compile and browse reports, and a display screen on which each input field for inputting at least one of the viewers is displayed, and a total A screen for selecting a desired tabulation form from the list of forms and a tabulation style selection means including an input field for inputting the tabulation name of the selected tabulation style and the number of columns of the tabulation table as the number of tabulation items When,
It has a summary table that includes cells arranged in a grid consisting of the number of columns of the selected summary format entered by this summary style selection means and a predetermined number of rows, and each column of this summary table has a column attribute Column attribute setting means including a schedule layout screen displaying a setting start button for setting
By turning on the setting start button of each column in the summary table layout screen by this column attribute setting means, “item name”, “no summary setting”, “input data”, “four arithmetic operations”, and “total” A column attribute list including a display screen for selecting one of the listed column attributes,
Aggregation attribute condition setting means for inputting the aggregation attribute displayed in the column attribute list selected by the column attribute selection means into a cell of each row belonging to each column;
A business report total management system comprising: a total form registration means for storing a total form in which attributes are set for each cell of the total table layout screen by each means.   With respect to the specific report name registered in the report form registration means, the report deadline or report acceptance period is searched under a predetermined condition, and the report target person set in the report name is sent electronically via the network. 3. The business report tabulation management system according to claim 1 or 2, characterized by prompting the report name to be reported at a predetermined time by e-mail or web posting.   After the report deadline, the report target person set in the report form is compared with the report target person who received the report within the deadline, and the prompt is given to the report target person other than the report target person who received the report. The business report totaling management system according to claim 3. Report condition input step for inputting at least one of report name, report deadline, report period, report target person, total / viewer who totals / views reports on the display screen in which each input field is displayed,
A screen for selecting a desired report format from the report format list is displayed, and a report format selection step for inputting the number of rows and columns of the selected report format in the input fields of the screen,
The input table that has the number of rows and columns of the selected report format entered in this report format selection step and has grid cells, and the input table layout screen that displays the setting activation button in each cell of this input table A cell attribute setting step for setting cell attributes;
By turning on the setting start button of each cell in the input table layout screen in the cell attribute setting step, “no attribute setting”, “item name”, “single line string”, “double line string”, A cell attribute selection step for selecting one of the cell attributes displayed in the list on the screen in which “Numeric Value”, “Formula”, and “Selected Item List” are listed,
Additional attributes such as “number of characters”, “number of rows”, “integer digits”, “decimal digits”, “formula” or “selected item” are displayed for the cell attributes selected in this cell attribute selection step. Attribute additional condition setting step for inputting these additional attributes on the screen;
And a storage step of storing a report format generated by performing attribute setting for each cell of the input table layout screen in each setting step. Report condition input step for inputting at least one of report name, report deadline, report period, report target person, total / viewer who totals / views reports on the display screen in which each input field is displayed,
A screen for selecting the desired tabulation format from the tabulation list is displayed, and the tabulation name for entering the tabulation name of the selected tabulation format and the number of columns in the tabulation table, which is the number of tabulation items, is entered in the input field on the screen A selection step;
It has a summary table that includes cells arranged in a grid consisting of the number of columns of the selected summary format entered by this summary style selection means and a predetermined number of rows, and each column of this summary table has a column attribute A column attribute setting step including a schedule layout screen displaying a setting start button for setting
By turning on the setting start button of each column in the summary table layout screen by this column attribute setting means, “item name”, “no summary setting”, “input data”, “four arithmetic operations”, and “total” Column attribute list, and a column attribute selection step including a display screen for selecting one of these listed column attributes,
Aggregation attribute condition setting step of inputting the aggregation attribute displayed in the column attribute list selected by the column attribute selection means into a cell of each row belonging to each column;
A business report total management method comprising: a total form registration step for storing a total form in which attributes are set for each cell on the total table layout screen by each means.