Blog Site

 Error

Web Part Error: A Web Part or Web Form Control on this Page cannot be displayed or imported. You don't have Add and Customize Pages permissions required to perform this action. Correlation ID: 81be869f-5009-f008-e1ec-d7631ea60a7b.
Dec 20
How to put multiple values within a fetchXML condition through parameters in Reporting Services.

If you need to use dynamic multiple value parameters in a fetch condition the correct syntax would be something like this:

 

<filter type="and">

<condition attribute="code" operator="in" value="@Code" />

<condition attribute="productname" operator="in" value="@ProductName" />

</filter>

 

@Code and @ProductName are multiple value parameters.

 

Or maybe you want to do this manually. In that case the syntax would be:

 

<fetch mapping='logical'>

<entity name='product'>

<filter type="and">

<condition attribute="code" operator="in" >

    <value>111</value>

    <value>222</value>

    <value>333</value>

</condition>

</filter>

</entity>
</fetch>

 

The values were invented for the example.

if you want to learn more about Dynamics CRM and Reporting Services we recommend to buy our book











​           Order now


Comments

Great post - just what I wa...

Great post - just what I was looking for
 on 10/18/2017 7:47

Great post - just what I wa...

Great post - just what I was looking for
 on 10/18/2017 7:47

x05276100@Gmail.com 

 on 6/24/2018 2:06
​​
​​
All Material in this Website is Property of Remoting Coders. ©2003-2017 Remoting Coders. All rights reserved.

John Doe

Chat with us

Jane Smith
12:23 PM

Hi, I wanted to make sure you got the latest product report. Did Roddy get it to you?


Remoting Coders is typing a message...
All of our staff members are not available at the moment, please try again later, or leave your questions here and we'll back to you shortly.