Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jim_cool
Starting Member
43 Posts |
 Posted - 2006-11-21 : 01:10:06
|
| Hi allIf we want to restrict no of rows per page for table to 25 then we simply need to put =Int((RowNumber(Nothing)-1)/25)in group expression of a table.But can anyone tell me , how can i restrict no of rows per page for matrix?I created one row group in my matrix and there i specified same expression as above but when i try to run report it gives me the error "A scope for RowNumber function is not valid.When used in group expression the value for scope parameter of rownumber must be name of group directly containin g current group.".Plz help me. |
|
|
|
|
|
Restricting no of rows per page for matrix