Multiple request parameter

[Petbul]

Hi,
please, how can I set more than one parameter related to one db field (key).
E.g. - request_id1,request_id2,etc. related to requests.request_id. (so somethink like any of...).
I need to use it in report header (in detail are related info from other tables for given request).
Thanks Petr

 

[IanWaterman]

If I understand you correctly, you want to enter multiple request_id in your parameter.

When you create parameter (or edit) just check the box
Allow multiple values.

This effectively creates an array and can be used in you select expert as Request_id = {?RequestParameterName}

to display the contents of your multi-element parameter use the join function eg

join ({?RequestParameterName},",&quot

this will list contents delimited with a comma.

Ian