5

Connecting with API could be a better solution. This is how I did it: Step 1: Prepare data in CiviCRM Get the site key Create a CiviCRM and Drupal user with correct access rights Get(Create) the API-key of that user Create a data processor with relevant data, accessed with API First column to be an index key, used to connect with other CiviCRM data sources ...


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.


3

Reporting needs vary widely, and Jasper is a heavy-duty solution compared to pretty much anything else. SearchKit is the future of advanced report building within Civi. CiviReports is clunky and requires custom code to do much of its heavy lifting. There's very little that can't be done with SearchKit today that can be done with CiviReports, and that list ...


3

You can build that with Search Kit Try this on dmaster.demo.civicrm.org


3

I was able to do this with a Drupal View and adding the Views Aggregator Plus module. I created a view using Contributions. The format was Table with Aggregation Options. I added the Filter Criteria and Fields that I wanted to display. In the Format:Settings-- I "grouped and compressed" the Recurring Id field "Count" the Contribution ID ...


2

Another option is to use Data processor extension, you can output the result as search or report or dashlet.


2

I recommend the summary fields extension: https://civicrm.org/extensions/summary-fields It'll keep a calculated copy of the last contribution amount (and many other useful fields) as custom fields of the contact, making reporting like this much easier. Because contributions are stored in a separate table, generating fields like 'last contribution' tends to ...


2

If you use Advanced Search, then there is a section called Change Log, with an option of 'created' and you can set your date parameters including Date Range You can also do it via Search Builder If you cannot find Change Log there then you may need to enable Logging civicrm/admin/setting/misc?reset=1, or check your Search Display Preferences civicrm/admin/...


2

You can with SearchKit... Try this link on dmaster (Note all the configuration is in the link so it won't get wiped out by a dmaster refresh.)


2

Pay Later isn't available in reports provided by core civicrm. I added this to extendedreport extension recently - https://github.com/eileenmcnaughton/nz.co.fuzion.extendedreport/pull/434 The PR is merged so you can use the latest (or master) version and use contribution details extended report to find the required filter.


1

There's also a Date Added search under Search - Custom Searches.


1

Just a directory filling up. Deleted some unused files and the error went away.


1

In our experience using docx with the core features only works for very simple templates. Have a look at the CiviOffice Extension instead. It's still in development but could already do want you want: https://docs.civicrm.org/civioffice/en/latest/


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 ...


1

If you run it manually from the scheduled jobs screen you need to edit the mail report entry there and set those parameters. Normally you would set them in the specific command you use for cron for a specific report. See https://docs.civicrm.org/user/en/latest/initial-set-up/scheduled-jobs/#job_mail_report. For getting the instance id that's a good point. ...


1

I am hoping to overcome this by November. I will be offering a mobile app by subscription that automates much of this, but on the CiviCRM side there will be a couple of available extensions which provide the underlying functions. My thought is to use geocoding and populate a list of volunteers creating a walklist smart group with each volunteer and their ...


1

How about creating an ACL(View only) on a group and restricting the report based on custom permission? Isn't creating a view or report using dataprocessor not an option?


1

OK, my bad. I had to update the nz.co.fuzion.extendedreport extension, too.


1

You're correct, however you can do this with the new Search Kit. It's currently an optional extension under Admin - System Settings - Extensions. After enabling there's a new option under the Search menu.


1

As per comments it sounds like the report is set to Add To My Reports on the access tab (making it private to the owner).


1

Go to the report you want to add to your "My Reports." Click on the Access tab at the far right. Check the box beside "Add to my reports? That should do it for you.


1

My guess is you have a cron job scheduled to do this. See https://docs.civicrm.org/user/en/latest/initial-set-up/scheduled-jobs/#timing for how to adjust your timing.


1

I think it's at the below link and yes it's strangely missing. Do you want to open a lab ticket? https://github.com/civicrm/civicrm-core/blob/33307b5a0da280c63ed0d8fa1f8a3e899a217ad0/CRM/Report/Form.php#L5473


1

Under Administer > Customize Data and Screens > Date Preferences you can adjust various date settings. In this case it's a little unclear but rather than changing the "Birth and deceased dates" setting you need to adjust the "searchDate" setting which is "Used in search forms and for relationships." The "Start offset&...


1

And another solution to check out using the CiviCRM Data Processor Extension


Only top voted, non community-wiki answers of a minimum length are eligible