Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Previewing problems - group totals wrong
Message
De
09/09/2002 17:13:01
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Titre:
Previewing problems - group totals wrong
Divers
Thread ID:
00698523
Message ID:
00698523
Vues:
56
I have several old reports not using the report designer that print sub-totals and grand totals that have been accumulated to arrays. I did some cutting/snipping etc. and have a "sort of" sample at the end of this post. If I use the VFP preview feature detail records seem to be processed every time I page forward/backward in the preview. If I advance to a sub-total group the amounts are one thing. If I then back up a few pages and forward again to the sub-totals are different. As part of the group footer band, the final field is actually a call to a UDF that zeroes out the accumulated amounts stored in the arrays. Everything works fine when I print to the printer. I've tried printing to an ASCII file then doing a MODI FILE and that works OK but I have additional formatting problems to address and the report looks tacky -- though not quite as bad as the following cust&paste. Any suggestions out there regarding the previewing problems?
TIA
Scott

===============================
REPORT "SAMPLE"
===============================
[snip]
T TRAN CARDHOLDER # EXP. DT. AMOUNT
Y DATE SALES ORDER NUMBER CD TYPE TAX 1
===============================================
APPROVED & SETTLED TRANSACTIONS

K 08/01 ************1191 12/05 1.00
01RECUR01 VMCP 0.00

K 08/01 ************1191 12/05 2.00
01RECUR02 VMCP 0.00
[snip]
-----------------------------------
| APPROVED & SETTLED BY CARD TYPE |
|---------------------------------|
| CARD TYPE | # ORDERS | $ AMOUNT |
|-----------|----------|----------|
| AMX | 3 | -1.96 | << totals <<
| NOV | 2 | 2.00 | << accumulated <<
| VMC | 19 | 21.44 | << to an array <<
| VMCP | 7 | 4.05 | << & printed <<
|-----------|----------|----------| << here <<
| TOTALS | 31 | 25.53 |
-----------------------------------
------------------------------------------------
DECLINED TRANSACTIONS

K 08/01 ************1191 12/05 1.05
01RECUR03 VMCP 0.00

K 08/01 ***********1005 12/05 1.04
01RECUR04 AMX 0.00
[snip]
-----------------------------------
| DECLINED TOTALS BY CARD TYPE |
|---------------------------------|
| CARD TYPE | # ORDERS | $ AMOUNT |
|-----------|----------|----------|
| AMX | 8 | 8.47 | << totals <<
| NOV | 4 | 4.34 | << accumulated <<
| VMC | 8 | 8.74 | << to an array <<
| VMCP | 3 | 3.35 | << & printed <<
|-----------|----------|----------| << here <<
| TOTALS | 23 | 24.90 |
-----------------------------------
[snip]
TOTALS RECAP
----------------------------------------------
|CARD | APPROVED| PENDING| PENDING|DECLINED|
|TYPE |& SETTLED|APPROVAL|SETTLEMENT| |
|-----|---------|--------|----------|--------|
|AMX | -1.96| 0.00| 0.00| 8.47| << totals <<
|NOV | 2.00| 567.12| 19,000.00| 4.34| << accumulated <<
|VMC | 21.44|6,000.01| 0.00| 8.74| << to an array <<
|VMCP | 4.05|8,600.00| 2.00| 3.35| << & printed <<
|-----|---------|--------|----------|--------| << here <<
|TOTAL| 25.53|2,167.13| 19,002.00| 24.90|
----------------------------------------------
*** END OF REPORT***
Scott Ramey
BDS Software
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform