Thanks for the reply.

I could achieve that as you said:

Create a group outside the table with no headers and having page break at the end and the expression for grouping should be as given. 30 is the number for which you need a break. Similarly we can use 65000 but it is really failing bcoz of the grouping I suppose, not sure what might be the answer.

=ceiling(rownumber(nothing)/30)

when i use a less number like 30 40 100 200 it is ok, but when i use 65000 my RDLC file looks like it is hanged up and no report comes up. But when i remove that and execute the report for the same data it comes it easily on the rdlc files. And exporting to excel from this viewer is really failing i think it is becoz of the memory option.

But page break with 65000 is making the report come up very slowly compared to without pagination. Is there any way we can avoid this.

And export to excel fails in normal (without pagination) when rows exceed like 40 or 50k.

Please let me know if you have any answer.

Any help would be greatly appreciated.