Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 Exporting to Excel so headers repeat on each page

Author  Topic 

theboyholty
Posting Yak Master

226 Posts

Posted - 2010-10-20 : 05:24:43
I have a problem in that I wish to have reports export to Excel but to send headers to Excel headers, rather than have them occupy the top few rows of the spreadsheet. This way they'll repeat on each page when previewed and printed and also makes the actual data workable.

Would look a whole lot more professional too.

I found this link:
[url]http://www.bigresource.com/Tracker/Track-ms_sql-09r5rK2y/[/url]
Which seems to suggest that I can amend my DeviceInfo setting for SimplePageHeaders and that this is supposed to reside in the rsreportserver.config file but i've looked in here and (on my installation at least) these attributes don'e exist.

This question seems to be asked a lot but rarely answered in a meaningful way so i'd appreciate some input from someone who's got some experience of this.

Thanks.

---------------------------------------------------------------------------------
http://www.mannyroadend.co.uk The official unofficial website of Bury Football Club
   

- Advertisement -