Can't suppress duplicate data

[CrystalBox]

I use Crystal XI and ACCESS database.

My problem began when the database was modified to include an additional table. Before the additional table was added a typical report would look something like this: (only one item from the "Allegation" and "Basis" table per case could be selected, as shown below)

Case_No. Emp_Name #1 Emp_Name #2 Allegation Basis

001 J. Doe A. Doe Harassment Age
002 Z. Doe G. Doe Fail to promote Race 003 H. Doe R. Doe Discrim. Gender

Now, that the "Allegation" and "Basis" tables have been modified, I can select multiple items from these two tables. This is where I'm having problem with duplicates. Here's a sample of what the reports look like now:

001 J. Doe A. Doe Harassment Age
001 J. Doe A. Doe Demotion Age
001 J. Doe A. Doe Discrimination Gender

002 Z. Doe G. Doe Fail to promote Race
002 Z. Doe G. Doe Discrimination Race
002 Z. Doe G. Doe Retaliation Race

003 H. Doe R. Doe Discrimination Gender
003 H. Doe R. Doe FailToReinstate Medical
003 H. Doe R. Doe Discrimination Religion

This is what I would like to see on my report:

001 J. Doe A. Doe Harassment Age
Demotion Age
Discrimination Gender

002 Z. Doe G. Doe Fail to promote Race
Discrimination Race
Retaliation Race

003 H. Doe R. Doe Discrimination Gender
FailToReinstate Medical
Discrimination Religion

I tried using the "suppress duplicates" option, but it only is working on the case number.

I appreciate any help you can give me.

 

[CrystalBox]

Thanks for clarifying that. My first time using it.

Well I tried it and it works. Thanks again LB. Now I can submit my report.