how to disply data in crystal report from multiple tables

Question

Hello

I am new to C#.net and i am developing one application in which i want to display data into crystal report from sql server 2005

i have 3 tables in database.(ChallanMaster1),(ChallanMaster2)and (ChallanOverviewMaster)

Table1: ChallanMaster1 Table2: ChallanMaster2

Fields: ChallanID1 Fields: ChallanID2

ChallanNumber ChallanNumber

TakaNumber1 TakaNumber2

meter1 meter2

Weight1 Weight2

Quality Quality

Stamp Stamp

Table3: ChallanOverviewMaster

Fields: ChallanID

ChallanNumber

Total Taka

TotalMeter

TotalWeight

Quality

Stamp

Now i want to display crystal report like this

Num1 Meter1 Weight1 Num2 Meter2 Weight2

1 451 551 13 54 41

2 74 41 4 12 441

.. .... ... ..... ... ...

So Please help me in this problem.

Thanks in Advance

Rahul

Vishal Jadav · Answer

Hello  Crystal report is very powerfull as well as painfull tool . It provides facility of LINK when u select ur tables from databaseexpert u need to give link of ur tables. like u have primery keys in ur tables is : ChallanId . In all tables u are using have contain that field. just give links to them and place (drag and drop) ur fields in CrystalReport and it will show u which u require. Hope it will help. Be frank to ask question.. Best Of Luck.