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

.net xml crm fetch fetchxml
Vishnu picture Vishnu · Jun 27, 2013 · Viewed 7.5k times · Source

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.

Answer

Jake1164 picture Jake1164 · Jun 27, 2013

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:

Related questions

Read XML Attribute using XmlDocument

How can I read an XML attribute using C#'s XmlDocument? I have an XML file which looks somewhat like this: <?xml version="1.0" encoding="utf-8" ?> <MyConfiguration xmlns="http://tempuri.org/myOwnSchema.xsd" SuperNumber="1" SuperString="whipcream"> <…

Read More
How to read attribute value from XmlNode in C#?

Suppose I have a XmlNode and I want to get the value of an attribute named "Name". How can I do that? XmlTextReader reader = new XmlTextReader(path); XmlDocument doc = new XmlDocument(); XmlNode node = doc.ReadNode(reader); foreach (XmlNode chldNode in …

Read More
Query an XDocument for elements by name at any depth

I have an XDocument object. I want to query for elements with a particular name at any depth using LINQ. When I use Descendants("element_name"), I only get elements that are direct children of the current level. What I'm …

Read More