Can Microsoft report Builder be used with data sources other than databases.  For example, can you build reports using data from an Excel file?

bklugh
bklugh used Ask the Experts™
on
My copmpany uses report Builder to produce reports from our SQL Server 2008 database.  Can I use it to make reports from Excel data?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
ValentinoVBI Consultant
Most Valuable Expert 2011
Commented:
Your data source can be any OLE DB or ODBC source.  As long as you've got a provider, it should work.

So the answer is: yes, it should be possible to use an Excel file as source for your report.

However, I wouldn't go that way, I would set up a process that imports the files into a proper DB first and build reports using that DB.  But yeah, it's possible.
SQL Expert/Infrastructure Architect
Commented:
I agree with ValentinoV. A database is the way I would go but ...

Here is an example if you don't want to go the full yard
http://www.connectionstrings.com/excel-2007

Regards Marten

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial