Convert an input parameter

[TimothyP]

How do I create a report that converts data from an input parameter to generate an output record based on variables I assign? To simplify, how would I convert an input parameter from 12345 to an output record of VWXYZ? So for this sample I think my variables would be defined something like this...
V=1
W=2
X=3
Y=4
Z=5

Any help would be appreciated.

Thanks,
Tim

 

[Turkbear]

Hi,
Could you explain more fully what you mean by an 'output record'?

Do you want to pass something like 12345 and then use a record selection criteria of VWXYZ ?

 

[lbass]

Not sure exactly what you mean, but maybe you could adapt the following method, which assumes the parameter is a string:

replace(replace(replace(replace(replace({?parm},"1","V&quot,
"2","W&quot,"3","X&quot,"4","Y&quot,"5","Z&quot

-LB