Parameter that will accept multiple values (delimited by semi-colon)

[gk17]

Hi,

I want to have a parameter that will accept multiple values entered by a user separated by semi-colons. Currently, I'm using the following selection formula for sites:

({?sites}='' or ','+{table.sites}+',' in ','+Replace({?sites}," ","")+',')

That works out well but now I want to do something similar with names which will be in lastname, firstname format. The comma will throw this off. What needs to be changed to accommodate semi-colons instead? I tried doing the following which didn't work out:

({?names}='' or ';'+{table.names}+';' in ';'+Replace({?names}," ","")+';')

Thanks.

 

[PeterDimitrov]

Can you provide a sample value for {?names} and {table.names} ?

http://www.R-Tag.com

Viewer and Scheduler for Crystal reports, SSRS and Dynamic Dashboards.

 

[gk17]

Thanks for the reply Peter. I was able to get this resolved by removing the replace function.