Version 10: Grouping two things at once?

[TheElephantMan]

Good morning, all.

I have two reports, one that lists employee skills grouped by employee, another that lists employee projects grouped by employee:

(First Report)
Fred
Java
C
Jake
SQL
Visio
Jonas
None

(Second Report)
Fred
Warp Drive Development
Jake
None
Jonas
Compiler Design
Team Building

I'd like to merge the two reports into one, so that the final product looks like this:

STAFF SKILL(S) PROJECT(S)
Fred
Java Warp Drive Development
C
Jake
SQL None
Visio
Jonas
None Compiler Design
Team Building

I have a few tutorials on group design, but all of them assume that the items being grouped all have the same count. I am stymied as to how to create the group on my own.

Much thanks, in advance.

TEM

 

[pbateman]

You will need a link between which skill is required on each project.

 

[TheElephantMan]

Hello, all, again.

I fear I didn't really explain myself properly; the skills and the projects are not related to each other, only to the employee. Basically, I want to have a report that has three columns, grouped together:

Employee Name
Employee Skills Employee Projects
| |
V V

Skills and Projects don't have to be in a columnal format, just as long as they are grouped properly by the respective employees.

Thanks, again.

TEM

 

[pbateman]

I'd list Employee Skills in the main report and add the Employee Projects as a sub-report.

 

[lbass]

As Pbateman suggests, use the projects report as a subreport. Import it into the skills report and place it to the right in the skills report's employee group header_b section (Leave the group name in group header_a). Link the subreport to the main report on the employee field. Then go to the section expert and format the group header_b section to "Underlay Following Sections".

-LB

 

[Turkbear]

Hi,
Depending on the database used and the size of the tables, you may be better off creating a view the has both the skills and the projects for each employee and use that for the report ( it is better, in most cases, to do as much joining and other processing at the Database end rather than in Crystal)