Just wanted to share how a volunteer Admin for one of our projects is handling assets - e.g. Table assignments for Events; Room assignments for Camp; Equipment etc.
Warning: must be abstract thinker - and you'll never look at Tables the same :-)
Let's look at Table assignments for Events - as I have the site open and can pull in some screenshots - to Demo ...
This type of report is called a "pivot table". There's a report that will do what you want in the Extended Reports extension. If you don't have that installed, do the following (or ask your administrator):
Go to Administer menu » System Settings » Extensions.
Click the Add New tab.
Search for Extended Reports in the extension list and click the ...
If you mean exporting after doing eg a Search or Advanced Search, then on the screen where you select which fields to export, you can check a box to save that common set of fields for future exports (see image below). Then, the next time you go to do an export you can select to "Use Saved Field Mapping" and select the previously saved set of fields.
There was a pretty good 101 session about custom report in CiviCon Denver 2015. Unfortunately, there don't seems to be a video about it. You can check resources here : https://denver2015.civicrm.org/sessions/civicrm-custom-reports-101 (pdf and custom extension).
My recommended steps for doing a custom report :
you must first do the sql query you want in ...
This does appear to be a legitimate issue, so I've created a bug in the tracker here: https://issues.civicrm.org/jira/browse/CRM-18079
Generally it's better not to use this folder for maintainability reasons - it is better to use an extension - but since it is an advertised piece of functionality, it should work as intended!
Thanks for reporting this.
In case you don't know of it, there is a Custom Search available under 'searches' for Include/Exclude Groups. So you could use that.
Step 1: create a Smart Group based on Activities within timeframe (A)
Step 2: create a smart group of 'all individuals' (B)
Step 3: use Include/Exclude Search to say B minus A
Old question but for a CiviCRM only solution, I found that Extended Report has a Report Extended Report - Flexible contact report that does an aggregation of all the phone numbers.
As of version 5.8, you have to use the following PR to make it work : https://github.com/eileenmcnaughton/nz.co.fuzion.extendedreport/pull/461
To use this method :
Since you are using Drupal, I would also suggest considering how much you can save most users getting in to CiviCRM at all, and providing a lot of the UI via Views and Webforms. We have done this for chapter based organisation, and this has often involved using the Permissioned Relationships extension to provide the ACL.
The outcome is that the user can ...
I just ran into this issue (on current Drupal, current CiviCRM setup) and confirmed that the way it's set now, a non-admin user needs the permission "access deleted contacts" to run this report.
Hope that's helpful - not much of an answer but I lost access to my old account and don't have enough rep to post a comment :)
The questions about "assign housing and coordinate special needs" would really need more specific requirements to be able to provide a substantive answer.
If 'assign housing' means something like, "provide fields so people can indicate whether they want single rooms, shared rooms, or specify other attendees that they want to share with" then yes I can ...
As ErikH stated it is always good practice to create a new extension or create a custom folder to override core files
So In order to add a supplement address in the report you need to add a new column to the report first
'civicrm_address' => array(
'dao' => 'CRM_Core_DAO_Address',
'fields' => array(
Can't comment on CiviReports, but I know my way around Drupal Views enough to suggest that as an alternative option since it allows you to specify for each field/column which Location Type to use for the phone, email etc
And to ensure you only see a single row for John even if he has multiple Work Phones it looks like there are two approaches.
Views Merge ...
Follow the below step get the contacts report with tag values.
Find contact using search option. (sitename/civicrm/contact/search?reset=1)
Click on search without apply any filter if you want report for all contact.
Select the contacts and then perform the action export contacts
select this option Select fields for export and Do not merge on this page.
(Expanding comment as an answer...)
Reports > Contact Reports shows the Reports that have been created from Report Templates. Your extension adds a Report Template, so from Report > Contact Reports, click 'New Contact Report' to see the templates. Select your template, configure and save as a new Report.
Use a Thank-You Letter.
Run a contribution report for 2016.
Select the individual(s) you want to create reports for
In the Actions dropdown, select "Thank-You Letters for Contributions"
Select your Grouping (I use Contact)
Select Your separator-- Comma will put all information into groups separated by commas, Table Cell will separate each contribution into ...
Regarding reports, it is possible to create an instance of a report (Administer > CiviReport > Create new report from template) that includes the fields, filtering and grouping options, etc., and to save it so that it can be reused directly from a menu item. Individual users can also add these personalized reports to their user dashboard as reportlets. And ...
This will result in one api call per row, which can add up to a lot of queries on the db.
A lighter-weight solution would be do do a single api call before the loop to look up all location types and store them in a local variable, then you can use array_search or similar for each row to get the proper value.
Ok here's what I do when faced with situtations like this: check how Eileen does it:
At times I'll extend one of her extended reports; it's a very well written extension.
Check out an example here - this is a report that joins tables the extension creates/maintains with other civicrm core tables to produce this report:
I think you can get what you want with the "Event Participants Report" (under the Events > Event Reports Menu). In the "Sorting" tab, just tick the box for "Section Header / Group By" against "Last Name, First Name". You use the "Filters" tab to restrict to a particular time period, set of events etc.
In general if I can't do something off the shelf in ...
A bit of css will do it.
I would suggest to create a new css file in you custom directory like /wp-content/plugins/files/civicrm/my_css/my_stylesheet.css
Navigate to Administer->System Settings->Resource URLs and put your URL to the css file http://yoursite.com/wp-content/plugins/files/civicrm/my_css/my_stylesheet.css
In your css file:
Our need was for class rosters which included the one or two adults approved to pick up the child from class.
The result is a list which displays a child's info on the same line as the adult(s) approved for pick up.
For this solution we actually needed two views; View A shows the adults and is embedded into View B which lists the kids, using the contact ID ...
I will add this as an answer so i can add the screenshot. You 'should' be able to filter by Groups in a civicrm contact based View. In the screenshot you will see i have both Group Name and Group ID set as fields, and have Group ID set as an Exposed Filter. Hope that helps if only to confirm that something is amiss in the world of Views for you.
(Note: on ...
When starting on reporting I did a lot of debugging in my report and in the parent class to find out what was happening.
Your specific error: I strongly suspect 'relationship_type_c_civireport.label' should be 'relationship_type_id_c....' but I am not sure.
Check if there is a postProcess function in your class. If there is, it should call the parent ...