Thursday, February 14, 2013 9:58 PM
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
Friday, February 15, 2013 10:07 AM
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.
Friday, February 15, 2013 11:17 AM
Please mark as answered or vote helpful if this post help resolved your issue. Thanks!
k r o o t z