Re: Subtotals in reports

Try

select employee_id,job,sum(reg_hrs) reg_hrs,sum(ovt_hrs) ovt_hrs,sum(dbl_hrs) dbl_hrs from table_with_data
group by employee_id,job;

( Prior to running set BREAK on employee_id in SqlPLus)

"Omar Malik" <obNOSPAMmar_at_hotmail.com> wrote:

>Hello
>Can someone please help me with this problem. I want to be able to get
>subtotals in reports. My report displays employee IDs, the jobs they worked
>on and the hours (standard, overtime, double time) they had for each job. I
>need to able to break the data into pieces so that the hours are subtotalled
>for each job in this manner.
>
> data (job 1)
> subtotal (hrs)
> data (job 2)
> subtotal (hrs)
>
>
> PAGE1
>
> data (Job 3)
> subtotal (hrs)
>
>
> etc..........
>Please let me know how to go about this.
>Thanks
>

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Fri Jul 06 2001 - 10:53:43 CDT