I have a multiple value parameter set as a number type. The values of the parameter list are numbers, but I also have descriptions for each that are string values. I am displaying only the description for the users to select the parameters. The descriptions are not available in the database, nor can I add them in the database. Then I'm using the values in the record selection. That is all working fine.
What I now want is to list in a formula in my header the descriptions of the parameters chosen. Is there even a way to get the descriptions? Otherwise, I'd settle for a list of the values, and do some replaces. When I try to the Join({?MVPArray}, " ") formula, I get a message that it must be a string array. If I add totext it wants it to be subscripted. When I add subscripting, I get more errors or it only shows the one value I request in the subscript.
I can't make my parameter a string type, because then I have to do a tonumber({?MVPArray}) in my record select and it wants it subscripted and it probably still wouldn't work.
Any ideas?
What I now want is to list in a formula in my header the descriptions of the parameters chosen. Is there even a way to get the descriptions? Otherwise, I'd settle for a list of the values, and do some replaces. When I try to the Join({?MVPArray}, " ") formula, I get a message that it must be a string array. If I add totext it wants it to be subscripted. When I add subscripting, I get more errors or it only shows the one value I request in the subscript.
I can't make my parameter a string type, because then I have to do a tonumber({?MVPArray}) in my record select and it wants it subscripted and it probably still wouldn't work.
Any ideas?