report display

  • Thread starter Thread starter galin
  • Start date Start date
G

galin

Hi guys,
I have a form that runs ID,Name,SUM of Pay Codes (such as
OVT,REG,VAC),FROM DATE...TO DATE. When I run the form I
achieve the desired result. Then I run a report.But what
I really need help is how to have all totals displayed on
a top or bottom of the report and have the date range in
the middle.
The reason I am asking that is when I run the form for a
period of two years for every single day I have the
name,ID and all totals repeating itself.It doesn't seem
very clear...

I need

ID,Name,TOTAL REG hours,TOTAL VAC hours,TOTAL OVT hours
on one row

and dates like
1999/11/12
1999/11/13
1999/11/14 ans so on after the first row

Thank you
 
galin said:
Hi guys,
I have a form that runs ID,Name,SUM of Pay Codes (such as
OVT,REG,VAC),FROM DATE...TO DATE. When I run the form I
achieve the desired result. Then I run a report.But what
I really need help is how to have all totals displayed on
a top or bottom of the report and have the date range in
the middle.
The reason I am asking that is when I run the form for a
period of two years for every single day I have the
name,ID and all totals repeating itself.It doesn't seem
very clear...

I need

ID,Name,TOTAL REG hours,TOTAL VAC hours,TOTAL OVT hours
on one row

and dates like
1999/11/12
1999/11/13
1999/11/14 ans so on after the first row
Click to expand...


I'd have to know more about the report's record source to be
sure, but it looks like you could just put the totals in the
Name/ID group header section. Use Sorting and Grouping
(View menu) to create a group with header.
 
Back
Top