报表模式化开发手册(UAP for NCv3)

stonys

目 录
第一章 总体介绍.......................................................................................................................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

时间点123

感谢分享66666666666666

nankeyimeng

AggGatheringBillVO

1109432622

好东西，谢谢楼主分享。

pping45

谢谢版主，有帮助

cool_internet

正需要

zhuhaicwm

好东西！支持！，有没有NC 其他模块的资料？

yangcirrr84

先下了
以后上nc在实习

yangcirrr84

我用讯雷下的could not parse（无法解析）

唐博狐

应该不错，可惜我现在积分还不够

Alan

应该不错，看看自己的积分再说

mengxuyang

应该不错，看看自己的积分再说

dearfws

好东西啊，可惜分数不够

浩泽水润

这样经典的东西太难得了

icemannbb

怎么都要钱的啊？努力赚钱！good good study daydayup！！

lzliuhong

好东西！支持！

guangdian

我要努力赚积分

outman

我怎么下不了呀？？是不是条件不够呀

winner

还是不够权限，呆会我也传个文件吧

sunmoonstar

好东西！支持！，有没有NC 其他模块的资料？
本贴来自www.oyonyou.com,原贴地址：https://www.oyonyou.com/viewthread.php?tid=1927