Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Turn off hyperlink action for website in SQL 2005 SSRS Report

Unanswered Turn off hyperlink action for website in SQL 2005 SSRS Report

  • Tuesday, January 29, 2013 9:59 PM
     
     
    Sign In to Vote
    0

    I have a SSRS 2005 report that is used for an invoice.  In the report is a link to a website like http://www.microsoft.com where the customer can go view information.  When you view the report on the screen, the link does not display as a link nor can a user click on it and have it try to open the link.  This is the action we want.  However, when the report is exported to a PDF, the user can click on the link.  The customer does not want that behavior.  Is there a way as part of the rendering to PDF to not provide this behavior?

    Thank you 

    Charles Allen Managing Consultant BKD Technologies


    • Edited by Charles AllenMVP Tuesday, January 29, 2013 10:01 PM Updated information
    •  
     

All Replies

  • Tuesday, January 29, 2013 11:19 PM
     
     
    Sign In to Vote
    0

    Hi Charles,

    Please have a look into the following article:

    http://www.bidn.com/blogs/BrianKnight/ssis/972/ssrs-action-to-open-a-url-in-a-new-window

    Thanks,

    Zaim Raza.

     
  • Thursday, January 31, 2013 6:36 AM
    Moderator
     
      Has Code
    Sign In to Vote
    0

    Hi Charles,

    If I understand correctly, you want to make the "Jump to URL" action active in PDF format and inactive in HTML format. In SQL Server 2005 Reporting Services, this requirement cannot be achieved. However, in SSRS 2008 R2, a new built-in field “Render Format Name” was introduced, and we can achieve this requirement by using an expression like:

    =IIF(Globals!RenderFormat.Name="PDF", "http://www.microsoft.com", Nothing)

    Thanks for your understanding.

    Regards,
    Mike Yin

    If you have any feedback on our support, please click here

    Mike Yin
    TechNet Community Support

     
  • Thursday, January 31, 2013 2:34 PM
     
     
    Sign In to Vote
    0
    Thank you for your response.  Actually, we don't want the action in any output. 

    Charles Allen Managing Consultant BKD Technologies

     
  • Friday, February 01, 2013 1:46 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi Charles,

    Thanks for your posting.

    From you description, you want to disable the hyperlink in the report actually. To achieve your goal, use the following steps:

    1. Right click the textbox that contains the hyperlinks, and open the Properties dialog box.
    2. Click the Navigation tab, set the “Hyperlink action” to “None”.

    Regards,
    Mike Yin

    If you have any feedback on our support, please click here

    Mike Yin
    TechNet Community Support

     
  • Friday, February 01, 2013 4:54 PM
     
     
    Sign In to Vote
    0

    Mike, thank you but that setting is already there as you recommended.  It seems to be a feature of Adobe files.  In fact, when you view the PDF, the URL is formatted without the blue lettering and underline commonly associated with a URL.  However, if you point to it the pointer changes to a hand as you would expect when pointing to a link. 

    They are on SQL 2005.  The text box is in the page footer. 

    Charles Allen Managing Consultant BKD Technologies

     
  • Monday, February 04, 2013 2:23 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi Charles,

    Thanks for your posting.

    For your concerns about the format of the hyperlinks generated by a “Jump to URL” action, it is the expected behavior in SSRS. If you would like, you can format the text in the textbox such as set the font color to Blue and add an underline. In SSRS 2008 and higher, we can import HTML content to report, in that way, the hyperlinks will render as you expected.

    If the hyperlinks still exist in the PDF file after you remove the “Jump to URL” action for the report, please try to remove the existing RDL file from the report server, redeploy the report, and then export the report to PDF and check the issue again.

    Hope this helps.

    Regards,
    Mike Yin

    If you have any feedback on our support, please click here

    Mike Yin
    TechNet Community Support