I have a dataset, report, and report viewer on a form. I want the form to get
the data from the dataset NOT the database and then tie the report to the
viewer. I don't seem to be having much luck in figuring it out, Any ideas?

I believe you want something like this:

http://www.codeproject.com/aspnet/crystal_report.asp

This technique is pretty widely refered to as the "push" method, so a
search for "crystal reports push method" might get you even more
information.  When I tried this technique, however, I had speed issues
over a direct database connection as the dataset grew.  So, for smaller
reports, it's fine.

If many users on the same server are using the same report, remember
you can stick it in the application cache (Cache[]) to cut memory usage.

DBConcurrencyException on dataset update (because of datetime primary key ?)
escaping special operators, ', etc.
Naming data access components
database connection loss
INSERT before checking duplicate values