I am trying to write an inventory report, which is using two databases.
The primary site uses the database InvA, and where the product is in the secondary facility this database has a secondary code which is basically the key for the inventory line in the InvB database.
I have written a SQL statement that connects to the two databases and collects the data they want, combining where needed and the data matches what they want. A single table combining the product quantity by product code and lot code, regardless of facility.
1) The problem I'm having is how do I create a report that uses my SQL statement which connects to two databases? Is there a way of assigning two connection strings to a single SqlDataSource? Is there an example for this?
2) Do I have to programmatically "merge" my datasources into a single data table, and then use an ObjectDataSource? Is there an example of this?
3) Does Telerik use DataSource and Database interchangeably, meaning I can only use one database per report? Should I be asking the client if I can modify the database to include a table valued function?