hai,

I need a help in crystal report,i had a problem while doing group by clause,

this is my query when i test it in my sql-server it is working fine

select people.firstname,people.initial,people.lastname,sum(TotalRHBillAmount),sum(Timesheet."TotalHDBillAmount"),sum(Timesheet."TotalVABillAmount"),sum(Timesheet."TotalOTBillAmount"),sum(Timesheet."TotalAmountbill") from timesheet join people on timesheet.peoplecode=people.peoplecode Group by people.lastname,people.firstname,people.initial

how to do it in crystal report, can u help me out pls its urgent