Actually, all I want to do is print the field in a report. We put lots of
comments in edit fields and I'd like for it to come out on a crystal report.
I presently use report builder to do this but there are some strategically
placed print interfaces that uses crystal. If I just place the field in the
report I get MAX LENGTH errors, if I use the formula I get if I use the sql
formula I get a 7520 ODBC error.
Shirley
-----Original Message-----
From: suki0112358 [mailto:gsukeforth@...]
Sent: Friday, May 03, 2002 11:47 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: [Off Topic] Crystal Reports - formula with memo
field
I think it works fine. Below is part of the SQL code for a report
that truncates the [Part.PartDescription] field. The report then
uses a parameter field to look for partial matches within the
substring. (Thanks to the person who pointed me to the SQL editor in
field explorer).
Maybe I'm missing something. This is way cool. If you really
want to get this working, you can e-mail me and I think we can work
it out.
00000000000000000000000000000000000000000000000000000000000000000
SELECT
PartOpr.OprSeq, PartOpr.WCCode, PartOpr.SubContract,
SUBSTRING((Part.PartDescription),1,255) <<<<<<<<<<<<<<<<<
FROM
Vantage.PartOpr PartOpr INNER JOIN Vantage.Part Part ON
PartOpr.Company = Part.Company AND
PartOpr.PartNum = Part.PartNum AND.............
WHERE
(SUBSTRING((Part.PartDescription),1,255)) LIKE '%7fa%'
0000000000000000000000000000000000000000000000000000000000000000000
:gs
comments in edit fields and I'd like for it to come out on a crystal report.
I presently use report builder to do this but there are some strategically
placed print interfaces that uses crystal. If I just place the field in the
report I get MAX LENGTH errors, if I use the formula I get if I use the sql
formula I get a 7520 ODBC error.
Shirley
-----Original Message-----
From: suki0112358 [mailto:gsukeforth@...]
Sent: Friday, May 03, 2002 11:47 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: [Off Topic] Crystal Reports - formula with memo
field
I think it works fine. Below is part of the SQL code for a report
that truncates the [Part.PartDescription] field. The report then
uses a parameter field to look for partial matches within the
substring. (Thanks to the person who pointed me to the SQL editor in
field explorer).
Maybe I'm missing something. This is way cool. If you really
want to get this working, you can e-mail me and I think we can work
it out.
00000000000000000000000000000000000000000000000000000000000000000
SELECT
PartOpr.OprSeq, PartOpr.WCCode, PartOpr.SubContract,
SUBSTRING((Part.PartDescription),1,255) <<<<<<<<<<<<<<<<<
FROM
Vantage.PartOpr PartOpr INNER JOIN Vantage.Part Part ON
PartOpr.Company = Part.Company AND
PartOpr.PartNum = Part.PartNum AND.............
WHERE
(SUBSTRING((Part.PartDescription),1,255)) LIKE '%7fa%'
0000000000000000000000000000000000000000000000000000000000000000000
:gs
--- In vantage@y..., "Troy Funte" <tfunte@e...> wrote:
> I have never successully gotten it to work either.
>
> Troy
>
> ----- Original Message -----
> From: Shirley Graver
> To: vantage@y...
> Sent: Friday, May 03, 2002 7:52 AM
> Subject: RE: [Vantage] Re: [Off Topic] Crystal Reports - formula
with memo field
>
>
> I've tried this method everytime this thread appears. I can get
it into the
> SQL fine, When I drop it on to the form and preview I get. ODBC
> ERROR:[MERANT] [ODBC PROGRESS DRIVER] [PROGRESS]Column not
> found/specified(7520). This hasn't been an urgent issue so I
havent really
> gone to the trouble to hunt down the solution.
> Shirley Graver
> Systems Administrator
> Rubber Associates Inc.
> Cleveland/Akron, OH
>
> -----Original Message-----
> From: deanestor [mailto:it@d...]
> Sent: Friday, May 03, 2002 6:10 AM
> To: vantage@y...
> Subject: [Vantage] Re: [Off Topic] Crystal Reports - formula
with memo
> field
>
>
> I have only just picked up this thread.
>
> David,
>
> you don't need to see the field in the list in the SQL
Expression
> Editor (Crystal doesn't display the blob/memo fields here, but
it
> will let you create an expression on that field, unlike
formulas).
>
> So, just create your expression and type in the field name and,
if I
> remember rightly, it will work.
>
> Anton Wilson
> Deanestor
>
>
>
> --- In vantage@y..., "David Sloan" <dsloan@e...> wrote:
> > I tried the first method last Friday. It would not work as I
could
> not get
> > the memo field in the list of fields in the formula editor as
it
> was over
> > 255 characters. Yes it should work, but you have to be able
to pull
> in the
> > field to use it in a formula, but to use it in a formula it
has to
> be 255
> > characters or less ---Catch 22
> >
> > Method 2 works well. You just have to remember to re-truncate
all
> fields
> > that you modify every time you do a database dump & load, or
> rebuild, or
> > upgrade to a new version.
> >
> > Regards,
> > David Sloan
> > Entech Integrated Technologies
> >
> > ----- Original Message -----
> > From: "Ted Kitch" <ted@m...>
> > To: <vantage@y...>
> > Sent: Wednesday, March 27, 2002 1:54 AM
> > Subject: RE: [Vantage] [Off Topic] Crystal Reports - formula
with
> memo field
> >
> >
> > > 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@m...
> > >
> > > -----Original Message-----
> > > From: sarah.vareschi@n... [mailto:sarah.vareschi@n...]
> > > Sent: Tuesday, March 26, 2002 9:28 AM
> > > To: vantage@y...
> > > 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=17
> 050071
> > >
> >
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]
> > >
> > >
> > >
> > > 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/.
> > > (2) To search through old msg's goto:
> > 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
> > >
> > > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
> > >
> > >
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
> 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/.
> (2) To search through old msg's goto:
> 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
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
>
>
>
> [Non-text portions of this message have been removed]
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
> 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/.
> (2) To search through old msg's goto:
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
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
>
>
>
> [Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
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/.
(2) To search through old msg's goto:
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
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]