Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Forcing Report to draw extra detail rows
Message
 
To
03/11/2010 13:04:03
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
01487978
Message ID:
01488014
Views:
67
>>>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform