Hi, I have created reports with drill thru functionality. I use a blue foreground and bold font to give the user hints as to what they can drill into. I would like to be able to turn off the blue, bold, and even the drill thru action when the report is being printed or exported. I have thought of basing those properties on a hidden/non hidden report (ex. @ShowLinks) parameter, but the best scenario would be if I could determine (via a global variable) whether a report is being exported or printed rather than the user having to remember to set a parameter. Any ideas? Thanks,Rick

Hi Rick, This can be done using the built-in field RenderFormat.IsInteractive/RenderFormat.Name in SSRS 2008 R2. See http://blogs.msdn.com/b/robertbruckner/archive/2010/05/02/globals-renderformat-aka-renderer-dependent-report-layout.aspx on how to use Globals!RenderFormat aka Renderer Dependent Report Layout in reporting sevices. However, the previous reporting services (2008 or 2005) can't do it. thanks, Jerry