# Crystal Reports **Category:** [Yahoo Archive](https://www.epiusers.help/c/yahoo-archive/9) **Created:** 2001-05-04 09:30 UTC **Views:** 553 **Replies:** 8 **URL:** https://www.epiusers.help/t/crystal-reports/2785 --- ## Post #1 by @system
Troy, Steve, Wayne and Thad,

Thanks for the help. I finally got it working. Part of the problem was
picking the wrong field.

Sorry to have taken so long to get back to you , but other fires here were
chasing my back end.

Again, thanks a million!!

Dave Cole
Reeder & Kline





[Non-text portions of this message have been removed]
--- ## Post #2 by @system
Hi,

I need some help with Crystal Reports.

In the Part Master we use the Part Number field for out part number and the
Description field for the Customer Part number.

For example:
Part: 2400-055
Description: L47746P01 (Shaft, Aft, - Low Pressure Turbine Rotor)

All our parts are entered this way. I would like to be able to extract just
the first part of the description up to but not including the "(" to print
on some labels.

Thanks,

Dave Cole
Reeder & Kline




[Non-text portions of this message have been removed]
--- ## Post #3 by @system
Does every part description have the "(" in it?

Troy
----- Original Message -----
From: Cole, Dave
To: eManfacturing Yahoo Groups (E-mail)
Sent: Tuesday, May 01, 2001 2:00 PM
Subject: [Vantage] Crystal Reports.


Hi,

I need some help with Crystal Reports.

In the Part Master we use the Part Number field for out part number and the
Description field for the Customer Part number.

For example:
Part: 2400-055
Description: L47746P01 (Shaft, Aft, - Low Pressure Turbine Rotor)

All our parts are entered this way. I would like to be able to extract just
the first part of the description up to but not including the "(" to print
on some labels.

Thanks,

Dave Cole
Reeder & Kline




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


Yahoo! Groups Sponsor



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 the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
--- ## Post #4 by @system
If every description contains the "(" in it, then you can create a Function in place of the part.partdescription on your report. The function will be one line as follows:

left({part.partdescription},instr({part.partdescription},"(")-1)


HERE'S what the above line does...
---leaves only the part of the description to the left of the "("

instr({part.partdescription},"(")
---returns the position of the "(" in the string.


The InStr (str1,str2) function returns the position of the first occurrence of one string within another. This position is a 1 based index of the characters in str1. If str2 is not found in str1, the InStr function returns 0.

the LEFT(Str,Length) function obtain a certain number of characters from the left end of a text string. For instance, you could use the Left function to obtain just the area code from the values in a field containing phone numbers.
----- Original Message -----
From: Cole, Dave
To: eManfacturing Yahoo Groups (E-mail)
Sent: Tuesday, May 01, 2001 2:00 PM
Subject: [Vantage] Crystal Reports.


Hi,

I need some help with Crystal Reports.

In the Part Master we use the Part Number field for out part number and the
Description field for the Customer Part number.

For example:
Part: 2400-055
Description: L47746P01 (Shaft, Aft, - Low Pressure Turbine Rotor)

All our parts are entered this way. I would like to be able to extract just
the first part of the description up to but not including the "(" to print
on some labels.

Thanks,

Dave Cole
Reeder & Kline




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


Yahoo! Groups Sponsor



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 the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
--- ## Post #5 by @system
Dave,
Try this formula:

LEFT ( {Part.PartDescription}, INSTR ({Part.PartDescription}, '(' ) -
2 )

It gets a little confusing with all the parentheses, but here's the gist of
what's going on:
LEFT is a function that returns the first X number of characters from a
string (the left-most characters). It takes two parameters: the text you
want to copy from and the number of characters to return. You know what
text you want it to copy from but the number of characters will change from
part to part, so you need to use another function to get that number.
INSTR is a function that tells you the location of a character (or
characters) within a larger set of text. It also takes two parameters: the
text you want to search and the text you are looking for. This tells us how
far into the Part Description the left parenthesis is found, but that number
is too far for what you want so you subtract 2 from that answer which
removes the parenthesis and the space before it.

I hope this made sense.
Good luck!
================
Steve Sanders
Delta Centrifugal Corp.
-----Original Message-----
From: Cole, Dave [mailto:dave@...]
Sent: Tuesday, May 01, 2001 1:01 PM
To: eManfacturing Yahoo Groups (E-mail)
Subject: [Vantage] Crystal Reports.


Hi,

I need some help with Crystal Reports.

In the Part Master we use the Part Number field for out part number and
the
Description field for the Customer Part number.

For example:
Part: 2400-055
Description: L47746P01 (Shaft, Aft, - Low Pressure Turbine Rotor)

All our parts are entered this way. I would like to be able to extract
just
the first part of the description up to but not including the "(" to print
on some labels.

Thanks,

Dave Cole
Reeder & Kline




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


Yahoo! Groups Sponsor



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 the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
--- ## Post #6 by @system
At 01:00 PM 5/1/2001 -0500, you wrote:
> Description: L47746P01 (Shaft, Aft, - Low Pressure Turbine Rotor)
>All our parts are entered this way. I would like to be able to extract just
>the first part of the description up to but not including the "(" to print

Hey, Dang It! That's a GEAE number! I can't help you out, you darned
competitor, you!

Instr() might locate the "(". And Left() might chop up to that
position. Seriously, though... putting it in a user field or VB form
would be the better solution.

-WC
--- ## Post #7 by @system
Only the parts I ship to customers.

I tried using the "Instr" function to locate on the "(" and then the "Left"
function to extract from beginning of string to the number returned by
"Instr", but I don't ever get anything back even when I know for sure the
description contains the "(".

I am trying to create a Crystal shipping label and want the Customer's part
number on it.

