Record in Multiple Groups

[ncollingham]

I am creating a report in Crystal Reports 11 that needs to have a single record in each group it is associated with, for example I have the following:

Name Memberships
Ricki aaa, bbb, ccc
Nick aaa
Nate aaa, ddd
James bbb, ccc

I need to group it by memberships and display the user in each group it is a member of. To make things more difficult, the memberships are a comma separated value in the database (DB2). I am using the native DB2 unicode connection to the DB. Is this possible?

 

[Madawc]

Awkward. Crystal assumes that each detail belongs in just one group.

One solution would be to do a separate subreport for each group, showing all details that are in that group. If you don't already know how to use subreports, use SEARCH or your own HELP function to get details.

Subreports make a lot of work for computers, but save time for humans. You decide which is more important for your particular circumstances.

Where I work, we go to a lot of trouble to make our mainframe screens and reports run efficiently. We use Crystal mostly for investigations and management information, cases where it doesn't much matter if a job takes twice as long because the user can be doing something else in the meantime. For a big Crystal report that is run frequently, it would be worth going to some trouble to make it efficient. In other cases it makes sense to save programmer-time.

Madawc Williams (East Anglia, UK)