How to Split SSRS output in Excel if it exceeds the limit ?

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
=Ceiling((RowNumber(Nothing))/60000)
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.

Regards
Author.

How to Split SSRS output in Excel if it exceeds the limit ? was last modified: October 1st, 2017 by Justin Antony

SSRS cell merge error in Excel output

SSRS Excel cell merge error
When exporting report to Excel and while resorting the data if we encounter the merged cell error then we need to remove image control if present in our report will solve the issue.

 

 

SSRS cell merge error in Excel output was last modified: October 1st, 2017 by Justin Antony