مشكلة هى تخلص فية عايز ريبوت يظهر فى بيانات مثالنا مستشفيات متعددة مثل معهد ناصر وهكذا انا عايز ومعا الفترة من الشهر الى الشهر ومن سنة الى سنة انا عايز يتم ضغط جميع الشهور والسنين فى سجل واحد اى record
دى جملة سيكول
SELECT SUM(TClinic.Neaft_City) AS 'Neaft_City', SUM(TClinic.Instrance) AS 'Instrance', SUM(TClinic.Concract) AS 'Concract', SUM(TClinic.Family) AS 'Family', " + " SUM(TClinic.Free) AS 'Free', SUM(TClinic.Case_Arab) AS 'Case_Arab', SUM(TClinic.Case_Forgien) AS 'Case_Forgien', LtMonth.Month, SUM(TClinic.Neaft_City) + SUM(TClinic.Instrance + TClinic.Concract + TClinic.Family + TClinic.Free + TClinic.Case_Arab + TClinic.Case_Forgien) AS TotalAll," + " SUM(TClinic.Total_Clinic1) AS 'Total_Clinic1', TClinic.MonthID, TClinic.YearNow, SUM(TClinic.Neaft_City) AS 'totalNeaft_City', SUM(TClinic.Instrance) AS 'totalInstrance', SUM(TClinic.Concract) AS 'totalConcract', SUM(TClinic.Family) AS 'totalFamily', SUM(TClinic.Free) AS 'TotalFree', SUM(TClinic.Case_Arab) AS 'TotalCase_Arab', SUM(TClinic.Case_Forgien) AS 'TotalCase_Forgien', LTHospt.HospNam " + " FROM LTHospt INNER JOIN LTDepHosp ON LTHospt.CodDep = LTDepHosp.CodDep INNER JOIN TClinic ON LTHospt.CodDep = TClinic.CodDep AND LTHospt.CodHosp = TClinic.CodHosp INNER JOIN LtMonth ON TClinic.MonthID = LtMonth.IDMonth " + " WHERE TClinic.CodDep =" + dropCent.SelectedValue + p_sql + " and TClinic.YearNow>=" + drpYear.SelectedValue + " and TClinic.YearNow<=" + drpyr3.SelectedValue + " GROUP BY TClinic.YearNow, TClinic.CodDep, TClinic.CodHosp, LTHospt.HospNam, LTDepHosp.NameDep, TClinic.MonthID, LtMonth.Month ORDER BY TClinic.CodDep,TClinic.CodHosp,Month(TClinic.MonthID) ";
