Ok I'm very close to getting it to work: this is the formula (@Dept_Array) that converts the numeric array to a string array:
//Variable daclaration section
Global stringvar array x; //new array
Local numbervar j; //counter
Local numbervar num := count ({?Dept_ID}); // length of numbers array
//Loop through the ?Dept_ID array
// resize array to the same size as input array
Redim x[num];
//Loop throug numeric array
//convert each record to text then store in x
For j := 1 to num Do
(
x[j] := totext({?Dept_ID}[j])
);
That works ok, now the new error I get is when I call this formula:
if
{@Dept_Array} = '' then
'Corporate' + chr(13) + chr(10) +
'Education' + chr(13) + chr(10) +
'Enterprise Architecture Solutions' + chr(13) + chr(10) +
'Enterprise Program Services' + chr(13) + chr(10) +
'Enterprise Technology Solutions' + chr(13) + chr(10) +
'Health & Human Services' + chr(13) + chr(10) +
'IEP Online' + chr(13) + chr(10) +
'IT' + chr(13) + chr(10) +
'LTI' + chr(13) + chr(10) +
'Pacific North West' + chr(13) + chr(10) +
'Project Management Solutions' + chr(13) + chr(10) +
'Public Consulting Group' + chr(13) + chr(10) +
'Quality Solutions' + chr(13) + chr(10) +
'Technology Consulting'
else Join (
{@Dept_Array}, chr(10) + chr(13))
The new error I get is "A boolean is required here" and it points to the ' ' .
It's stating that I need a boolean instead of the ' ' (space).
Edited by Colonel45 - 13 May 2011 at 9:25am
IP Logged
