hey Piotr,

I resolved the issue by using dynamic crosstab query concept.

by checking each userid with respect to groupid.

Anyways thanks a lot.

Cheers!

Sandy.