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