How to process multi select parameters using a stored procedure

  • pl;'ol';/l

  • I must be missing something. Passing parameters from SSRS to SQL procedures is usually very, very simple. You define them in the query.

    As for multi-value parameters, I like using table-value-parameters for those, if you're on SQL 2008. No need to parse out a string in the proc if you do that.

    So I must be misreading something, because what I'm reading seems to say that you can't figure out how to pass a parameter from a report to a stored procedure.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • Ok here is a very simple question. I have a multi select parameter, where I'm setting the Label = (company + '-' + companyid)

    so a concatenated Label, I have created in the same query a Value of companyid field.

    How can I make the Value parameter hidden and pass the array(?) to my stored procedure?

    Is that clear enough?

  • do you think the words "concatenate" or "multi select" are too hard for people to understand?

  • or maybe I need to define how sql databases use a "query" to get data, or maybe define what a stored procedure is?

    just how simple do my statements need to be to get some help? Do I need to go back to how computers were built or how they work?

  • oh and while we are at it, what is a "table-value-parameter" because that is a new term, that I don't see in any setting in ssrs

  • DeanORenO (1/9/2012)


    do you think the words "concatenate" or "multi select" are too hard for people to understand?

    I was going to try to help you, but if you're just going to be insulting, I'll take my time elsewhere.

    Best of luck to you.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • p[

    'kl[pl

  • DeanORenO (1/9/2012)


    pl;'ol';/l

    Wow, I looked at this because I thought I might be able to help, but I can't because you apparently edited the post into nonsense. Plus you insulted someone who tried to help you. Still I'll try to help.

    Your second question really isn't clear. The Value property of a parameter is never displayed to the user in reporting services. Here are some articles that might help you understand multi-value parameters:

    http://msdn.microsoft.com/en-us/library/aa337396.aspx

    http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/ssrs_multi_value_parameters

    http://msdn.microsoft.com/en-us/library/aa337292.aspx

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply