• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 674
  • Last Modified:

Microsoft Dynamics CRM Advanced find

I need help creating a report.  On our website, we ask demographic questions of our users.  These are stored as a separate forms record.  My issue is that I cannot figure out how to pull both the contact information I need (First name, Last name, Institution, email, and primary phone number) as well as the questions and their respective answers.  I can get one or the other but not both on one report.

Ideas?  Suggestions?  Questions?

  • 2
1 Solution
Feridun KadirPrincipal ConsultantCommented:
Am I right in thinking you have a contact (or user?) record that has linked to it multiple questions and answer records?

If so, then there must be a linking field from the q an a record to the contact. In Advanced Find, run the query of the Q and A record. Then when you select Add Columns click in the drop down at the top of the windows (Record Type) and then select the parent record type, contact. Then you will see contact columns which you can add to the results view.
ACUIWebDeveloperAuthor Commented:
Our System Administrator figured it out on his own, but does not remember what he did exactly to make it work. So, unfortunately, the answer is not available for posting. Thanks anyways for all comments.
ACUIWebDeveloperAuthor Commented:
No actual solution specified because it was not available.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now