locked
SSRS does not render multi paramaters RRS feed

  • Question

  • SSRS does not render multi paramaters.  It only renders the first selection of the many paramaters i have an option for.

    SSRS 2008/SQL 2008/WIN Server 2003 R2
    Wednesday, February 3, 2010 4:46 PM

Answers

  • Hi kdwenze,

    Thanks for your posting.

    By design, the values for a multiple values parameter is an array. If we use the parameter in this way " =Parameters!parameter.Value ", it will return an array not a string value. In some cases, if we double-click the parameter from "Expression" editor, the report designer will auto add (0) to the expression like this " =Parameters!parameter.Value(0) ", it will only return the first value of the values of the multiple values.

    If we are using multi-values parameter in a Filter, please make sure the filter is some one like this:
    Expression: = Fields!field.Value
    Operator: IN
    Value: =Parameters!parameter.Value (No (0) at the end)


    By the way, if possible, could you please post the RDL to me to this mail sqltnsp @ microsoft dot com(Please remove spaces around @, and replace " dot " with .). That will help us to solve the issue smoothly.
    Email Format:
    Subject: Thread: 
    SSRS does not render multi paramaters
    
    Body:
    
    Hi Jin,
    
    Thread URL: http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/eee98efb-7e17-41e0-a4a2-3147366ead3f
    <Other information that would be helpful>


    If there is anything unclear, please feel free to ask.

    Thanks,
    Jin Chen

    Jin Chen - MSFT
    • Marked as answer by Jerry Nee Thursday, February 18, 2010 8:29 AM
    Thursday, February 4, 2010 7:27 AM

All replies

  • normally you will need to have your stored procedure parse the parameters or use the in statement

    ie select * from tablename where pk in (@multi_parameter)
    looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
    Wednesday, February 3, 2010 4:55 PM
  • Hi kdwenze,

    Thanks for your posting.

    By design, the values for a multiple values parameter is an array. If we use the parameter in this way " =Parameters!parameter.Value ", it will return an array not a string value. In some cases, if we double-click the parameter from "Expression" editor, the report designer will auto add (0) to the expression like this " =Parameters!parameter.Value(0) ", it will only return the first value of the values of the multiple values.

    If we are using multi-values parameter in a Filter, please make sure the filter is some one like this:
    Expression: = Fields!field.Value
    Operator: IN
    Value: =Parameters!parameter.Value (No (0) at the end)


    By the way, if possible, could you please post the RDL to me to this mail sqltnsp @ microsoft dot com(Please remove spaces around @, and replace " dot " with .). That will help us to solve the issue smoothly.
    Email Format:
    Subject: Thread: 
    SSRS does not render multi paramaters
    
    Body:
    
    Hi Jin,
    
    Thread URL: http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/eee98efb-7e17-41e0-a4a2-3147366ead3f
    <Other information that would be helpful>


    If there is anything unclear, please feel free to ask.

    Thanks,
    Jin Chen

    Jin Chen - MSFT
    • Marked as answer by Jerry Nee Thursday, February 18, 2010 8:29 AM
    Thursday, February 4, 2010 7:27 AM
  • Hi kdwenze,

    Is there any update?

    Thanks,
    Jin Chen
    Jin Chen - MSFT
    Wednesday, February 10, 2010 1:48 AM