how to disply data in crystal report from multiple tables

Jul 15 2010 9:19 AM

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

Answers (1)

Arabic Data With Asp.net