asked on 7/22/2010

SQL Server Reporting Services - Using hyperlink in Expression

I have a report in SQL Server Reporting Services. i have an expression which has a hyperlink.

I don't want to underline the hyplink. Can someone help me.

Thanks in advance.

="(" + trim(Fields!circuit.Value) + ", " + " <a href='" + Parameters!pLocation.Value + "stat_track_reroute.aspx? Fields!ruling_link.Value + "'></a>)"

Open in new window

SSRS Microsoft SQL Server 2008

Last Comment

cimscims

8/2/2010

Howard Cantrell

7/22/2010

If you have your expression in a textbox you can go to the textbox properties window and in there goto the Misc label and then goto the Action Box click on the right empty box and that will show you where to put the hyplink.

cimscims

7/22/2010

ASKER

Planocz,

I have the hyperlink in the textbox and is working fine. The problem is the hyperlink is underlined by default. I don't want the underline for the hyperlink. I have attached the image for your reference.
untitled.bmp

cimscims

7/23/2010

ASKER

Any Clues??

Howard Cantrell

7/23/2010

I wil try and look at it again this weekend. I am on a project today.

cimscims

7/23/2010

ASKER

Thanks Planocz.

Howard Cantrell

7/24/2010

You have to put your hyplink expression in a textbox you can go to the textbox properties window and in there goto the Misc label and then goto the Action Box click on the right empty box and that is where toyou put the hyplink. The cursor changes to a hand when you hover over the textbox. JUST click and it will go to your link. If you do not like the look of a textbox, then you can change the background/borders or whatever you want.
This does work. I tried it.

cimscims

7/26/2010

ASKER

Planocz. I think you misunderstood the question. I had no problems in getting the hyperlink to work from the beginning.

The link was working fine but my only problem is "i don't want the underline in the hyperlink" as shown in the "untiltled.bmp" in my earlier post.

In the first post, i have posted the expression value with <a href>, i want to put "text-underline:none" or something like that to avoid the underline.

Howard Cantrell

7/26/2010

The problem is that I do not know of a way to hide the line. Do not think it can be done in regular coding either. The way I have said it above it that to get around this problem is to create a label type/ textbox label and tie it to the link which would do the samething that you are trying a do in your posting.

cimscims

7/29/2010

ASKER

Sorry planocz. I was out of office for a couple of days. I don't know whether we are on same page..

I have the below value in the expression inside the textbox as mentioned in my earlier post.

="(" + trim(Fields!circuit.Value) + ", " + " <a href='" + Parameters!pLocation.Value + "stat_track_reroute.aspx? Fields!ruling_link.Value + "'></a>)"

If i do that, underline is appearing. I just want to put "text-underline:none" or something like that to avoid the underline.

Please let me know if i am not correct.

ASKER CERTIFIED SOLUTION

cimscims

8/2/2010

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial