Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Count many records
Message
De
20/12/2003 12:09:07
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00860973
Message ID:
00860982
Vues:
22
>I use this command
>set filter to.....
>Count FOR alltrim(result)="Pass" To a
>Count FOR alltrim(result)="fail" To b
>
>c1 20 2
>c2 30 3
>c3 38 4
>c4 40 diffr
>c5 21
>c6 55
>c7 33
>c8 23
>c9 23
>c10 55
>
>all have diffrient pass/fail value.
>but in my report always
> pass fail
>c1 20 2
>c2 20 2
>c3 20 2
>c4 20 2
>c5 20 2
>c6 20 2
>c7 20 2
>c8 20 2
>c9 20 2
>c10 20 2

Hilmar will be back (inshallah:)
I think you would need to provide piece of code doing all these + report field expressions.

You don't need to do a series of set filter + count. Also Count command as you used places results in memory variables which you seem to named a and b (bad naming). If your report has expression as m.a and m.b they'd have scalar values from last count.

Have you tried 'select ... group by ...' ?
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform