SSRS Report footer export to excel problem
Hi All,I am using SQL Server 2008 BI studio for Reporting services. When i export the report to the excel, the footer image or textbox didnt get diaplayed in the excel while header image is properly diplayed.Does anybody knows solution on it.Please help on this.Thanks in advanced.-Kalpesh
June 30th, 2009 6:06am

Hi Kalpesh, We can know you want to display the footer of the report in exported Excel file from your post. Excel does not have a concept of a "page", so when we look at the spreadsheet, we will not see a footer. We should be able to see the footer when looking at "page preview" or when looking at the "header/footer" of the spreadsheet. The "header/footer" is accessed in different ways depending on the version of Excel. We can find the "header/footer with "Help". For more information, please see: Use headers and footers in worksheet printouts in Excel2007: http://office.microsoft.com/en-us/help/HP100215501033.aspx If you have any more questions, please feel free to ask. Thanks, Jin Chen
Free Windows Admin Tool Kit Click here and download it now
July 7th, 2009 4:20am

Hi, Thanks for above post. It is helpful.Thanks Shiven:)
July 12th, 2011 1:10am

Hi Kalpesh, Were you able to export footer image to the excel. I am having a problem making the image appear in the footer when I export to excel (in the page preview). Can you please let me know how I can do this. It is part of my embedded images in the report. I appreciate your help! Thanks
Free Windows Admin Tool Kit Click here and download it now
May 28th, 2012 11:14pm

Hi Basani, I think What ever content you will keep under Report Footer will not appear in Excel.Thanks Shiven:) If Answer is Helpful, Please Vote
May 29th, 2012 8:45pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics