Suppress extra detail rows 1

[ind123p]

I am using CR XI and Access 20000

My report is in the form of a letter. I have grouped on Customer Id.
In GH1 I have Customer Name, Address, City, State, ZIP and Subject.

I have no trouble with this report when customer has only one Home address.

If the customer has multiple home address I want to show only the first address. In the address table I have ADDRID and I have done a Record Sort on ADDRID.

MY PROBLEM:
In the details section I get the same detail rows that appeared for Adddr1.

For example

This is what I am getting

John Doe
24 Washington st,Chicago

1234 ABCDE
5678 PQRS
9876 WETH
1234 ABCDE
5678 PQRS
9876 WETH

This is what I am expecting

John Doe
24 Washington st,Chicago

1234 ABCDE
5678 PQRS
9876 WETH

How do I suppress the extra detail lines ?

 

[Madawc]

Do an extra level of grouping, by the 1234 ABCDE values. Show just the group header or footer of this group, suppresing the details.

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

 

[Madawc]

You could also do a formula suppression, {value} = Previous({value}), provided the details were sorted in the correct order (Report > Record Sort Formula). But grouping is better.

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

 

[ind123p]

Madawc,

You rock!!!

Your grouping solution works perfect for me..

Star for you!!!
thanks