SSRS 2008 Surpress the Report Header
I need to surpress the report header holding the company logo and report title when exporting to excel or csv formats, how can I do this in SSRS 2008?
December 8th, 2009 7:06pm

I think you can modify the rsreportserver.config file and alter the Excel extension as seen below. You will prob need to restart the services after this and also IIS.<Render> <Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering"> <Configuration> <DeviceInfo> <SimplePageHeaders>True</SimplePageHeaders> </DeviceInfo> </Configuration> </Extension></Render>
Free Windows Admin Tool Kit Click here and download it now
December 8th, 2009 7:46pm

This was a design goal for the next release. In SSRS 2008 R2, you can have rendering dependent conditions like you are suggesting.Without upgrading, I recommend that you use a parameter to hide the header items in a rectangle and then switch the parameter value when rendering to Excel. Paul Turley, MVP [Hitachi Consulting] SQLServerBIBlog.com
December 8th, 2009 7:52pm

Could you explain more on how to use a parameter to hide the header when rendering a report in excel?
Free Windows Admin Tool Kit Click here and download it now
December 9th, 2009 12:25am

Sure. Hiding items using a parameter...Create a Boolean type parameter. I'll call it HideHeaderPlace all of the header items in a rectangle in the top area of the report body.In the Hidden property for the rectangle, use the expression:=(Parameters!HideHeader.Value)Hiding the header only for Excel rendering...Again, this is new feature in SSRS 2008 R2.Use the new RenderFormat object in an expression on the Hidden property, like this:=IIF(Globals!RenderFormat.Name="EXCEL", True, False)...actually the IIF function is unnecessary. You could use the same logic as my first example:=(Globals!RenderFormat.Name="EXCEL") Paul Turley, MVP [Hitachi Consulting] SQLServerBIBlog.com
December 9th, 2009 2:03am

Thank you so much.
Free Windows Admin Tool Kit Click here and download it now
December 9th, 2009 6:01pm

Is there any workaround for identifying the rendering format in SSRS 2008?
November 19th, 2010 9:58am

Not in SSRS 2008. You will need to upgrade the product to use this feature.Paul Turley, MVP [Hitachi Consulting] SQLServerBIBlog.com
Free Windows Admin Tool Kit Click here and download it now
November 19th, 2010 3:48pm

Bummer :-) Thanks Paul!
November 19th, 2010 5:04pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics