Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Count??
Message
De
07/08/2009 04:05:02
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Allemagne
 
 
À
07/08/2009 03:51:19
Paul Ong
Knights of Christ Foundation
Californie, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Titre:
Versions des environnements
Visual FoxPro:
VFP 8
OS:
Windows XP SP2
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01416689
Message ID:
01416690
Vues:
77
Paul,

lets see if I understand.

#1 you have a report
#2 you like to count the records where EMPTY(A)

"A" is a bad field name (A is workarea #1), lets use Field1

-you need a summary band on the report (assuming you will output the number and you now how to do)
-you need a variable
-Menu Report / Variables ...
-Add - enter a name (lets say "lnCount")
Initial = 0
Calculation type "None"
Reset at "Report"
Expression IIF(EMPTY(Field1),lnCount,lnCount+1)
Set release at report end
-in summary band add field lnCount

Assuming you will not display, its easier to use SQL SELECT or CALCULATE

Agnes
>hi all,
>
>again to mess up with you people, i have a simple question, i have a record that im sending to the report, say i have 5 records with fields a,b,c
>now on the report form i want to count the number of records where field a is not empty and omit those who are, however, count in the form seems to act different, correct me if im wrong, does it count the total no. of records sent into the report form? if so, is there a way to add an expression or a workaround just to count for fields not empty?
>
>thanks in advance
>
>Paul
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform