Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creeping (downward) 'Page header' band
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01174906
Message ID:
01174976
Views:
8
Thanks a whole bunch.

This is why my vote for UT member of the year has always included you in my list.


>Hmmm .. it appears to be a bug in the report writer (although MSFT may consider it "by design". I tested it in VFP 9 and the same problem occurs. If a field is stretchable and Constant band height is chosen, the field doesn't get stretched.
>
>Try taking a different approach. Create one field object on the report and make it tall enough to accomodate all the address stuff. Use an expression to combine all the fields the way you want. A little know trick in the report writer is to use a ";" and a "," between fields like this:
>
>Addr1;Addr2;City,State,Zip
>
>The ";" tells the report writer to add a CRLF between the two fields as long as the first field isn't blank. The "," tells the report writer to trim the two fields on either side, and then add a space between them .. but not if the first field is blank. So the above expression would get you the following if Addr2 is blank:
>
>Addr1
>City State Zip
>
>and it would get you the following if addr2 is filled in
>
>Addr1
>Addr2
>City State Zip
>
>
>
>
>
>
>
>>>First of all, keep in mind that the title band only prints on the first page. So if your report is more than one page long, the title band won't print on page 2 and the page header will start right at the top.
>>>
>>>Try marking the title band as "Constant Band Height" to see if that helps your situation. That should keep the title band at exactly the same height no matter what data "stretches".
>>
>>Wow! You are fast.
>>
>>While that does solve the problem described, it now seems to have the field of the address that has "Stretch on overflow" specified is no longer stretching. Where it has 3 short lines in it, only one is printing. In fact the band has 2 fields with "Stretch with overflow" checked and neither is printing more than a single line.
>>Any way to cure this?
>>
>>Thanks again.
>>
>>
>>
>>
>>>
>>>
>>>
>>>
>>>>My expertise with the Report Designer is limited at best.
>>>>
>>>>I've encountered a problem when amending a report to accommodate addition "Address" lines AND at the same time "fixing" a separator line at the bottom of the "Title" area.
>>>>
>>>>The "address" is printed in the "Title" area, with all four lines specified to "Float" and the second line also being "Stretch with overflow". Below the address are 3 lines that I attempted to keep in a FIXED position by specifying "Fix relative to top of band" for each of them.
>>>>All this seems to work exactly as I want.
>>>>
>>>>BUT the "Page Header" area creeps downward as the address' second field - the "Stretch with overflow" field - has more and more lines in it. When the data has a single line the "Page header" are is lower than expected but in a tolerable position. However, if the field has 2 lines the "Page header" area creeps down an additional line, and yet another line if the address has 3 lines in it.
>>>>
>>>>How do I stop this creeping?
>>>>I'd also like to have the "Page header" area always start printing at the place I appear to have placed it on the designer as opposed somewhere further down as it does now.
>>>>It may be relevant that there is also an image (company logo) in the "Title" area.
>>>>
>>>>Any help greatly appreciated.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform