Joining a MultiLookup on a multi-value report parameter

jdallen75 used Ask the Experts™
I can't seem to figure out what's wrong with this multi-lookup syntax on a textbox expression:

=Join(MultiLookup(Split(Parameters!LineType.Value,","), Fields!Message.Value, Fields!Translation.Value, "dsGetTranslations"), ",")

LineType is a multi-value, hidden, text report parameter with no available values specified, and default values from another dataset.

I'm receiving this error: "The value expression for the textrun 'txtHeader.Paragraphs[0].TextRuns[0]' contains an error: Conversion from type 'Object()' to type 'String' is not valid.

This expression works OK if I just look at the first LineType element alone:

=Lookup(Parameters!LineType.Value(0), Fields!Message.Value, Fields!Translation.Value, "dsGetTranslations")
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Business Intelligence Developer and Analyst
Top Expert 2015
Try this.

Join(MultiLookup(Split(join(Parameters!LineType.Value,","),","), Fields!Message.Value, Fields!Translation.Value, "dsGetTranslations"), ",")


Fantastic - it would have taken me a while to figure out 2 Join's. Thanks!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial