Recently we upgraded to SSRS-2008 R2 from SSRS-2008 (enterprise edition) and noticed that all the underlines for hyper-links in all reports are missing. Also the font color has reset back to default color (had set to blue to indicate a hyperlink). Redeployed the same report from VS-2008 SP1 but no luck. Although the formatting (color + underline) looks ok in the preview mode in VS. Anyone else experienceing this issue? Would be great to know if there's any workarounds as many end users are getting confued with this change :( -Rajiv

Recently we upgraded to SSRS-2008 R2 from SSRS-2008 (enterprise edition) and noticed that all the underlines for hyper-links in all reports are missing. Also the font color has reset back to default color (had set to blue to indicate a hyperlink). Redeployed the same report from VS-2008 SP1 but no luck. Although the formatting (color + underline) looks ok in the preview mode in VS. Anyone else experienceing this issue? Would be great to know if there's any workarounds as many end users are getting confued with this change :( -Rajiv Hi Rajiv, Based on your information, I would recommend you download the report from the reportserver,then open report's XML file in the BIDS, to have a check whether the textbox's style like below: <Style> <TextDecoration>Underline</TextDecoration> <Color>DarkCyan</Color> </Style> If not, you might need to add the style again. Thanks, Challen Fu

Hi Rajiv, Did you get any solution for this. Even we are facing the same problem. text formatting is not applied at some places and hyperlink/actions dont have underline. We have 300+ reports and we cannot change each one of them. is there any hotfix or patch available for this. Any help would be greatly appreciated..!!!! Thanks Ravi

Some further analysis on this: I compared the source of two files and here is the difference: SSRS 2008 R2: <a tabindex="2" onclick="ClientReport153d310f6dd443df9204c6ad30701e05.ActionHandler('Drillthrough','118iT0R0x0:0');return false;" onkeypress="if(event.keyCode == 13 || event.which == 13){ClientReport153d310f6dd443df9204c6ad30701e05.ActionHandler('Drillthrough','118iT0R0x0:0');}return false;" href="" sty le="cursor:pointer;" class="a152a" TARGET="_top">Member Months</a> SSRS 2008: <a tabindex="2" onclick="ClientReport5bd71a7d7ff34f7484c7f266481555d8.ActionHandler('Drillthrough','116iT0R0x0:0');return false;" onkeypress="if(event.keyCode == 13 || event.which == 13){ClientReport5bd71a7d7ff34f7484c7f266481555d8.ActionHandler('Drillthrough','116iT0R0x0:0');}return false;" href="" style="cursor:pointer;text-decoration:none;color:White" TARGET="_top">Member Months</a> R2 keeps style in a class whereas 2008 has inline code. When I navigate to this class in R2 source, i dont see the format as used in RDL. This is very strange. How is the style changing??? Anyone has any thoughts...???? Please help...!!!!

Some further analysis on this: I compared the source of two files and here is the difference: SSRS 2008 R2: <a tabindex="2" onclick="ClientReport153d310f6dd443df9204c6ad30701e05.ActionHandler('Drillthrough','118iT0R0x0:0');return false;" onkeypress="if(event.keyCode == 13 || event.which == 13){ClientReport153d310f6dd443df9204c6ad30701e05.ActionHandler('Drillthrough','118iT0R0x0:0');}return false;" href="" sty le="cursor:pointer;" class="a152a" TARGET="_top">Member Months</a> SSRS 2008: <a tabindex="2" onclick="ClientReport5bd71a7d7ff34f7484c7f266481555d8.ActionHandler('Drillthrough','116iT0R0x0:0');return false;" onkeypress="if(event.keyCode == 13 || event.which == 13){ClientReport5bd71a7d7ff34f7484c7f266481555d8.ActionHandler('Drillthrough','116iT0R0x0:0');}return false;" href="" style="cursor:pointer;text-decoration:none;color:White" TARGET="_top">Member Months</a> R2 keeps style in a class whereas 2008 has inline code. When I navigate to this class in R2 source, i dont see the format as used in RDL. This is very strange. How is the style changing??? Anyone has any thoughts...???? Please help...!!!! We have experienced this identical issue when upgrading from SSRS2005 to SSRS2008 R2. Must I edit the CSS file on the report server to resolve this problem? Please help. -Craig

According to Microsoft, this behavior is by design. They decided to hide hyperlinks in reports that used to make them obvious. I'm guessing the fact that our customers who became used to easily determining clickable links on our reports would be upset by the change was completely lost on Microsoft. The only way to resolve the bug (yes it is a bug) is to either modify every report (which is not practical for those of us who host hundreds of reports) or modify the CSS files on the report server. You can find those files at: C:\Program Files\Microsoft SQL Server\MSRS10.x\Reporting Services\ReportManager\Styles and C:\Program Files\Microsoft SQL Server\MSRS10.x\Reporting Services\ReportServer\Styles Please forgive my snarkiness. It's been a rather frustrating day. Hope this helps. -Craig

Hi, I'm trying to underline the links in my reports modifying the css files Craig said but it's not working. I'm working with the report viewer control in my webpage. Can someone give more directions for modifying the CSS that Craig said? Thanks for the help.

Has any progress been made on correcting this in Report Viewer or in a subsequent release of a sql server r2 update?

Hi there, I've finally found the solution for this issue. First, let me explain you the fact I think that is causing it, it occurs in the way IE renders the data to HTML with the ReportViewer control, when we've got a report field with a configured action and established to underlined, the underline isn't rendered because the auto-generated styles have established the underlining decoration property at the level of the div that contains the field; in contrast when we don't have an established action in the field, underscore works. And last but not least, here is the solution: The solution is very simple, is to put an expression in the Font-TextDecoration property of the field that has the action and that we want to underline, as follows: =iif(1=1, "Underline", "None") Hoping this solution be useful. Jhonny Galeano

Thanks to JhonnyGaleano I found the following solutions: <TextDecoration>=”Underline”</TextDecoration> <FontFamily>=”Tahoma”</FontFamily> <FontStyle>=”Italic”</FontStyle> <FontSize>=”8pt”</FontSize> <FontWeight>=”Bold”</FontWeight> <Color>=”#00ff00″</Color> I think this may only apply when you use an older version of the Report Viewer control on SQL R2 or Denali. We're using the ReportViewer web control version 8.0 from SQL 2005. More info here: http://rsinteract.wordpress.com/2011/09/19/no-underline-shown-on-links-action-hyperlink-drillthrough-in-reporting-services-r2-and-denali/

Manual solution: Click on the text in the cell of the rdl which represents the hyperlink. Either by right-clicking and selecting Placeholder Properties or in the Properties box, set the Markup Type to HTML.