Crystal 2008 Beginner

[karmacop]

Hey Guys

I've recently started using Crystal 2008 to try and create reports from our companies job/client managment system.

Im querying 3 tables from the DB:

clients - client data (uid, name, address etc)

jobs - data for each job, (title, description, uid, client etc)

job_details - individual update for each job, i.e. client logs a job (a record is created in the jobs table), an engineer reponds to the job and adds a detail saying he has checked it out and adds a half hour to the detail, he then decides he needs to pass it over to 2nd line, who investigate the job more and add their own detail to the job with additional time on it etc.

Im trying to create a report that list each client on a seperate page, then on each clients page list all jobs opened for them over the previous month. I've gotten this far ok using a group based on each client, with each group starting on a new page, but the next part is stumping me.

I also want to include how many hours each job took, and then at the bottom, the total amount of hours used each month.
I've created a list of jobs for each client from the jobs table, but i now somehow need to add an addtional field showing the sum of the hours from any job_detail related to that job.

If someone could point me in the right direction id be most grateful

 

[lbass]

Add a group #2 on job. If you then right click on the job_details hour field and insert a sum at the job level and at the client level, do you get the correct result or is it inflated?

It might help to see a sample of data at the details level for one client with more than one job and with multiple records per job.

-LB