I understand your problem from the first post. But perhaps I have not made myself clear. From a database perspective you do not need to CONNECT TO multiple databases to get data FROM multiple databases if you can use a cross-database query (like in MS-SQL). You can connect to a SINGLE database and use SQL query that gets data from the other databases. From the perspective of the data consumer (Crystal Reports) you are connecting to a single database and getting a single result set. The inter-database communication is handled by the database engine.

Like I said before, I have not worked with Crystal reports, so I don't know what kind of limitations you have regarding the flexibility of the queries you use. But it seems that if you are limited when you connect to multiple databases and you can get the data with a single query to a single database, then it would stand to reason that if you only connect to a single database and specify a cross-database query then you have worked around the problem.

Peter
------------------------------------------------------
Work smarter, not harder.

Thanks. I see what you mean.
But I am not familar with the a cross-database query. Would you please tell me what the a cross-database query will be in this case.

Thanks

Ally

I posted it above... but here is the syntax again. Obviously, you'll need to write it to suit your needs as I don't know what you are actually trying to query. The key is to prefix the table name with "DatabaseName..":

SELECT t1.[ID], t1.Description FROM DatabaseA..TableA2 AS t1
    UNION ALL
SELECT t2.[ID], t2.Description FROM DatabaseB..TableB2 AS t2
ORDER BY [ID]

Peter
------------------------------------------------------
Work smarter, not harder.

Actually I tried that. Somehow it didn't work.
Thanks anyway.


Ally

your problem is related to crystal report i think,
so try to do untyped crystal report and create a datasource and attach it to the report.

Ahmed Ali
Software Developer