Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to SELECT and group
Message
From
07/01/2004 21:05:58
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00864910
Message ID:
00864946
Views:
11
>You don't need second cursor for a report. Instead add a field with
>TaxAmount as an expression to a Summary band and select Sum under
>Calculations.

Sergey, i don't understand.....

Supose the report is like this,
Detail Line from my 1st cursor.... 
+--------+-----------+---------+--------+----+
| Art.   | Descrip.  | Pr.Unit | Quant. |Tax |
+--------+-----------+---------+--------+----+
  00001    ABC         12.23      2        1
  00002    CDS          9.33      1        3
  00003    C1           2.99      1        2
+--------+-----------+---------+--------+-----+

Footer Band with second select with total per TAX and another totals
+-------------+-----+       
| Tot TAX     | TAX |       
+-------------+-----+
| 100.00      |  1  |
|  80.00      |  2  |
|  20.00      |  3  |
|             |  4  | 
+-------------+-----+
| 200.00      |     |
+-------------+-----+
Thank's

João Batista
Previous
Reply
Map
View

Click here to load this message in the networking platform