I am doing the similar thing

Our ERP is Oracle 11i. I use SQL Server Reporting Services with DTS/Transact SQL for corporate reporting, including daily sales revenue flash,Order bookings, Material Purchasing, entire Inventory for all divisions around the world including currency conversion, expenses, gross margin etc. I like the reporting services. It is easy and fast development/deployment tool. I can share with you if you like my email is [e-mail]