Thanks for your help. I didn't think that it was possible but just wanted to be sure. I settled for a tool-tip and user training.

Forum Newbie

I am having the same problem and would like to hear in more detail, how you were able to populate every matrix cell. How did you build your...

Great idea. I'll take care of it. Thanks for everyone's help.

Thanks for your quick response. There was a trigger on the table that was giving me the error. I disabled it and now it works.

Thank you very much for your quick and helpful replies. I'm set.

Thank you for your reply. Unfortunately it didn't work. I decided to include the empid in the dataset and filter on that and now it is working. ...

Thanks!  FOR XML PATH is exactly what I was looking for.  Here is the new solution using FOR XML PATH rather than the user defined function.

select count(CustomerId) as...

Thank you very much for your reply.  The explanation helps.  I knew that there wasn't a concatenating aggregate, which is why I wrote the function, but I thought that I...