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.