multiple group behavior

[martinjt]

I have a question about multiple group behavior. I have two groups, Boards and Jobs. I need to show all active jobs and all boards for each individual. The outcome for someone who has 2 boards and 3 jobs is:
Board1
Job1
Job2
Job3
Board2
Job1
Job2
Job3
I need to have no more than the greatest multiple of rows on the report as there are of either group, so in this case it would be 3. The ideal outcome would be
Board1 Job1
Board2 Job2
Board2 (or blank) Job3
It's ok to repeat one of the boards (or be blank) but I need all of the data to appear. Another scenario would be if there were more boards than jobs in which case one of the jobs could repeat (or be blank) while all boards show. Make sense?

Using Crystal version 9.2.2.693 with Oracle database. Thank you.

 

[Madawc]

Looks like a crosstab. You find this function under 'Insert' and the software does most of the work for you.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[martinjt]

Thanks Madawc. I discovered that the very "problem" I was having was exactly what the requestor wanted! The end result afforded the most information as to board affiliations with industies:

Board1 Job1
Board1 Job2
Board1 Job3
Board2 Job1
Board2 Job2
Board2 Job3

But if I do need to consolidate like my initial strategy, I'll now consider crosstabs. Appreciate it!