Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
New User, Expression question
Message
From
25/07/2002 11:25:43
Darrin Hughes
Chena-Don Textiles and Armory
Jacksonville, Florida, United States
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00682288
Message ID:
00682530
Views:
10
Ok, that's ALMOST got it... it's giving me all the stock numbers that begin with "LP" and have a total of 0.

Just had to change it to the following:
REPORT FORM MyReport FOR LEFT(IN_STOCK,2) <> "LP" OR IUTOTAL <> 0 TO PRINTER
And that did it, thanks a lot!!! You just made my Christmas list.

>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?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform