Groups | Blog | Home
all groups > sql server reporting services > july 2005 >

sql server reporting services : excel vs. pdf - is it possible to eliminate header?


Cory
7/29/2005 11:49:03 AM
I have a report that has images etc. (company logo) at the top which works
fine when rendering to pdf. However I'd like to elimiate this stuff when
rendering to xls. Is that possible?

Thanks.

Bruce L-C [MVP]
7/29/2005 2:05:37 PM
Try CSV ASCII instead. Much faster and it will do what you want.

Here is an example of a Jump to URL link I use. This causes Excel to come up
with the data in a separate window:
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
"&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

AddThis Social Bookmark Button