Error with join expression SSRS 2005

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

Error with join expression SSRS 2005

Author

Topic

collie
Constraint Violating Yak Guru

400 Posts

Posted - 2010-03-04 : 16:59:11

Hi,

I have a multivalue parameter. 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

Whisky-my beloved dog who died suddenly on the 29/06/06-I miss u so much.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-03-05 : 10:15:20

is Parameters!CustomerType.Label multivalued?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

collie
Constraint Violating Yak Guru

400 Posts

Posted - 2010-03-05 : 11:33:16

yes it's multivalued

Whisky-my beloved dog who died suddenly on the 29/06/06-I miss u so much.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-03-05 : 11:51:41

oh why are taking label rather than value?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

collie
Constraint Violating Yak Guru

400 Posts

Posted - 2010-03-05 : 17:05:32

Hi,

because value =id and label =name. When i put value i get 2 for example and label gives me the name eg Paper.

Whisky-my beloved dog who died suddenly on the 29/06/06-I miss u so much.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-03-06 : 02:11:23

what does this return you?

join(Parameters!CustomerType,",")

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

collie
Constraint Violating Yak Guru

400 Posts

Posted - 2010-03-06 : 02:58:51

Hi,

This is what i get:
[rsCompilerErrorInExpression] The Value expression for the textbox ‘textbox71’ contains an error: [BC30518] Overload resolution failed because no accessible 'Join' can be called with these arguments:
Build complete -- 1 errors, 0 warnings

Whisky-my beloved dog who died suddenly on the 29/06/06-I miss u so much.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources