Post reply

Multiple parameter ODBC

  • January 16, 2013 at 4:16 am

    #393949

    Hi

    I have created a report in BIDS 2008 that connects via ODBC connection.

    I am having issue with the parameters for multiple values.

    In the Dataset query I have :

    (M10.PARTNO in (:Alloy))

    and in the dataset properites under parameter I have:

    =join(Parameters!Alloy.Value, ", ")

    This works if I select one value from the drop down, but if i select more than one it returns no data.

    Can anyone please advise?

    Thanks

    R

  • January 16, 2013 at 8:51 am

    #1577872

    Try changing =join(Parameters!Alloy.Value, ", ") to just =Parameters!Alloy.Value

  • January 16, 2013 at 9:27 am

    #1577898

    Thanks for the reply. Unfortunately still no data. Work if I select one value but more than one gives no data.

  • January 16, 2013 at 10:01 am

    #1577937

    Ok, think you'll need to split the parameter out in the query like the one here[/url]

    So M10.PARTNO in (:Alloy)) becomes M10.PARTNO in ((SELECT Item FROM dbo.DelimitedSplit8K(:Alloy, ',')))

    Assuming you're using MS SQL as your datasource, which I'm not sure you are.

  • January 17, 2013 at 6:33 am

    #1578290

    Thanks

    Im writing it against Oracle 11g

    Is the "dbo.DelimitedSplit8K" part of the query you have written what I should type or should i replacing it with something else? At the moment it is saying 'Right paraenthisis missing' I have checked and there are the right amount of brackets there.

    Thanks

    Rakhee

  • January 17, 2013 at 8:10 am

    #1578327

    dbo.DelimitedSplit8K is the user-defined function described in the article I linked to in my second reply. It's only valid in MS SQL though.

    It's basically a bit of code that will convert the parameters into the correct format:

    The parameters are being passed to the report query as 'Brass, Bronze' - you need something to convert it into 'Brass', 'Bronze'

    This link might help you further:

    http://social.msdn.microsoft.com/Forums/uk/sqlreportingservices/thread/31c1ab35-2b78-4d30-9fec-7c95e1cd7d0a

    Cheers

    Gaz

  • January 17, 2013 at 8:54 am

    #1578359

    Thank you for your help, I found the issue.

    I changed my conenction type to Oracle rather than ODBC and now your first suggestions works.

  • January 17, 2013 at 9:16 am

    #1578372

    Excellent, thanks.

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

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