SSRS page break on Tablix with Rownumber, only one row group and no default group expression

Question

I created a report with one table, and it has one RowGroup (which automatically arrived) when I dragged the fields of my report. [He does not have a specific expression group]

Now my requirement is to create page breaks based on line number.

I clicked on the properties of the RowGroup and gave the Group expression = Coverage (RowNumber (Nothing) -1/2000)

And the page break "Between each instance of the group"

Now the page breaks, but the problem is breaking it for every line in my scoreboard.

How can I overcome the same thing and break it down into only 2000 lines.

This is done to eliminate the exception of Excel export for big data.

What am I doing wrong with tablix / group settings.

Answer 1

I have not done this before, but try adding another group outside of your current group with this expression. Then set the page break in it.

Edit: I just read the question. I think you are unfaithful. I think it should be:

=Floor((RowNumber(Nothing)-1)/2000) 

I could not understand how you can set this as a group expression, and it will group the group correctly. So you still need two groups:

• An external group with this expression and page layout.
• A group of information in which you display the actual display on each line.