Crystal Reports Multiple Rows problem

Message

   Hi All

I'm sure there is a really simple solution to the problem I am having but as yet I haven't found it.

I have a client table (one row per client) linked to a client orders table (one row per order so mulitple rows possible for each client). The client order table has an order type field completed for each order.

My report is displaying basic client data from the client table - id, name, gender, dob etc and I want to display a field which simply says True or False as to whether that client has a specfic type of order against them from the client orders table. I need my report to be kept to one line per client.

Currently I have just done a simple Iif statement... Iif(client_order_type ="MISC","TRUE","FALSE) but I am getting multiple rows returned. one row for every order and then the answer to the Iif statement after each row. As I am not showing the Order Type as a field in my report I wasn't expecting this to happen. 

Hope that made sense and someone out there can solve this for me.

Thanks