Please Epicor -Stop Using Array's

Yahoo Archive
1
TB = Typo BooBoo - should have been RB for Report Builder. Sorry.

The ENTRY function in RB is nice. Does all that positioning substring stuff automatically. Basically says to look for the Nth occurance in TargetString of data seperated by Xstring or in this case the Nth occurance in RepList sperated by Tilde (a formula field = CHR(126) ).

I am not that familiar with Crystal's built-in functions, but heck they are a report writer company and Progress isn't (dig dig), so Crystal ought to be able to figure out how to write an ENTRY type function.

-Todd C.

-----Original Message-----
From: David Gartner [mailto:dgartner@...]
Sent: Wednesday, November 05, 2003 11:27 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Please Epicor -Stop Using Array's


Todd,

What is TB and is there a cleaner way to do this function using Crystal?

First salesperson
Local numbervar varFirstTilde := InStr (1, {%SalesReplistsubstring}, "~")-1;
If varFirstTilde <> 0 Then
Mid ({%SalesReplistsubstring}, 1, varFirstTilde)

Second salesperson
Local numbervar varsecondTilde := InStr (1, {%SalesReplistsubstring},
"~")-1;
If varsecondTilde <> 0 Then
Mid ({%SalesReplistsubstring}, 5, varsecondTilde)

Luckily all of my ID's are three letters. It appears your formula is much
simpler.

Falling off the edge of understanding,

David Gartner
EPG Companies Inc.
Vantage 5.20.322, Progress 9.1D5


-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Wednesday, November 05, 2003 9:30 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Please Epicor -Stop Using Array's


In 5.20 and prior (looks like different in 6.0 and up) they use the Tilde
(~) character to seperate values in the array. In TB the CHR(126) formula
will be a Tilde character. I set a variable as this then use a formula
like:
ENTRY(1,SalesRepList,Tilde)
to get a value out - in this case the first rep.

This ought to be enough to get you going on it. If not ask again.
-Todd C.


-----Original Message-----
From: Tricia Simon [mailto:t.simon@...]
Sent: Wednesday, November 05, 2003 9:25 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Please Epicor -Stop Using Array's


Brian,

Is there a way to access the arrays in Report Builder???? I've been
beating
my head against a wall trying to write a report and coming up empty (and
with an aching head!) due to the RepList array. Can anyone tell me how to
do this??????

Thanks in advance!!

Tricia Simon, Controller
Riten Industries, Inc.


-----Original Message-----
From: Brian Stenglein [mailto:bstenglein@...]
Sent: Tuesday, November 04, 2003 2:32 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Please Epicor -Stop Using Array's


I know that this probably won't do any good here, but I'm looking for
moral support from my fellow report writers and I need to take a
moment to vent at the Epicor programmers.

We are upgrading from 5.0 to 6.0 and I can't stand some of the
changes they've made to the DB schema. For example, they've made the
Rep Commission information into array's. We were all complaining
about how the field RepList was an array with the Rep Codes separated
by ~'s. Well now the RepSplit, RepRate, RepSales, and RepComm fields
are now array's separated by ;'s. We've been begging them to get rid
of the RepList array and now they've compounded our problems by added
4 more. I've just learned that the Price Break info has been turned
into an array of 10 items.

Now, I am able to manipulate these array's into usable information,
but the information certainly isn't as easy to use as it was when
each instance of a certain topic was in its own field, and not thrown
into a useless array. It takes a lot of formulas to parse out the
information into usable pieces.

If anyone from Epicor development is out there, could you please
explain why you like to torture us with the array's, and for the love
of Pete, would you quit adding them to the Database structure.

Thanks,

Brian Stenglein
Clow Stamping Co.



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

