Suppress if not a Multiple Record

[Butlertl]

My requirement is to pull all remedy tickets, for a particular week, and that have multiple tickets for a single customer.

I have combined the Last Name and First Name and created a group based on the combined names.....

I used an INSERT Summary and a Count on each customer name.

I also have a Distinct Count total for customer names that have more than one ticket.

I want to select only those tickets that have multiple tickets for each customer and exclude tickets that are not multiple.

I have searched this list and have not found a solution. Thanks again for your suggestions.

T Butler

 

[lbass]

Insert a group on {@custname} and then go to report->selection formula->GROUP and enter:

count({@custname},{@custname}) > 1

-LB

 

[Butlertl]

Thanks....that worked.