Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
#$&*@ Report Designer
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00187082
Message ID:
00187088
Views:
23
I'm not claiming that this solution is better for performance, or anything but ease of maintenance. I find it better to do complicated setup work in the code which calls the report form, and keep the report form as simple as possible. (I hate debugging someone else's report when there are complicated formulas hidden in report variables and so forth.)

That said, if it were my problem, I'd try setting up the cursor that the report runs from so that there are enough blank records inserted into P.O. detail to give the correct size for that area in each P.O. Then you still have a fairly "normal" looking detail band which just has Qty, Descr, Price, and Total (or whatever you do specifically) on a single line, with an numbers set to show spaces rather than zeroes. And of course you put a single line under the single items in this simple detail band.

Of course, there may be better solutions!

HTH,
Rich.

>The customer wants the band that prints their purchase order line items to always be the same height, irregardless of the number of line items.
>
>They also want vertical separator lines that run through the line item "box" and connect the header and footer boxes.
>
>Here's the approach I'm going to try. Any alternative suggestions are most welcome:
>1. Define a report variable to count the number of line items.
>2. Call a UDF in the detail band On Exit expression and pass the line count and another variable by reference.
>3. In a text box in a footer below the detail band put a text box that streches. Bind it to the second parameter in step 2. Add vertical lines that strech to fill the footer band.
>4. The UDF will load the second parameter with the number of carraige return characters required to pad the "detail" section to the constant height.
>
>TIA.
>
>Frustrated in LA,
Rich Addison, Micro Vane, Inc., Kalamazoo, MI
Relax, don't worry, have a homebrew.
- Charlie Papazian, The New Complete Joy of Home Brewing
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform