Using Arrays within Crystal

[ZanyCat]

Does anyone have any examples of using arrays in Crystal?<br><br>I know this is probably the kind of stuff you guys do in your sleep but I would appreciate it greatly!<br><br>I am trying to write a report to calculate commission rates for salespeople and I am stuck on using an array to calculate which commission rate the salespeople will get for each sale.&nbsp;&nbsp;The commission rates are subject to certain conditions ...i.e which commission group the product sold belongs to and which commission group the salesperson falls under. The matrix which is currently used to manually calulate the commission percentage is a grid which has product groups down one side and salesperson commission groups across the top. These are then cross referenced to get the correct commission percentage.<br><br>I hope this is as clear as mud!!<br><br>Thanks in anticipation<br><br><br>Zany<br>x<br>

 

[kenhamady]

Zany,

Is this edition of Crystal based on Crystal Version 8? Because up through Crystal version 7 you can only subscript an array to pull a value OUT of it. You can't update a value in the array by referring to it by number. This really takes the wind out of the sales for using variable arrays.

I have played with one dimensional arrays just for fun. I am not sure that even Crystal 8 will support an array matrix in two dimensions with coordinates. However, according to the help screen I just read in V8, an array can have up to 1000 elements, so I suppose if you do some calculations to get your subscript,you could dummy up a two dimensional array with coordinates.

Hope this makes sense. [sig]<p>Ken Hamady<br><a href=mailto:ken@kenhamady.com>ken@kenhamady.com</a><br><a href=

http://www.kenhamady.com/>Crystal

Reports Taining by Ken Hamady</a><br>[/sig]