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 used Ask the Experts™
My copmpany uses report Builder to produce reports from our SQL Server 2008 database.  Can I use it to make reports from Excel data?
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
ValentinoVBI Consultant
Most Valuable Expert 2011
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
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

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