I'm exporting a SSRS report to Excel. For some input parameters the number of rows generated by the SSRS is around 100,000(more than 65000 rows) and it throws an error while exporting.
One option what I tried is, to export as CSV and open the CSV and save it as Excel work book(I have office 2010 in my machine). It works, but the problem is, all the column header are displayed as text box names. For ex,(I'm looking for name Emp Name, but it is giving me Emp_Name).
Is there any solution or work around for this? Please suggest.