I have a textbox which I want users to only see when they are looking at the report online.Is it possible to hide a textbox when printing or exporting? How do I do this?Thanks

I dont think its possible to selectively avoid some components in the print. Following alternative might help Create a report parameter something like ReportMode with values View and Print. Based on this parameter value, the report component can be made visible/hidden using conditional visibility expression (If there are more changes you need in the report print view compared to normal view, this parameter can help too). If you dont want to show this report parameter, make it hidden and set the value to View by default. Then, add a link in the report labeled Print which calls the same report with ReportMode set to Print. Hope this helps...hegde

Hi, In addition to Hegde, in Properties window of the cell, there is an option called DataElementOutput. Set this option to NoOutput. When you export the report to CSV or XML format, the cell modified wont be exported. But you still cannot prevent the textbox from printing. The work around that I can think of is using parameter just as Hegde said. Please let me know if this helps. Raymond

Hi would you tell me how to add a link in the report labeled Print ,I can use parameter to make thetextbox hiden right now, and I dont want to show this report parameter, I don't know how to change the "Print" label, Thank you very much!

Hi would you tell me how to add a link in the report labeled “Print” , I can use parameter to make the textbox hiden right now, and I don’t want to show this report parameter, I don't know how to change the "Print" label, Thank you very much! You can not modify the print button, but inside your report you could create a textbox labelled print and set it's navigation property to open the same report with a parameter that hides this textbox (as hegde suggested).

Dexter A feature was added in the R2 version release that makes this pretty simple. Use the RenderFormat built-in field to determine the report's rendering format in the Hidden property expression for any report item. If you wanted a textbox to show up only when the report is viewed in HTML, you could set the Hidden property for this textbox to the following expression: =(Globals!RenderFormat.Name <> "HTML4.0") *Please vote if helpful* Paul Turley, MVP [Hitachi Consulting] SQLServerBIBlog.com