< http://rd.yahoo.com/M=267637.4116719.5338353.1261774/D=egroupweb/S=17050071
83:HM/A=1754451/R=0/SIG=11tpj98m3/* http://www.netflix.com/Default?mqso=60178
323&partid=4116719> click here

< http://us.adserver.yahoo.com/l?M=267637.4116719.5338353.1261774/D=egroupmai
l/S=:HM/A=1754451/rand=823102074>

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




[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
<http://rd.yahoo.com/M=267637.4116732.5333197.1261774/D=egroupweb/S=1705007183:HM/A=1754451/R=0/SIG=11t8a5ls2/*http://www.netflix.com/Default?mqso=60178323&partid=4116732> click here
<http://us.adserver.yahoo.com/l?M=267637.4116732.5333197.1261774/D=egroupmail/S=:HM/A=1754451/rand=116997129>

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




[Non-text portions of this message have been removed]
2
I know that this probably won't do any good here, but I'm looking for
moral support from my fellow report writers and I need to take a
moment to vent at the Epicor programmers.

We are upgrading from 5.0 to 6.0 and I can't stand some of the
changes they've made to the DB schema. For example, they've made the
Rep Commission information into array's. We were all complaining
about how the field RepList was an array with the Rep Codes separated
by ~'s. Well now the RepSplit, RepRate, RepSales, and RepComm fields
are now array's separated by ;'s. We've been begging them to get rid
of the RepList array and now they've compounded our problems by added
4 more. I've just learned that the Price Break info has been turned
into an array of 10 items.

Now, I am able to manipulate these array's into usable information,
but the information certainly isn't as easy to use as it was when
each instance of a certain topic was in its own field, and not thrown
into a useless array. It takes a lot of formulas to parse out the
information into usable pieces.

If anyone from Epicor development is out there, could you please
explain why you like to torture us with the array's, and for the love
of Pete, would you quit adding them to the Database structure.

Thanks,

Brian Stenglein
Clow Stamping Co.
3
Yah,what he said.


-----Original Message-----
From: Brian Stenglein [mailto:bstenglein@...]
Sent: Tuesday, November 04, 2003 2:32 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Please Epicor -Stop Using Array's


I know that this probably won't do any good here, but I'm looking for
moral support from my fellow report writers and I need to take a
moment to vent at the Epicor programmers.

We are upgrading from 5.0 to 6.0 and I can't stand some of the
changes they've made to the DB schema. For example, they've made the
Rep Commission information into array's. We were all complaining
about how the field RepList was an array with the Rep Codes separated
by ~'s. Well now the RepSplit, RepRate, RepSales, and RepComm fields
are now array's separated by ;'s. We've been begging them to get rid
of the RepList array and now they've compounded our problems by added
4 more. I've just learned that the Price Break info has been turned
into an array of 10 items.

Now, I am able to manipulate these array's into usable information,
but the information certainly isn't as easy to use as it was when
each instance of a certain topic was in its own field, and not thrown
into a useless array. It takes a lot of formulas to parse out the
information into usable pieces.

If anyone from Epicor development is out there, could you please
explain why you like to torture us with the array's, and for the love
of Pete, would you quit adding them to the Database structure.

Thanks,

Brian Stenglein
Clow Stamping Co.



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/
4
I hear you and agree 10000%. Makes doing commisioned sales reports by various sub-totals extremely difficult. Thanks for the heads up to a ugly situation in 6.0.
-Todd C.

-----Original Message-----
From: Brian Stenglein [mailto:bstenglein@...]
Sent: Tuesday, November 04, 2003 1:32 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Please Epicor -Stop Using Array's


I know that this probably won't do any good here, but I'm looking for
moral support from my fellow report writers and I need to take a
moment to vent at the Epicor programmers.

We are upgrading from 5.0 to 6.0 and I can't stand some of the
changes they've made to the DB schema. For example, they've made the
Rep Commission information into array's. We were all complaining
about how the field RepList was an array with the Rep Codes separated
by ~'s. Well now the RepSplit, RepRate, RepSales, and RepComm fields
are now array's separated by ;'s. We've been begging them to get rid
of the RepList array and now they've compounded our problems by added
4 more. I've just learned that the Price Break info has been turned
into an array of 10 items.

Now, I am able to manipulate these array's into usable information,
but the information certainly isn't as easy to use as it was when
each instance of a certain topic was in its own field, and not thrown
into a useless array. It takes a lot of formulas to parse out the
information into usable pieces.

If anyone from Epicor development is out there, could you please
explain why you like to torture us with the array's, and for the love
of Pete, would you quit adding them to the Database structure.

Thanks,

Brian Stenglein
Clow Stamping Co.



Yahoo! Groups Sponsor

ADVERTISEMENT
<http://rd.yahoo.com/M=267637.4116732.5333197.1261774/D=egroupweb/S=1705007183:HM/A=1754451/R=0/SIG=11t8a5ls2/*http://www.netflix.com/Default?mqso=60178323&partid=4116732> click here
<http://us.adserver.yahoo.com/l?M=267637.4116732.5333197.1261774/D=egroupmail/S=:HM/A=1754451/rand=102324125>

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




[Non-text portions of this message have been removed]
5
What the hell! I spoke with Epicor tech support last Friday asking if these
fields had been removed. I specifically was asking about the Replist but we
talked about the RepRate and Split. "No they haven't been removed." I then
went on to say I thought I had heard off the Listserv of changes or
modifications to those fields had happened between 5.2 and 6.0. "Nope,
still the same."

Who do you believe?

David Gartner
EPG Companies Inc.
-----Original Message-----
From: Brian Stenglein [mailto:bstenglein@...]
Sent: Tuesday, November 04, 2003 1:32 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Please Epicor -Stop Using Array's


I know that this probably won't do any good here, but I'm looking for
moral support from my fellow report writers and I need to take a
moment to vent at the Epicor programmers.

We are upgrading from 5.0 to 6.0 and I can't stand some of the
changes they've made to the DB schema. For example, they've made the
Rep Commission information into array's. We were all complaining
about how the field RepList was an array with the Rep Codes separated
by ~'s. Well now the RepSplit, RepRate, RepSales, and RepComm fields
are now array's separated by ;'s. We've been begging them to get rid
of the RepList array and now they've compounded our problems by added
4 more. I've just learned that the Price Break info has been turned
into an array of 10 items.

Now, I am able to manipulate these array's into usable information,
but the information certainly isn't as easy to use as it was when
each instance of a certain topic was in its own field, and not thrown
into a useless array. It takes a lot of formulas to parse out the
information into usable pieces.

If anyone from Epicor development is out there, could you please
explain why you like to torture us with the array's, and for the love
of Pete, would you quit adding them to the Database structure.

Thanks,

Brian Stenglein
Clow Stamping Co.


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]
6
According to Epicor, all changes are listed in the Change Documents and Whats New Documents. When I laughed and asked how long they had worked at Epicor she didn't think it was to funny.



-----Original Message-----
From: David Gartner [mailto:dgartner@...]
Sent: Tuesday, November 04, 2003 2:59 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Please Epicor -Stop Using Array's


What the hell! I spoke with Epicor tech support last Friday asking if these
fields had been removed. I specifically was asking about the Replist but we
talked about the RepRate and Split. "No they haven't been removed." I then
went on to say I thought I had heard off the Listserv of changes or
modifications to those fields had happened between 5.2 and 6.0. "Nope,
still the same."

Who do you believe?

David Gartner
EPG Companies Inc.
-----Original Message-----
From: Brian Stenglein [mailto:bstenglein@...]
Sent: Tuesday, November 04, 2003 1:32 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Please Epicor -Stop Using Array's


I know that this probably won't do any good here, but I'm looking for
moral support from my fellow report writers and I need to take a
moment to vent at the Epicor programmers.

We are upgrading from 5.0 to 6.0 and I can't stand some of the
changes they've made to the DB schema. For example, they've made the
Rep Commission information into array's. We were all complaining
about how the field RepList was an array with the Rep Codes separated
by ~'s. Well now the RepSplit, RepRate, RepSales, and RepComm fields
are now array's separated by ;'s. We've been begging them to get rid
of the RepList array and now they've compounded our problems by added
4 more. I've just learned that the Price Break info has been turned
into an array of 10 items.

Now, I am able to manipulate these array's into usable information,
but the information certainly isn't as easy to use as it was when
each instance of a certain topic was in its own field, and not thrown
into a useless array. It takes a lot of formulas to parse out the
information into usable pieces.

If anyone from Epicor development is out there, could you please
explain why you like to torture us with the array's, and for the love
of Pete, would you quit adding them to the Database structure.

Thanks,

Brian Stenglein
Clow Stamping Co.


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]



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/
7
Brian,

Is there a way to access the arrays in Report Builder???? I've been beating
my head against a wall trying to write a report and coming up empty (and
with an aching head!) due to the RepList array. Can anyone tell me how to
do this??????

Thanks in advance!!

Tricia Simon, Controller
Riten Industries, Inc.


-----Original Message-----
From: Brian Stenglein [mailto:bstenglein@...]
Sent: Tuesday, November 04, 2003 2:32 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Please Epicor -Stop Using Array's


I know that this probably won't do any good here, but I'm looking for
moral support from my fellow report writers and I need to take a
moment to vent at the Epicor programmers.

We are upgrading from 5.0 to 6.0 and I can't stand some of the
changes they've made to the DB schema. For example, they've made the
Rep Commission information into array's. We were all complaining
about how the field RepList was an array with the Rep Codes separated
by ~'s. Well now the RepSplit, RepRate, RepSales, and RepComm fields
are now array's separated by ;'s. We've been begging them to get rid
of the RepList array and now they've compounded our problems by added
4 more. I've just learned that the Price Break info has been turned
into an array of 10 items.

Now, I am able to manipulate these array's into usable information,
but the information certainly isn't as easy to use as it was when
each instance of a certain topic was in its own field, and not thrown
into a useless array. It takes a lot of formulas to parse out the
information into usable pieces.

If anyone from Epicor development is out there, could you please
explain why you like to torture us with the array's, and for the love
of Pete, would you quit adding them to the Database structure.

Thanks,

Brian Stenglein
Clow Stamping Co.



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/
8
In 5.20 and prior (looks like different in 6.0 and up) they use the Tilde (~) character to seperate values in the array. In TB the CHR(126) formula will be a Tilde character. I set a variable as this then use a formula like:
ENTRY(1,SalesRepList,Tilde)
to get a value out - in this case the first rep.

This ought to be enough to get you going on it. If not ask again.
-Todd C.


-----Original Message-----
From: Tricia Simon [mailto:t.simon@...]
Sent: Wednesday, November 05, 2003 9:25 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Please Epicor -Stop Using Array's


Brian,

Is there a way to access the arrays in Report Builder???? I've been beating
my head against a wall trying to write a report and coming up empty (and
with an aching head!) due to the RepList array. Can anyone tell me how to
do this??????

Thanks in advance!!

Tricia Simon, Controller
Riten Industries, Inc.


-----Original Message-----
From: Brian Stenglein [mailto:bstenglein@...]
Sent: Tuesday, November 04, 2003 2:32 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Please Epicor -Stop Using Array's


I know that this probably won't do any good here, but I'm looking for
moral support from my fellow report writers and I need to take a
moment to vent at the Epicor programmers.

We are upgrading from 5.0 to 6.0 and I can't stand some of the
changes they've made to the DB schema. For example, they've made the
Rep Commission information into array's. We were all complaining
about how the field RepList was an array with the Rep Codes separated
by ~'s. Well now the RepSplit, RepRate, RepSales, and RepComm fields
are now array's separated by ;'s. We've been begging them to get rid
of the RepList array and now they've compounded our problems by added
4 more. I've just learned that the Price Break info has been turned
into an array of 10 items.

Now, I am able to manipulate these array's into usable information,
but the information certainly isn't as easy to use as it was when
each instance of a certain topic was in its own field, and not thrown
into a useless array. It takes a lot of formulas to parse out the
information into usable pieces.

If anyone from Epicor development is out there, could you please
explain why you like to torture us with the array's, and for the love
of Pete, would you quit adding them to the Database structure.

Thanks,

Brian Stenglein
Clow Stamping Co.



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
<http://rd.yahoo.com/M=267637.4116719.5338353.1261774/D=egroupweb/S=1705007183:HM/A=1754451/R=0/SIG=11tpj98m3/*http://www.netflix.com/Default?mqso=60178323&partid=4116719> click here
<http://us.adserver.yahoo.com/l?M=267637.4116719.5338353.1261774/D=egroupmail/S=:HM/A=1754451/rand=823102074>

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




[Non-text portions of this message have been removed]
9
Thanks! I'll give it a shot!

Tricia


-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Wednesday, November 05, 2003 10:30 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Please Epicor -Stop Using Array's


In 5.20 and prior (looks like different in 6.0 and up) they use the Tilde
(~) character to seperate values in the array. In TB the CHR(126) formula
will be a Tilde character. I set a variable as this then use a formula
like:
ENTRY(1,SalesRepList,Tilde)
to get a value out - in this case the first rep.

This ought to be enough to get you going on it. If not ask again.
-Todd C.


-----Original Message-----
From: Tricia Simon [mailto:t.simon@...]
Sent: Wednesday, November 05, 2003 9:25 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Please Epicor -Stop Using Array's


Brian,

Is there a way to access the arrays in Report Builder???? I've been beating
my head against a wall trying to write a report and coming up empty (and
with an aching head!) due to the RepList array. Can anyone tell me how to
do this??????

Thanks in advance!!

Tricia Simon, Controller
Riten Industries, Inc.


-----Original Message-----
From: Brian Stenglein [mailto:bstenglein@...]
Sent: Tuesday, November 04, 2003 2:32 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Please Epicor -Stop Using Array's


I know that this probably won't do any good here, but I'm looking for
moral support from my fellow report writers and I need to take a
moment to vent at the Epicor programmers.

We are upgrading from 5.0 to 6.0 and I can't stand some of the
changes they've made to the DB schema. For example, they've made the
Rep Commission information into array's. We were all complaining
about how the field RepList was an array with the Rep Codes separated
by ~'s. Well now the RepSplit, RepRate, RepSales, and RepComm fields
are now array's separated by ;'s. We've been begging them to get rid
of the RepList array and now they've compounded our problems by added
4 more. I've just learned that the Price Break info has been turned
into an array of 10 items.

Now, I am able to manipulate these array's into usable information,
but the information certainly isn't as easy to use as it was when
each instance of a certain topic was in its own field, and not thrown
into a useless array. It takes a lot of formulas to parse out the
information into usable pieces.

If anyone from Epicor development is out there, could you please
explain why you like to torture us with the array's, and for the love
of Pete, would you quit adding them to the Database structure.

Thanks,

Brian Stenglein
Clow Stamping Co.



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

<http://rd.yahoo.com/M=267637.4116719.5338353.1261774/D=egroupweb/S=17050071
83:HM/A=1754451/R=0/SIG=11tpj98m3/*http://www.netflix.com/Default?mqso=60178
323&partid=4116719> click here

<http://us.adserver.yahoo.com/l?M=267637.4116719.5338353.1261774/D=egroupmai
l/S=:HM/A=1754451/rand=823102074>

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




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



[Non-text portions of this message have been removed]
10
Sorry Tricia, haven't tried it in Report Builder. I've only dealt
with the RepList Array in Access, although I have parsed out some of
the other arrays in Crystal. The basic logic behind it though is to
use a function to find the location of the first seperator, in this
case the ~. Then your first Rep Code would be whatever is left of
that location. Then you find the location of the second ~ and your
second rep code is whatever is between the first ~ and the second ~.
I don't know the exact functions you need to use in Report Builder,
but in Crystal I use the Instr function to find the location of the
seperators and the Left function to grab the text for the first code,
and the Mid function for the remaining codes. The Len function can
be helpful sometimes to get the length of the string and the Right
function will return the X # of Right most characters. Once you know
the right functions to use and how they work its not too hard, just a
pain in the backside that shouldn't be necessary.

Hope that helps,

Brian Stenglein
Clow Stamping Co.

--- In vantage@yahoogroups.com, "Tricia Simon" <t.simon@r...> wrote:
> Brian,
>
> Is there a way to access the arrays in Report Builder???? I've
been beating
> my head against a wall trying to write a report and coming up empty
(and
> with an aching head!) due to the RepList array. Can anyone tell me
how to
> do this??????
>
> Thanks in advance!!
>
> Tricia Simon, Controller
> Riten Industries, Inc.
>
>
> -----Original Message-----
> From: Brian Stenglein [mailto:bstenglein@c...]
> Sent: Tuesday, November 04, 2003 2:32 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Please Epicor -Stop Using Array's
>
>
> I know that this probably won't do any good here, but I'm looking
for
> moral support from my fellow report writers and I need to take a
> moment to vent at the Epicor programmers.
>
> We are upgrading from 5.0 to 6.0 and I can't stand some of the
> changes they've made to the DB schema. For example, they've made
the
> Rep Commission information into array's. We were all complaining
> about how the field RepList was an array with the Rep Codes
separated
> by ~'s. Well now the RepSplit, RepRate, RepSales, and RepComm
fields
> are now array's separated by ;'s. We've been begging them to get
rid
> of the RepList array and now they've compounded our problems by
added
> 4 more. I've just learned that the Price Break info has been turned
> into an array of 10 items.
>
> Now, I am able to manipulate these array's into usable information,
> but the information certainly isn't as easy to use as it was when
> each instance of a certain topic was in its own field, and not
thrown
> into a useless array. It takes a lot of formulas to parse out the
> information into usable pieces.
>
> If anyone from Epicor development is out there, could you please
> explain why you like to torture us with the array's, and for the
love
> of Pete, would you quit adding them to the Database structure.
>
> Thanks,
>
> Brian Stenglein
> Clow Stamping Co.
>
>
>
> 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/
11
Todd,

What is TB and is there a cleaner way to do this function using Crystal?

First salesperson
Local numbervar varFirstTilde := InStr (1, {%SalesReplistsubstring}, "~")-1;
If varFirstTilde <> 0 Then
Mid ({%SalesReplistsubstring}, 1, varFirstTilde)

Second salesperson
Local numbervar varsecondTilde := InStr (1, {%SalesReplistsubstring},
"~")-1;
If varsecondTilde <> 0 Then
Mid ({%SalesReplistsubstring}, 5, varsecondTilde)

Luckily all of my ID's are three letters. It appears your formula is much
simpler.

Falling off the edge of understanding,

David Gartner
EPG Companies Inc.
Vantage 5.20.322, Progress 9.1D5


-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Wednesday, November 05, 2003 9:30 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Please Epicor -Stop Using Array's


In 5.20 and prior (looks like different in 6.0 and up) they use the Tilde
(~) character to seperate values in the array. In TB the CHR(126) formula
will be a Tilde character. I set a variable as this then use a formula
like:
ENTRY(1,SalesRepList,Tilde)
to get a value out - in this case the first rep.

This ought to be enough to get you going on it. If not ask again.
-Todd C.


-----Original Message-----
From: Tricia Simon [mailto:t.simon@...]
Sent: Wednesday, November 05, 2003 9:25 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Please Epicor -Stop Using Array's


Brian,

Is there a way to access the arrays in Report Builder???? I've been
beating
my head against a wall trying to write a report and coming up empty (and
with an aching head!) due to the RepList array. Can anyone tell me how to
do this??????

Thanks in advance!!

Tricia Simon, Controller
Riten Industries, Inc.


-----Original Message-----
From: Brian Stenglein [mailto:bstenglein@...]
Sent: Tuesday, November 04, 2003 2:32 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Please Epicor -Stop Using Array's


I know that this probably won't do any good here, but I'm looking for
moral support from my fellow report writers and I need to take a
moment to vent at the Epicor programmers.

We are upgrading from 5.0 to 6.0 and I can't stand some of the
changes they've made to the DB schema. For example, they've made the
Rep Commission information into array's. We were all complaining
about how the field RepList was an array with the Rep Codes separated
by ~'s. Well now the RepSplit, RepRate, RepSales, and RepComm fields
are now array's separated by ;'s. We've been begging them to get rid
of the RepList array and now they've compounded our problems by added
4 more. I've just learned that the Price Break info has been turned
into an array of 10 items.

Now, I am able to manipulate these array's into usable information,
but the information certainly isn't as easy to use as it was when
each instance of a certain topic was in its own field, and not thrown
into a useless array. It takes a lot of formulas to parse out the
information into usable pieces.

If anyone from Epicor development is out there, could you please
explain why you like to torture us with the array's, and for the love
of Pete, would you quit adding them to the Database structure.

Thanks,

Brian Stenglein
Clow Stamping Co.



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

<http://rd.yahoo.com/M=267637.4116719.5338353.1261774/D=egroupweb/S=17050071
83:HM/A=1754451/R=0/SIG=11tpj98m3/*http://www.netflix.com/Default?mqso=60178
323&partid=4116719> click here

<http://us.adserver.yahoo.com/l?M=267637.4116719.5338353.1261774/D=egroupmai
l/S=:HM/A=1754451/rand=823102074>

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




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