fetchxml parameter - search free text and get all back

Betty 1 Reputation point

I hope someone could help me.

I have a report for D365 in fetchxml.
I want to use the "KRG" parameter and the user wants to search free text.
So into the dataset: <condition attribute="new_KRGname" operator="like" value="anonymous user" />


then I search with a % as a wildcard - so I get all entries with a text - but not the entries without a text > is there a way to search free text and get all entries with and without text?

best regards betty

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,822 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Joyzhao-MSFT 15,566 Reputation points

    Hi @Betty
    I am not sure if you are using SSRS products. I am not familiar with fetchxml and D365. I am sorry that I cannot provide useful help.
    I look forward to your issue being resolved as soon as possible.
    Best Regards,

    0 comments No comments