Displaying values for Multi-value parameter

[Alain Quesnel]

At the top of my report, if I want to display the selected value for a given
parameter, I can put this expression in a text box:

="The xyz param's value is: " & Parameters!paramXYZ.Label(0).ToString

How do I go about displaying all the selected values for a multi-value
parameter (one that has mulitple checkboxes in the drop-down list)? Is it
possible to do a for loop and iterate through the values of the param within
an expression? Something like

for i = 0 to Parameters!paramXYZ.Count - 1
mystring = mystring & ", " & Parameters!paramXYZ.Label(i).ToString

And then display mystring in the textbox? Or can I use a list control on the
report?


Thank you,

Alain Quesnel
***@logiquel.com

www.logiquel.com

[Mouhanad Alkhaldi]

try to use the join as in the following:

=join(Parameters!Color.Value,"~")
or
=join(Parameters!Color.Label,"~")

taken from the post:
http://www.sqldev.org/sql-server-reporting-services/get-report-multi-value-parameters-39502.shtml


Mouhand Alkhaldi
www.mouhanad-alkhaldi.info

Post by Alain Quesnel
At the top of my report, if I want to display the selected value for a given
="The xyz param's value is: " & Parameters!paramXYZ.Label(0).ToString
How do I go about displaying all the selected values for a multi-value
parameter (one that has mulitple checkboxes in the drop-down list)? Is it
possible to do a for loop and iterate through the values of the param within
an expression? Something like
for i = 0 to Parameters!paramXYZ.Count - 1
mystring = mystring & ", " & Parameters!paramXYZ.Label(i).ToString
And then display mystring in the textbox? Or can I use a list control on the
report?
Thank you,
Alain Quesnel
www.logiquel.com
Submitted via EggHeadCafe
Creating Google Motion Charts from Excel data
http://www.eggheadcafe.com/tutorials/aspnet/86599bca-edda-4204-af15-7a1cf901a071/creating-google-motion-charts-from-excel-data.aspx

[Mouhanad Alkhaldi]

you can try the following expression:

=join(Parameters!Color.Value,",")

or (if your parameter is coming from query)

=join(Parameters!Color.Label,",")

from the original post:
http://www.sqldev.org/sql-server-reporting-services/get-report-multi-value-parameters-39502.shtml




Mouhand Alkhaldi
www.mouhanad-alkhaldi.info

Post by Alain Quesnel
At the top of my report, if I want to display the selected value for a given
="The xyz param's value is: " & Parameters!paramXYZ.Label(0).ToString
How do I go about displaying all the selected values for a multi-value
parameter (one that has mulitple checkboxes in the drop-down list)? Is it
possible to do a for loop and iterate through the values of the param within
an expression? Something like
for i = 0 to Parameters!paramXYZ.Count - 1
mystring = mystring & ", " & Parameters!paramXYZ.Label(i).ToString
And then display mystring in the textbox? Or can I use a list control on the
report?
Thank you,
Alain Quesnel
www.logiquel.com

Post by Mouhanad Alkhaldi
=join(Parameters!Color.Value,"~")
or
=join(Parameters!Color.Label,"~")
http://www.sqldev.org/sql-server-reporting-services/get-report-multi-value-parameters-39502.shtml
Mouhand Alkhaldi
www.mouhanad-alkhaldi.info
Submitted via EggHeadCafe
ASP.NET GridView Persist User-Selected CheckBox Values
http://www.eggheadcafe.com/tutorials/aspnet/58db18a0-fcd6-43d2-954a-ae076427b739/aspnet-gridview-persist-userselected-checkbox-values.aspx

[Mouhanad Alkhaldi]

=join(Parameters!Color.Value,"~")
or
=join(Parameters!Color.Label,"~")




http://www.sqldev.org/sql-server-reporting-services/get-report-multi-value-parameters-39502.shtml

mouhanad Alkhaldi

Post by Alain Quesnel
At the top of my report, if I want to display the selected value for a given
="The xyz param's value is: " & Parameters!paramXYZ.Label(0).ToString
How do I go about displaying all the selected values for a multi-value
parameter (one that has mulitple checkboxes in the drop-down list)? Is it
possible to do a for loop and iterate through the values of the param within
an expression? Something like
for i = 0 to Parameters!paramXYZ.Count - 1
mystring = mystring & ", " & Parameters!paramXYZ.Label(i).ToString
And then display mystring in the textbox? Or can I use a list control on the
report?
Thank you,
Alain Quesnel
www.logiquel.com

Post by Mouhanad Alkhaldi
=join(Parameters!Color.Value,"~")
or
=join(Parameters!Color.Label,"~")
http://www.sqldev.org/sql-server-reporting-services/get-report-multi-value-parameters-39502.shtml
Mouhand Alkhaldi
www.mouhanad-alkhaldi.info

Post by Mouhanad Alkhaldi
=join(Parameters!Color.Value,",")
or (if your parameter is coming from query)
=join(Parameters!Color.Label,",")
http://www.sqldev.org/sql-server-reporting-services/get-report-multi-value-parameters-39502.shtml
Mouhand Alkhaldi
www.mouhanad-alkhaldi.info
Submitted via EggHeadCafe
JSONP AJAX and ASP.NET Demystified
http://www.eggheadcafe.com/tutorials/aspnet/b71ea548-93e0-4cec-9fb1-35f641b83e65/jsonp-ajax-and-aspnet-demystified.aspx

[Mouhanad Alkhaldi]

=join(Parameters!Color.Value,"~")


=join(Parameters!Color.Label,"~")

http://www.sqldev.org/sql-server-reporting-services/get-report-multi-value-parameters-39502.shtml

Post by Alain Quesnel
At the top of my report, if I want to display the selected value for a given
="The xyz param's value is: " & Parameters!paramXYZ.Label(0).ToString
How do I go about displaying all the selected values for a multi-value
parameter (one that has mulitple checkboxes in the drop-down list)? Is it
possible to do a for loop and iterate through the values of the param within
an expression? Something like
for i = 0 to Parameters!paramXYZ.Count - 1
mystring = mystring & ", " & Parameters!paramXYZ.Label(i).ToString
And then display mystring in the textbox? Or can I use a list control on the
report?
Thank you,
Alain Quesnel
www.logiquel.com

Post by Mouhanad Alkhaldi
=join(Parameters!Color.Value,"~")
or
=join(Parameters!Color.Label,"~")
http://www.sqldev.org/sql-server-reporting-services/get-report-multi-value-parameters-39502.shtml
Mouhand Alkhaldi
www.mouhanad-alkhaldi.info

Post by Mouhanad Alkhaldi
=join(Parameters!Color.Value,",")
or (if your parameter is coming from query)
=join(Parameters!Color.Label,",")
http://www.sqldev.org/sql-server-reporting-services/get-report-multi-value-parameters-39502.shtml
Mouhand Alkhaldi
www.mouhanad-alkhaldi.info

Post by Mouhanad Alkhaldi
=join(Parameters!Color.Value,"~")
or
=join(Parameters!Color.Label,"~")
http://www.sqldev.org/sql-server-reporting-services/get-report-multi-value-parameters-39502.shtml
mouhanad Alkhaldi
Submitted via EggHeadCafe
Creating Google Motion Charts from Excel data
http://www.eggheadcafe.com/tutorials/aspnet/86599bca-edda-4204-af15-7a1cf901a071/creating-google-motion-charts-from-excel-data.aspx