DrillDown Reports in SSRS

The Main Purpose of This article is ,How to use Drill Down Reports in SSRS..,
Before that, we have to know what is meant by Drill down Reports..

     Drilldown Reports are nothing but,With in the same report implementing the functionality of expansion and collapse is called Drill down Report.with this feature we can move from one content to another content with in the report
and also this drill down Reports Provides Visibility and hiding with in the same report ,Generally to analyze the data, bottom to top,top to bottom  in hierarchical fashion .., these reports are helpful

Create a table like this
Create table employee(eid int,ename varchar(30),eaddress varchar(200),sal int,deptname varchar(30))

Eid	Ename	Eaddress	Sal	Deptname
1001	Sharathkumar	Hyderabad	50000	IT
1002	ranivenkat	St.louis	50000	IT
1003	Prasad	Warangal	50000	IT
1004	Satish	Hyderabad	50000	IT

Open BIDS.., Take a New Report and Create a Data Source,assign a Dataset to the Created Datasource.
after that.., take a table on to the Report Design Surface and assign the data to the table,which is to show in the Report,like this

after this See The Preview...

Now.., Which Columns have to be keep in hide.., Select Those Columns like this

Now Press F4.., and change the properties of Hidden to True and Toggle Item to ename(The column name ,Which we are Implementing the Drill Down action) like this

Now,See the Preview...

The Preview will be Like This

Click The Expand Option Provided on the ename Column to view the data inside...