all groups > sql server reporting services > may 2007 >
You're in the

sql server reporting services

group:

Display Multi Value parameter in the report as a field


Display Multi Value parameter in the report as a field Sriman
5/14/2007 10:09:00 AM
sql server reporting services:
Hi,

I would like to show the Multi value parameter values in my report in the
title.
How can i display all value with comma separated. like If the user selects 4
values of out of 100 , I have to show the report title like "Event
Data:comp1, comp2.."


Regards,
RE: Display Multi Value parameter in the report as a field Michael C
5/14/2007 10:24:04 AM

Use the Join.String(Parameter!MyParameter.Value,",") method

Michael

[quoted text, click to view]
RE: Display Multi Value parameter in the report as a field Sriman
5/14/2007 10:33:03 AM
In the expression I have written like this..
=Join.String(Parameters!paramComputerName.Value,",") and got this error
[BC30516] Overload resolution failed because no accessible 'Join' accepts
this number of arguments

Regards,
Sri

[quoted text, click to view]
RE: Display Multi Value parameter in the report as a field Michael C
5/14/2007 10:39:02 AM

try just using Join() instead of Join.String(). How many entries from the
multi value are they picking?



[quoted text, click to view]
RE: Display Multi Value parameter in the report as a field Sriman
5/14/2007 10:51:01 AM
thank you.
join() worked fine to me.

[quoted text, click to view]
AddThis Social Bookmark Button