SSRS Query Data in Header or Footer Not Exporting to Excel

Posted by Adam Rink at 11/16/2007
Categories: SQL Server Reporting Services - SSRS
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. 

 

What did you think of this article?




Trackbacks
Trackback specific URL for this entry
  • No trackbacks exist for this entry.
Comments
Display comments as (Linear | Threaded)
Page: 1 of 2
  • 11/16/2009 Data Security wrote:
    Thanks for great info......
    Reply to this
    1. 7/31/2010 budget car insurance wrote:
      I am sure my visitors will find that very useful
      Reply to this
    2. 8/9/2010 SEO Guide wrote:
      I like this concept. I visited your blog for the first time and just been your fan. Keep posting as I am gonnacome to read it everyday..
      SEO Guide
      Reply to this
  • 12/2/2009 Data Security Tools wrote:
    Thanks for taking time to help...
    Reply to this
    1. 7/27/2010 Palmyra bathroom remodeling wrote:
      Good post thanks for giving the information on application.
      Reply to this
  • 12/8/2009 MSSQL Query Analyzer wrote:
    Thank you. I just tried it and it works fine for me.
    Reply to this
    1. 7/23/2010 Web Advertising Agency wrote:
      I liked the application.
      Reply to this
      1. 7/29/2010 cat repellant wrote:
        This was the tool i was looking for.
        Reply to this
  • 1/8/2010 mobile casino wrote:
    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
  • 1/24/2010 histoire des casinos wrote:
    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
  • 2/3/2010 Sophocles wrote:
    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
  • 2/19/2010 MSSQL Query Analyzer wrote:
    thanks for this nice post. this is so useful for me.
    Reply to this
  • 3/5/2010 web development wrote:
    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
  • 3/13/2010 casinos de France wrote:
    I need your help. I am not using the thematic theme and am using some other theme. I want to have a page which will list all categories along with their icons. How can I achieve that?
    Reply to this
  • 3/15/2010 PCSecurityShield.com wrote:
    Thanks for taking the time to help, I really apprciate it.
    Reply to this
  • 3/18/2010 sharma web services wrote:
    I like your website, It has been a pleasure to read the different articles in it, I'm subscribing to your rrs feed right now!
    sharma web solution

    sharma web solution
    Reply to this
    1. 7/11/2010 ortho home defense mice wrote:
      I like the comment you have written..... its good
      Reply to this
  • 4/2/2010 Bonus dei casino online wrote:
    I have one string which i want to print in html page as a report.This is containing the html tags as TD TR etc.,now the problem is there can be multiple pages and all the pages should have a perticular header and footer.I am not able to break the string during page break.
    Reply to this
    1. 7/18/2010 organic pesticides wrote:
      try to search the help column of that software you get the solution...
      Reply to this
  • 4/4/2010 porn tube wrote:
    your article is so informative and interesting. nice shared.
    Reply to this
  • 4/14/2010 Search enginge optimization wrote:
    I am using Reporting Services 2005 and SQL Server 2000. I placed a reportviewer control on my ASP2.0 webpage to display a report and The problem happens after upgrading from Visual Studio 2003 to Visual Studio 2008. Those reports which were exported to Excel document found out to have missing footer but the same issue did not happen to other reports type........
    Reply to this
  • 4/21/2010 adelaide graphic design wrote:
    How can I become a web design teacher in a community college?
    Reply to this
    1. 7/29/2010 SEO Guide wrote:
      I like this concept. I visited your blog for the first time and just been your fan. Keep posting as I am gonna come to read it everyday..
      Reply to this
  • 4/21/2010 web design melbourne wrote:
    What are the differences between web design and graphic design and which career should I choose?
    Reply to this
  • 4/22/2010 top picks 2010 wrote:
    Awesome post! Interesting info to know.
    http://www.undiscoveredequities.com/top_10_2010.html
    Reply to this
  • 4/22/2010 corporate gift idea wrote:
    Brilliant post mate, keep up the good work J
    http://www.standout.com.au
    Reply to this
  • 4/22/2010 promotional items wrote:
    You really know your stuff... Keep up the good work!
    http://www.standout.com.au
    Reply to this
  • 4/25/2010 medical ppo wrote:
    Can I have many reports in one excel sheet just by running one query in SSRS?

    IS it possible?

    Or do I ahve to run everytime individual query?

    Or any new method that anybody has to optimize?
    Reply to this
  • 4/26/2010 pc recovery wrote:
    what software is the easiest to use to transfer digital tape to a computer?
    Reply to this
  • 4/26/2010 Amish Furniture wrote:
    Thanks for the little info.... and I hope it will help some one...
    Reply to this
  • 4/29/2010 Texas holdem spielen wrote:
    I am also running version 1.9.5 and would like to upgrade. Are there any database scripts that need to be run to upgrade to 2.1.2? I can't locate any info on upgrading so wanted do some research before I start.
    Reply to this
  • 5/10/2010 MejiaNICOLE30 wrote:
    That is cool that we are able to get the www.lowest-rate-loans.com and this opens up new chances.
    Reply to this
  • 5/11/2010 Classified India wrote:
    This procedure allows you to export data from a worksheet range to a text file. You may specify the character (e.g, a space, tab, pipe, comma, etc) that separates the exported elements.
    Reply to this
  • 5/14/2010 Online Scheduling Application wrote:
    Thanks for the information man...I will really try this out in my PC....
    Reply to this
  • 5/14/2010 Mobile wrote:
    Thanks for your support and informative post.
    Reply to this
  • 5/16/2010 bird feeders wrote:
    Reporting Services provides a variety of query design tools you can use to create queries dataset in Report Designer.
    Reply to this
  • 5/16/2010 organic fertilizer wrote:
    I thought it was going to be some boring old post, but it really compensated for my time. I will post a link to this page on my blog. I am sure my visitors will find that very useful
    Reply to this
  • 5/18/2010 Unique Home Decor wrote:
    It’s often necessary to convert data stored in an Access database to another form and such as an Excel workbook. You may wish to take advantage of some of Excel’s unique analytical capabilities or simply share data with someone unfamiliar with Access....................
    http://www.nicehomedecore.com
    Reply to this

Page: 1 of 2
Leave a comment

 Enter the above security code (required)

 Name

 Email (will not be published)

Your comment is 0 characters limited to 3000 characters.