Get Text Value of Lookup in SSRS - Instead of GUID

All Replies

• Saturday, February 16, 2013 6:56 AM

  Answerer

   

   
  

  1

  Hi,

  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.

  ---

  Scott Durow
  Read my blog: www.develop1.net/public     Follow Me on Twitter
  If this post answers your question, please click "Mark As Answer" on the post and "Mark as Helpful"

  • 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
  •  
  • Reply
  • Quote

   
• Monday, February 18, 2013 2:54 PM

   

   
  

  0

  I figured out the real problem.

  I needed contractnumber, not contractid.

  • Reply
  • Quote

   
• Thursday, February 21, 2013 1:12 PM

   

   
  

  1

  Hello all,

  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.......

  ---

  Prudveen D

  • Proposed As Answer by prudween Friday, February 22, 2013 6:49 AM
  •  
  • Reply
  • Quote