Hi Mark,
You can create an array from the rep list field. I do the same with the rep rate and rep split fields.
stringvar array aRep := Split ({OrderHed.SalesRepList},'~' );
stringvar sRep1 := aRep[1];
stringvar sRep2 := aRep[2];
etc.....
Regards,
Linda Lowney
Decoustics Limited
Date: Tue, 10 May 2005 13:50:34 -0000
From: "innerpac_il" <mark_smith@...>
Subject: RE: Crystal Question
I need to pull a value from rep rate in the invoicedtl table, which is
an array. I only want to pull the first value in the array for each
rep. In report builder this is essentially done for you (i.e., reprate
[1]), but I don't know how to "code" it to get crystal to pull this
value.
Thanks,
Mark Smith
Innerpac, Inc.
You can create an array from the rep list field. I do the same with the rep rate and rep split fields.
stringvar array aRep := Split ({OrderHed.SalesRepList},'~' );
stringvar sRep1 := aRep[1];
stringvar sRep2 := aRep[2];
etc.....
Regards,
Linda Lowney
Decoustics Limited
Date: Tue, 10 May 2005 13:50:34 -0000
From: "innerpac_il" <mark_smith@...>
Subject: RE: Crystal Question
I need to pull a value from rep rate in the invoicedtl table, which is
an array. I only want to pull the first value in the array for each
rep. In report builder this is essentially done for you (i.e., reprate
[1]), but I don't know how to "code" it to get crystal to pull this
value.
Thanks,
Mark Smith
Innerpac, Inc.