Help needed with grouping in a report!!!

  • Thread starter Thread starter Amit
  • Start date Start date
A

Amit

Hi,

I'm still getting my toes wet re: reports, so will
appreciate any help.

I have a report to list the individuals partnering with a
program, and the projects they're working on. I'd like to
display the names of individuals and the projects they're
working on.

An individual can work on more than one project. When the
records are displayed, if an individual is working on more
than one project, his/her name is displayed twice.
There's already a group header for Program (a Program has
many-to-many relationship with individuals), and the
records are sorted on lastName, firstName and projectTitle
in that order.

How can I make the individual's name display only once and
then list the projects s/he is working on? Kinda create a
sub-group on (lastname, firstname) within each Program.
Also, the lastname and firstname fields are separate. I'm
not sure how to create a sub-group on the combination.

Here's what's happening:
==================================================
Program_1
----------
Individual_1 Project_1_1
Individual_1 Project_1_2
Individual_2 Project_1_3
Individual_3 Project_1_1
Individual_3 Project_1_2
Individual_3 Project_1_4

Program_2
---------
Individual_1 Project_2_1
.........

=================================================
=================================================

Here's how I would like to display the records:
=================================================
Program_1
----------
Individual_1 Project_1_1
Project_1_2
Individual_2 Project_1_3
Individual_3 Project_1_1
Project_1_2
Project_1_4

Program_2
---------

...........
=====================================================

Thanks!

-amit
 
Amit

Take a look at the properties of the "[individual]" control -- there should
be a HideDuplicates (or some such) which you can set.

Create a new, unbound control. Set its source to (actual syntax may vary):
= [YourLastName] & ", " & [YourFirstName]

Now you can remove the [LastName] and [FirstName] controls and work just
with the new, concatenated control.
 
Back
Top