Hi, How do I create the below as an SSRS table? In the Matrix I added Person to the Column field. How do I add Address, Phone, Email to the matrix? Thanks. Table format I want is... Person1 Person2 Person3 Address valuex valuey valuez Phone valuep1 valuep2 valuep3 Email valueE1 valueE2 valueE3 SQL Query... SELECT Person, Address, Phone, Email FROM Contacts

Hi, Your query should be like below: SELECT Person ColGrp, 'Address' RowGrp, Address DetailVal FROM Contacts UNION ALL SELECT Person, 'Phone', Phone FROM Contacts UNION ALL SELECT Person, 'Email', Email FROM Contacts ORDER BY Person, RowGrp In the report design 1. Take a matrix control and assign the dataset. 2. For Row grouping group on Fields!RowGrp.Value 3. For Column grouping group on Fields!ColGrp.Value 4. For detail cell place the expression as =Fields!DetailVal.Value Hope its clear & helpful....Pavan Kokkula Tata Consultancy Services.