Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Adding blank line every 5 detail rows
Message
From
20/10/2006 17:02:37
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Adding blank line every 5 detail rows
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01163756
Message ID:
01163756
Views:
47
Hi,

My client has a "payments" report that prints out yearly payments. They would like a blank line printed every 5 rows to make it easier to read. In the past pre-VFP9 I had written the routine to actually figure out how many detail lines would be on a page and then I would insert blank rows in the cursor. I did it this way because they did not want blank lines on the top of any pages and they wanted extra blank lines around certain "text" rows (e.g. "Starting payments of $2,000.00 a month...".

All of the above code was in the code that created the cursor. Under VFP9, I no longer seem to be able to reliably tell how many lines are going to print in the detail section of a report so I really don't know where I "am" on the page as it outputs. So I have been thinking of having the report writer insert the space. Options are:

1) insert a blank object above and below the "real" detail object and use some hook to the Print When to suppress the blanks when I don't want them; first attempt caused the detail band to grow even though I had "delete if blank" turned on for these blank objects

Has anyone else tried to do this? Looking for ideas before I burn up a lot of time on it.

Thanks,

Albert Gostick
Next
Reply
Map
View

Click here to load this message in the networking platform