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.

Beceriler: MySQL, PHP, Yazılım Mimarisi

Daha fazlasını gör: 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

İşveren Hakkında:
( 0 değerlendirme ) Adelaide, Australia

Proje NO: #4430393

Bu iş için 4 freelancer ortalamada $144 teklif veriyor


Hello, Please consult your PMB. Thanks.

in %bids___i_period_sub_35% gün içinde140%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(15 Değerlendirme)

HI I will do your requirement very quick...

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(13 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde194%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)

I can start immediately.

in %bids___i_period_sub_35% gün içinde140%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde140%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)