January 16, 2013 at 4:16 am
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
Try changing =join(Parameters!Alloy.Value, ", ") to just =Parameters!Alloy.Value
January 16, 2013 at 9:27 am
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
January 17, 2013 at 6:33 am
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
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:
Cheers
Gaz
January 17, 2013 at 8:54 am
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
Excellent, thanks.
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy