Link to home
Get AccessLog in
Avatar of jdallen75
jdallen75Flag for Canada

asked on

Joining a MultiLookup on a multi-value report parameter

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")
Avatar of Arifhusen Ansari
Arifhusen Ansari
Flag of India image

Link to home
This content is only available to members.
To access this content, you must be a member of Experts Exchange.
Get Access
Avatar of jdallen75


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