Thanks,

Dave Cole
Reeder & Kline

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Tuesday, May 01, 2001 5:43 PM
To: vantage@...
Subject: Re: [Vantage] Crystal Reports.


Does every part description have the "(" in it?

Troy
----- Original Message -----
From: Cole, Dave
To: eManfacturing Yahoo Groups (E-mail)
Sent: Tuesday, May 01, 2001 2:00 PM
Subject: [Vantage] Crystal Reports.


Hi,

I need some help with Crystal Reports.

In the Part Master we use the Part Number field for out part number and
the
Description field for the Customer Part number.

For example:
Part: 2400-055
Description: L47746P01 (Shaft, Aft, - Low Pressure Turbine Rotor)

All our parts are entered this way. I would like to be able to extract
just
the first part of the description up to but not including the "(" to print
on some labels.

Thanks,

Dave Cole
Reeder & Kline




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


Yahoo! Groups Sponsor



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! Terms of Service.



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




[Non-text portions of this message have been removed]
--- ## Post #8 by @system
Try substituting the mid() function for the left function. it may not make
a difference but it's worth a try.

example:

MID( [partdesc] , (INSTR( [partdesc] , ")") - 1) )

where [partdesc] is the description field from the database.

also, try doing just

INSTR( [partdesc] , ")") to see if the parentheses character is being found.

also, try substituting a plain old positive integer for the instr function

MID( [partdesc] , 8 )

please let me know what the results are.

-----Original Message-----
From: Cole, Dave [mailto:dave@...]
Sent: Wednesday, May 02, 2001 11:33 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Crystal Reports.


Only the parts I ship to customers.

I tried using the "Instr" function to locate on the "(" and then the "Left"
function to extract from beginning of string to the number returned by
"Instr", but I don't ever get anything back even when I know for sure the
description contains the "(".

I am trying to create a Crystal shipping label and want the Customer's part
number on it.

Thanks,

Dave Cole
Reeder & Kline

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Tuesday, May 01, 2001 5:43 PM
To: vantage@...
Subject: Re: [Vantage] Crystal Reports.


Does every part description have the "(" in it?

Troy
----- Original Message -----
From: Cole, Dave
To: eManfacturing Yahoo Groups (E-mail)
Sent: Tuesday, May 01, 2001 2:00 PM
Subject: [Vantage] Crystal Reports.


Hi,

I need some help with Crystal Reports.

In the Part Master we use the Part Number field for out part number and
the
Description field for the Customer Part number.

For example:
Part: 2400-055
Description: L47746P01 (Shaft, Aft, - Low Pressure Turbine Rotor)

All our parts are entered this way. I would like to be able to extract
just
the first part of the description up to but not including the "(" to print
on some labels.

Thanks,

Dave Cole
Reeder & Kline




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


Yahoo! Groups Sponsor



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! Terms of Service.



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




[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/
--- ## Post #9 by @system
I'm thinking the double messages may be due to the delay -- in other words, I sent three messages last night, and when I didn't see them come through the list 2 hrs later, I sent them again thinking I must have done something wrong. Later on I saw both copies come across.

Troy

----- Original Message -----
From: Thad Jacobs
To: 'vantage@yahoogroups.com'
Sent: Wednesday, May 02, 2001 5:03 PM
Subject: RE: [Vantage] Crystal Reports.


Try substituting the mid() function for the left function. it may not make
a difference but it's worth a try.

example:

MID( [partdesc] , (INSTR( [partdesc] , ")") - 1) )

where [partdesc] is the description field from the database.

also, try doing just

INSTR( [partdesc] , ")") to see if the parentheses character is being found.

also, try substituting a plain old positive integer for the instr function

MID( [partdesc] , 8 )

please let me know what the results are.

-----Original Message-----
From: Cole, Dave [mailto:dave@...]
Sent: Wednesday, May 02, 2001 11:33 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Crystal Reports.


Only the parts I ship to customers.

I tried using the "Instr" function to locate on the "(" and then the "Left"
function to extract from beginning of string to the number returned by
"Instr", but I don't ever get anything back even when I know for sure the
description contains the "(".

I am trying to create a Crystal shipping label and want the Customer's part
number on it.

Thanks,

Dave Cole
Reeder & Kline

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Tuesday, May 01, 2001 5:43 PM
To: vantage@...
Subject: Re: [Vantage] Crystal Reports.


Does every part description have the "(" in it?

Troy
----- Original Message -----
From: Cole, Dave
To: eManfacturing Yahoo Groups (E-mail)
Sent: Tuesday, May 01, 2001 2:00 PM
Subject: [Vantage] Crystal Reports.


Hi,

I need some help with Crystal Reports.

In the Part Master we use the Part Number field for out part number and
the
Description field for the Customer Part number.

For example:
Part: 2400-055
Description: L47746P01 (Shaft, Aft, - Low Pressure Turbine Rotor)

All our parts are entered this way. I would like to be able to extract
just
the first part of the description up to but not including the "(" to print
on some labels.

Thanks,

Dave Cole
Reeder & Kline




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


Yahoo! Groups Sponsor



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! Terms of Service.



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




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


Yahoo! Groups Sponsor


Select a CityLas VegasAnaheimAtlantaAtlantic CityBaltimoreBostonChicagoDallasDenverFt.LauderdaleHoustonLas VegasLaughlinLos AngelesNashvilleNew OrleansNew YorkOrlandoPhiladelphiaPhoenixReno/Lake TahoeSan DiegoSan AntonioSan FranciscoSeattleWashington DC



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 the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
--- **Canonical:** https://www.epiusers.help/t/crystal-reports/2785 **Original content:** https://www.epiusers.help/t/crystal-reports/2785