Display data without duplicate records

[austin22]

I am using Crystal Reports 8.5 version.
I am working with two tables: 'Action Case Number' and 'Case Notes'. In the visual linking expert, the link is as follows: Action Case Number->Case Notes
The linking option is "left outer join".(there is no reference in the record selection formula for the 'Case Notes' table).

The report is grouped by Action Case Number and I have placed the Action Case Number in the 'Group Header' space and the actions and case notes in the 'Detail' space. The report looks like this if case has 2 notes and 3 actions:

Example #1

Case Number
Action 1
Note 1
Action 2
Note 1
Action 3
Note 1

Action 1
Note 2
Action 2
Note 2
Action 3
Note 2

When it should look like this:

Example #2

Case Number
Action 1
Action 2
Action 3

Note 1
Note 2

How do I get my report to display like Example #2

 

[lbass]

You need to tell us which table each field comes from. Is Action from the Action Case table?

-LB

 

[austin22]

Sorry about that...

The Case number and action fields are from the Action Case Table and the Notes field is from the Case Notes Table

austin22

 

[lbass]

I think your best bet is to use only one table in the main report --Action Case, and insert a subreport that uses the notes table in the group footer (case no), that is linked on the case no field.

-LB

 

[austin22]

Thank you for the suggestion...it worked out with the subreport.

Have a great day!

austin22