SQLTeam.com | Weblogs | Forums

Ssrs 2008 export to excel


In a ssrs 2008 report, the users have been exported the report in a PDF format. Now the users want to export the report to an excel file that has the extension of .xls. The want to do that since they want to be able to filter columns using excel. The problem is some of the report columns show up in 2 or 3 columns in excel.

To solve this problem, I have removed the following items from the report header:

  1. Report name and
  2. report runtime, and
  3. report page numbers.

I have placed the items that were in the report header into the report footer. These items appear on the report when the report is executed but do not appear on in excel from the export.

I am asking about keeping the items in the report header since my company has a standard to include these in the header.

Thus can you tell me the following:

  1. What else I can do to solve my problem and/or
  2. Is there a way for the export to excel to work and still keep the report name, run time, and/or page numbers in the report header?

I would appreciate it if you would tell me how to accomplish my goal and/or let me know if what I am requesting is not possible.