Error with join ssrs 2005

• collie

  Old Hand

  Points: 367

  More actions

  March 6, 2010 at 1:23 am

  #230591

  Hi,

  I have a multi select parameter CustomerType.

  I have a textbox with the following expression ="Customer Type: " & join(Parameters!CustomerType.Label,",")

  When i run the report i get the following error:

  Warning 1 [rsRuntimeErrorInExpression] The Value expression for the textbox ‘textbox71’ contains an error: Overload resolution failed because no Public 'Join' can be called with these arguments: 'Public Shared Function Join(SourceArray As String(), [Delimiter As String = ]) As String': Argument matching parameter 'SourceArray' cannot convert from 'String' to 'String()'. 'Public Shared Function Join(SourceArray As System.Object(), [Delimiter As String = ]) As String': Argument matching parameter 'SourceArray' cannot convert from 'String' to 'Object()'.

  What is the problem?

  Thanks

• bkahler

  Valued Member

  Points: 55

  More actions

  July 9, 2010 at 11:19 am

  #1190952

  Parameters!CustomerType.Label is not an array.

  It is the Label displayed for the Parameter.

  Use Parameters!CustomerType.Value

• gayathridevi.msit

  Ten Centuries

  Points: 1294

  More actions

  July 12, 2010 at 3:10 am

  #1191354

  Hi,

  Whether your dataset for the parameter is Cube (MDX ) or Sql query?

  if it is from cube can u provide some sample input for your parameter?

  Regards,
  Gayathri 🙂