I have a problem with my ssrs reports not being very excel friendly. When the report exports to excel sometimes one report column will generate two excel columns. the heading description takes up two columns but description 2 takes up only one column. How can i force the export to stick to the strict layout of the viewed report. I know i copy the body of the report, place the entire thing in to Text Pad, and then copy it back in to excel and this will fix the problem. My users need a simpler solution, so when they export the report they can do calculations w/o having to jack with the report layout. Thanks in advance

Hi, Have you refered below link:- http://blogs.msdn.com/b/chrisbal/archive/2006/07/08/659545.aspx Also adjusting your column width/un-even text box size will fix your problem, this is know problem in SSRS when export to excel is done, I have experienced this before and resolve it with a cranky headache. :( Please let us know your feedback. Thanks KumarKG, MCTS

It looks like it has to do with the header image and other elements in the header, the export still skips cells on either side, but it looks like this takes care of the merged cells that the header image spans. http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/eceea29c-5ee0-4035-9f19-d13a4e55dcf6/

I have also noticed if you export to CSV it will take out the heading, just make sure to associate your CSV files with excel.