November 1, 2007 at 7:25 am
We have reports that are distributed in an excel format, and some managers are quite picky about the format.
Tabular reports of course have headers which scroll down the page / repeat on new pages when shown through the report server.
When these tabular reports are exported to Excel, is there any way of getting the headers to show on each page? Currently the report is exported but does not repeat the header on each new page.
Any help would be great.
Thx
November 1, 2007 at 8:19 am
Change the spreadsheet template to have a "freeze panes" in the correct spot.
--Jeff Moden
November 1, 2007 at 8:24 am
I didn't know that the export functionality used an excel template. Where can I find this template then?
November 1, 2007 at 5:22 pm
It doesn't... from the way you were talking, I thought you were using a "blank formatted" spreadsheet file as a template that you copied for new files.
What are you currently using to copy data to the spreadsheet.
--Jeff Moden
November 2, 2007 at 1:43 am
Currently the reports are distributed via subscriptions, with the "render format" set as Excel. There is no manual export of the report as this is controlled by the report manager itself.
November 2, 2007 at 8:55 am
Ah crud... my bad... I gotta learn to read which forum these are in... I know squat about reporting services... my appologies.
--Jeff Moden
November 3, 2007 at 4:02 am
LOL - toooooo many late nights reading forums... 😉
Still, I read in BOL that you have little control over the page format when rendering to Excel. Bummer.
November 3, 2007 at 3:53 pm
If you're up for using 3rd-party products, OfficeWriter from http://www.softartisans.com provides much more control over Excel output. Strictly spreaking, it uses Excel as the development environment for reports so that you have all Excel capabilities available. In fact, Microsoft has licensed the technology for a future (2008?) release in SSRS, but if you need the ability now....
Another link with more detail: http://officewriter.softartisans.com/officewriter-250.aspx
November 4, 2007 at 7:55 am
Jason Coleman (11/3/2007)
LOL - toooooo many late nights reading forums... 😉Still, I read in BOL that you have little control over the page format when rendering to Excel. Bummer.
You CAN get some control over the format using an empty but preformatted spreadsheet (with column names included), a little VBS copy copy the template to a new file, and OPENROWSET.
--Jeff Moden
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply