Friday, February 15, 2013 10:35 PM
In SSRS, how can you force a filtered lookup to display the text value instead of the guid?
Saturday, February 16, 2013 6:56 AMAnswerer
When querying using fetch xml or against the filtered views, you simply need to add 'name' onto the id field. So if you had primarycontactid you would use primarycontactidname to get the display name.
- Proposed As Answer by Scott DurowMicrosoft Community Contributor, Editor Saturday, February 16, 2013 9:24 PM
- Marked As Answer by DavidJennawayMVP, Moderator Monday, February 18, 2013 9:51 PM
Monday, February 18, 2013 2:54 PM
I figured out the real problem.
I needed contractnumber, not contractid.
Thursday, February 21, 2013 1:12 PM
I have worked with the SSRS to retrieve the text value of the lookup field. i achieved it.
i am having "territory" lookup in my form. so in SSRS i took the filtered views and then we will have the two schema names with the "territory" as "territory" and "territoryname". I took the "territoryname" in the query.
As in this way i acheived the issue...
Hope this will be useful to you guys.......
- Proposed As Answer by prudween Friday, February 22, 2013 6:49 AM