Blob fields in Vantage 5.0/Crystal 8.5

Yahoo Archive
1
You can change the length of blob/memo fields in Vantage to be 255 or less, Crystal Reports will then let you use these fields in formulae.
I think the info was on the ERANet, if not, email me privately & I will see if I can find it here (My desk is a mess as I am moving locations)

Regards,
David Sloan
IT Manager
Entech Integrated Technologies

Phone: +61 8 8245 6789
Fax: +61 8 8245 6788
Direct Phone: +61 8 8245 6732
Postal Address: PO Box 1141, Marleston SA 5033
Site Address: 37 Belford Ave, Devon Pk SA 5008
================================
email: dsloan@...
Web: http://www.entechgroup.net
================================
----- Original Message -----
From: Troy Funte
To: vantage@yahoogroups.com
Sent: Tuesday, July 03, 2001 5:53 AM
Subject: [Vantage] blob fields in Vantage 5.0/Crystal 8.5


In Vantage 5.0, Part Descriptions are now blob/memo fields instead of string fields. Crystal 8.5 will not allow you to use memo fields in formulas. So now I can't select records based on Part Descriptions any more. Does anyone know of a workaround for this?

Troy Funte
Liberty Electronics



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


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 http://docs.yahoo.com/info/terms/




[Non-text portions of this message have been removed]
2
In Vantage 5.0, Part Descriptions are now blob/memo fields instead of string fields. Crystal 8.5 will not allow you to use memo fields in formulas. So now I can't select records based on Part Descriptions any more. Does anyone know of a workaround for this?

Troy Funte
Liberty Electronics



[Non-text portions of this message have been removed]
3
This is the best solution that I've seen. Anton Wilson posted this a while
back.

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
Misha1
ted@...

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Monday, July 02, 2001 3:24 PM
To: vantage@yahoogroups.com
Subject: [Vantage] blob fields in Vantage 5.0/Crystal 8.5

In Vantage 5.0, Part Descriptions are now blob/memo fields instead of string
fields. Crystal 8.5 will not allow you to use memo fields in formulas. So
now I can't select records based on Part Descriptions any more. Does anyone
know of a workaround for this?

Troy Funte
Liberty Electronics



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


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/.
<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!
<http://docs.yahoo.com/info/terms/> Terms of Service.


[Non-text portions of this message have been removed]
4
" 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."

When I enter the SQL expression editor, it doesn't give me the Part Description to choose from.

If I go to SQL Designer, I can't get the above statment to work. I get the old "Unable to understand after Declare" error when I process the SQL statement. Here is the complete Statement:

SELECT
Part.PartDescription,
Rtrim(Part.PartDescription),
Part.PartNum
FROM
vantage.Part Part

I also tried:

SELECT
Part.PartDescription,
fn SUBSTRING((Part.PartDescription),1,255),
Part.PartNum
FROM
vantage.Part Part

Any idea what I'm doing wrong?

Troy Funte
Liberty Electronics



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