Hi,
Try this...
SELECT c.[Contract], f.Area, dc.DeliverableCategory, d.DueDate, d.DueDateAdjusted, d.CompletedDate, d.PercentComplete, d.Comments
FROM tblDeliverables d LEFT JOIN
CommonData.dbo.tblContracts c on c.ConID = d.Contract LEFT JOIN
tblFunctionalAreas f ON f.FunID = d.FunID LEFT JOIN
tblDeliverableCategories dc ON dc.DelCatID = d.DelCatID LEFT JOIN
tblEmployeesResponsible e ON e.DelCatID = d.DelCatID
WHERE d.DueDate >= @Start AND d.DueDate <= @End
AND d.[Contract] = CASE WHEN @ConID IS NOT NULL THEN @ConID ELSE d.[Contract] END
AND d.FunID = CASE WHEN @FunID IS NOT NULL THEN @FunID ELSE d.FunID END
AND e.EmpID = CASE WHEN @EmpID IS NOT NULL THEN @EmpID ELSE e.EmpID END
Hope this will help you.
Cheers