SELECT Examtran.*; FROM examtran; where code>=thisform.codefm.value .and. code<=thisform.codeto.value ; .and. sec>=thisform.secfm.value .and. sec<=thisform.secto.value ; .and. scode>=thisform.shiftfm.value .and. scode<=thisform.shiftto.value ; .and. lcode>=thisform.levelfm.value .and. lcode<=thisform.levelto.value ; .and. year>=thisform.yearfm.value .and. year<=thisform.yearto.value; .and. nmonth>=thisform.nmonthfm.value .and. nmonth<=thisform.nmonthto.value; ORDER BY result; INTO CURSOR bbb SELECT bbb.*; FROM bbb; where code>=thisform.codefm.value .and. code<=thisform.codeto.value ; AND change1=1 AND bex=2; ORDER BY descr; INTO CURSOR bbbc REPORT FORM ALLTRIM(thisform.file.Value)previewBut in report i am not getting required result.should i changes some in report