The REPORT command accepts the same typical scopes that a SCAN does so you can code as follows:
REPORT FORM MyReport FOR LEFT(IN_STOCK,2) == "LP" AND IUTOTAL = 0 TO PRINTER PROMPT
Cathy
>Yep, get ready for it, I'm gonna say and ask some stupid things :-)
>
>I need to build an expression in a report but I don't know how to implement it. The program I have, mostly developed by a third party, prints out several reports from Cougar Mountain Accounting data files. The problem with the actual report is I need it NOT to print some entire entries, specifically any IN_STOCK numbers begining with "LP" and any entry that has a 0 total in iutotal. So the questions are:
>
>1: I know I need to modify the form to include the expresion to exclude, but do I need to place that expression in every field across the page, or just in the fields in question?
>
>2: How do I build said expression in the first place? Will logical functions work? Do I need to build it using some type of INLIST command, or somthing else?
>
>3: Did I just have thick for breakfast, or are these questions making any kind of sense?