Hi thanks for your reply.

I managed to do what you have suggested.

I created many groups which caused the report not to be properly grouped.

Cheers