SQL Server 2008 R2 - Sharepoint 2010 I have published a report into a sharepoint webpart. The result is that I have 2 header images (one in sharepoint and the other one in the report). Moreover I have scrolling problems with a header within a webpart. Is it possible hiding the header in visualization and showing it only when print / exporting? thanks in advance

Try this. Put all your header items into a rectangle. Set the Hidden property of the rectangle to: =(Globals!RenderFormat.Name<>"IMAGE") This will show these items only when the IMAGE rendering extension is used (used by the print control) otherwise, it will be hidden. Please let me know if this works for you. Paul Turley, MVP, www.SQLServerBIBlog.com *Please vote if helpful*

Hi LBA, As Paul posted, you can try to use the “Globals!RenderFormat.Name” built-in field to achieve this. For example, if we need to hide the image when view the report, but the image needs to display when export the report to PDF format, we can write an expression to control the visibility of the image: IIF(Globals!RenderFormat.Name=”PDF”, FALSE,TRUE) For more information about Using Built-in Globals and Users References (Report Builder 3.0 and SSRS), please refer to the article below: http://msdn.microsoft.com/en-us/library/dd255216(v=SQL.105).aspx Thanks, Bin Long Forum Support Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com