SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


In SSRS, how to insert hyperlink in a cell.


In SSRS, how to insert hyperlink in a cell.

Author
Message
THE-LIP
THE-LIP
SSC Rookie
SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)

Group: General Forum Members
Points: 33 Visits: 30
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.
devilsid
devilsid
Valued Member
Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)

Group: General Forum Members
Points: 60 Visits: 90
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.
THE-LIP
THE-LIP
SSC Rookie
SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)

Group: General Forum Members
Points: 33 Visits: 30
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.
devilsid
devilsid
Valued Member
Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)

Group: General Forum Members
Points: 60 Visits: 90
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..
THE-LIP
THE-LIP
SSC Rookie
SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)

Group: General Forum Members
Points: 33 Visits: 30
In Action properties which section will i choose and what is the expression i can use to achieve the above scenario?
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search