I would set the page size to your label size, and then group on the N values and tell the group to page break between each group.

Not sure how you can get from one row to multiple labels other than passing a the count to the query. You could also potentially use the row...

What about filtering the dataset or the tablix using the Top N values.

As part of the query that populates the parameter, I actually exclude the "ALL" from being returned.. You can do that in the query or in a filter.

Yes it can... Please take a look at this MSSQL Tip from a few weeks back>

http://www.mssqltips.com/sqlservertip/2866/sql-server-reporting-services-using-multivalue-parameters/%5B/url%5D

I do not have Office 2007 any more, but I believe it is the same as 2010... You make the change in the connection properites. You will want to...

Take a look at the filter data type.

You will need to save it someplace to be referenced.

I am at a loss... maybe a few screen prints of the properties for the page sizes and the actual layout may be helpful.

I know I often have had to put a tablix / matrix inside a rectangle object to contain it within a certain area even if the cangrow property is set...

Are you adding the text box to the matrix or outside the matrix? Have you turned off the CanGrow properties of the columns? Last, what happens if...

Does it spill over if you export to pdf?

click on the report design area and then go to properites. Check the interactive page sizes.

yes... the pc will just need to have the browser open to the specficied report.

You can set the autorefresh report level property. Take a look at:

http://www.wiseowl.co.uk/blog/s213/auto-refresh.htm