I have a tablix in my report designed with Report Builder 2.0. I am trying to get the HEADERS REPEAT on new page. I am trying to achieve this through grouping expressions.
I right clicked on the group belonging to the tablix (details_3 is what Report builder named it) and chose Group Properties, and on Grouping expressions, I had this expression: =RowNumber(Nothing) / 10. I also clicked on Page break section and checked "Between instance of each group".
Now, when I run the report, this particular tablix has headers repeating on new page but only one row per page shows up. WHat I am trying to achieve is have 10 rows per page.
Am I missing something? Any help would be greatly appreciated!