Select rq.ReportName, rq.reportTitle,   
(CASE isComments  
          WHEN  0 THEN STR(ResponseTotal) 
          ELSE ResponseComments 
        END)as ReponseTotal,Sum(responseTotal) as YTD, 
  SUM(CASE rq.reportQTitle 
         WHEN rq.reportTitle in ('Homicide','Rape','Robbery') THEN responseTotal  
      END) as Total 
 
FROM ReportsData rd, ReportQuestions rq,ReportDataGroup rg  
WHERE rq.ReportQID = rd.ReportQID  
AND rd.ReportGroupID=rg.ReportGroupID 
AND rg.StartDate = '11/1/2009' 
AND rg.EndDate = '11/5/2009' 
GROUP BY rq.ReportName,reportTitle, responseTotal, ReportQOrder,isComments,responseComments 
ORDER BY reportQOrder