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

Question

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