sharepoint SSRS parameter problem
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
November 15th, 2010 2:37am

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
Free Windows Admin Tool Kit Click here and download it now
November 15th, 2010 4:39am

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
November 16th, 2010 4:10am

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
Free Windows Admin Tool Kit Click here and download it now
November 16th, 2010 5:03am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics