Dynamics Community Forum Thread Details

How to get lookup field Name in SSRS report

I have 3 entities, say A, B and C, both B & C are child records (1-N) of A. Entity B has fields looking up to both A(regardingid) and C. In my SSRS i am meant to check in my B Table if C is equals to a particular/specific type of record name, then tick a box. My problem now is, how do i do if (c== "name string" or even an Id). My Fetchxml is below :

I am passing @Aid as a paremeter. Is my fetchXMl wrong here ? , I am currently using this to search entity C in B:

=IIF((Fields!C.Value Like "*The timeline checks and calculations are correct and appropriately evidenced*") AND (decision.Value= "Pass"),chr(254),"o"), but it returns back nothing, with multiple repeating cells. PLease someone with better knowledge help.

Thanks

You should download Xrmtoolbox and check your fetchxml statement in fetchxml builder, this will check if your fetxchxml is currectly pulling the result you are looking for.

I assume your aid is entity a's id. pulling aid will get you guid of the record instead of the name, if you want to compare name, it should be attribute "Aname", or use "aid" if you are comparing against guid.

For example, primary contact is a lookup field for owner.

If you want to check against guid, it should be like

If you want to check against name, it should be like

Either one will work when you use lookup field as filter condition.

Please mark as verfied if this resolve your issue.

Quick Links

Leaderboard