Connection 9GrVL1h8QoFwbCUEdAB3r9104+9fbUpdy0wpyWF86zuNGJHvXWvCvEYV2Q== Connection DataSource1 30 DataSource1 Connection :p3,_x0020_int1,112,20 :d1,date1,106,20 :d2,date2,106,20 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 ,int1,int1,System.Int32,_x0031_,False,False ,date1,date1,,System.DateTime,,False,False,True,False,_x003C__x003F_xml_x0020_version_x003D__x0022_1.0_x0022__x0020_encoding_x003D__x0022_utf-16_x0022__x0020_standalone_x003D__x0022_yes_x0022__x003F__x003E__x003C_StiSerializer_x0020_version_x003D__x0022_1.02_x0022__x0020_type_x003D__x0022_Net_x0022__x0020_application_x003D__x0022_State_x0022__x003E__x003C_DateTimeType_x003E_DateAndTime_x003C__x002F_DateTimeType_x003E__x003C__x002F_StiSerializer_x003E_ ,date2,date2,System.DateTime,,False,False 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 5:44:28 PM 2/1/2014 8:51:02 PM C:\Users\Aris\Downloads\Report.mrt d22f3546351142929f07687bfb12a557 Report Centimeters 2013.1.1600 CSharp