I couldn't get the Edit Field to wrap either. I took a look in the
forms design, and did not see any settings. We're running 3.0, so I
don't know if it is different in 4.0.
I remember a long time ago there was a discussion on this list regarding
printing out memos. Unfortunately, this was before we archived messages,
and at the time I wasn't using memos, so I didn't pay much attention. Now,
however, my controller has been suing AR memos to keep track of customers
reasons for not paying, etc. He DESPERATELY wants to see this on a report,
and I can not figure out how to accomplish this. I remember someone coming
up with a solution and I would love it if that person (I don't remember who)
would share it with me!!!
>printing out memos. .... wants to see this on a report,
>and I can not figure out how to accomplish this. I remember someone coming
Double click on the field in RB; in the alignment properties, you can
select word wrap. I think you may have to manually increase the height of
the record band line; also maybe play with the field width and format.
If anyone is interested we use memos quite a bit. I have a report that is
formated and works well. I will upload this report to the report builder
list in e groups under "MEMOS".
Shirley H. Graver
Systems Administrator
Rubber Associates Inc. (Certified to QS9000/ISO9002)
Cleveland/Akron, Ohio
>If anyone is interested we use memos quite a bit. I have a report that is
>formated and works well. I will upload this report to the report builder
I think she needs to join Memo and InvcHead. Unfortunately, the join
fields are different data types. Memo.Key1= string, and
InvcHead.InvoiceNbr = integer. I suggested Crystal might do it if you use
one of the type conversion functions as the join field. Can R.B. do that
at all?
Thanks, Wayne. After some playing, I have a solution using Access by
converting the data type of the string field in memo.key1 to a text, and
then joining that to the invoicehead table.
However, I hate using access for my reports because it goes through ODBC,
which means
(1) it is very unstable in vantage 4
(2) I have to run it myself or install ODBC on each users machine that needs
the report, which opens potential data issues if users figure out how to
modify data
So, if anybody knows a way to get in Report Builder to link the memo to the
invoice header, I would be very grateful!
"I suggested Crystal might do it if you use
one of the type conversion functions as the join field."
--------------------------------------------------------------
I would love to know how to do this - different problem but it might be the solution...
I need to convert a blob/memo field type to a string.
How do I do this in Crystal ?
thanks,
Anton Wilson
Deanestor Healthcare
Message: 22
Date: Fri, 22 Sep 2000 12:47:57 -0400
From: Wayne Cox <wmc@...>
Subject: RE: Memo Field on Report Builder Report
At 12:24 PM 9/22/2000 , you wrote:
>If anyone is interested we use memos quite a bit. I have a report that is
>formated and works well. I will upload this report to the report builder
I think she needs to join Memo and InvcHead. Unfortunately, the join
fields are different data types. Memo.Key1= string, and
InvcHead.InvoiceNbr = integer. I suggested Crystal might do it if you use
one of the type conversion functions as the join field. Can R.B. do that
at all?
-Wayne
[Non-text portions of this message have been removed]
Im having a small issue with an edit field in VB forms. When text is added
to the field it does not wrap around when it reaches the scroll bars. I
havent located any controls to edit the format for edit boxes. Is this a
bug or am I being a little dull today?
Shirley H. Graver
Systems Administrator
Rubber Associates Inc. (Certified to QS9000/ISO9002)
Cleveland/Akron, Ohio