I'm having a little difficulty with the Group By and Sum Functions.  The following is SQL generated in Crystal:

 

 SELECT "tblLoads"."BillToName", "tblLoads"."LoadID", "tblLoads"."PickupDate", "tblLoads"."ConsCity", "tblLoads"."ConsSt", "tblLoadDispatch"."DriverPay"
 FROM   "EXP2000"."dbo"."tblLoadDispatch" "tblLoadDispatch" INNER JOIN "EXP2000"."dbo"."tblLoads" "tblLoads" ON "tblLoadDispatch"."LoadID"="tblLoads"."LoadID"
 WHERE  ("tblLoads"."PickupDate">={ts '2007-09-07 00:00:00'} AND "tblLoads"."PickupDate"<{ts '2007-09-08 00:00:00'})
 ORDER BY "tblLoads"."BillToName", "tblLoads"."LoadID"

 

I need to be able to have the records grouped by the LoadID field and then the DriverPay field summed.  Multiple records exist with a different value for DriverPay.

 

Can anyone help?

 

Thanks!!

 

Thanks for the help!  I added the Group and Summary to the report, moved the fields to the same line, and received the ouput I wanted.

 

The SQL, however, didn't generate the Group By clause.  How can I do that?  I was reading about creating an object and dropping the SQL in SQL Expressions field and tried some of that, but it didn't work.

 

Any ideas?

 

Thanks again for your direction!  It helped me get done what I needed to get done.

 

Ciao!

 

Where is Edit Query Functionality in Crystal?  I'm not finding anything in the Help Files.

 

Thanks,

SRK

 

BTW, that group by statement is what I want to do and then sum the tblLoadDispatch.DriverPay field.

 

To get to the "Perform Grouping on Server" go to the File menu and select "Report Options".  It's a check-box on this screen.  You'll also want to turn on "Use Indexes or Server for Speed."

 

If you want to set this for all new reports that you create, go to the File menu and select "Options", go to the Database tab and turn on the same two options that I mentioned above.

 

-Dell