SSRS: Export To Excel?

Question

Whenever i export my SSRS report to excel, the record gets extracted to multiple columns instead of one column which makes harder to do much stuff in excel? I know it has to do with alignment but can anyone tell me specific what i can do to fix this?

Answer 1

You would have to be more detailed in your question to provide a specific answer to your problem. However, in my experience, in order to achieve a useful Excel export from an SSRS report it is best to keep the layout of the report as simple as possible. Keep distinct fields in their own columns and keep merged fields and groupings to a minimum. That way your field data should be given a column of its own in Excel and allow for further manipulation with relative ease.