erro هنگام گزارش گيري

[dorna1985]

سلام
در cristal report با دو error مواجه مي شم و در حاليكه همون اطلاعات رو از پايگاه داده به در ستي مي بينم؟

run-time error '9'
subscript out of range
run-time error '3021'
either bof or eof is true, or the current record has been delete ,requested opration
requires a current record

[mpmsoft]

دوست عزیز لطف کنید کد مربوط به پاس دادن مقادیر به کریستال رو قرار دهید

[dorna1985]

من به كد برنامه دسترسي ندارم و فقط tsqlهاي مربوطه رو از profiler دراوردم كه دو دستور زير مربوط به error هاي بالاست


SET FMTONLY ON Select Kala.CodeKala, isnull(sum(SanadDetail.Qty*(Case Sanad.SanadTypeCode when 1 then 1 when 2 then -1 end)),0) AS Jam from SanadDetail Inner Join Sanad On SanadDetail.SanadCode=Sanad.Code Inner Join Kala On Kala.Code=SanadDetail.KalaCode Inner Join Places On Sanad.AnbarCode=Places.Code Inner Join Grooh On Places.GroohCode=Grooh.Code Where Sanad.Jdate<= '870730' And Cast(grooh.No As Int)>=1 And Cast(Grooh.No As Int)<= 26 And Kala.Codekala>= '00039931' And Kala.Codekala <= '99178606' Group
By Kala.CodeKala Order By Kala.CodeKala WHERE 1=2 SET FMTONLY OFF

SELECT PersonInfoMah.BimehPlaceCode As Mahal, Sum(BimehMah.JamNavizh) As JamNavizh, Sum(BimehMah.JamMashmol) As
JamMashmol, Sum(BimehMah.PersonPardakht) As PersonPardakht, Sum(BimehMah.KarfarmaPardakht) As KarfarmaPardakht, Sum(BimehMah.BikariPardakht) As BikariPardakht From Person Inner Join PersonInfoMah On Person.Code=PersoninfoMah.PersonCode Inner Join BimehMah on BimehMah.PersonCode=Person.Code Left Join Karkard On Karkard.PersonCode=Person.Code WHERE PersonInfoMah.BimehPlaceCode>=110000001 AND PersonInfoMah.BimehPlaceCode<=110000550 And Left(Ltrim(Rtrim(Person.Code)), Len(Ltrim(Rtrim(Person.Code))) - 7)=11 And Karkard.MaliYearCode= 91 And BimehMah.MaliYearCode= 91 And PersonInfoMah.MaliYearCode=91 Group By PersonInfoMah.BimehPlaceCode Order By PersonInfoMah.BimehPlaceCode