CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • Adding Addtional Columns to Event Reports
Pages: [1]

Author Topic: Adding Addtional Columns to Event Reports  (Read 669 times)

woolaped

  • I’m new here
  • *
  • Posts: 16
  • Karma: 0
  • CiviCRM version: 4.4.4
  • CMS version: Wordpress
  • MySQL version: 5.6.1
  • PHP version: 5.4.3
Adding Addtional Columns to Event Reports
March 19, 2014, 06:54:45 am
Hi

I am trying to add a 'company' column on to my event report. Along with participant, Event, status and, role. People registering for this event put this detail in so I just want to dispay it on the  report/

Thanks

William

KilakwaBT

  • I post occasionally
  • **
  • Posts: 101
  • Karma: 11
  • CiviCRM version: 4.5.5
  • CMS version: WordPress 4.1
  • MySQL version: 5.1.68
  • PHP version: 5.3
Re: Adding Addtional Columns to Event Reports
March 19, 2014, 08:49:23 am
If you go under reports, select Event Reports and run the participant report you can set criteria. This will allow you to add columns (the one you are looking for is probably 'Organization') as well as set specific criteria for the report (event, registration dates, status, etc.)

Hope this helps.

BT

woolaped

  • I’m new here
  • *
  • Posts: 16
  • Karma: 0
  • CiviCRM version: 4.4.4
  • CMS version: Wordpress
  • MySQL version: 5.6.1
  • PHP version: 5.4.3
Re: Adding Addtional Columns to Event Reports
March 19, 2014, 09:32:54 am
Hi

Thanks, yes i found this but how to I make it stick? There is no option to save the selection once you have checked the required box?

Thanks

woolaped

  • I’m new here
  • *
  • Posts: 16
  • Karma: 0
  • CiviCRM version: 4.4.4
  • CMS version: Wordpress
  • MySQL version: 5.6.1
  • PHP version: 5.4.3
Re: Adding Addtional Columns to Event Reports
March 19, 2014, 09:38:42 am
OK found out how to make it stick by previewing, then saving selection. Unfortunatly this column doesn't appear when I go to manage events and look at the participants list?


My next question is that we have a field called 'employer' this doesn't appear as report criteria - display column option.

How do I creat it?

Thanks

William
« Last Edit: March 19, 2014, 09:45:48 am by woolaped »

KilakwaBT

  • I post occasionally
  • **
  • Posts: 101
  • Karma: 11
  • CiviCRM version: 4.5.5
  • CMS version: WordPress 4.1
  • MySQL version: 5.1.68
  • PHP version: 5.3
Re: Adding Addtional Columns to Event Reports
March 19, 2014, 01:04:40 pm
Is your employer field a custom field? If so, It will be listed in a custom field group that you may need to expand in the criteria. It may need to be a participant field to be viewed in the participant report.

As for saving I usually create the report format I want and do a save as in the report settings section. You can add it to a menu there. In a lot of cases when there are frequent events it is easier to create a special menu for registration reports. You can do this in Administration>Customize Data & Screens>Navigation Menu.

BT

woolaped

  • I’m new here
  • *
  • Posts: 16
  • Karma: 0
  • CiviCRM version: 4.4.4
  • CMS version: Wordpress
  • MySQL version: 5.6.1
  • PHP version: 5.4.3
Re: Adding Addtional Columns to Event Reports
March 26, 2014, 05:07:32 am
Sorry I am really struggling with this, how do I get into the participant fields?

I have gone into Participant Listing Options and added a new Participant listing but it seems not to be active nor let me add any fields to it.

Regards

William

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Adding Addtional Columns to Event Reports
March 26, 2014, 08:46:10 am

can u be more specific and give us urls on the demo server.

Note that participant listings are not customizable via UI. U'll need to write your own participant listing in php/sql that includes stuff u need

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

woolaped

  • I’m new here
  • *
  • Posts: 16
  • Karma: 0
  • CiviCRM version: 4.4.4
  • CMS version: Wordpress
  • MySQL version: 5.6.1
  • PHP version: 5.4.3
Re: Adding Addtional Columns to Event Reports
March 26, 2014, 10:20:04 am
Hi Donald

Thanks, I will ask my consultant to look at the UI.

Regards

William
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • Adding Addtional Columns to Event Reports

This forum was archived on 2017-11-26.