Click here to Skip to main content
13,351,457 members (43,015 online)
Rate this:
Please Sign up or sign in to vote.
I have to generate a report using SSRS.

My users having 1000's of codes in excel. They will give that code as input.
For that code a report has to be generate in SSRS.

Is there any possible way to give excel as input data in SSRS
Posted 29-Aug-12 1:27am
digimanus 29-Aug-12 6:39am
which excel version?
kirthiga S 29-Aug-12 6:40am
MS Excel 2003
Rate this: bad
Please Sign up or sign in to vote.

Solution 3

Yes you can connect MS Excel as DataSource of SSRS. Just use OLEDB provider. You design SSRS report using your excel data.
Rate this: bad
Please Sign up or sign in to vote.

Solution 4


You can build SSRS Reports from Excel. one draw back is if your excel contains Formulas those formulas will be dropped i.e your SSRS report contains only data not formulas.

In Case of Data Source Select OLEDB Provider instead of Microsoft SQL Server. and the rest of all are same

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web04 | 2.8.180111.1 | Last Updated 6 Mar 2013
Copyright © CodeProject, 1999-2018
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100