Tip - SQL报表 - 按每N行记录将报表分页
来源:互联网 发布:杀手6pc版优化一团糟 编辑:程序博客网 时间:2024/05/22 13:53
报表可以通过设置其Layout的大小来控制分页,但是如何更精确的按照每N行记录对报表分页?
see - http://msdn2.microsoft.com/en-us/library/ms157328.aspx
Page Breaks
In some reports, you may want to place a page break at the end of a specified number of rows instead of, or in addition to, on groups or report items. To do this, create a group in a data region (typically a group immediately outside the detail), add a page break to the group, and then add a group expression to group by a specified number of rows.
* The following expression, when placed in the group expression, assigns a number to each set of 25 rows. When a page break is defined for the group, this expression results in a page break every 25 rows.
=Int((RowNumber(Nothing)-1)/25)
see - http://msdn2.microsoft.com/en-us/library/ms157328.aspx
Page Breaks
In some reports, you may want to place a page break at the end of a specified number of rows instead of, or in addition to, on groups or report items. To do this, create a group in a data region (typically a group immediately outside the detail), add a page break to the group, and then add a group expression to group by a specified number of rows.
* The following expression, when placed in the group expression, assigns a number to each set of 25 rows. When a page break is defined for the group, this expression results in a page break every 25 rows.
=Int((RowNumber(Nothing)-1)/25)
- Tip - SQL报表 - 按每N行记录将报表分页
- Tip - SQL报表 - 按每N行记录将报表分页
- Tip - SQL报表 - 按每N行记录将报表分页
- Tip - SQL报表 - 按每N行记录将报表分页
- 水晶报表分组分页且每页最多显示N条记录
- RDLC报表:每页显示N条记录
- RDLC报表:每页显示N条记录
- Tip - SQL报表打印的空白页问题
- Tip - SQL报表打印的空白页问题
- Tip - SQL报表打印的空白页问题
- Tip - SQL报表打印的空白页问题
- Tip - SharePoint + RDLC (SQL客户端报表)
- Tip - 报表服务: 发送报表订阅的sql命令
- SQL报表 - 按Table的行数分页
- 分页报表
- Hot Tip - SQL 报表服务(Reporting Services) RDL
- Hot Tip - SQL 报表服务(Reporting Services) RDL
- Hot Tip - SQL 报表服务(Reporting Services) RDL
- 中国的IT企业和客户,哪个更贱?
- 有关《大道至简》的几点讨论~
- 测试-答对5道题的人是天才,答对4道的是帅才,答对3道的是将才,答对2道的是奇才,答对1道的是人才
- Web Service调用Nhibernate数据访问异常:xx cannot be serialized because it does not have a parameterless constructor
- UBB解析优化的心得:Regex构造函数的性能
- Tip - SQL报表 - 按每N行记录将报表分页
- 《软件测试管理》第14章软件测试常见问题——(四)测试技术常见问题
- 命名空间大小写导致的not CLS-compliant
- CSS:CSS Hack 汇总快查
- Tips - Web UI 资源索引
- 《Web全面性能测试实战》第2章Web全面性能测试模型
- Orcas Team Suite 2007年6月份CTP的下载链接
- DNN - skin quick reference
- 有源则至清——我读《移山之道》