User Dataset Query in SSRS for D365

 User Dataset Query in SSRS for D365

In SSRS report, when populate user field,  below User dataset query can be used to retrieve user info.

 

<fetch version="1.0" output-format="xml-platform"

       mapping="logical" distinct="false">

   <entity name="systemuser">

      <attribute name="fullname" />

      <attribute name="systemuserid" />

      <order attribute="fullname" descending="false" />

      <filter type="and">

         <condition attribute="systemuserid"

                    operator="eq-userid" />

      </filter>

   </entity>

</fetch>