SSRS Report From EXCEL Sheet

1. Create a Driver for Excel Sheet
       Start--> Control Panel-->Admin Tools--> DataBases-->R.C-->Add-->ODBC MS Excel Setup
-->DataSource name:  DS_Excel   --> Select Work Book-->Browse-->OK

2. Data Set & DataSet Creation in Report Level:
In Reports goto View-->Report Data-->New DataSource-->General-->Name-->DSrc_Excel-->
Embedded Connection--> Type(ODBC) --> Edit--> Click option "String Connection"
--> Build--> Machine Data Source-->Driver Name--> DS_Excel--> Clik OK-->Ok-->ok

New DataSet Name: DST_Excel --> Click on Query Builder--> Query Designer
Select * From [Sheet1$] --> ok --> Ok

Next you know how to drag Report item(Table/list/Matrix.......) to your Report Design page...... and all other things.