Connection 9GrVL1h8QoFwbCUEdAB3r9104+9fbUpdy0wpyWF86zuNGJHvXWvCvEYV2Q== Connection DataSource1 30 DataSource1 Connection :p3,,112,20 :d1,,106,0 :d2,,106,0 SELECT s.id, s.EPONYMIA, kat.DNSH, kat.POLH, s.EPAGGELMA, s.AFM, kat.THL1, NVL (tz.res, 0) AS res FROM SUPL s, SUPL_KATASTHMATA Kat, ( SELECT SUM (RES) AS res, ID_PELATH FROM (SELECT ID_PELATH, CR_DATE, CASE WHEN -1 = :p3 THEN (PEL_XREOSI - PEL_PISTOSI) * SUNOLO WHEN 0 = :p3 THEN (PEL_XREOSI - PEL_PISTOSI) * (AJIA_FPA_0 + KATHARO_0) WHEN 1 = :p3 THEN (PEL_XREOSI - PEL_PISTOSI) * (AJIA_FPA_1 + KATHARO_1) WHEN 2 = :p3 THEN (PEL_XREOSI - PEL_PISTOSI) * (AJIA_FPA_2 + KATHARO_2) else 0 END res FROM ALL_PARASTATIKA INNER JOIN P_L_M ON (ALL_PARASTATIKA.ID = ID_PARASTATIKOY) INNER JOIN ANALISI_ANA_FPA_GR_L2 ON (P_L_M.ID = ID_MASTER) WHERE NOT EXISTS (SELECT 'x' FROM P_L_MA WHERE P_L_MA.ID_MASTER = P_L_M.id) UNION ALL SELECT ID_PELATH, CR_DATE, CASE WHEN -1 = :p3 THEN (PEL_XREOSI - PEL_PISTOSI) * SUNOLO WHEN 0 = :p3 THEN (PEL_XREOSI - PEL_PISTOSI) * (AJIA_FPA_0 + KATHARO_0) WHEN 1 = :p3 THEN (PEL_XREOSI - PEL_PISTOSI) * (AJIA_FPA_1 + KATHARO_1) WHEN 2 = :p3 THEN (PEL_XREOSI - PEL_PISTOSI) * (AJIA_FPA_2 + KATHARO_2) else 0 END res FROM ALL_PARASTATIKA INNER JOIN P_X_M ON (ALL_PARASTATIKA.ID = ID_PARASTATIKOY) INNER JOIN ANALISI_ANA_FPA_GR_X2 ON (P_X_M.ID = ID_MASTER) WHERE NOT EXISTS (SELECT 'x' FROM P_X_MA WHERE P_X_MA.ID_MASTER = P_X_M.id)) WHERE TRUNC (CR_DATE) BETWEEN ( :d1) AND TRUNC ( :d2) GROUP BY ID_PELATH) tz WHERE s.ID = Kat.ID_PROMHTHEYTH AND S.ID = Tz.ID_PELATH(+) AND KAT.IS_EDRA = 1 AND S.IS_DEFAULT_L = 0 EngineV2 None;Black;2;Solid;False;4;Black Transparent 467605c1cf9340be81f82d427492820d 1,1,1,1 Page1 29.7 21 Arial,100 [50:0:0:0] System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll Report 2/3/2014 10:30:42 AM 2/1/2014 8:51:02 PM D:\Report.mrt 6ba509b43e5c4d8ba4f93731340a45cf Report Centimeters 2013.2.1612 CSharp