Click here to Skip to main content
Rate this: bad
good
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
Comments
digimanus at 29-Aug-12 6:39am
   
which excel version?
kirthiga S at 29-Aug-12 6:40am
   
MS Excel 2003
Rate this: bad
good
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.
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 4

Hi,
 
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
  Permalink  

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



Advertise | Privacy | Mobile
Web01 | 2.8.1411022.1 | Last Updated 6 Mar 2013
Copyright © CodeProject, 1999-2014
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