The width of a list that contains an embedded matrix grows unexpectedly
- by Greg Lorenz
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 boarder 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 experianceing 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 effectivly stop the matrix form growing past the space allowed by the list control?