Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Howto? Start a subtotal on a new page?
Message
From
03/09/2002 12:24:33
 
 
To
01/09/2002 14:09:13
Andrew Fell-Gordon
Calypso Publications Ltd
Enfield, United Kingdom
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00695618
Message ID:
00696274
Views:
13
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
Previous
Reply
Map
View

Click here to load this message in the networking platform