Link to home
Start Free TrialLog in
Avatar of apollo7
apollo7Flag for United States of America

asked on

We are working on converting SQL SSRS reports to FetchXML

Dynamics 365 9.1,  

We are working on converting SQL SSRS reports to FetchXML for the Dynamics 365 Online environment.  We have completed most of a report but still have the following to convert:


SQL
select Value
from FilteredStringMap
where FilteredViewName ='FilteredFEI_nanoportdemo'
and attributename = 'fei_nano_nnplocation'

Open in new window


FETCH
<fetch mapping="logical" version="1.0">
  <entity name="StringMap">
    <attribute name="Value" />
    <filter>
      <condition attribute="ViewName" operator="eq" value="FEI_nanoportdemo" />
      <condition attribute="attributename" operator="eq" value="fei_nano_nnplocation" />
    </filter>
  </entity>
</fetch>

Open in new window


We can query the Stringmap in SQL and can see it Fetchxml Builder but cant link the stringmap/option set to the report

ASKER CERTIFIED SOLUTION
Avatar of Feridun Kadir
Feridun Kadir
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of apollo7

ASKER

Thanks, we reviewed our approach based on your comment and this solved our issue