Hey Darrin,

What happens if you just filter the result set as I spoke about earlier?

Pat.


>OOPS...
>
>Seems the boss was slightly unclear about which totals he wanted...
>
>The coding as it stands now is:
>
>

>REPORT FORM CDIPIU FOR LEFT(IN_STOCK,2) <> "LP" TO PRINTER
>

>
>Now I need it NOT to print any entry with an iutotal AND in_onhand equal to 0. iutotal tracks the number used over the course of the reporting cycle and in_onhand is just the number we have in the building. If either of them has a total other than zero I need the entry to print, but if BOTH are 0 I need to exclude it from the report...
>
>Help?
>
>
>>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?