包含嵌入矩阵的列表的宽度意外增长
我在 Reporting Services 2005 中有一份报告，其中包含一个带有嵌入矩阵的列表，并尝试在列表上添加边框，但是，当我在 Visual Studio 中运行该报告时，矩阵会增长到超出页面末尾，因此边框随着它的增长而增长，导致它增长到第二页。看来 Reporting Services 2000 Service Pack 1 中应该有一个修复程序，但我在 2005 年仍然遇到这个问题。
该列表有一个详细信息组，使用以下表达式将一行上的记录限制为 4 条： =ceiling(rownumber("list1")/4)，矩阵有一个列组，该列组应使用以下表达式根据列表确定的行号回收那些列组：=rowNumber("list1_Details_Group")
我还尝试将列表放在一个矩形中，希望阻止矩阵增长，但无济于事。
如何有效地阻止矩阵形式增长超过列表控件允许的空间？
I have a report in reporting services 2005 that includes a list with an embedded matrix and am attempting to put a border on the list, however, when I run the report in visual studio the matrix is growing past the end of the page and therefore the border is growing with it causing it to grow into the second page. It appears that there was supposedly a fix for this in reporting services 2000 service pack 1 but I am still experiencing the issue in 2005.
The list has a details group that limits the records on a row to 4 using the following expression: =ceiling(rownumber("list1")/4), the matrix has a column group that should recycle those based on the rownumber determined by the list using the following expression: =rowNumber("list1_Details_Group")
I have also attempted to put the list in a rectangle in hopes to stop the matrix from growing to no avail.
How do I effectively stop the matrix form growing past the space allowed by the list control?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我找到了一个解决方案......列表最初是报告的宽度，这导致其上的边框在内部矩阵的末尾和列表的末尾之间增加了一定的空间量。如果我将列表设为嵌入矩阵的大小，那么它将是矩阵增长以容纳必要值后的大小。
就边框而言，如果您希望列表的边框与报表的宽度对齐，则需要完成一些操作。每行增长的矩阵列的大小必须准确，如果每行有 4 列，则矩阵列的宽度为报告的宽度 / 4。此外，每个行必须始终有 4 列数据矩阵中的行。这可以在查询中通过使用 % (Mod) 运算符并根据需要添加其他记录来完成。
I found a solution to this.... the list was initially the width of the report which cause the boarder on it to grow that amount of space between the end of the matrix inside and the end of the list. If I make the list the size of the matix that is embedded it will be the size of the matrix after it grows to accomodate the neccessay values.
In terms of the border, if you want the boarder of the list to line up with the width of the report a few things need to be done. The size of the matrix columns that grow for each row must be exact where if there are 4 columns for each row the width of the matrix column is the width of the report / 4. In addition you must always have 4 columns of data for each row in the matrix. This can be accomplshed in the query by using the % (Mod) operator and adding additional records as needed.