CiviCRM Community Forums (archive)

Hi,

I often have reports to do, eg numbers of contacts group by country, number of contacts per tag, number of activities per contacts...

Nothing rocket science, basically a fat sql query and display the result in a table.

I'd like to add a simple framework, a la custom search, so you can create a custom report/dashboard in a few lines

/civicrm/report/custom/XXX.php

class civicrm_custom_report_XXX extends civicrm_custom_report {

setSQL () {
  return "SELECT sort_name as name, count(*) as total, bla bla FROM bla bla bla WHERE ...;";
}


and it would display the table with columns name+total+bla bla

and be called civicrm/reports?report=XXX&param...

does it make sense ? Would it be useful for someone else ?


X+