JPH10143592A - Report preparation device provided with connection repetitive frame and connection repetitive frame generation method - Google Patents

Abstract

PROBLEM TO BE SOLVED: To prepare an efficient report by ending data arrangement by a first upper repetitive frame, then performing separation for the interval of the first upper repetitive frame and arranging data by a second lower repetitive frame in the case of including a repetitive frame linker in information for a report format. SOLUTION: A user interface 500 inputs the information for the repetitive frame linker to a continuous repetitive frame information input processor 502 along with the information for the respective repetitive frames. Thereafter, in the case of generating the repetitive frame by the information for the report format, a data take-out part 520 repeatedly takes out the next data while the data corresponding to a data base connection data field are present in a data base 550 and transmits them to an arrangement part 530. The arrangement part 530 places a gap at the interval between the first and second upper and lower repetitive frames and then performs correction so as to position the start position of the second lower repetitive frame at the end part of the gap.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to database report generation, and more particularly, to a report creator for continuously using repetition frames and a method for generating linked repetition frames.

[0002]

2. Description of the Related Art A report creator is a tool for outputting data in a database in a desired format. A typical report maker currently in use is Repo
rtSmith, CrystalReport and ReportMaster. FIG. 1 is a block diagram of a general report creator. The report writer has a user interface 100 and SQL
It includes a (Structured Query Language) creator 110, a data extracting unit 120, an arranging unit 130, a frame summarizing unit 140, and a database 150.

[0003] The database 150 is a set of data stored in an auxiliary storage device of a computer in a certain configuration format. The user interface 100 receives from the user information about the data desired by the user and the format of the report that the user intends to create. Usually, on a PC, the user interface 100 is a GUI (Graphic User
Interface). The SQL creator 110 uses the information on the data to
Create the SQL required to retrieve data from. The data extracting unit 120 extracts data necessary for preparing a report from the database 150 using the SQL created by the SQL creator 110. The arranging unit 130 creates a report according to the data extracted from the data extracting unit 120 and the information on the report format provided from the user interface 100. The frame summarization processing unit 140 calculates summarization information such as a total and an average of a series of data output in the report based on the information input through the user interface 100, and outputs the summary information to the report.

Here, the user interface 10
0, the SQL creator 110, the data fetching unit 120, the arranging unit 130, and the frame summarizing processing unit 140 are constituent blocks of a general application program, and are loaded into a main memory of a computer and executed when executed. Typically, the report creator user interface 100 receives information about the report format in the form of frames.
The frame is divided into a fixed frame and a repeated frame.

[0005] The fixed frame is a control object to which a certain range of display area is allocated and data is displayed only within the allocated area. On the other hand, the repetition frame is a control object in which the size of the display area is not limited. Accordingly, the present creator creates a report by repeatedly retrieving data while the data corresponding to the database concatenated data field contained within the repeat frame is present in database 150.

FIG. 2 is a diagram showing an example of a repetition frame. In FIG. 2, reference numeral 200 indicates the repetition frame, and reference numerals 210 and 220 indicate the database concatenated data fields, ie, the fields contained within the repetition frame. The repetition frame 200 controls the report writer to repeatedly retrieve the next data while the data corresponding to the database connection data fields 210 and 220 contained therein are present in the database. According to the repetition frame shown in FIG. 2, name and address data are shown on one line in the report, and the display of other name and address data is sequentially repeated downward until there is no more data in the database.

On the other hand, in preparing a report on data in a database, it is often required that two or more repetition frames are used in combination. FIG.
FIG. 4 is a diagram illustrating a report to which a connected repetition frame in which two repetition frames are used in combination is to be applied; According to the report shown in FIG. 3, first, educational background matters for individuals are shown in order, and then family matters are shown. Thereafter, data for other people is shown. In this manner, the educational background items and the data for each item are repeatedly displayed in one connected unit.

