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

Cassie Mod · 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

Cassie Mod · Answer

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.