Please review the post below which talks about same issue

http://gauravsqlserver.blogspot.com/2011/03/repeat-tablix-row-header-on-each-page.html

Please have a look on the article I posted on this.

This gives you the details on how to control the number of rows per page

http://gauravsqlserver.blogspot.com/2011/03/how-to-fix-number-of-rows-per-page-in.html

I postd an artcile in my blog on controling the number of rows per page in SSRS

http://gauravsqlserver.blogspot.com/2011/03/how-to-fix-number-of-rows-per-page-in.html

Thanks,

Gaurav

Thanks All...this makes sense now.

Gaurav Mittal

Hello Mr. Gonzalez,

I am confused on how the properties Directory, FileSpec, Resource are assigned to variables...

based on my understanding the foreach loop container(Locate Files) has ADO enumerator and in this...

nice article...but one question..if we have to do the same thing at run time (means when user export the rport to pdf or excel) from the report viewer..is there any...