Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
concatinating SSRS Multivalue parameters with expressions

Answered concatinating SSRS Multivalue parameters with expressions

  • Thursday, February 07, 2013 12:02 PM
     
     
    Sign In to Vote
    0

    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.

    Please HELP


     

All Replies

  • Thursday, February 07, 2013 12:30 PM
     
     
    Sign In to Vote
    0

    Hi,

    From where you will get 35,68,76,87 etc? Is it harcoded?

    Thanks,

    Rana

     
  • Thursday, February 07, 2013 12:53 PM
     
     
    Sign In to Vote
    0

    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:

    Name:John

    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) 



    • Edited by twizy Thursday, February 07, 2013 12:54 PM
    • Edited by twizy Thursday, February 07, 2013 12:56 PM
    •  
     
  • Friday, February 08, 2013 8:39 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hi Twizy,

    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.

    Regards,

    Charlie Liao
    TechNet Community Support