troubleshooting Question

Crystal Report displaying multiple records

Avatar of wade2000
wade2000 asked on
Crystal Reports
6 Comments1 Solution256 ViewsLast Modified:
Using CR11 and trying to display notes for an organisation which has contacts
for example, at organsation ABC i met with contact1,contact2,contact3 and the note for that meeting

at the moment its displaying
ABC contact1 "the note"
ABC contact2  "the note"
ABC contact3  "the note"

the way i want it is
ACB Contact1,contact2,contact3 "the note"

This was fine when Select Distinct records was working, at the moment when i select it, i get this error
"Failed to retrive data from the database"

is there any other way to achieve this

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 6 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros