Crystal Report from two tables from two databases. C#WinApp.

Mayank Jani

Hi Everybody,

Greetings of the day...

I am trying to create a crystal report that fetches records from two tables and two databases.I can use Inner Join for two table from same database but when there are two databases the join query occurs problem.

please see the attached file.

1.What is mistake in my query?

2.Why the exception shows the folder that contains crystal report material, and not the connection string OleDbConnection?

3.How to add 2nd OleDbConnection (MyMast) in query string?

Please help on these problems.

Thank you

Mayank Jani

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Cassie Mod9y ago
Accepted answer
olso use several connectionstrings in app.config don;t use that to get the db connection, don't create a db connection in your class, just get the connection from app.config
+1
Cassie Mod9y ago
You can't do that on fly directly. You have two options:
1. Create a linked server in DB invironment, then create a SP to take care of it.
2. Get two DataSets for them, then merge two datatables into one based the id.
+1