Hi all,

I have received a request that based upon the values entered in a parameter that can accept multiple values the column label will change. For example, if all of the values that have been selected for the parameter contain the word 'Refinance', the column label should change, otherwise it will not. I have already figured that I can use Upper Bound to determine the number of values entered in the parameter, but I am unable to figure how to do the count for the values entered in the parameter that match my criteria. Figure a loop would be needed that would say something like If instring parameter 'Refinance' then i = 1, then i = i + 1, but I am not sure of the syntax?

The thought is when the loop is finished I would compare the count for that one against the total number of values entered and if they are the same then the column label would be changed.

Any ideas on how best to do this would greatly be appreciated.

Thanks,

Ed