>I am trying to filter the records, like this.
>
>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
>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
>
>
> REPORT FORM ALLTRIM(thisform.file.Value)preview
>
>
>But in report i am not getting required result.should i changes some in report
The problem may be either 1. in the condition, or 2. in the report.
For 1., check the result, with a command like BROWSE NORMAL.
For 2. (if the cursor has the records you like), the problem is usually in the report DE. Open the report and eliminate all tables from the DataEnvironment.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
