Print SAY and Memo Fields Together Report Writer. 1

[fp26guylearningvfp60]

Hi Fox Friends;

Ran into this bit of ugly yesterday. I have a report with 2 SAYs (Label) and 2 memo fields. I want to associate the SAY with the first line of the memo field. The memo field is defined as "float". In the report writer it looks something like this....

Desc1 MEMO1

Desc2 MEMO2

But when it prints, it looks like this.

Desc1 MEMO1
MEMO1
MEMO1
Desc2 MEMO1
MEMO1
MEMO1

MEMO2

Anway around this?
TIA - Wayne

 

[DSummZZZ]

Not unless you can predict how many lines the memo is going to occupy, since the memo floats but the label doesn't.
You could try adding the label to the memo and see if you like that. In the expression builder, do something like:

"Desc1 " + Memo1

Of course, it will occupy the same space but it might do what you need.

Dave S.

 

[ramani]

HI
1. May be you have to use ALLTRIM(MEMO1)
2. Also, if the DESC1 space is not enough, make sure the width is sufficient. Otherwise combine bot the fields and have DESC1+" "+ALLTRIM(MEMO1) and have a long field, if that helps.

ramani :-9
(Subramanian.G),FoxAcc, ramani_g@yahoo.com

 

[davidtoranzo]

Hi,

In the report writer that simply shouldn't happen. Verify:
* Double clicking MEMO field -> Relative position -> Above-variable height field checked,
* Double clicking DESC field -> Relative position -> Above-constant height field checked,
* Double clicking DESC field -> Relative position -> Above-constant height field checked,
* Double clicking detail band -> constant height band not checked,

Hope this helps!

David.