Crystal REport Group clause

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

Hi,

I am visual basic programmer, I have used 1 Crystal into my VB Project, but when I create package to install it on other system.

I have Install it on other PC (there is no crystal report).

But When I run the crystal report it does not open and just viewer is displayed and gives error that "PHYSICAL DATABASE NOT FOUND"

Please tell me the Files to be distributed with Package and Deployment Wizard to Install on other PC.

It' very urgent matter.
:confused: