实现Developer/2000环境下动态生成报表功能

Implementation of Dynamic Report-Creation Based on Developer/2000

通常数据库应用系统中的输出报表必须在系统开发阶段定制 ,不能满足用户不断变化的管理需求 .介绍了用Oracle开发工具Developer/2 0 0 0结合DDE(DynamicDataExchange)技术实现任选查询和动态生成报表的方法 ,这种方法允许用户根据自己的要求选择输出报表的内容和格式 ,并利用Excel进行编辑 ,极大地增强了系统的报表生成能力和灵活性 ,具有很好的实用性 .

Output reports of database application system are usually designed in the developing process, which limits the change of uses management requirements. This paper presents an implementation method of optional query and creating reports while the system runs based on Oracle development tool Developer/2000 and Dynamic Data Exchange techniques. Using the method, users can select the fields and records in the output report according to their own requirements. It effectly enhances systems capability and flexibility of report generation.