Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
New User, Expression question
Message
De
25/07/2002 11:25:43
Darrin Hughes
Chena-Don Textiles and Armory
Jacksonville, Floride, États-Unis
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00682288
Message ID:
00682530
Vues:
12
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?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform