Drop Down Parameter List

I have a string with values that are separated by a space. It looks like this: DAY MICS SUN FIX STD . I would like to take the string and make it a drop down list in a report parameter. I have tried the split function but it errors on me. How can I accomplish this

Answer this question

Drop Down Parameter List

truittjl
Is the value dynamic
If not, could have manually put into parameter list

If it's dynamic, I think best way is to use a Query for the parameters
and do the split in T-SQL

split function
http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnsqlmag01/html/TreatYourself.asp
Filipo
Thanks for responding. Yes the value is dynamic. When you say do the split in T-SQL (Transaction SQL ) how do you do that I dropped the code from the article link you sent me into the code section under report properties. I get an error "There is an error on line 0 of custom code: [BC30188] Declaration expected." Maybe that is not where it goes My query looks like this so far: SELECT ImplodedsubKeywordsList WHERE FORMULA("@Contains(keywords;\"KI Product Demand Category\")" ) Do I just tack that code onto the end of it somehow Thank you.
Drop Down Parameter List

Answer this question

Drop Down Parameter List

Hot Topic

SQL Server

Drop Down Parameter List

Drop Down Parameter List

truittjl

Filipo