Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Select for a Report
Message
From
10/03/2003 18:35:42
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00763620
Message ID:
00763996
Views:
19
Hi Sergey,

No, this group all balance in one record.

I give you an Ex this is what my table ficmmvp have, only these 3 records
in breaks are the values,
Customer (9999) movimento(05) Quantidade(100) Product(IS0001)..in
Customer (9999) movimento(55) Quantidade(050) Product(IS0001)..out
Customer (9999) movimento(05) Quantidade(250) Product(IS1000)..in
Customer (1000) movimento(05) Quantidade(150) Product(IS0001)..in
Report,
Customer 9999
Product    Stock
IS0001        50
IS1000       250

Customer 1000
Product    Stock
IS1000       150
so, in this case the report must have 3 lines (the select need to give 3 lines to do the report)

Thank's

João
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform