VFP 8.
Client has a report with two memo fields, one placed vertically under
the other, in a page footer.
Page Footer "Constant Band Height" is unchecked.
Top memo is "Fix relative to top of band" and "Stretch with overflow"
Bottom memo is "Float" and "Stretch with overflow"
When the second is located under the first, vertically, the last line
of the second memo is cut off. When moved so each take up half the
width, the second memo starts at the second line of the first, and is
not cut off. Adding a CHR(13)+CHR(10) to the second memo has no
effect.
Simple code to reproduce:
CREATE TABLE testtext (mtext M)
INSERT INTO testtext VALUES ("Four score and seven years ago, our
fathers brought forth upon this continent a new nation"+;
", conceived in liberty and dedicated to the proposition that all men
are created equal.")
CREATE REPORT testtext
Place the two memos (both referring to mtext) in the footer and play
around with it. Ideas welcomed.
--
Ted Roche
Ted Roche & Associates, LLC
Author: Richard Kaye
Posted: 2005-10-19 14:55:52 Link
How about a single report object with the 2 memo fields in the
expression, separated by a CRLF. Alltrim both of them.
Ted Roche wrote:
>VFP 8.
>
>Client has a report with two memo fields, one placed vertically under
>the other, in a page footer.
>
>Page Footer "Constant Band Height" is unchecked.
>
>Top memo is "Fix relative to top of band" and "Stretch with overflow"
>
>Bottom memo is "Float" and "Stretch with overflow"
>
>When the second is located under the first, vertically, the last line
>of the second memo is cut off. When moved so each take up half the
>width, the second memo starts at the second line of the first, and is
>not cut off. Adding a CHR(13)+CHR(10) to the second memo has no
>effect.
>
>Simple code to reproduce:
>
>CREATE TABLE testtext (mtext M)
>INSERT INTO testtext VALUES ("Four score and seven years ago, our
>fathers brought forth upon this continent a new nation"+;
>", conceived in liberty and dedicated to the proposition that all men
>are created equal.")
>CREATE REPORT testtext
>
>Place the two memos (both referring to mtext) in the footer and play
>around with it. Ideas welcomed.
>
>--
>Ted Roche
>Ted Roche & Associates, LLC
>
>
[excessive quoting removed by server]
Author: Ken Watkins
Posted: 2005-10-19 15:04:27 Link
Ted -
I ran into something like this once.
The best I could do was use the line drawing tool
and place a small horizontal line between the two
paragraphs. Otherwise, VFP seemed to lose its sense
of location. It fixed my problem, not sure if it will
help yours.
Ken Watkins
Ted Roche wrote:
>VFP 8.
>
>Client has a report with two memo fields, one placed vertically under
>the other, in a page footer.
>
>Page Footer "Constant Band Height" is unchecked.
>
>Top memo is "Fix relative to top of band" and "Stretch with overflow"
>
>Bottom memo is "Float" and "Stretch with overflow"
>
>When the second is located under the first, vertically, the last line
>of the second memo is cut off. When moved so each take up half the
>width, the second memo starts at the second line of the first, and is
>not cut off. Adding a CHR(13)+CHR(10) to the second memo has no
>effect.
>
>Simple code to reproduce:
>
>CREATE TABLE testtext (mtext M)
>INSERT INTO testtext VALUES ("Four score and seven years ago, our
>fathers brought forth upon this continent a new nation"+;
>", conceived in liberty and dedicated to the proposition that all men
>are created equal.")
>CREATE REPORT testtext
>
>Place the two memos (both referring to mtext) in the footer and play
>around with it. Ideas welcomed.
>
>--
>Ted Roche
>Ted Roche & Associates, LLC
>
>
Author: Jean Laeremans
Posted: 2005-10-19 15:22:17 Link
On 10/19/05, Ted Roche <tedroche@gmail.com> wrote:
> VFP 8.
>
> Client has a report with two memo fields, one placed vertically under
> the other, in a page footer.
Just a WAG...place an invisible line between them
A+
jml
Author: Ted Roche
Posted: 2005-10-19 16:10:07 Link
On 10/19/05, Ken Watkins <kwat@floodcity.net> wrote:
> The best I could do was use the line drawing tool
> and place a small horizontal line between the two
> paragraphs. Otherwise, VFP seemed to lose its sense
> of location. It fixed my problem, not sure if it will
> help yours.
Funny, I thought I recalled something like that. I tried it, but no joy.
Richard: I've suggested that to a client and they want it the way they
want it, but will likely come around...
Author: Kevin Cully
Posted: 2005-10-19 18:48:53 Link
Could you place the contents of these memo fields into a two record
cursor and use VFP 9's multiple detail band capabilities to do the dirty
work for you?
Did that sentence make any sense at all? It's been a long day.
Kevin Cully
CULLY Technologies, LLC
kcully@cullytechnologies.com
http://www.cullytechnologies.com
Ted Roche wrote:
>On 10/19/05, Ken Watkins <kwat@floodcity.net> wrote:
>
>
>>The best I could do was use the line drawing tool
>>and place a small horizontal line between the two
>>paragraphs. Otherwise, VFP seemed to lose its sense
>>of location. It fixed my problem, not sure if it will
>>help yours.
>>
>>
>
>Funny, I thought I recalled something like that. I tried it, but no joy.
>
>Richard: I've suggested that to a client and they want it the way they
>want it, but will likely come around...
>
>
[excessive quoting removed by server]
Author: Ken Watkins
Posted: 2005-10-19 21:33:00 Link
On 10/19/05, Ken Watkins <kwat@floodcity.net> wrote:
>>> The best I could do was use the line drawing tool
>>> and place a small horizontal line between the two
>>> paragraphs. Otherwise, VFP seemed to lose its sense
>>> of location. It fixed my problem, not sure if it will
>>> help yours.
>>>
>>
>> Ted Roche wrote: Funny, I thought I recalled something like that. I
>> tried it, but no joy.
>
Ted -
Now I'm just scratching my head trying to remember.
Did you try using a text box with an empty var instead
of a line? I know it was something like that.
Ken Watkins
Author: Ted Roche
Posted: 2005-10-20 07:58:03 Link
On 10/19/05, Ken Watkins <kwat@floodcity.net> wrote:
> Did you try using a text box with an empty var instead
> of a line? I know it was something like that.
Yup. And Space(20). A line, black and white. I know there's a trick.
For this client problem, combining the memos in one field should serve
them fine.
--
Ted Roche
Ted Roche & Associates, LLC
Author: Ted Roche
Posted: 2005-10-20 08:08:48 Link
On 10/20/05, Richard Kaye <richard@rfcsystems.com> wrote:
> Wow... A client who tells you explicitly how to put objects in the
> frx... Micro-managing things a bit, eh?
>
> Ted Roche wrote:
>
> >Richard: I've suggested that to a client and they want it the way they
> >want it, but will likely come around...
> >
My clients are VFP developers. They can be a testy bunch ;)
Most of my VFP consulting these days is supporting other development
teams when they hit the wall on a particular topic: automation, email,
SourceSafe, MySQL, etc.. Sort of like ProFox, but with less sheep ;)
--
Ted Roche
Ted Roche & Associates, LLC
Author: Richard Kaye
Posted: 2005-10-20 09:22:05 Link
Wow... A client who tells you explicitly how to put objects in the
frx... Micro-managing things a bit, eh?
Ted Roche wrote:
>Richard: I've suggested that to a client and they want it the way they
>want it, but will likely come around...
>
>
--
Richard Kaye
RFC Systems
Voice: 973.761.0868
Fax: 973.761.4329
For the fastest response time, please send your tech support
queries to techsupport@rfcsystems.com
---------------------------------------------------------
---------------------------------------------------------