Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Howto? Start a subtotal on a new page?
Message
De
03/09/2002 12:24:33
 
 
À
01/09/2002 14:09:13
Andrew Fell-Gordon
Calypso Publications Ltd
Enfield, Royaume Uni
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00695618
Message ID:
00696274
Vues:
10
Thank you, I will give that a shot today as well!

>I don't think you can do this in the report writer. I've alw3ays found it very obstinate if you try to make it do page throws that it is not planned for.
>
>You could get round the problem by creating a cursor that matches your data cursor but with an extra field to identify detail records from subtotals. Then copy your data into the cursor group by group, adding an identifier such as "A" in the extra field. At the end of the group add a new record (extra field = "B") that holds the subtotal values. So your cursor looks line this
>
>A - Detail record for group 1
>A - Detail record for group 1
>...
>A - Detail record for group 1
>B - Subtotal record for group 1
>A - Detail record for group 2
>A - Detail record for group 2
>...
>A - Detail record for group 2
>B - Subtotal record for group 2
>...
>
>Then you can group on the extra field and force a page throw on that group. You would then not do sub-totalling in the report but just print the values of the sub-total from the subtotal records.
>
>Of course this gives your report an overhead, particularly if the dataset you are printing is large. However i use this technique of creating specialised report cursors to create a number of oddball reports and it works well on small volumes of data.
>
>Best regards
>
>Andrew
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform