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 CiviReport (Moderator: Dave Greenberg) »
  • Last and First Name on reports
Pages: [1]

Author Topic: Last and First Name on reports  (Read 1570 times)

gmotyka

  • Guest
Last and First Name on reports
May 27, 2010, 02:34:50 pm
I'd like to have Last Name then First Name in 2 separate fields in all of my reports rather than the full name in one field.
Any ideas?
Thanks!!! ;D


CiviCRM 3.1.3
Joomla 1.5.15

Rajan Mayekar

  • I post frequently
  • ***
  • Posts: 177
  • Karma: 20
    • Rajan's Blogs
Re: Last and First Name on reports
May 27, 2010, 09:38:16 pm
You need to modify $this->_columns to take first_name and last_name fields

This will help you.
http://wiki.civicrm.org/confluence/display/CRMDOC/CiviReport+structure+and+customization

Best Regards,
Rajan

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: Last and First Name on reports
July 21, 2010, 07:44:51 pm

in general pasting complete sections of code on the forums is not recommended

seems like you might want to consider hiring someone from http://civicrm.org/professional/ to help you make the desired changes

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

mdlueck

  • Ask me questions
  • ****
  • Posts: 382
  • Karma: 4
  • CiviCRM version: 4.7.24
  • CMS version: Drupal 6.x
  • MySQL version: 5.5.54
  • PHP version: 5.3.10
Re: Last and First Name on reports
April 11, 2011, 11:11:23 am
Thanks Rajan for your pointer.

Our organization also wises to sort via last name. I would think this a common enough request, so perhaps it could be considered for Civi core and eliminate for us to develop a custom report. (hint, hint...)

As a bonus, I am going to attempt to modify the "Membership Report (Detail)" report in such a way as to leave First and Last name fields separated when the Export to CSV is performed.
--
Michael Lueck
Lueck Data Systems
http://www.lueckdatasystems.com/

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: Last and First Name on reports
April 11, 2011, 12:32:23 pm
Quote
Our organization also wises to sort via last name. I would think this a common enough request, so perhaps it could be considered for Civi core and eliminate for us to develop a custom report. (hint, hint...)

Hi,

You might have heard about mih http://www.civicrm.org/mih that seems to be a good way of providing improvements to civicrm while feeding the developers. In general, when the org(s) with the initial request is providing about half of the funding, the new feature is added as one looking for further funding (hint, hint ;)

Rajan seems to point out to a simple solution (read: that one single org could fund with a few hours of development...)

X+
X+
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviReport (Moderator: Dave Greenberg) »
  • Last and First Name on reports

This forum was archived on 2017-11-26.