SSRS Multilookup Function for Names with Comma Separation
- by AliceAyers292
I would like to put the following in a a multilookup drop-down in reporting services:
"Smith, John", "Jones, Tim", "Kelly, Andy"
The comma separating the first and last name prevents the multilookup from working correctly. I am also unable to use ticks (' or ") in reporting service to keep the separating comma from working like a multilookup comma that separates the fields I want to select from. Is there a way to keep the comma in the names while still allowing multilookup?
Any help would be much appreciated. Thank you!