In SSRS, how to insert hyperlink in a cell.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services » In SSRS, how to insert hyperlink in a cell.

In SSRS, how to insert hyperlink in a cell.

Rate Topic

Display Mode

Topic Options

Author

Message

THE-LIP

Posted Wednesday, March 20, 2013 4:00 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 3:20 AM
Points: 16, Visits: 27

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.

Post #1433107

devilsid

Posted Wednesday, March 20, 2013 6:16 PM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, April 17, 2013 10:26 PM
Points: 16, Visits: 61

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.

Post #1433557

THE-LIP

Posted Wednesday, March 20, 2013 11:06 PM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 3:20 AM
Points: 16, Visits: 27

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.

Post #1433589

devilsid

Posted Thursday, March 21, 2013 4:42 PM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, April 17, 2013 10:26 PM
Points: 16, Visits: 61

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..

Post #1434073

THE-LIP

Posted Friday, March 29, 2013 2:57 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 3:20 AM
Points: 16, Visits: 27

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

Post #1436843

« Prev Topic | Next Topic »

Permissions