CE report connecting to 2 databases 1

[mgpeters]

I have a crystal 10 report that reports off 2 diff datasources (one is SQL Server via ODBC and the other Oracle 9.2 via direct connect).

When I attempt to publish this to CE 10 I don't know how to set it up with the login creditentials for both data sources. Can anyone help?

 

[IanWaterman]

First you need to create on your CE server ODBC and Oracle connections ideally with same name as the report.

Add object to CE, then within the Report object select the Process Tab and then database.

On left hand side you should see a list of your two data sources, with the first one highlighted. Complete the login info ie add password. Then click on second data source and repeat. Then click UPdate and report should now be ready to run.

If your data source names are different to the original report you should be able to use the alternate login box.

Ian

 

[mgpeters]

Thanks! That works like a charm.