sorry , yes i did mean customer 1, customer 2 .......etc

thanks for the reply i will try this in the morning

its a tablix which i have grouped by customer and hidden the detail row by using the row visability option

have a look at data driven subscriptions , i believe this will cover what you would like to achieve

Thanks for the reply but im getting the same result