SELECT E.*, EDS.NumDS+E.DSCHAR as DSZ, P.ProdKod,
Substring(P.ProdKod, 1 , 4 ) as Format,
M.ExpMade, E.Kolvo-ISNULL(M.ExpMade, 0 ) as Ost,Cnt.Country,TM.BegMade,TM.EndMade,
EDS.NumDS+' '+Cnt.RusCountry as OtchSt1,
 CASE E.Kolvo-ISNULL(M.ExpMade, 0 )
   WHEN  0  THEN 'Произведено'
   ELSE 'Не произведено'
 END  AS Status
FROM EXPORT E
LEFT JOIN ExpDS EDS
ON E.ID_DS = EDS.ID_DS
LEFT JOIN Customers Cus
ON EDS.ID_Cust = Cus.ID_Cust
LEFT JOIN Country Cnt
ON Cus.ID_Country = Cnt.ID_Country
LEFT JOIN Products P
ON E.ID_Prod=P.ID_Prod
LEFT JOIN (SELECT ID_Exp, Sum(Kolvo) As ExpMade FROM Made
WHERE ID_Exp IS NOT NULL
GROUP BY ID_Exp)M
ON E.ID_Exp = M.ID_Exp
LEFT JOIN (SELECT ID_Exp, Min(DatePr) As BegMade ,Max(DatePr) As EndMade FROM Made
WHERE ID_Exp IS NOT NULL
GROUP BY ID_Exp)TM
ON E.ID_Exp = TM.ID_Exp
WHERE E.ID_Exp IN
(SELECT DISTINCT ID_Exp FROM Made
WHERE ID_Exp IS NOT NULL AND
      DatePR >=  :DateBeg AND
      DatePR <=  :DateEnd )