>>>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).
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.