How to pass "like" or "Contains" parameters to fetchXML in ssrs report

Question

I tried to pass parameter to fetch XML for generating report.

It works fine for "Text Equals" field. But does not works for "Contains" .

I tried this but it doest work.

<condition attribute="new_owner_lead" operator="like" value="@ParameterName"  />

also tried this

value='%"+@ParameterName+"%'
value='%@ParameterName%'

but it doesnt work.. Can Any one suggest.

Thanks in advance.

score 1 · Answer 1 · answered Jun 27 '13 at 12:17

1

Go into the properties of the dataset and click on the Parameters "tab". Enter the following for your parameter value: ="%" & Parameters!myParameter.Value & "%"

Then use the standard value for a parameter in the condition value:

answered Jun 27 '13 at 12:17

Jake1164

12,291
6
47
64

I am getting this error with this approach. [![enter image description here][1]][1] [1]: https://i.stack.imgur.com/bu0qS.png – Muzaffar Mahmood Jun 14 '20 at 14:18

score 1 · Answer 2 · answered May 24 '16 at 22:14

Go into the Properties of the Dataset (Make sure you don't go to the Parameters section) (See image below) and click on the Parameters "tab". Enter the following for your Parameter value:

="%" & Parameters!myParameter.Value & "%"

where myParameter is your variable, so yours will be different here.

Then use the standard value for a parameter in the condition value:

<filter type="and">
   <condition attribute="XXXXXXXXXX" operator="like" value="@myParameter" />
</filter>

I am getting this error with this approach. [1]: https://i.stack.imgur.com/bu0qS.png — Muzaffar Mahmood, Jun 14 '20 at 14:18

score 1 · Answer 3 · answered Aug 11 '21 at 23:56

Here is what the condition should be:

<condition attribute="new_owner_lead" value="%TEST%" operator="like"/>

In you case you can use something like:

var fetchXml = 
    $"<filter type='and'>
        <condition attribute='new_owner_lead' value='%{ParameterName}%' operator='like'/>
   </filter>";

How to pass "like" or "Contains" parameters to fetchXML in ssrs report

3 Answers3