CAJ | 학술논문

为减少数据冗余，根据规范化理论设计的数据库不能直接输出分类汇总的结果，需要进行转换生成交叉表，并利用水晶报表的 Push 模式实现对交叉表的显示。在。 NET 和 SQL Server 环境下，探讨了动态交叉表的生成和利用水晶报表动态绑定数据源显示数据的方法，并给出了较为详细的实现过程。
위감소수거용여，근거규범화이론설계적수거고불능직접수출분류회총적결과，수요진행전환생성교차표，병이용수정보표적 Push 모식실현대교차표적현시。재。 NET 화 SQL Server 배경하，탐토료동태교차표적생성화이용수정보표동태방정수거원현시수거적방법，병급출료교위상세적실현과정。
To reduce data redundancy, it is impossible to output a subtotaled report based on a database design which follows the strict design paradigm. To do it, transforming data to cross-table and rendering them via push model in crystal reports is needed. Based on .NET and SQL server environment, this paper explores and studies the technique about generating dynamic cross-table and the method about dynamic binding the data source to display data, as well as gives a more detailed implementation process.