In order to implement such a connected repetition frame, first, a repetition frame for an educational background item should be executed, and then a repetition frame for a family item should be executed. Should be performed repeatedly on the whole. However, such a connected repetition frame cannot be implemented by a conventional report creator. The reason is that in outputting data from a conventional report creator by repeating frames, the starting position is usually fixed, while the position where the repetition ends is variable depending on the amount of data. This is because the position of the end of the upper repetition frame depends on the amount of data in the database, so that the data of the upper repetition frame violates the area of the lower repetition frame and two types of data are output in an overlapping manner.

[0009]

SUMMARY OF THE INVENTION The present invention has been made to solve the above problems, and it is an object of the present invention to provide a report creator having a connected repetition frame function and a method for generating a connected repetition frame. There is a purpose.

[0010]

To achieve the above object, a user interface for inputting a report format and an SQL creator for generating an SQL for data to be retrieved using the input report format are provided. Said created
A data fetching unit that fetches data from the database using SQL, a locating unit that creates a report in accordance with the information on the input report format, and the fetched data are included in the input report format. A report creator comprising a frame summary processing unit for creating a frame summary using information necessary for creating the frame summary and a database storing data.

The report format includes information for first and second repeated frames and information for a repeated frame linker including an interval between the first and second repeated frames,
When the information on the report format includes the repetition frame linker, the arranging unit separates the second lower repetition frame by an interval between the repetition frames after finishing the data allocation using the first repetition frame. The method is characterized by arranging data according to a program.

According to another aspect of the present invention, there is provided a method of generating a connected repetition frame, wherein a user interface to which a report format is input and an SQL for data to be extracted using the input report format.
A data fetching unit for fetching data from a database using the SQL creator and the created SQL, an arranging unit for creating a report according to the information on the entered report format, A first and second iterations in a report creator comprising a frame summarization processing unit for preparing a frame summary using information necessary for preparing a frame summary included in the report form and a database storing data. A report format including information on a frame and information on a repetition frame linker including an interval between the first and second repetition frames is input, and a report link data field included in the first repetition frame is input to a report format. Repeatedly outputting the next data while the corresponding data exists in the database; Correcting the start position of the second repetition frame, and data corresponding to a database connection data field included in the second repetition frame from the corrected start position of the second repetition frame exists in the database. And outputting the next data repeatedly.

[0013]

Preferred embodiments of the present invention will be described in detail with reference to the accompanying drawings. FIG. 4 is a diagram for explaining the repetitive frame linker. Reference numeral 400 indicates an upper repeat frame, reference numeral 410 indicates a lower repeat frame, and reference numeral 420 indicates a repeat frame linker.

The upper repetition frame 400 is a repetition frame to be repeated first, and the lower repetition frame 410 is a repetition frame which starts repetition after the upper repetition frame data repetition is completed. The repetition frame linker 420 connects the upper and lower repetition frames. The linker 420 contains information on the interval between the upper and lower repetition frames, so that the lower repetition frame starts repeating at the point where the repetition of the upper repetition frame ends. Therefore, the repetitive frame linker 420 serves as a buffer to prevent data collision between the upper and lower repeated frames.

FIG. 5 is a block diagram of a report creator according to the present invention. User interface 50 shown in FIG.
0, SQL creator 510, data extraction unit 520, and placement unit 530
The frame summarization processing unit 540 and the database 550 include a user interface 100, a SQL creator 110, and a data fetching unit 12 of a conventional report creator shown in FIG.
0, the arrangement unit 130, the frame summary processing unit 140, and the database 150, respectively.

In order to obtain the function of the connected repetition frame, the connected repetition frame information input processor 502 in the user interface 500 includes information on two or more repetition frames and information on the repetition frame linker in information on a report format. Is entered as Meanwhile, the placement unit
After finishing the data arrangement by the upper repetition frame in 530, the repetition frame linker includes the repetition frame linker if the information on the report format includes the repetition frame linker. Data arrangement by the lower repetition frame is performed with an interval between frames.

