Solved

Microsoft Dynamics CRM Advanced find

Posted on 2014-01-15
3
584 Views
Last Modified: 2014-02-08
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?

Thanks,
0
Comment
Question by:ACUIWebDeveloper
  • 2
3 Comments
 
LVL 29

Expert Comment

by:Feridun Kadir
ID: 39782250
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.
0
 

Accepted Solution

by:
ACUIWebDeveloper earned 0 total points
ID: 39830531
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.
0
 

Author Closing Comment

by:ACUIWebDeveloper
ID: 39843912
No actual solution specified because it was not available.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We were having a lot of "Heartbeat Alerts" in our SCOM environment, now "Heartbeat" in a SCOM environment for those of you who might not be familiar with SCOM is a packet of data sent from the agent to the management server on a regular basis, basic…
Many companies are making the switch from Microsoft to Google Apps (https://www.google.com/work/apps/business/). Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now