Display Multi Value Parameter in Header 1

[satinsilhouette]

Hi,

I need to display a multi value integer (not string) parameter in SRSS 2005 Header. I can't seem to find any snippets of code for an interation loop or anything else. Has someone done this yet?

Ex:

AU
1
2
3
4
5
6

User chooses 3,4,5. They want to see 3,4,5 displayed in header.

Thanks!

Thanks so much!
satinsilhouette

 

[DaveInIowa]

Header Expression:

=Join(Parameters![red]multiValueParameterName[/red].Value, ",")

 

[satinsilhouette]

Hi,

Thanks but that is for string, not integer. I appreciate you answering though!

Thanks so much!
satinsilhouette

 

[DaveInIowa]

What do you mean by it "is for string, not integer"? It returns a string but does not require the parameter itself to be a String/Text data type as the Join function is overloaded to accept an array of Objects. Did you attempt to use it to see what it does?

 

[satinsilhouette]

Yes and it barked at me, gave me an error. Said I couldn't use the join with an interger.

Thanks so much!
satinsilhouette

 

[DaveInIowa]

I'm using SSRS 2008 and not having any problems using Join with a multi-value integer parameter. Where are you seeing this error; in the Expression editor or at run-time? When you type "=Join(" in the Expression editor, what do you see for the Intellisense options after typing the opening parenthesis?

 

[DaveInIowa]

By the way, you're not typing

=Join(Parameters!multiValueParameterName.Value[b][red](0)[/red][/b], ",")

are you?

 

[satinsilhouette]

well you hit the nail on the head. If you just double click on the parm in the expressions it adds the (0).

Thanks that was a great catch! Problem solved!

Thanks so much!
satinsilhouette