I have data within a table in the format below. I'm relatively new to SSRS but I believe what I want to achieve is possible. ServerName Name Category Occurence SQLSERVER001 Audit Backup/Restore Event 8 5 SQLSERVER001 Audit DBCC Event 8 15 SQLSERVER001 Audit Login Failed 8 10 SQLSERVER001 Audit Server Alter Trace Event 8 93565 SQLSERVER001 Data File Auto Grow 2 2075 SQLSERVER001 Hash Warning 3 55 SQLSERVER002 Log File Auto Grow 2 20 SQLSERVER002 Missing Column Statistics 3 280 SQLSERVER002 Object:Altered 5 1310 SQLSERVER002 Object:Created 5 27045 SQLSERVER002 Object:Deleted 5 110 SQLSERVER002 Server Memory Change 9 10 SQLSERVER002 Sort Warnings 3 10 I want to put together a SSRS report with a format like this SQLSERVER001 ServerName Name Category Occurence SQLSERVER001 Audit Backup/Restore Event 8 5 SQLSERVER001 Audit DBCC Event 8 15 SQLSERVER001 Audit Login Failed 8 10 SQLSERVER001 Audit Server Alter Trace Event 8 93565 SQLSERVER001 Data File Auto Grow 2 2075 SQLSERVER001 Hash Warning 3 55 SQLSERVER002 ServerName Name Category Occurence SQLSERVER002 Log File Auto Grow 2 20 SQLSERVER002 Missing Column Statistics 3 280 SQLSERVER002 Object:Altered 5 1310 SQLSERVER002 Object:Created 5 27045 SQLSERVER002 Object:Deleted 5 110 SQLSERVER002 Server Memory Change 9 10 SQLSERVER002 Sort Warnings 3 10 All the information is within a single table, but I can change the design to fit. Thanks in advance.

Hi, Below are the steps to achieve it. 1. Create a new dataset with the query in that dataset. 2. Now in the report design, drag and drop a tablix control. 3. Set the dataset to the table dataset properties. 4. Now group on ServerName field. 5. Select Group header and group footer checkbox for that group. 6. Select group header right click and select add row below within the group header header. 7. In the first row of the group header place ServerName field in the first column. 8. In the second row of the group header on the first column place "ServerName", in the second column place "Name", in the third column place Category", in the forth column place "Occurence". 9. In the detail row under the proper column place the appropiate field name. Hope its clear & helpful....Pavan Kokkula Tata Consultancy Services.

Thanks for the reply, I will have a go at it now. One thing that I have to point out is that the list of Servers must be drnamic, so the list can be 2 servers to start with, but could end up being 20. I do not want to have to go and start editing the report everytime I want to add a server to the list.