Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Make a list in the textbox based on selection Expand / Collapse
Author
Message
Posted Wednesday, November 13, 2013 3:49 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, June 9, 2014 1:21 AM
Points: 58, Visits: 191
Goal:
Based on the selection, I want to have them displayed, in the text box, as a list for instance.

Canada,
xxxxxx,
xxxxx,
xxxxx,
xxxx,
xxxx,
xxx
etc.

Not this:
Canada, xxxxxx, xxxxx, xxxxx, xxxx, xxxx, xxx


Problem:
How should I do it?

Information:
The data source is SSAS.


  Post Attachments 
picture1.png (4 views, 254.42 KB)
picture4.png (3 views, 133.36 KB)
Post #1513780
Posted Wednesday, November 13, 2013 4:04 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 9:09 AM
Points: 213, Visits: 1,126
Hi,

If you're currently using =join(Parameter,",") to split the parameter into the horizontal list, you could try changing this to =join(Parameter,vbcrlf) to specify the multivalue parameter list should be delimited by a carriage return/line feed rather than a comma.

So in your case this would be

=join(Parameters!geo.Label,vbcrlf)
Post #1513790
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse