Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Conditional printing
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00667045
Message ID:
00667663
Vues:
27
>>Do you mean limit the detail band to 12 records .. or do you mean that one detail record will stretch several lines and you want to limit how much it stretches on one page?
>>
>>For the first option .. create a variable that counts the lines on the report. Then set up a data group with an expression similar to the following:
>>
>>INT((nLine - 1) /12)
>>
>>Also, make sure the data group is marked as "Start on new page".
>>
>>If what you are asking is the second option I described .. then you're going to have to build a cursor and manipulate the data before hand .. in essence .. breaking up the data into one record for each "12-line" chunk of data.
>
>Cathy,
>Yes to the first option. Now would I put the RECNO() group inside the new group? or vice-versa?
>Thanks,


I think I'm confused now! Are you saying that one detail band (record) can stretch from one page to the next ... and you want to ensure that no more than 12 detail bands (record) appear on one page? If this is the case .. the 1st data group expression should be INT((nLine -1) /12) and then create a second data group with RECNO() as the expression.

But now I'm wondering if I'm not quite understanding your situation. Are you printing "continued" because one single detail band/record is overflowing to the next page .. or that additional detail bands (records) belonging to some logical group overflow to the next page. If it's the latter .. just change the RECNO() data group to be the logical group that you want to track.

If you want to try to keep the detail band (record) together .. and you can assume a certain amount of space for printing the record (such as 1"), try this: Create a data group on RECNO(), set the "Start on new page of less than" option to 1 (for 1 inch), and then move everything from your detail band into the Group Header or Footer band and leave the Detail band completely empty (set it to a height of zero).

Cathy
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