lskidgel (7/29/2015)
I need to display a specific row number for each page; #1-17 on page 1, 18-30 on page 2 etc.My matrix column grouping include 4 sections; 'week 1', 'week 2', 'week 3'...
Each section has the same questions, so I only want the questions to display once on the row grouping and their answers in each corresponding column. That display is working properly.
My problem is, when I try to use an expression such as this; IIF(RowNumber(Nothing)<= 17, false, true)
or this; IIF(RowNumber(Nothing)>= 17 And (RowNumber(Nothing)<= 40), false, true)
as a hidden expression on the Question Row Group, to display only the designated # row, the table is blank.
I checked how the matrix is counting the rows: RowNumber(Nothing), so I see the problem, I just don't know how to fix.
Can anyone tell me how I can count the actual # of rows displayed rather than the row # from dataset?
Hi
You need to play with the page break property of the group "WeeklyNrRow"
the Grouping Expression for "WeeklyNrRow" must be :
=Int(RowNumber(Nothing)/17)
If this does not work:
It appears RowNumber does not fit in the matrix on the contrary of the table data region
Then I think you will have to attach a rownumber in sql for each grouping set using the ranking function
:w00t: !!!GOOGLE IS YOUR BEST FRIEND!!! :w00t: