CiviCRM Community Forums (archive)

What's the status on civireport - seems like no news for a year and no real activity.

Reports are great selling points and I really miss them when showing a CiviCRM demo. Therefore I am looking at different possibilities but I don't want to duplicate efforts if civireport is still active.

Regards

Rob

We're currently in discussions with a couple of organisations for whom the reporting limitations are a real sticking point so we'd really like to make some progress on this and are prepared to contribute to make this happen, since we know it's a feature that some existing clients also want more of. One of the limitations is that through the standard searches everything works on contacts so searches for information purely on activities by area for example are not possible. We'll be constructing some custom searches to cover this kind of thing, but will it be possible at some to extend the search builder to allow this kind of search?

We are currently developing "phase 1" of CiviCase for case management - to be launched with the 2.2 release (scheduled for Q1 2009). We will be beefing up the ability to search on / list activity records in the context of Cases. Depending on time and resources, these enhancements might also be implemented for activity search / listings outside of the CiviCase component. If not, we'd be happy to give your team some pointers in getting this functionality generalized.

I've been looking at the Case stuff and it looks great: it's something that a couple of our clients in the UK voluntary sector will welcome.

The reporting requirements that are not currently met are mostly around this area. They are generally looking for the ability to produce reports such as how many activities of type x were carried out in this period with disregard for which contacts were involved as in some instances they just need the numbers and types of interventions. We have a few clients with similar requirements so we may well be able to help with getting this generalised although we're pretty busy for the next couple of months.

We've also got a more complex situation under discussion in which we're hoping to have Civi chosen as a solution over a  proprietary system which I've mentioned on this post http://forum.civicrm.org/index.php?topic=4400 and the reporting required there will be to look at activities, cases, grants and memberships without all the contacts behind those things. This is complicated by the requirement to have some kind of multi-organisation use of the system and we'd be hoping to sponsor this in 2.3. I'll try to get a clear list of searches on here.

I'd be interested to know some more about this than I can get from the video presentations which seem to be largely marketing. For example what would be involved in getting it to work with CiviCRM? Is there a demo available?

First off we charge for support.  Our software is free. So if no support is required then no fee will need to be paid.  Support will be provided for something like 200.00 annually per organization.

The product is going to be released in beta late november.  As soon as it is available I will be sure to post information here.

The product uses a data dictionary that tells the report 'wizard' where to get it's data, etc..  To get Clementine to work on CiviCRM we would need to populate the data dictionary to reflect CiviCRM's schema.  Currently it can run reports off of tables, views and stored procedures (parameterless).  We are working on getting paramaters working on stored procs.

-LeoD