CODEWITHSUNDEEP
reporting-servicessql-server-2008-r2ssrs-2008ssrs-2008-r2
Kapil Dhawan
Kapil Dhawan

Reputation: 111

Excel as Datasource in SSRS report

How can I give Excel as datasource in SSRS report I am developing SSRS report in Visual Studio 2008, please help me in this, I have read various links but unable to get desired results.

Upvotes: 3

Views: 14563

Answers (1)

Trubs
Trubs

Reputation: 3032

In Visual studio - there is an option to create a datasource from an ODBC connection. From these dialogs you should be able to create a machine dsn to the excel file you require.

So...... from your report in visual studio, Click Create new DataSource...

enter image description here enter image description here enter image description here enter image description here enter image description here enter image description here

Upvotes: 5

Related Questions