<div>
<div class="content wysiwyg-content">
Using .net to interface to SSRS 2005, when the user views a report and selects the export to excel function, the report actually exports fine. &nbsp;however, all of the formatting is showing up in the excel file such as merging rows, hiding rows with no data and in some instances merging columns. &nbsp;Is there a way to modify the export functionality so that the data would be in &quot;raw&quot; format in excel? &nbsp;Exporting to csv would be an option, however the column headings dont export as part of this functionality. &nbsp;Thanks for any help.<br />

</div>
</div>


Using .net to interface to SSRS 2005, when the user views a report and selects the export to excel function, the report actually exports fine.  however, all of the formatting is showing up in the excel file such as merging rows, hiding rows with no data and in some instances merging columns.  Is there a way to modify the export functionality so that the data would be in "raw" format in excel?  Exporting to csv would be an option, however the column headings dont export as part of this functionality.  Thanks for any help.


SSRS- Export to Excel Formatting

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.