Split SSRS Excel Output
SSRS Excel Export for more than 65536 rows in the output is as follows
Detail Section Righ Click – > Add Parent Group
-> Group by window write the formula as below
Add Page break in the group properties
-> select page break between each group option
Once you export excel, you will find different worksheets created for data having rows more than 60000.