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?