>I have a report (FoxPro) that has a table in the data env. The report works fine and reports all records (REPORT FORM reports\test.frx preview). But now I want to use the for clause and only report one record. IT DOES NOT WORK!!!! (REPORT FORM reports\test.frx For test.casenum == "CR00771" preview) I verified the record exist. Why doesn't this work?
>
>Thanks.
>
>:>
It's because you use double-equal sign. If two character expressions are compared with the == operator, the expressions on both sides of the == operator must contain exactly the same characters, including blanks, to be considered equal, i.e. both expressions should have the same length, and if you have Casenum e.g. C(10) it's longer than right part expression.
You may probably use "=".
Edward Pikman
Independent Consultant