Closed

civicrm custom report -

Create a custom search OR modify / create a custom report to produce a csv file to specifications.

The attached csv is what I need to produce. It would be nice if you could include all the empty and zero columns (hidden from the user) but I can paste them into excel file later.

The report includes approx 37 custom fields.(group IDs 19 and 20) NB these fields are not searchable (not indexed) and therefore even if you expose them to a report (which I can do myself) they will not appear.

One field needs to be an aggregate of contributions for a given time period (like the existing custom search "contributions by aggregate" )

Also for any of the select fields (not the other fields) I need the values not the label eg 1 or 2 not yes or no.

For the above three reasons I think a custom search would be the way to go.

Attached is

the csv I need to produce -

the code for the existing custom search([url removed, login to view])

4 civicrm tables: civicrm_custom_field, civicrm_custom_group, and civicrm_option_group

I also attach another custom search which displays custom fields (I need HACC client and Hacc carer)

The search I need is contribution aggregate by type (multi select) for a given date range.
the result needs to be all the custom fields from group ids 19 and 20 plus the aggregate hours into column 40.

Skills: MySQL, PHP, Software Architecture

See more: php code to create report, produce report, excel paste csv, excel report csv file, excel create custom file, custom php architecture, modify csv file php, csv report, civicrm report, custom report , label software csv, csv label software, custom field search, create custom search, report csv, custom fields search, create software specifications, time tables software, php custom report, civicrm custom report, php csv file modify field, modify report php, modify csv file, custom csv file, custom civicrm event forms drupal

About the Employer:
( 0 reviews ) Adelaide, Australia

Project ID: #4430393

4 freelancers are bidding on average $144 for this job

stefanache

Hello, Please consult your PMB. Thanks.

$140 USD in 5 days
(15 Reviews)
4.8
html5css3php5

HI I will do your requirement very quick...

$100 USD in 3 days
(13 Reviews)
3.9
deepakc147

Hello. Interesting proposition. I'm ready to work.

$194 USD in 3 days
(1 Review)
0.0
sas201303

I can start immediately.

$140 USD in 3 days
(0 Reviews)
0.0
tRneVyRYVPup

Hello, We are freelance software developers. If you contact us, we can give a quote for your project and we can discuss the details. w w w . s o l v e r . i o

$140 USD in 3 days
(0 Reviews)
0.0