SSRS Multilookup Function for Names with Comma Separation
Posted
by
AliceAyers292
on Stack Overflow
See other posts from Stack Overflow
or by AliceAyers292
Published on 2013-10-30T15:50:39Z
Indexed on
2013/10/30
15:53 UTC
Read the original article
Hit count: 272
reporting-services
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!
© Stack Overflow or respective owner