Language = VB.NET 2005

I have an sql database which is the source of my reporting front-end. the reports are predesigned in visual studio, but when the front end app opens a table or a view, I want to place the data from the table or view into the report, with a default header and footer. My questions are:

A) how can i dynamically change the source server, database, and table/view/procedure that the report is generated from, and then dynamically add the appropriate text/label/picture objects to the crystalreports.engine.reportdocument object at runtime?

B) the program has a feature where if one server is down, it can revert to a backup server. to this, i need to change the source server on a reportdocument after it has been loaded. this is probably the same solution as problem A.


thanks for any help