mutivalue parameter

Question

i have a report which has a column called createdvia which in the table in numeric id's. like 25,35,45 and gave a case statement in query where ever id that is 35 is email and rest as OTHER and named the column as CreatedBy. i want a parameter in the report which should be createdBy and in the drop down should be like Email,Other,Both. i tried creating a 2nd dataset which i took created by column and tried giving it as paramter but i am getting an error. When i give Createdvia column its perfect and drop down shows all 25,35,45...

The case statement i gave is

case when createdvia='35' then 'email' else 'other' end as CreatedBY

i need a multivalue parameter which gives me drop down as Email,Other,both

---

HoneyBunch

Answer 1

HI Honeycrust,

You can solve your problem by creating a query of your parameters having two columns, ID and NAME.

On your parameter properties select Available Values -> Get values from query then :

On Value field choose the field which be used on your query, and on lable field choose the field which will be printed.

Regards

---

dj's

http://simplesqlserver.wordpress.com/

Answer 2

See below:

---

Please mark as answered or vote helpful if this post help resolved your issue. Thanks!

k r o o t z