I am using Reporting Services 2005 and SQL Server 2000. I placed a reportviewer control on my ASP2.0 webpage to display a report.
When I tried to export my report to an Excel file, I get a lot of extra columns. I cannot sort the result in an Excel file because of the header displayed on the report. I tried to move header in the special table located in the body section of the report. That got rid of the extra columns; however, I cannot sort selected columns because it includes a cell from this table-header. A client DOES NOT WANT to select some section of the report and perform sorting, so sorting is performed for all data rows in the report by selecting one or more columns. The same client also DOES NOT WANT to place header information in the footer section.
1.) Is it possible to exclude the header of the report when exporting it to Excel. For some reason, when I export my report to Excel file I cannot see the footer section of the report. Can I hide the header section of the report when it is displayed in an Excel file?
2.) If I cannot implement the option #1, how to implement this option:
If the report is complex, you might want to consider a separate version designed for Excel. You could place your own 'psuedo' button on the proper report, the button will run the Excel version and automatically render it to Excel via URL access.