1

We want to run a report on the enquiries/feedback and the outcomes and signposting that result from each one. However, when we run a report it splits each record entered into individual records for 'Enquiries/Feedback', 'Outcome', 'Signposting' etc so they are not joined up and therefore we cannot see what the outcome was of an enquiry or where it was signposted to. How can we do this? Many thanks

  • It would help us all to help you if you specify what CMS and what version of CiviCRM you are using. Also add a little more detail, possibly screen prints so we can understand your issue. Just read your question and I have no clue what you are talking about other than a report that does something you did not expect.... – ErikH - CiviCooP Oct 19 '17 at 14:30
  • This is the version we are using: CiviCRM 4.7.22 For some reason I can't add a screenshot to this comment box. But basically each record that we have entered onto the database gets split out when reporting as if it were a separate entry but we would like it to just be the one entry as when it was entered – George Healthwatch Oct 19 '17 at 14:35
  • 1
    @GeorgeHealthwatch It's best to add screenshots by editing the original question. – Jon G - Megaphone Tech Oct 19 '17 at 17:04
  • The screenshots will be critical here because CiviCRM is used for a variety of uses - and "Enquiries/Feedback", "Outcome", etc. are terms specific to your usage. With screenshots, we can tell how they were implemented for you (e.g. as Activities, Cases, etc.) and provide you with appropriate help. – Jon G - Megaphone Tech Oct 19 '17 at 17:05
  • and the reason you are being asked about your CMS is that Drupal (views) let's you pull together info which is otherwise v hard to do in civicrm – petednz - fuzion Oct 19 '17 at 17:56
1

I'm going to guess that these fields containing "enquiries/feedback and the outcomes and signposting" are either custom contact fields with multiple entries or activities. In either case, you probably want to use the report grouping feature to group by contact (e.g. by contact id), that would likely get you closer to what you want. If you sort by id or date of these other things, then you might get a nice chronological display per contact.

If you want a fancier display, you'll likely have to write a custom report.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.