Hi Guys

I am fairly new to CR and would like some help on a report that has already been created and i need to amend it.

This is the layout of the report

@custname           @pickupaddress       @dropoffaddress          @fare
customer name        Pickup address          drop off address          32.00
customer name        pickup address          drop off address           32.00
customer name        pickup address          drop off address          32.00
customer name        pickup address          drop off address          20.00
customer name        pickup address          drop off address          10:00
customer name        pickup address          drop off address          120.00


What i want my report to look like is this

@custname           @pickupaddress       @dropoffaddress          @fare
customer name        Pickup address          drop off address          32.00
customer name        pickup address          drop off address          
customer name        pickup address          drop off address         
customer name        pickup address          drop off address          20.00
customer name        pickup address          drop off address          10:00
customer name        pickup address          drop off address          120.00

The first three records are apart of a group booking and what i want it to do is only show one fare for that group booking i.e 32.00, i have added a group to group the customers name by the groupbooking ID.

Can anyone HELP PLEASE

Or you can right click on the field - format field and click on suppress if duplicated

Dear grahamsurtees:

you can solve your problem by doing these steps:

Right click on your flield -> format field -> in commod tab choose suppress if duplicated