I dont see any option to have page breaks on column groups, is this even possible?

http://blogs.msdn.com/chrishays/archive/2004/07/23/HorizontalTables.aspxCheck this outPraxy

Hi,Based on your post, you might build a matrix report and want to set its page breakon column groups. If so, you can follow these steps;1. Add a list control and put the matrix into it.2. Set the list grouping-on expression based onwhich you wantthe matrixpagebreak and check the checkbox ofthe page break option inthis list grouping dialogue window.This is to use the list to split the matrix into multiple parts based on the List grouping-on expression as you want, and then set the page break between them.Hope this help,thanks,Jerry

Hello - I am trying to follow Jerry Nee's instructions, using Report Builder 2. I added a list box (is that a list control?) and put the matrix in it. I associated the ListBox with my dataset and added the necessary ColumnGroups, and specified where I want the pageBreak. When I run the report, I get the following error: The Hidden expression for the tablix ‘DataMatrix’ has a scope parameter that is not valid for an aggregate function. The scope parameter must be set to a string constant that is equal to either the name of a containing group, the name of a containing data region, or the name of a dataset. (rsInvalidAggregateScope) Would that be related to a Hidden Expression I have for rows in my Matrix??? Marion in Rochester

(Couldn't edit prior post) ok - So I understand that the report is unhappy because my matrix was hiding rows, based on groups - but, I had to remove the groups to make the rows static.... Is there a workaround? how do I hide rows based on row counts in groupings, if I can't group?Marion in Rochester