The Design And Realization Of Flexible Report Forms System

The modern enterprise information rapid inflation causes the unceasingly demand of user on report form and access mode. The Flexible report forms system attempts to provide a way which can independently design the report form for the user in the certain scope according to its own need of the form, the reports data fetching, the computation and the processing method. The system automatically produces the report form according to the user's definition.As report form style and data access mode is varied, it is a good solution that uses the multistage mapping method in the Flexible report form system which fetches the origination of the question. Therefore, the multistage mapping method took as backstage core on data fetches in the Flexible report form system. Through the Flexible report form system design, the concrete design, the database design as well as modules design, I have carried on the design to the entire Flexible report form system. Through the establishment of Flexible report form system, the user have achieved the free custom-made report form style, and can fetch data freely, carries on the operation to the data by the formula which defines and output the demonstration. There also achieved the good versatility. Using Delphi 7.0 as the development kit and SQL Server 2000 as the database management system, we will perfectly realize the function of all modules in Flexible report form system based on the above design thought and have realized each kind of function of the Flexible report form system initially.As the transplant question of the report platform, the effective method is to analyze the table structure and its relations with other table by the data dictionary way, and to face such data dictionary programming. After hung the report platform to the concrete database, data in the database can be presented by a direct-viewing method and the user can define it to reports. And according to the user's definition, producing integrity inquiry condition, the data can be took out and supplied for the next step of processing.It is the key problem how to analyze the database. With the thought of "Multistage mapping, by level translation", we successfully analyze tables and relations in the database, and clean the barriers for establishing the report processing platform cross databases.