How does one keep the upper level grouping items from disappearing when their lowest level detail group has no records? For example if my highest level group is YEARS and the next-highest level is SALESPERSON, I want all years and all salespeople to be displayed whether or not there are any detail records for them. I'm guessing that I will have to hard code all the years and names into lefthand columns and then find some way (with a variable or parameter or something) to tell the detail rows which rows to return. Perhaps there is an example of this somewhere? Any help will be much appreciated.HomeCookN

Hi HomeCookN, Based on your scenario, I think you have to hard cod it to return all the records you needed in the database using the T-SQL, as matrix could only display the data records retrieved from the database. So here I would recommend you submit a feedback to the Microsoft Connect at this link https://connect.microsoft.com/SQLServer/Feedback This connect site is a connection point between you and Microsoft, and ultimately the larger community. Your feedback enables Microsoft to make software and services the best that they can be, and you can learn about and contribute to exciting projects. Regards, Challen Fu Challen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Thanks Challen. I've never heard about MS Connect before. I'll check into it.HomeCookN