Crystal Report

[jvijay05]

hi,


i want to create a crystal report with oledb sql server....

i have three tables..............

i have to create crystal report with sql query


ie

"SELECT a.ccode,a.BillNo,a.BillDate,a.CustomerName,a.lamt, a.lno,b.customercode,b.address,b.area,b.city,b.pin code,c.LicenseNo,c.CompanyName,c.Address,c.City,c. Pincode FROM Billing as a, CustomerMaster as b, CompanyMaster as c where LoanAmount<>0 and a.ccode=b.customercode and a.lno=c.LicenseNo and a.BillNo in (11,13,16,19)"

if am use dataset the printed in crystal report repeatedly


Give me some idea or sample coding


by
vijay