Say for e.g. we want a report that shows all the contacts based on owners selected.
If we create the query using advanced find, our query will look like this
Here we have selected three users for owner.
From the query we get the initial impression that it won’t be possible to use the above Fetch XML in our report as the Value Tag needs to dynamic based on the no. of the owners selected.
However to use it in the report we need to make the following change in the query
Here @Owners Query Parameter will takes its value from a Multivalued Report Parameter.
Hope it helps.