Design And Implementation Of General Reporting System Based On Electronic Records

Currently, there are various reporting tools with many different functions from each other, and the style and pattern can be defined in most of them. Those tools are based on the database structure with static storing, which can't support the extensions or changes of the companys' operation well. Some companys use database structure with dynamic storing to keep the database structure when their operation changed, which can protect the software investment.We have designed the electronic records with custom-defined pages, which use the dynamic storing structure of database. The changes of data item will affect the data in dynamic database only by mapping the data in electronic records to the corresponding data in dynamic database. The electronic records allow the changes of companys' operation, which protect the software investment by keeping the database structure when data item changed.Those reporting tools in the market can't work in the database structure with dynamic storing. it has defined the method that based on conditional choosing of electronic records, and expounded the description language which supports many reporting pattern by analyzing reporting data, pattern and output, then constructed an integrate reporting tool model finally.We have realized an electronic records-based general reporting based on the reporting model above through using Datawindow.NET and Visual Studio 2005 .NET tools, which realize the functions of choosing, filtering, previewing and printing of electronic records. The system has worked in a project of 863 oriented target:"digital medical treatment decision-making system based on grid".