<p>Hey.</p>
<p> </p>
<p>Does anyone have an idea how to solve my problem: I'm trying to build a report parameter (multi value) so that it displays a value "service name", but stores a different value "serviceid".</p>
<p> </p>
<p>The reason for this is that service name is the informative field which users know and can make a selection out of. So Report parameter should show the service name and user should be able to select 1-n out of the displayed names.</p>
<p> </p>
<p>BUT: the service names might include commas (,) which seems to cause problems in storing the values. I'd like to store serviceid values instead for further use.</p>
<p> </p>
<p>I tried to figure out whether I could affect the stored value in before open -script but it's too late by then.</p>
<p> </p>
<p>SO: is it possible to present one type of values (string) in report parameter for user to choose from and according to the selection, store different type (integer) in the same report parameter? The data set I'm using for the representable values includes both name and id in the select -statement.</p>
<p> </p>
<p>My Before Open script -></p>
<p>First part that works:</p>
<p>this.queryText = this.queryText.replace("ostovoimat", params[RP_Ostovoiman_tila"].value.join("','");</p>
<p>This part doesn't:</p>
<p>this.queryText = this.queryText.replace("palvelut", params[RP_Palvelut"].value.join("','");</p>
<p>in this palvelut -part I should use the palveluid that's an integer..</p>
<p> </p>
<p>The main data set SQL includes the usage of string arrays as follows:</p>
<p><b>AND </b>ovs.tila <b>in</b> ('ostovoimat') <b>AND</b> p.palveluid <b>in</b> (palvelut)</p>
<p>-> ostovoimat works fine, palvelut not at the moment..</p>
<p> </p>
<p>Thanks in advance, Elja</p>
<p> </p>
<p>Ps. sorry about the little mistake in the topic, it seems I can't correct it after posting the topic.</p>
