Post reply

In SSRS, how to insert hyperlink in a cell.

  • March 20, 2013 at 4:00 am

    #275476

    I have developed a report using SSRS 2008 R2. In the report i've multiple tables and given page break to render in multiple sheet. Now I want do hypelink like when i click a cell in the sheet1, it will navigate to sheet2 or sheet3.

    How will i achieve this?

    Any suggestion will be appreciable.

  • March 20, 2013 at 6:16 pm

    #1599197

    Select a certain cell or maybe insert a new one i.e "page 2"

    right click on it and goto text box properties and select action ...

    you will have 3 options to choose from ....

    hope this helps.

  • March 20, 2013 at 11:06 pm

    #1599226

    Thanks for your reply..

    But that is not what i need. Below is an example

    I have a excel worksheet, sheet1 contains these data

    Category Sub Category

    Bike Honda

    Hero

    Bajaj

    and Sheet2, Sheet3, Sheet4(Honda,Hero,Bajaj respectively) are showing detailed data.

    when i click on Honda it will go to sheet2, when i click on Hero it will go to sheet3.

    I can do this in excel by making hyperlink and link to different sheet with in the same worksheet.

    But same thing i want to do in ssrs.

    Ex: I have made 4 different tables and able to Export to excel with multiple sheet as above example. How will i link the cells in first table to detailed table.

    I think now u can understood what exactly i need.

  • March 21, 2013 at 4:42 pm

    #1599623

    The Hyperlink function in excel is the same function as action function(SSRS 2008) you can use it to goto a certain section of the report which has detailed data for a summarized set.

    this should be acheivable for the example you mentioned above..

  • March 29, 2013 at 2:57 am

    #1601943

    In Action properties which section will i choose and what is the expression i can use to achieve the above scenario?

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

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