Showing posts with label sources. Show all posts
Showing posts with label sources. Show all posts

Sunday, March 11, 2012

CR 6.0 multiple DSN queries and joins

Hi all, I'm new to this forum so will try to ask only relevant questions on point. What I am looking to do is query multiple DSN sources and join the results in a consolidated report using CR 6.0. Does anyone know if I can query multiple DSN's with CR 6.0 and if so what might the connection string look like?

Thanks in advance.

Cheers

DanSKIf the DSNs point to different database, I think it is not possible. Export the tables in single database and link them