DataSet (designer), Report (MS) and custom connections   

Hello all...

I have a website to which I want to add some reporting ability using the MS 
reporting tools. (local, not RS)
When you add a new DataSet (TableAdapter) it want's to establish a new, 
direct connection to a database.
When you add a report, to design it you need a direct database connection.

However, in our app, we have a class which manages and hands out 
connections, based on the currently logged in user (using login names to 
SQL, to allow for auditing).

How can I get DataSets/TableAdapters, and MS local reports to use a 
connection object as handed out by my centralized class instead of wanting 
to directly establish their own connections?

Thanks in advance, ...
- Arthur Dent.

date: Fri, 29 Aug 2008 17:28:02 -0400   author:   Arthur Dent