I have an SSRS 2008 R2 report, where I have users that want to export the reports to excel. They are able to export the reports to excel, and they want to be able to sort the data in excel. However they are getting an error message that says there is a problem due to 'merged cells'. Thus can you tell me what you would do to solve the problem?
1 Answers
0
votes
The problem of merged cells is due to header cells being different sizes from the tablix cells. Excel tries to align everything like in the report by merging the cells together which causes complications when sorting. What you need to do is strip the headers out when you render in Excel format. There are some strategies to do this. See my answers about how to add a new Excel renderer or how to export to Excel with no headers.
