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: 239

Filed under:

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

Related posts about reporting-services