Post reply

SSRS Parameter: The option to type in multiple values in text box

  • May 24, 2016 at 10:28 am

    #314136

    Hi guys,

    I would like some insight on how to incorporate in my parameter the ability to allow user to type directly multiple values into a text box parameter. I'm not looking to do a drop down filter. I want the users to be able to type or copy and paste the said member id numbers directly into the text box and run the report. Example: "000001020 0001030210 0010100100 1001010101"

    The parameter in question is @memberid

    Below is a sample of how my parameters are created:

    where (GLCodeL4Descr IS NOT NULL) AND (t1.MasterHierarchyId > 0) AND (t1.GLCodeL4 IN (@glcode)) AND (t1.MasterHierarchyId IN (@benplan)) AND

    (t1.DateOfServiceFrom BETWEEN CAST(@startdate AS datetime) AND CAST(@enddate AS datetime)) AND (t1.DatePosted BETWEEN @datepostedfrom AND

    @datepostedto)

    AND t1.Memberid =@Memberid

  • May 24, 2016 at 1:24 pm

    #1881196

    Anyone??????

  • May 24, 2016 at 6:51 pm

    #1881232

    If you do that, you'll have to parse the values yourself. Try DelimitedSplit8K[/url] and put that in your WHERE clause.

  • May 24, 2016 at 8:06 pm

    #1881239

    pietlinden (5/24/2016)

    If you do that, you'll have to parse the values yourself. Try DelimitedSplit8K[/url] and put that in your WHERE clause.

    Thanks for your input. So even if the data is in the format below I would still need to parse it out?

    000301020

    000500200

    000300020

    012002022

  • May 24, 2016 at 8:51 pm

    #1881240

    Yes, because otherwise SSRS will see it as a single long text string. If you're passing it to a stored procedure as a parameter value, then you absolutely need it.

Viewing 5 posts - 1 through 4 (of 4 total)

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