How to retrive data

How to retrive data from EXCL file by using SSRS.(My data is not sql server)

There are Excel drivers for both ODBC and OLE DB. Here's an example of an OLE DB connection string for Excel:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1"

Then you can select from sheets in the workbook:

SELECT * FROM [sheet1$]