.Net Dojo: Microsoft.Reporting Without SQL Server 2005

I was working for a client who wanted an easy way to build dynamic reports.  They wanted to be able to easily alter the reports, with the option to save them off to Excel.  Now, I could have used a GridView to show the data and written out the Excel sheet, but I think Grid Views are overrated and over used as reporting tools.  So, I started looking at the Microsoft.Reporting namespace.  This namespace provides similar functionality to Crystal Reports.  The only problem: my data was stored in Oracle.  I started by picking apart how the ReportViewer works to see if I could somehow import the data dynamically.  Logically, I thought the Sql 2005 reporting services was essentially building a report based on a dataset selected from the database.  Here’s what I discovered.