Hi,

I have just started working with CR, I am using CR 10.
I created a report which is referrefing a AAA database, I want to change these references to BBB database which has the same data than AAA but different name columns.
I am using ODBC-System DSN, and when I try to change from AAA to BBB, I am configuring SetDatasourcelocation, unsuccessfully.:(

Private Function SetDataSource _
(ByVal conn As String, ByVal query As String, _
ByVal dataSet As DataSet)

   ' Use ADO.NET object model to set up the connection
   ' information.
   Dim oleConn As New OleDbConnection(conn)
   Dim oleAdapter As New OleDbDataAdapter()
   oleAdapter.SelectCommand = New OleDbCommand(query, oleConn)

   ' Connect to the data source, fetch the data, and disconnect
   ' from the database.
   oleAdapter.Fill(dataSet, "Customer")

   ' Pass the populated data set to the report.
   Report.SetDataSource(dataSet)
End Function

[C#]
private void SetDataSource
(string conn, string query, DataSet dataSet)
{
   // Use ADO.NET object model to set up the connection
   // information.
   OleDbConnection oleConn = new OleDbConnection(conn);
   OleDbDataAdapter oleAdapter = new OleDbDataAdapter();
   oleAdapter.SelectCommand = new OleDbCommand(query, oleConn);

   // Connect to the data source, fetch the data, and disconnect
   // from the database.
   oleAdapter.Fill(dataSet, "Customer");

   // Pass the populated data set to the report.
   Report.SetDataSource (dataSet);
}