SSRS Query Data in Header or Footer Not Exporting to Excel
One issue that I have noticed with SSRS is that headers and footers do not contain query data that is derived from a hidden text field.
The work around is to assign the data to a global parameter that is hidden. Then reference the global parameter in the footer or header. The data will now be available in Excel headers and footers.
If you are not seeing a header or footer this is because by default Excel hides the headers and footers. In Excel 2007, click the Insert menu then the Headers & Footers button. In Excel 2003, click the View menu, then Headers & Footers.
The work around is to assign the data to a global parameter that is hidden. Then reference the global parameter in the footer or header. The data will now be available in Excel headers and footers.
If you are not seeing a header or footer this is because by default Excel hides the headers and footers. In Excel 2007, click the Insert menu then the Headers & Footers button. In Excel 2003, click the View menu, then Headers & Footers.
Thanks for great info......
Reply to this
Thanks for taking time to help...
Reply to this
Thank you. I just tried it and it works fine for me.
Reply to this
I don't have an immediate solution, but a common problem in Excel is files bloating because one/some/all of the worksheets have saved all 64K rows instead of the ones being used. The fix in Excel is to select all the lower rows not being used, and delete them, then save the spreadsheet, close and reopen. Therefore, I'd pursue the angle of extra rows being saved in the export, and see if there is a way to keep this from happening.
Reply to this
I want to express my admiration of your writing skill and ability to make reader to read the while thing to the end. I would like to read more of your blogs and to share my thoughts with you. I will be your frequent visitor, that’s for sure.
Reply to this
For active rapidshare users one of the most convenient ways of finding films/music at rapidshare is to use rapidshare SE( http://www.rapidsharemix.com )
Reply to this
thanks for this nice post. this is so useful for me.
Reply to this
This is really an issue, today i wanted to submit the same bug description, only the case is with page footers. With export to word first page footer replicated on all exported pages. With other formats no problem, only the word.
Reply to this