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]