Here is my scenario;

I have a list of employees with certain certifications, I don't really care
what the details are of the certications just do they have them.

I have one employee record and many certification records for that one
employee. I need to report in a nice layout whether or not they have a
particular cert.

When I create a group I get a nice list of all the certs that this employee
has, but I want to display in a table format, with specific areas for each
cert.  Unfortunatly when I do this I only get the one record.

How can I do this?

Sorry if it is confusing.

Jay

Hi Jay,

I am not sure if I understand you correctly, but if I do understand you
correctly:
You want to create a group for the different sorts of certifications under
the group USER. (just show the group name (=certification name) in this
group.

In this way you get all the certifications from that person. If you define
the relationship between table_USER and table_Certifications as a so called
"Left outer join" you will e.g. see a person listed but without any
certifications.

I hope this help .. if not: I need more info.

Gregor.

Gregor,

Here is exactly what I am doing....

I have a section in my report with a list of Cert Names eg.
________________
|Cert Name   |         |
|CertA       | YES    |
|CertB       | NO      |
|CertC       | YES    |
---------------------

And so on and so on, but I am really only displaying 5 out of 100 possible
certs for now. Which is what I want.

What I currently am getting is;

|Cert Name   |         |
|CertA       | YES    |
|CertB       |            |
|CertC       |            |
---------------------

|Cert Name   |         |
|CertA       |            |
|CertB       | NO      |
|CertC       |            |
---------------------

|Cert Name   |         |
|CertA       |           |
|CertB       |            |
|CertC       | YES    |
---------------------

Group on the employee.
Suppress Details and Group Header.
In the group header initialize a shared string variable for each cert type.
In the Detail band have formulas that put Yes in the appropriate shared
Variable.
In the Group Footer print the employee info and a series of Shared Variables
This will give you:

Emp No       Cert A    Cert B   Cert C
    1             Yes
    2                            Yes        Yes
    3             Yes          Yes