I have a report in which a field was changed from
a small character field to a memo field. Some of
the memo fields contain a good deal of text, so this
field on the report needed to be changed to stretch:

http://www.proudviews.com/RptStretch.jpg

After changing the report field to stretch with overflow,
setting the vertical lines to stretch with the
band, and setting the line below the memo fied to
float, here is the result:

http://www.proudviews.com/stretch_new.jpg

The memo field now stretches as desired, but the
vertical lines are lost across a page break, and
very oddly, a field set not to print repeated
values is now showing repeated values.

Any input on ironing this out? I usually don't
use memos much in reports, so there may well be
some setting I'm missing to make this look right.

-- TRW
_______________________________________
t i m . w i t o r t
_______________________________________

Re: Report field stretching problems by Dan

Dan
Tue Mar 11 18:38:28 CDT 2008

Where do your vertical lines start and end? In the group header and footer?

Your repeating value can be kludged with a report variable set to count, and
reset on your group break expression. Use a Print When condition of
YourVariable=0.

Dan

Tim Witort wrote:
> I have a report in which a field was changed from
> a small character field to a memo field. Some of
> the memo fields contain a good deal of text, so this
> field on the report needed to be changed to stretch:
>
> http://www.proudviews.com/RptStretch.jpg
>
> After changing the report field to stretch with overflow,
> setting the vertical lines to stretch with the
> band, and setting the line below the memo fied to
> float, here is the result:
>
> http://www.proudviews.com/stretch_new.jpg
>
> The memo field now stretches as desired, but the
> vertical lines are lost across a page break, and
> very oddly, a field set not to print repeated
> values is now showing repeated values.
>
> Any input on ironing this out? I usually don't
> use memos much in reports, so there may well be
> some setting I'm missing to make this look right.
>
> -- TRW
> _______________________________________
> t i m . w i t o r t
> _______________________________________



Re: Report field stretching problems by Cathy

Cathy
Wed Mar 12 07:55:56 CDT 2008

- Make sure the vertical line starts at the very top of the band and goes to
the very bottom of the band.

- Check what the "Also Print" options are on the Print When screen for the
item that isn't supposed to repeat. It may be set to repeat when a band
overflows or something strange like that.

Other than that, it's hard to say what the problem is without seeing the
actual report. If you're still stumped .. and you can isolate the report and
some test data outside of your app .. feel free to zip it up and email it to
me and I'll take a look at it when I get a chance.

Cathy Pountney


"Tim Witort" <tim_witort@hotmail.com> wrote in message
news:Xns9A5EA299DC572timwitortwrotethis@216.196.97.131...
>I have a report in which a field was changed from
> a small character field to a memo field. Some of
> the memo fields contain a good deal of text, so this
> field on the report needed to be changed to stretch:
>
> http://www.proudviews.com/RptStretch.jpg
>
> After changing the report field to stretch with overflow,
> setting the vertical lines to stretch with the
> band, and setting the line below the memo fied to
> float, here is the result:
>
> http://www.proudviews.com/stretch_new.jpg
>
> The memo field now stretches as desired, but the
> vertical lines are lost across a page break, and
> very oddly, a field set not to print repeated
> values is now showing repeated values.
>
> Any input on ironing this out? I usually don't
> use memos much in reports, so there may well be
> some setting I'm missing to make this look right.
>
> -- TRW
> _______________________________________
> t i m . w i t o r t
> _______________________________________


Re: Report field stretching problems by tim_witort

tim_witort
Thu Mar 13 16:06:38 CDT 2008

Cathy Pountney seemed to utter in
news:A758A610-2E18-44B9-BE29-325C1A4F51B1@microsoft.com:

>
> "Tim Witort" <tim_witort@hotmail.com> wrote in message
> news:Xns9A5EA299DC572timwitortwrotethis@216.196.97.131...
>>I have a report in which a field was changed from
>> a small character field to a memo field. Some of
>> the memo fields contain a good deal of text, so this
>> field on the report needed to be changed to stretch:
>>
>> http://www.proudviews.com/RptStretch.jpg
>>
>> After changing the report field to stretch with overflow,
>> setting the vertical lines to stretch with the
>> band, and setting the line below the memo fied to
>> float, here is the result:
>>
>> http://www.proudviews.com/stretch_new.jpg
>>
>> The memo field now stretches as desired, but the
>> vertical lines are lost across a page break, and
>> very oddly, a field set not to print repeated
>> values is now showing repeated values.
>>
>> Any input on ironing this out? I usually don't
>> use memos much in reports, so there may well be
>> some setting I'm missing to make this look right.

> - Make sure the vertical line starts at the very top of the band and
> goes to the very bottom of the band.
>
> - Check what the "Also Print" options are on the Print When screen for
> the item that isn't supposed to repeat. It may be set to repeat when a
> band overflows or something strange like that.
>
> Other than that, it's hard to say what the problem is without seeing
> the actual report. If you're still stumped .. and you can isolate the
> report and some test data outside of your app .. feel free to zip it up
> and email it to me and I'll take a look at it when I get a chance.
>
> Cathy Pountney
>

Thanks, Cathy. That got me most of the way there. Since
I have a group in place, there is also a group header. So
the vertical lines needed to go up *through* the group header
bar until they were meeting the bottom of the page header
bar. This got the lines to continue as expected.

I still can't get the group field to display as desired.
Initially, the "Also print" options were set to "In first
whole band of a new page/column" and "when this group changes".
Unchecking the "In first whole band" checkbox removes the
undesired repetition shown in my example, but it also removes
the printing of that field at the top of a new page when
the group spans a page break. It's as if VFP considers both
the bands as the "first whole band"! Either the band that
stretched to the next page is the first whole band or the
band following it is, but certainly not both!

-- TRW
_______________________________________
t i m . w i t o r t
_______________________________________