Page break in matrix

Question

Post reply

Page break in matrix

Ellen Heijmans

SSC Eights!

Points: 840
More actions
July 23, 2016 at 4:14 am

#309426

I've have a matrix that must, if it has more than 3 columns, add a pagebreak after every 3 columns. I've searched the Internet, and some of the things look promissing, but I can't make it work.
One of the things I did, was adding a parent group on the expression Field!NumberOfRow.Value Mod 3 and checked the box for a pagebreak on this group. Nothing.
I saw a post somewhere that included the listbox with this matrix added, but it wasn't clear how to do it.
Can anyone help me?
Forum Etiquette: How to post Reporting Services problems

[/url]

Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]

How to Post Performance Problems - by Gail Shaw
[/url]

mister.magoo SSC-Forever Points: 47174 More actions · Answer 1

Two options come to mind.

Make your column width such that no more than three columns fit per page, this will cause automatic page breaks.

The method you tried but with this expression for the column group:

=Ceiling(RowNumber("Tablix1") / 3)

You can set a page break after each group and even set the visibility of the textbox in the group header to "hide" so that you don't get an extra row on the report.

Don't forget to change the report viewer to "Print Layout" when testing or you won't see the page break happening.

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

Ellen Heijmans SSC Eights! Points: 840 More actions · Answer 2

The first isn't working. I use this report for export to Word and I get 4 columns on the page.

I've tried your second option. I added your code as an group expression. But now I only get two columns on 1page, instead of two columns on 2 pages.

I've added a parent group and added your code, made sure that both groups are sorting on the same column, same result.