1

My org wants to know which countries were represented at an event. A simple way to do this is to "group by" country. Does CiviReport have a concept of grouping by a column?

5

Reports for Contributions have grouping and quite a few in the 'Extended Reports' extension (which I guess most would use) as well. The 'Report Plus' extension has grouping also. So CiviCRM certainly has the concept of grouping. In addition the new 'Search Kit' can do grouping - and many other things, it's a really significant addition to CiviCRM.

1
  • 1
    The question mentions CiviReport, but I think Search Kit would be the best way to get a list of countries represented at an event. Oct 13 at 3:04
3

You can build that with Search Kit

Try this on dmaster.demo.civicrm.org

enter image description here enter image description here

3
  • i think it is great that you are offering these examples so thought adding the screenshot would help protect the example beyond the next 'flush' (or am i wrong? will they stick around?)
    – petednz - fuzion
    Oct 14 at 18:44
  • Good idea to include the screenshot, but actually it's all in the (very long!) URL so won't be flushed.
    – Aidan
    Oct 14 at 20:05
  • ah. right. nice
    – petednz - fuzion
    Oct 15 at 1:12
1

The "group by" in your question is presumably the sql construct. CiviReport makes heavy use of sql to build it's results and has a 'group by' concept that is essentially an abstraction of that sql concept, though somewhat more flexible.

But of course, it's always more complicated than you think, so the "group by" thing in CiviReport isn't always available, it's only there when it's been setup by whoever writes the civireport "template".

If you are working with a report that doesn't have group by option already visible to you in the UI, it's probably not hard to add it. Look in the developer tab to provide the specific/template you're using for your report and you can probably get some more specific help.

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.