Hi, I had created ssrs report in SSRS 2008 based on sharepoint list in SHarepoint 2007 I had created parameter of EMPGroup from another dataset. Paarmeter datatype is text. When I use that parameter to filter the report in tablx properties as columnname in parametername it shows data on running report but columnname LIKE parametername it shows error on running report why? Thanks & Regards, Vyankatesh Mujumdar

I use ="*" & Parameters!Name.Value & "*" but it shows me error. I had also tried this Expression: =iif(Fields!Test.Value like Parameters!Test.Value,"True","False") Comparison: = Value: True shows same error. I f I use ="*" & Parameters!Name.Value.toString() & "*" It dosent shows me error but not filtering any data What can I do? Is there any other way to use LIKE operator Thanks & Regards, Vyankatesh Mujumdar

Hi vyanku, From your description "When I use that parameter to filter the report in tablx properties as columnname in parametername it shows data on running report", it seems the parameter name is multiple values parameter. If I am incorrect, please feel free to let me know. By design, we are unable to compare a value with a mutli-value parameter using LIKE operator, as values in multi-value parameter are stored in an array. In order to fix the issue, please change the parameter to be single value parameter. Or, please tell us the scenario you have, there should have other solutions can be used to solve the issue. Thanks, Jin ChenJin Chen - MSFT

Yes . Correct. U resolved my problem. Like operator not works on Multiple value parameter. When I chaneged it to single value parameter it works. My problem is resolved. Thnaks :)Thanks & Regards, Vyankatesh Mujumdar