Able to use multiple databases in Crystal Reports XI?

[Former Member]

Post Author: CathyH

CA Forum: Data Connectivity and SQL

[Former Member]

Post Author: Alien8n

CA Forum: Data Connectivity and SQL

We got round this by using linked servers in SQL2005. Not sure how else you'd do it otherwise without the problems described above.Basically it'sSELECT [table1].A AS A, [table2].B AS B FROM [ls1].[db1].[schema1].[table1]INNER JOIN[ls2].[db2].[schema2].[table2] ON [ls1].[db1].[schema1].[table1].[pk] = [ls2].[db2].[schema2].[table2].[fk] if the databases are sat on the same server then simply drop the [ls] part of the string.

[Former Member]

Post Author: synapsevampire

CA Forum: Data Connectivity and SQL

You're just being silly now.

The one person that answers, and tells you that you can do something that you've decided is impossible, you decide is mistaken about being able to do so, then decide that 1/2 of what I said (that CR XI handles it like CR 8.,5, and basically every other application in the world) is the gospel and must mean that CR XI can't do it either.

Again, you can use multiple datasources in a report, despite what you think you know or how you've interepreted some written information.

Below is a BO example of the types of issues that can crop up when doing so (using CR 8 and multiple datasources), but since you don't bother to post the database types, or anything technical, it's hard to specifically advise you.

http://technicalsupport.businessobjects.com/KanisaSupportSite/search.do?cmd=displayKC&docType=kc&ext... 0 3410768

-k

[Former Member]

Post Author: CathyH

CA Forum: Data Connectivity and SQL

[Former Member]

Post Author: synapsevampire

CA Forum: Data Connectivity and SQL

It supports it the same as CR 8.5 does, it issues a warning (not an error), which is the same as most tools.

If the two datasources aren't linked, how would Crystal know where in each it is supposed to be?

If they're linked, then it isn't a problem, except that it's slow and it issues a warning.

Rather than asking generic questions you might pose your actual requirements to get a more tailored response.

-k