Thursday, February 07, 2013 12:02 PM
I am trying to display a multivalue parameters on a textbox and attaching some expressions to each instance of the parameter selected.
So far i have been able to use the =Join(Join(Parameters!subject.Value,",")) to display my parameters on a textbox and the result of this function is
matrixupdate, training completed, low sales, high turnover.
instead what i want to achieve is this using a count function with each parameter value diplayed.
matrixupdate: 35 , training completed : 68, low sales: 76, high turnover : 87.
Thursday, February 07, 2013 12:30 PM
From where you will get 35,68,76,87 etc? Is it harcoded?
Thursday, February 07, 2013 12:53 PM
No its not hardcoded. My table looks like this
Name subject date
John matrix update oct 2010
john matrix update jan 2012
john training completed feb 1998
john low sales jan 2003
john high turnover. sept 2006
I have a multivalued parameter called Parameters!subject.Value that has values. matrixupdate, training completed, low sales, high turnover and a parameter to select a name.
All i am trying to achieve is when a name is selected and any or all of the subject is selected, the report will display the name selected with a count of all the subjects selected under that name and the report will display
for the table displayed above if john is selected as the name parameter and all the subject is sellected.i want it to display:
matrix update: 2, training completed:1, low sales :1, high turnover:1
How can i pull this off usingt the =Join(Parameters!subject.Value,",") and Count(Fields!Parameters.value)
Friday, February 08, 2013 8:39 AMModerator
As per my understanding, this cannot be achieved. Join function returns a string created by joining a number of substrings contained in an array. We can separate the value in the array using a static string. In you scenario you want to separate the multiple parameters using dynamic number, this cannot be achieved in Reporting Services.
Thank you for your understanding.
TechNet Community Support
- Marked As Answer by Charlie LiaoMicrosoft Contingent Staff, Moderator Thursday, February 14, 2013 1:34 AM