Please help - multiple records in report

  • Thread starter Thread starter Kerstin
  • Start date Start date
K

Kerstin

Problem 1)
I need to come up with a report for every single employee
(right now it shows one big report where it lists every
employee - guess I need like a page break between the
different employees?)

Problem 2)
For every employee I have 4 or 5 different data lines that
i need to show. Like this:

Joe Doe
1/1/1994 to 31/12/94 $15.00
1/1/1993 to 31/12/93 $25.00

Right now my report looks something like this:

Joe Doe
1/1/1994 to 31/12/94 $15.00

Joe Doe
1/1/1993 to 31/12/93 $25.00

I need to find out how to get all the related data from
one employee on one report without repeating the
unnecessary info like the name.

Can someone give me an easy and quick solution?

:-)

Tahnks so much!!!!
 
Kerstin said:
Problem 1)
I need to come up with a report for every single employee
(right now it shows one big report where it lists every
employee - guess I need like a page break between the
different employees?)

Problem 2)
For every employee I have 4 or 5 different data lines that
i need to show. Like this:

Joe Doe
1/1/1994 to 31/12/94 $15.00
1/1/1993 to 31/12/93 $25.00

Right now my report looks something like this:

Joe Doe
1/1/1994 to 31/12/94 $15.00

Joe Doe
1/1/1993 to 31/12/93 $25.00

I need to find out how to get all the related data from
one employee on one report without repeating the
unnecessary info like the name.
Click to expand...


Use Sorting and Grouping (View menu) to specify that you
want to group on the employee field. Specify Yes for the
group Header, then move the employee specific data to the
group header section. To get each emploee on a separate
page, set the group header section's Force New Page property
to Before Section.
 
I solved part of the problem from reading another answer
here on the board.

Now I still need to figure out 2 things. My report looks
like this now

Joe Doe
1/1/1994 to 31/12/94 $15.00
_________________________________________________________
1/1/1993 to 31/12/93 $25.00
_________________________________________________________
1/1/1994 to 31/12/94 $15.00

I got the duplicate names off but how do I get rid of the
lines inbetween the data now?

I also cant figue out how to add a page break after each
employee names data is listed.

Thanks for any help!
 
Use Sorting and Grouping (View menu) to specify that you
want to group on the employee field. Specify Yes for the
group Header, then move the employee specific data to the
group header section. To get each emploee on a separate
page, set the group header section's Force New Page property
to Before Section.
Click to expand...
Thank you soooo much - worked like a charm!
 
Look for a horizontal line in the header or footer of your
employee section. They are hard to see sometimes, try
moving the header/footer up and down to find it.

For the page break you want to go into the properties of
the employee header and "Force New Page" before the
section.
 
Back
Top