jdallen75
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(Pa rameters!L ineType.Va lue,","), 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].T extRuns[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!LineTyp e.Value(0) , Fields!Message.Value, Fields!Translation.Value, "dsGetTranslations")
=Join(MultiLookup(Split(Pa
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].T
This expression works OK if I just look at the first LineType element alone:
=Lookup(Parameters!LineTyp
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER