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? Thanks, Bablu

Hi, You can achieve this in two ways:- 1) One is you can create 3 reports and you can use the Action "Jump to another report" property to achieve the functionality. 2) Create 3 subreports reports and a main report. In the main report add 3 tables and place all these subreports inside these tables with a page break and try to use the bookmark functionality for navigation. HTH, Ram

Hi Ram, Thanks for u r reply. I dont want to create 3 different reports. So I am thinking to choose u r second option. And my question is if I do in the way you suggested in the second option, will I be able to see in 3 different sheets when exported to excel? Thanks, Bablu

Yes,Make sure you add a page brerak after each table. You will be able to get it in 3 different sheets when exported to excel ! HTH, Ram