Help With Boolean Formula/Do Loop

[dgillz]

I need a boolean formula which I am going to use to conditionally suppress the details section. The boolean will compare an array from a multi-value parameter to an array built from several database fields.

Sample Array from Parameter:
['A','B','D']

Sample Array from Database Fields:
['A','B','C','D','I','M']

Note: If needed and it makes sense I can concatenate either of these into strings rather than dealing with arrays, and the longest the string would ever be is 22 characters.

So how do I compare each element of the parameter array to see if any single on of them exists in the database array, and then return true?



Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[lbass]

Something like this should work

whileprintingrecords;
stringvar stringx := {table.field1}+", "+{table.field2}+", "+{table.field3};
numbervar i;
numbervar j := ubound({?parm});
booleanvar x := false;

for i := 1 to j do(
if {?parm} in stringx then
x := true);
x

This assumes that the concatenation exists at the detail level and you are testing at the detail level.

-LB