CR OCX

[Fursten]

Hi,

I had created a report using CReports 7 and an ODBC connection.

In VB6.0 I call the report passing to it a connecting string. If I use the same ODBC with wich I create the report the report works fine. however, I now have another database. The tables have the same name, so I would like to use another ODBC connection in the connection properties that I give to the report in the VB application. However, it doesn´t work.

Is anyway to solve this? I want to use the same report with two diferent ODBC (table names are the same). Do I need to make a set location? Can it be done?

Thank you.

 

[StevenK]

You should be able to use the 'Database' -> 'Set Location' to repoint the Crystal Report tables to the different table location (through the other ODBC connection).
As long as the table structures are the same there should be no problem in doing this.
I hope that this helps.
Steve

 

[Fursten]

Hi,

But I would do it in VB, because I want to be able to choose the odbc connection. The problem is that it seems that the OCX doesn´t have any Database...set location. Is this right?

Thank you