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
---------------------------------------------
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
---------------------------------------------