Groups | Blog | Home
all groups > sql server reporting services > july 2004 >

sql server reporting services : Row Num in matrix



Chris Hays [MSFT]
7/30/2004 12:04:55 PM
Assuming you have one row of data in your query per product, you can put the
matrix in a list which groups on =Ceiling(RowNumber(Nothing)/4) and put
PageBreakAtEnd on either the list's grouping or on the matrix.

--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
[quoted text, click to view]

battula
7/30/2004 4:47:46 PM
I am using Matrix in my report.

I have One Row Group (ProductID) and 7 Static rows.
Expression for my ProductID Group is =Fields!ProductID.Value

How can I set the Page break so I can accomodate 4 Row Groups (i.e) 28 lines
on one page and then goto next page.

Any Suggestions.

AddThis Social Bookmark Button