Memo fields - Printing in Report Builder and Crystal

Use "SQL Expressions". The substring command can be used to extract any
number of characters from the field.

If you extract 255 or less characters, you can include the result of the
expression in regular crystal formulas - thus converting the field from a
memo to a string.

Anton Wilson,
Systems Analyst,
Deanestor Healthcare
www.deanestor.co.uk

------------------------------------
Message: 23
Date: Wed, 28 Mar 2001 11:12:12 -0500
From: "Jim Carnes" <jcarnes@...>
Subject: Memo fields - Printing in Report Builder and Crystal

I'm trying to create a report for someone pulling from the Podetail.comments
field. When I open it in RB or Crystal it only shows a length of 8. I'm
assuming there is a link to the memo table and memocat table but I can't
find the link. I've read through the archives and have downloaded the
memo.prl file but I don't see any Podetail memo information. I did remove
the filters and I still didn't get any of the podetail detail. I know this
has been hashed over a million times and I hate to bring it up again.

Secondly, I'm can't imagine that there isn't a way to do this in Crystal.
Does anyone know how to modify the field length? I could swear I've done it
before.

Thanks

Jim Carnes
jcarnes@...
Kenlee Precision Corporation
1700 Morrell Park Ave
Baltimore, MD 21230
410-525-3800 x132
---------------------------------------------
I'm trying to create a report for someone pulling from the Podetail.comments
field. When I open it in RB or Crystal it only shows a length of 8. I'm
assuming there is a link to the memo table and memocat table but I can't
find the link. I've read through the archives and have downloaded the
memo.prl file but I don't see any Podetail memo information. I did remove
the filters and I still didn't get any of the podetail detail. I know this
has been hashed over a million times and I hate to bring it up again.

Secondly, I'm can't imagine that there isn't a way to do this in Crystal.
Does anyone know how to modify the field length? I could swear I've done it
before.

Thanks

Jim Carnes
jcarnes@...
Kenlee Precision Corporation
1700 Morrell Park Ave
Baltimore, MD 21230
410-525-3800 x132
Easy as pie. Insert the comments field into your report, Right Click,
Select format, change "X(8) to "X(200) in the Character format field. Set
your width to 80 or so. Say OK to that then go to ALIGNMENT and select
"wrap". "Comments" is really not part of memo's

Shirley Graver
(End User)
Sys Admin
Rubber associates Inc.
Cleveland/Akron

-----Original Message-----
From: Jim Carnes [mailto:jcarnes@...]
Sent: Wednesday, March 28, 2001 11:12 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Memo fields - Printing in Report Builder and Crystal


I'm trying to create a report for someone pulling from the
Podetail.comments
field. When I open it in RB or Crystal it only shows a length of 8. I'm
assuming there is a link to the memo table and memocat table but I can't
find the link. I've read through the archives and have downloaded the
memo.prl file but I don't see any Podetail memo information. I did remove
the filters and I still didn't get any of the podetail detail. I know
this
has been hashed over a million times and I hate to bring it up again.

Secondly, I'm can't imagine that there isn't a way to do this in Crystal.
Does anyone know how to modify the field length? I could swear I've done
it
before.

Thanks

Jim Carnes
jcarnes@...
Kenlee Precision Corporation
1700 Morrell Park Ave
Baltimore, MD 21230
410-525-3800 x132



Yahoo! Groups Sponsor

Click Here to Find Software Faster


To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
At 11:12 AM 3/28/2001 , you wrote:
>I'm trying to create a report for someone pulling from the Podetail.comments
>field. When I open it in RB or Crystal it only shows a length of 8. I'm

Progress somehow has the ability to override the default format and cram a
whole bunch o' text in apparently small fields. In R.B., double click on
the field, set the format & width to something wider than 8, then double
click the alignment options and select "word wrap."

In Crystal, look for a "Can Grow" check-box in the formatting.

>assuming there is a link to the memo table and memocat table but I can't

The memos are a whole different story, and unfortunately can not really be
joined in R.B. The Memos.prl you mentioned is an interesting & creative
hack - it forces report builder to look at EVERY invoice memo for each
invoice, and then use conditional line printing to only include the
appropriate memos. Performance is terrible with this brute force,
non-indexed approach, and is gets exponentially worse as your database
grows. But it does work.

-Wayne Cox