Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Count many records
Message
From
20/12/2003 12:09:07
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00860973
Message ID:
00860982
Views:
23
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform