Post reply

Change hyperlink text

  • January 14, 2013 at 10:56 am

    #269197

    Using SSRS 2008 Standard.

    I'm not seeing a way to manipulate the hyperlink text. What I get is an entire URL string that looks tacky. I can't find anything in the text box properties that shows what I'm looking for.

    Is there a way to change the text to something like 'Click Here' by using am expression like you can do in Word or Excel?

  • January 15, 2013 at 1:55 am

    #1577182

    In the footer of a subscription email? Not that I am aware of.

    In the report itself, you could use an expression on the text box

  • January 15, 2013 at 8:05 am

    #1577352

    I meant changing the hyperlink in the text box. I am unfamiliar with expressions for HTML so I wanted to know if there was an easier way to do this without using expressions.

    What I have is tracking information that is created dynamically based on our carrier.

    Here's what my query looks like:

    WHEN SHIPPING 'FED EX'

    THEN 'www.fedex.com/.../.../.../.../tracking/id=' + SHIPPING

    WHEN SHIPPING 'SAIA'

    THEN 'www.saia.com/.../.../.../.../trackingid=' + SHIPPING

    ELSE SHIPPING

    So in SSRS it shows up in the text box as it should, but I'd like to 'trim' down the hyperlink to something more short and simple so that it doesn't take up unnecessary space. Change it to something like 'Click Here' or 'Tracking' instead of showing the entire URL for the hyperlink.

  • January 15, 2013 at 8:34 am

    #1577368

    Expressions in SSRS are C based expressions not HTML expressions.

    Instead of having the textbox display the URL, set the action on the text box to go to the url instead.

    The expression would be something like =Fields!URL.Value

    Then you just need to replace the actual data in the text box with "Click Here", make it blue, underline it, and it looks like a short Click Here to jump to URL link.

    Edit

    Attached a bog simple example

  • January 15, 2013 at 9:09 am

    #1577388

    Wow....that was way easier than I made it out to be. Still waiting for the coffee to kick in!

    Thanks for the help! This will make everything cleaner in the report.

  • January 16, 2013 at 1:35 am

    #1577691

    Not a problem, glad I could help

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply