在 SQL Server Reporting Services 中的 Tablix 上显示固定数量的行 [英] Display fixed number of rows on a tablix in SQL Server Reporting Services

问题描述

我在 SQL Server Report Builder 中制作了一份报告，我想显示每个表的固定行数，而不是每页.我发现这个表达式 =CEILING(RowNumber(Nothing)/25) 并在行组上探测它，位不起作用.

I have a report made in SQL Server Report Builder and I would like to show a fixed number of row per table, not per page. I found out this expression =CEILING(RowNumber(Nothing)/25) and probe it on the row group, bit did not work.

在上图中，我想固定 <> 将填充数据库数据的行数.

In the image above, I want to fixed the number of rows where the <> is going to be populated with database data.

如何做到这一点?

推荐答案

在 Group 属性中将其添加为 Group on 表达式:=CInt(Ceiling(RowNumber(nothing)/25)).让我知道这是否适合您:)

In the Group properties add this as a Group on expression: =CInt(Ceiling(RowNumber(nothing)/25)). Let me know if this works for you :)

这篇关于在 SQL Server Reporting Services 中的 Tablix 上显示固定数量的行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！