SELECT
	adr_Symbol as Symbol, 
	adr_Nazwa as Kontrahent, 
                dok_DataWyst as [Data wystawienia],
	dok_NrPelny [Numer dokumentu],
	isnull(Sum(ob_Ilosc * ob_CenaNetto),0) as [Wartość netto przed rabatem],
	isnull(Sum(ob_WartNetto),0) as [Wartość netto po rabatach],
	(isnull(Sum(ob_Ilosc * ob_CenaNetto),0) - isnull(Sum(ob_WartNetto),0)) as [Wartość netto udzielonego rabatu],
	'% udzielonego rabatu' = CAST((((isnull(Sum(ob_Ilosc * ob_CenaNetto),0) - isnull(Sum(ob_WartNetto),0))*100)/(isnull(Sum(ob_Ilosc * ob_CenaNetto),1)))as money)


FROM  dbo.kh__Kontrahent T0
JOIN dbo.adr__Ewid T1 ON T1.adr_IdObiektu = T0.kh_Id
JOIN dbo.dok__Dokument T3 ON T3.dok_OdbiorcaId = T0.kh_Id and dok_Typ = 2
JOIN dbo.dok_Pozycja T4 ON T4.ob_DokHanId = T3.dok_Id and ob_TowRodzaj in (1,8) 
WHERE     (adr_TypAdresu = 1) and dok_Status <> 2 and dok_DataWyst BETWEEN {DR:Data:}
Group by
adr_Symbol,
adr_Nazwa,
dok_NrPelny,
dok_DataWyst
Having
(isnull(Sum(ob_Ilosc * ob_CenaNetto),0) - isnull(Sum(ob_WartNetto),0)) <> 0
order by 
dok_DataWyst