Board index » delphi » QR 3.0.8 grouping

QR 3.0.8 grouping

Hi

I'm trying to output results from a single table in a summarised format

The data is summarised by person, then by the jobs that person has worked on
that week. (there are many entries for the same job in any single week, but
I don't need the breakdown of these entries for this report.)

Name         Job No                 total Hours
----------------------------------------------------------
J.Smith      1234                             10
                   2345                             20
                   2854                             10
                               total                   40

etc per person.

All of this data is contained in one table. Each time I try to group and
sum with QR it returns zero for the first grouped job number. (There should
be a value greater than zero).

I've got the report looking right in terms of extracting the job codes per
person, but the sum facility returns a different value.
the demo grouped report has a master detail approach. How do I group via a
single query ?

Regards
Dave

 

Re:QR 3.0.8 grouping


Hi I have since noticed that the summary is "sort of" working, but one line
out (if that makes sense) ... any ideas ????

ie instead of this
Name         Job No                 total Hours
----------------------------------------------------------
J.Smith
                   1234                             10
                   2345                             20
                   2854                             10
                              total                   40

I get this ...

Name         Job No                 total Hours
----------------------------------------------------------
J.Smith
                   1234                             0
                   2345                             10
                   2854                             20
                              total                   40

The Total is correct!!! the week summary for the last job, becomes the first
total for the next employee.. what am I doing wrong ?

any ideas ???

Regards

Dave

Other Threads