Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

In SSRS, how to insert hyperlink in a cell. Expand / Collapse
Author
Message
Posted Wednesday, March 20, 2013 4:00 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, March 17, 2014 11:46 PM
Points: 17, 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.
Post #1433107
Posted Wednesday, March 20, 2013 6:16 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, March 27, 2014 8:39 PM
Points: 18, Visits: 78
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
Posted Wednesday, March 20, 2013 11:06 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, March 17, 2014 11:46 PM
Points: 17, 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.
Post #1433589
Posted Thursday, March 21, 2013 4:42 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, March 27, 2014 8:39 PM
Points: 18, Visits: 78
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
Posted Friday, March 29, 2013 2:57 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, March 17, 2014 11:46 PM
Points: 17, Visits: 30
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 »

Add to briefcase

Permissions Expand / Collapse