报表模式化开发手册(UAP for NCv3)
目 录第一章 总体介绍.......................................................................................................................2
1. 开发概述.............................................................................................................2
1.1 技术型报表与业务型报表...........................................................................................2
1.2 一般报表开发存在的问题...........................................................................................2
1.3 模式化报表开发思路...................................................................................................2
2. 应用模型.............................................................................................................3
2.1 数据模型与展现模型...................................................................................................3
2.2 数据字典.......................................................................................................................4
2.3 业务系统集成...............................................................................................................5
第二章 低开发难度报表...........................................................................................................6
1. 概述.....................................................................................................................6
2. 查询类报表.........................................................................................................8
2.1 明细报表.......................................................................................................................8
2.2 汇总报表.....................................................................................................................17
2.3 列结构依赖于查询条件的报表（动态SQL）..........................................................23
3. 交叉类报表.......................................................................................................30
3.1 列向拼接查询型报表（复合查询）.........................................................................31
3.2 列向分支统计型报表（CASE-WHEN）...................................................................36
3.3 动态行列交叉型报表（旋转交叉）.........................................................................40
4. 投影类报表.......................................................................................................45
4.1 单元格依赖于行列条件的报表（投影交叉）.........................................................45
4.2 半录入半嵌入型报表（合并查询）.........................................................................51
5. 算法类报表.......................................................................................................55
5.1 数据加工预备知识.....................................................................................................55
5.2 非投影类占比报表（普通占比）.............................................................................60
5.3 投影类占比报表（投影占比）.................................................................................65
5.4 程序送数型报表.........................................................................................................69
6. 高级应用...........................................................................................................73
6.1 支持穿透的非投影交叉类报表（普通穿透）.........................................................73
6.2 支持穿透的投影交叉类报表（投影穿透）.............................................................79
6.3 支持主从连动的报表.................................................................................................84
6.4 支持统计图表的报表.................................................................................................88
第三章 高开发难度报表.........................................................................................................92
1. 基于行业报表工具开发的报表.......................................................................92
1.1 标准报表.....................................................................................................................92
1.2 分块填充报表...........................................................................................................104
2. 基于CELL REPORT工具开发的报表...........................................................111
2.1 CELL REPORT工具介绍.........................................................................................111
2.2 CELL REPORT报表.................................................................................................113
附录..............................................................................................................................................124
1．模式一览表......................................................................................................124
2．查询引擎FAQ之参数篇..................................................................................125 感谢分享66666666666666 AggGatheringBillVO 好东西，谢谢楼主分享。 谢谢版主，有帮助 正需要
好东西
好东西！支持！:)，有没有NC 其他模块的资料？ 先下了以后上nc在实习 我用讯雷下的could not parse（无法解析） 应该不错，可惜我现在积分还不够 应该不错，看看自己的积分再说:P
应该不错，看看自己的积分再说
应该不错，看看自己的积分再说:o :P 好东西啊，可惜分数不够 这样经典的东西太难得了 怎么都要钱的啊？努力赚钱！good good study daydayup！！ 好东西！支持！ 我要努力赚积分 我怎么下不了呀？？是不是条件不够呀 还是不够权限，呆会我也传个文件吧 好东西！支持！，有没有NC 其他模块的资料？本贴来自www.oyonyou.com,原贴地址：https://www.oyonyou.com/viewthread.php?tid=1927