1. Shared Dataset 功能在 SQL Server 2008 R2 / 2012 / 2014 的下列三个版本中不支持,详情请参考此处;
- Express Edition with Advanced Services
- Workgroup Edition
- Web Edition
2. Report type有两种:Tabular和Matrix; 选择Tabular后,可以选择两种Table Layout: Stepped和Block;选择Stepped时,可以勾选drilldown,即加号折叠展开的功能;
Report Type | Table Layout | |
Tabular | Stepped | Drilldown |
Block | ||
Matrix |
Stepped与Block的重要区别在于add parent group时,是否需要group header,如果需要group header就是stepped,如果不需要,就是
block;
3.