Hi Robert,

Which developping tool do you use? How do you drive the report engine?
API, OCX, ...

You have to set the ODBC- Connection in a way. I my be able to help you
if i'd know more of your developing environment. If you just use Crystal
reports you can change database via the database menu I believe. But i
think this is not you approach.

In VB I use somthing like

With CrystalReport1
    .CopiesToPrinter = CInt(txtReportKopien)
    .Destination = IIf(bPreview, 0, 1)
    .ReportFileName = ReportPath() + sFile
    .Connect = wsMain.Connect()
    .WindowState = 2
    .ProgressDialog = True
End With

...

Public Function Connect() As String
'----------------------------------------

Connect = "DSN=" + DatenQuelle() + ";UID=" + UserName() + ";PWD=" +
Pwd() + ";DSQ="

'----------------------------------------
End Function

Hope it'll help