reporting-services - 修复行而不添加框大小

Question

在此需要帮助有没有办法在不超过身体本身的情况下固定身体中盒子的大小？

这是身体：

当表 1 有更多记录时，它将增加框的高度，而表 1 和表 2 之间的范围相同。

我需要什么：当表 1 有更多记录时，它不会增加盒子的高度并消耗 tb1 和 tb2 之间的范围，直到它完全没有更多空间然后它会转到下一页。有没有办法做到这一点？

标签： reporting-servicesssrs-2012

Answer 1

Here's some quick help:

Add a Rectangle (Rec1) with the top at the top of Table1 (T1) and ends at Table 2 (T2).

Put T1 in it.

When T1 grows, it will consume space in rectangle and NOT push down T2 AS LONG AS you limit T1 records to fit in Rec1.

You'll need to add a ROW_NUMBER to the SQL data.

Figure out how many records can fit and filter the table for that many by ROW_NUM (ROW_NUM <= 20).

Copy T1 and make T3 with ROW_NUM > 20.