Post reply

How to use Hyperlink in the following scenario?

  • May 18, 2011 at 9:57 pm

    #236569

    Hi Guys,

    I am building a report in SSRS 2005

    And inside my report I have 3 different tables :

    First Table is for Instructions

    Second table is for detailed information of the data

    Third table is for Summary information of the data.

    Now what I want is in the second table, I have text "Click Here to go to Instructions". So I need to create a hyperlink to this and when someone clicks this text, the report needs to show the First table information i.e Instructions.

    Is this possible?

    And finally when exported to excel, they should appear in 3 different sheets (I can achieve this by making Page Break at the end)

    Thanks,

  • May 20, 2011 at 2:22 am

    #1327510

    Unless I am misunderstanding your question the answer is as follows:

    For the hyperlink you need to right click on the text box - then choose properties then choose the navigation tab. I have attached a screenshot.

    You can the desired hyperlink action - choose to jump to a report (within the reports project), bookmark on that report or url (which could be a report from a different project).

    I sometimes make the text blue and underlined - this is so that users realise that there is a link there to use.

    Hope that this helps.

  • May 20, 2011 at 5:23 am

    #1327560

    You can also use the document map properties.

Viewing 3 posts - 1 through 2 (of 2 total)

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