Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Forcing Report to draw extra detail rows
Message
 
À
03/11/2010 13:04:03
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
01487978
Message ID:
01488014
Vues:
66
>>>Hi,
>>>
>>>I have a report that must have 15 rows drwan even if 15 detail rows are not present in the driving cursor. The report layout I am duplicating has boxes in a grid format for the data to be filled in. How do I draw these boxes/lines for the "missing" rows?
>>>
>>>I can't just add in extra rows to the cursor as there are many groups that must be printed and each group prints on a new page, so I would have to add in extra rows for each group (which I guess I could do, but I'm hoping there is another way that might be easier).
>>
>>The solution is to add extra rows for each group. Each group mush have 15 rows - so, have a table with number from 1 to 15 and left join with your table.
>
>Suppose I can't add extra rows, what alternatives are there?


Not tested!!
1. Create a separate cursor with exactly 15 rows.
2. Add a variable that will count how many rows you have in main detail band.
3. Add new detail band based on newly created  cursor.
4. add all objects and make them "Float" 
5. In "Print When" put: RECNO(NewCursorAlias) < (15 - theCounterInMainDetBand). && Really hate that I must put PRE tag only for this row
6. Check Remove line if Blank.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform