SSRS Page Break while exporting in Excel..
we can use below expression in Group Expression of SSRS Tablix.
group expression =Ceiling((RowNumber(Nothing)) / Nth row)
replace Nth with any number like 65000 ..
Suppose you want to print fix number of rows per page in excel file then we can use above expression.
For ex- 2000 rows per page..
Use like this - Ceiling((RowNumber(Nothing)) / 2000).
Add page break in Group.
Every page will contain only 2000 per excel sheet ..
Enjoy . . :)
No comments:
Post a Comment