SQL Server Reporting Services - Excel Unformatted Export
The custom Excel Unformatted Export excludes the "Report Header" and grouping level information. If you have a grouped report and you just want the data, this tool is for you.
Get Raw Data Without Header and Groupings - Just Select the
New Export Type
A detailed
description of the tool along with many examples can be found in the Tutorial Section.