How to populate an array and compare the data
Posted on 2008-10-09
Im wondering how/where (withing the custom code?) im able to fill an array with data. What im doing is retrieving postal codes from clients and stripping the first 3 characters and trying to put those values into an array. With this array i will then compare each value against a string value (will be a list of all Alberta's postal codes) and keep a count so i can then display the number of clients from that certain area of Alberta.
eg. The array will contain thousands of postal codes (T2W, T0E, T0L, etc...) and then compare it to a string (such as T2W) and i would like it to return the total number within the array that are T2W.
Im just trying to figure out how im able to create the array within SSRS and populate it, then pass the array to another method or procedure that does the string comparison and returns a count value.
This may not be explained very well but any help is greatly appreciated.