SQL Server: Select query result in Tabular Format like Summary Report

Here I have created SQL script that full-fill your requirement.

I hope this will help you out.

SQL

DECLARE @Sheet AS TABLE(SheetName VARCHAR(5),ProcessDone CHAR(3),[Status] CHAR(8))

INSERT INTO @Sheet VALUES(1,'Yes','checked')
INSERT INTO @Sheet VALUES(1,'No','No')
INSERT INTO @Sheet VALUES(1,'Yes','checked')
INSERT INTO @Sheet VALUES(1,'Yes','No')
INSERT INTO @Sheet VALUES(1,'Yes','No')
INSERT INTO @Sheet VALUES(2,'Yes','No')
INSERT INTO @Sheet VALUES(2,'Yes','checked')
INSERT INTO @Sheet VALUES(2,'No','No')
INSERT INTO @Sheet VALUES(2,'Yes','checked')
INSERT INTO @Sheet VALUES(2,'Yes','No')
INSERT INTO @Sheet VALUES(2,'No','No')
INSERT INTO @Sheet VALUES(3,'No','No')
INSERT INTO @Sheet VALUES(3,'No','No')
INSERT INTO @Sheet VALUES(3,'Yes','No')
INSERT INTO @Sheet VALUES(3,'Yes','No')

SELECT SheetName
	  ,(COUNT(SheetName)) AS coscount
	  ,(SELECT COUNT(ProcessDone) 
	    FROM @Sheet 
	    WHERE ProcessDone='Yes'
		AND sheetName = s.SheetName
	   )AS [ProcessDone-Yes]
	  ,(SELECT COUNT(ProcessDone) 
	    FROM @Sheet 
		WHERE ProcessDone='No' 
		AND sheetName = s.SheetName
	   )AS[ProcessDone-No]
      ,(SELECT COUNT([Status]) 
	    FROM @Sheet 
		WHERE [Status]='checked' 
		AND sheetName = s.SheetName
	   )AS [Status-Checked]
FROM @Sheet s GROUP BY SheetName

Screenshot