Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Yikes! Same Report Twice on One Sheet of Paper???
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00664160
Message ID:
00664178
Vues:
72
This message has been marked as the solution to the initial question of the thread.
Since you have a group based on the Receipt number .. you can do it, but it's tricky.

You have to assume that all items in the detail band are butted tight up against the top of the detail band and there is no extra white space at the bottom of the detail band. You also have to assume that there are NO stretchable fields in the Detail band. And the big one ... no receipt can overflow to the next 1/2 page .. it must be contained in one half sheet.

If you can adhere to those rules .. create a report variable called nLines that is a Counter that resets at the end of each Receipt Number. In the Group Footer, add a field object with the following expression: REPLICATE(CHR(13), 99-nLines) .... where "99" is the maximum number of lines that can fit on a receipt. Mark this field as stretch with overflow. This forces enough blank lines in the group footer to make up for empty lines on the receipt.

This method makes a lot of assumptions .. especially the one about not overflowing to a second receipt form. If this isn't acceptable .. then you have to fudge a cursor to print from where it has exactly the right amount of detail lines for each "form" .. even if they are blank. But it still assumes that no fields are marked as stretch with overflow!

Cathy


>I have a report that is based on a parent-child relationship. It is a receipt grouped on the receipt number with detail items. It is 8.5 x 5.5 inches and used to print on perforated dot-matrix sheets. Now the users have purchased perforated laserjet sheets so I need the ability to print the same report twice on the same sheet of paper where the first printing will print at the top (already finished that part successfully) and the 2nd printing will start at just below the middle of the SAME page (which would be just below the perforation). I have not figured out how to do the 2nd printing yet. How to do this since you can only have 1 detail band? I already have 1 grouping also. Any ideas?
>TIA!!!!!
>Tracy
Cathy Pountney, Microsoft Visual FoxPro MVP
Memorial Business Systems, Inc. (www.mbs-intl.com)

My Website: (www.frontier2000.com)
My Blog: (www.cathypountney.blogspot.com)
My Book: The Visual FoxPro Report Writer - Pushing it to the Limit and Beyond
Free MSDN Article: What's New in the VFP 9.0 Report Writer
Free MSDN Article: The VFP 9.0 Report Writer In Action
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform