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: Tuesday, January 28, 2014 6:47 AM
Points: 56, Visits: 184
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-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 9:15 AM
Points: 165, Visits: 902
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