FIG. 6 is a flowchart illustrating a process of generating a connected repetition frame according to the present invention. First, when the user intends to use consecutive repetition frames, the user interface 500 inputs information on the repetition frame linker 420 together with information on each repetition frame from the user (step 600). Thereafter, if the next processing task generates a repetition frame according to the information on the report format, the data extracting unit 520 determines whether the data corresponding to the database connection data fields 210 and 220 included in the repetition frame is included. While the data is in the database 550, the next data is repeatedly extracted and transmitted to the placement unit 530. Then, the arranging unit 530 outputs the extracted data to a report (steps 610 to 620).

After processing the upper repetition frame, the arranging unit 530 determines whether the task to be processed next is information on the repetition frame linker 420 based on the information on the report format (step 630). ). If the next task to be processed is information relating to the repetitive frame linker 420, the arranging unit 530 includes the gap between the lower repetitive frames included in the repetitive frame linker and the lower repetitive frame. Of the lower repetition frame so that the start position of the frame is located at the end of the gap.
(640 steps). Next, the lower repetition frame is subjected to the 610
And 620 steps are performed (640 step).

On the other hand, if the information to be processed next is not the information on the repetitive frame linker 420, the process for the connected repetitive frame is terminated. As described above, the case of using two repetition frames including the upper and lower repetition frames has been described in the present embodiment, but more repetition frames may be connected by the repetition frame linker.

[0020]

As described above, according to the present invention, the problem that the start position of the conventional repetition frame is fixed is solved, and thus another repetition frame is fixed at a fixed position from the end position of the upper repetition frame. Starting frames can reduce extra space loss and produce more efficient reports.

[Brief description of the drawings]

FIG. 1 is a block diagram of a general report creator.

FIG. 2 is a diagram illustrating an example of a repetition frame.

FIG. 3 is a diagram exemplifying a report to be created using a connected repeating frame.

FIG. 4 illustrates a linked repetition frame including a repetition frame linker.

FIG. 5 is a block diagram of a report creator according to the present invention.

FIG. 6 is a flowchart illustrating a method of generating a connected repetition frame according to the present invention.

[Explanation of symbols]

 500 User Interface 502 Concatenated Repeated Frame Information Input Processor 510 SQL Creator 520 Data Extraction Unit 530 Arrangement Unit 532 Concatenated Repeated Frame Arrangement Processor 540 Frame Summarization Processor 550 Database

Claims (2)

[Claims] 1. A user interface to which a report format is input, an SQL creator for creating an SQL for data to be retrieved using the input report format, and a data from a database using the created SQL. A data fetching unit to be fetched, an arranging unit that creates a report according to the information on the input report format based on the fetched data, and information necessary for creating a frame summary included in the input report format. A report creator comprising a frame summarization processing unit for generating a frame summarization using the database and a database storing data, wherein the report format includes information on first and second repetition frames and the first and second repetition frames. And information on the repetitive frame linker including the interval between them. When a frame linker is included, after arranging the data by the first repetition frame, the data by the second lower repetition frame is arranged with an interval between the repetition frames. Report writer. 2. A user interface to which a report format is input, an SQL creator for creating an SQL for data to be retrieved using the input report format, and a data from a database using the created SQL. A data fetching unit to be fetched, an arranging unit that creates a report according to the information on the input report format based on the fetched data, and information necessary for creating a frame summary included in the input report format. A report creator comprising a frame summarization processor and a database storing data using the frame summarization unit, wherein information on first and second repetition frames and an interval between the first and second repetition frames are provided. Receiving a report format including information on a repetition frame linker including: and a report format included in the first repetition frame. Repeatedly outputting the next data while the data corresponding to the database connection data field exists in the database; correcting the start position of the second repeated frame by the interval; Repeatedly outputting the next data while data corresponding to the database connection data field included in the second repetition frame is present in the database from the start position of the two repetition frames. A method of generating a concatenated repetition frame.