ORACLE环境下通用报表系统的设计

DESIGN OF GENERAL REPORT SYSTEM UNDER THE ORACLE ENVIRONMENT

在ORALCE环境下用PRO~*C/C^++来开发通用报表系统,用临时视图、基础表、动态SQL语句等技术来提高报表系统的通用性和灵活性,以使报表系统能较好地适应应用环境的变化。通过对开发工具PRO~*C/C^++的分析,并综合运用这些技术,提出了通用报表系统的设计思想,为用户使用ORALCE数据库生成中文报表提供了一个便利途径。

PRO C/C+ + under ORACLE environment is used to develop general report system. The technique of temporary view, base table and dynamic SQL are used to enhance generality and flexibility, which can make report system preferably adapt the change of applied environment. By analyzing PRO C/C+ + and synthetically applying these techniques, design idea of general report system is putted forward, which provides a convenient approach to make Chinese report for users who use ORALCE.