Overload resolution failed because no accessible 'Join' can be called with these arguments

Question

I have a dataset in ssrs in which one of the parameter has expression as

=IIF(Parameters!EquipmentTypeID.Value(0)=-1,NOTHING,JOIN(CInt(Split(Parameters!EquipmentTypeID.Value," ").GetValue(0)),","))

I have a dataset in ssrs in which one of the parameter has expression as

*=IIF(Parameters!EquipmentTypeID.Value(0)=-1,NOTHING,JOIN(CInt(Split(Parameters!EquipmentTypeID.Value," ").GetValue(0)),","))

'Parameters!EquipmentTypeID.Value' has value in the form like '38 612-FTQ-> Wheels' from which I want to extract 38 in my expression.*

But when I run the report, I get following error:

Overload resolution failed becuase no accessible 'Join' can be called with these arguments.

Answer 1

Hi @Anjali Shah ，
The first parameter of 'Join' must be either an array of string ('String()') or an array of object ('Object()').
I find you have resolved the issue in the following link: https://stackoverflow.com/questions/72788378/overload-resolution-failed-because-no-accessible-join-can-be-called-with-these
If you have any question, please feel free to let me know.
Best Regards,
Joy

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.