SSRS R2: Underline formatting issue
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
November 16th, 2010 3:15am
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
Free Windows Admin Tool Kit Click here and download it now
November 18th, 2010 8:09am
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
November 19th, 2010 1:13am
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...!!!!
Free Windows Admin Tool Kit Click here and download it now
November 19th, 2010 1:19am
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
December 15th, 2010 7:04pm
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.
Free Windows Admin Tool Kit Click here and download it now
January 20th, 2011 2:55pm
Has any progress been made on correcting this in Report Viewer or in a subsequent release of a sql server r2 update?
February 15th, 2011 11:58pm
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
THANK YOU!! such a neat trick!
Free Windows Admin Tool Kit Click here and download it now
April 16th, 2013 4:47am