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

Anjali Shah 21 Reputation points
2022-06-28T15:07:27.283+00:00

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.

215756-image.png

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,735 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Joyzhao-MSFT 15,561 Reputation points
    2022-06-29T01:57:18.823+00:00

    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.

    0 comments No comments