[Off Topic] Crystal Reports - formula with memo fie ld

Sarah,

You will find SQL expressions under "Insert" "Field Object". "SQL
expression Fields:" is located just below "Formula Fields:"

Jim Stetter
-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Tuesday, March 26, 2002 12:29 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] [Off Topic] Crystal Reports - formula with memo fie
ld


Thanks for posting your solution. This sounds like the best one, since I
wouldn't have to change anything in the db. However, I can't find the
'Create SQL Expression' function on the 'insert' menu (or anywhere else)
in
crystal. I'm not sure why, I am on crystal 8.5.0.217. What version are
you
using?





[Non-text portions of this message have been removed]
Tech Support has a document that tells you how to change the actual field
size in the database from 1000 down to 250. Crystal will recognize a memo
field for a formula if its under 250. We tried this and it works very well.
The only thing to remember is if you change the size of a field and you run
the IDXBUILD it will reset the field size back to 1000. Just remember to
change it back to 250 again if you run IDXBUILD.

Sue Howard
Information Specialist
Image National, Inc.
sueh@... <mailto:sueh@...>


-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Tuesday, March 26, 2002 8:28 AM
To: vantage@yahoogroups.com
Subject: [Vantage] [Off Topic] Crystal Reports - formula with memo field


I'm trying to use a 'memo' field (orderdtl.linedesc) in a formula in crystal
reports and it won't let me use it. Has anyone found a way around this?



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=219350.1849043.3355872.1269402/D=egroupweb/S=17050071
83:HM/A=935585/R=0/*http://www.gotomypc.com/u/tr/yh/grp/300_1b/g22lp?Target=
mm/g22lp.tmpl>

<http://us.adserver.yahoo.com/l?M=219350.1849043.3355872.1269402/D=egroupmai
l/S=1705007183:HM/A=935585/rand=569371078>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
All credit for this goes to Anton Wilson for posting this fix for this
particular problem.

To those of you who use Crystal with ODBC, and have hit the problem of
Crystal being unable to use a field of over 255 characters (memo or blob
field) in a formula, I have discovered 2 good solutions.


1 - I discovered this today, and it was right in front of my nose all along.
It's by far the simplest solution and I'd recommend it.

Go into the "Insert" menu in Crystal. Select "Create SQL Expression". From
here you can either do an RTrim, or more safely, do a "{fn
SUBSTRING((field.name),1,255)}" - this ensures that the field is no longer
than 255 characters.

From there you can include the SQL expression in formulas.


2 - The second option is to edit the length of the field in question,
directly in the Progress database.

I recommend doing a search on Epicor's ERAnet for "memo fields" or some such
search string, to locate their instructions on this.

But for your information you will need to edit the Vantage session file
(vantage.vtg) according to those instructions and save the modified version
as a different file.

Create yourself a shortcut (and make sure only the right person has access
to it!) and run the program. This gets you into the database and you can
change the format of any field in Vantage.

In all honesty I'm not sure that this is necessary though. Using an SQL
Expression in Crystal is a much cleaner, safer solution.



Hope that helps!


Anton Wilson,
Systems Analyst,
Deanestor Healthcare

Ted Kitch
ted@...

-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Tuesday, March 26, 2002 9:28 AM
To: vantage@yahoogroups.com
Subject: [Vantage] [Off Topic] Crystal Reports - formula with memo field

I'm trying to use a 'memo' field (orderdtl.linedesc) in a formula in crystal
reports and it won't let me use it. Has anyone found a way around this?





Yahoo! Groups Sponsor


ADVERTISEMENT

<http://rd.yahoo.com/M=219350.1849043.3355872.1269402/D=egroupweb/S=17050071
83:HM/A=935585/R=0/*http:/www.gotomypc.com/u/tr/yh/grp/300_1b/g22lp?Target=m
m/g22lp.tmpl>


<http://us.adserver.yahoo.com/l?M=219350.1849043.3355872.1269402/D=egroupmai
l/S=1705007183:HM/A=935585/rand=569371078>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.


[Non-text portions of this message have been removed]
I think my problem is because I am not using ODBC, but rather just modifying
the Vantage Sales Order form using the dbf's. I have tried unsuccessfully
to search ePortal for the document on changing the field size and have
placed a call with tech support and am awaiting feedback.

Thanks for all the help.
Unfortunately, from my trials today, I found that neither of these
suggestions will work when modifying a form that uses the dbf's (not thru
ODBC). If anybody has found another way around this that would work with
modifying standard forms that use dbf's, I would love to hear it.



[Non-text portions of this message have been removed]
Sarah not sure of what your trying to do. This looks like a pretty involved
solution that might work. I have not played with it.

http://support.crystaldecisions.com/library/kbase/articles/c2007285.asp
<http://support.crystaldecisions.com/library/kbase/articles/c2007285.asp>

Good Luck

Dan Shallbetter
States Electric Mfg.


-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Tuesday, March 26, 2002 2:13 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] [Off Topic] Crystal Reports - formula with memo fie
ld


Unfortunately, from my trials today, I found that neither of these
suggestions will work when modifying a form that uses the dbf's (not thru
ODBC). If anybody has found another way around this that would work with
modifying standard forms that use dbf's, I would love to hear it.






[Non-text portions of this message have been removed]
Thanks for posting your solution. This sounds like the best one, since I
wouldn't have to change anything in the db. However, I can't find the
'Create SQL Expression' function on the 'insert' menu (or anywhere else) in
crystal. I'm not sure why, I am on crystal 8.5.0.217. What version are you
using?



[Non-text portions of this message have been removed]