adding seperator in list of values

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)

adding seperator in list of values

Author

Topic

winDows
Starting Member

9 Posts

Posted - 2008-07-30 : 15:53:39

Hi,

How can i add a seperator ; between each value while displaying multiple values from parameter list to the report.

ID - 1001; 1002; 1003; (like this).

thanks a lot .

Note. By mistake i posted this in some other forum, please don't lock this one please lock other one.Thanks.

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2008-07-31 : 02:41:44

I think it's going like this
Join(Parameters!Parmname.Label,"; ")

Webfred

There are 10 types of people in the world: Those who understand binary, and those who don't...

shilpaa
Starting Member

6 Posts

Posted - 2008-07-31 : 06:59:06

Hello,

You Can Use like this
= "ID - " & JOIN(Parameters!ID.Label ," ; ")

Shilpa Reddy

winDows
Starting Member

9 Posts

Posted - 2008-07-31 : 09:03:35

Thanks, it works.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources