Unable to sort SSRS report in Excel

Question

I need to figure out a way to fix an issue our customers having while exporting SSRS report to Excel. The report successfully gets exported to Excel, but is not sortable. Any suggestions would be appreciated.

Here is a screenshot of what the report structure looks like in Excel (I have deleted all the data from report to upload it here). In SSRS, I am not combining two columns or anything. All that is done in stored proc.

Let me know if I need to include additional information!

Screenshot:

Answer 1

This is a common problem with SSRS. Your header cells overlap your table columns, likely in an uneven manner, causing entire columns of your table to be merged cells between two columns.

A good solution is to add rows to the top of your table, and insert your header pieces in the table itself, so all alignment will be perfect and your table cells won't result in merging.