Filtering and sorting Membership Report

[JMM]

Hi,

I feel a bit desappointed with CiviReport :
- I would like to select an Organization (or Source) (I have several different ones, independant from one-another)
- I would like to sort by Membership Type (and then Name)

Is there any possibility to do that ?

4.5 Demo does not seem to propose any enhancement in this area, either.

[Donald Lobo]

You can help fix your disappointment

can you and/or your organization develop and contribute the report you need as an extension?

this will help you and avoid disappointing other folks looking for a similar report down the road

thanx

lobo

[JMM]

Hi Lobo,

Thank you for answering me.

I'd really be happy to follow your suggestion, but I am not really a programmer (and have none knowing CiviCRM) : I have just some limited skills :
- I can read and understand CiviCRM MySQL Tables and structure
- I can write (or modify) an SQL request (e.g. to include a new field like membership_type from the pertaining joined Table)
- I can also probably make some limited PHP modifications, provided that someone tells me in which PHP file(s)
- and I can test.

This does not seem too complex, but requires that someone tells me :
- where is the SQL request to modify
- which PHP file(s)
Would you ?

As an alternative, I also envisioned to use an external tool like FPDF (http://www.fpdf.org/?lang=en), besides CiviCRM, directly plugged to the CiviCRM DB, which I feel I could manage (based on PHP scripts provided on their site).

But of course, I'd prefer a CiviCRM consistent and integrated solution, compared to this hardcoded one.

Thanks again for your help

[Donald Lobo]

developer docs answers most/all of your questions. Check:

https://civicrm.org/participate/developer
http://wiki.civicrm.org/confluence/display/CRMDOC/Develop

lobo

[JMM]

Well !

I am going to climb the cliff (at least try to ...)

One question to begin : should I modify the current Membership Detail Report (adding one column, one or two filters, and one or two sort criteria), or create a new one (and then how should I name it ?) ?

I'll come back to you within a few days (time for me to learn and try) ;

In the meanwhile, I would appreciate any more help that you can

Thanks in advance

[JMM]

Hi Donald,

I did my best, but did not succeed : I am not skilly enough with PHP, nor familiar enough with Civi programming architecture

I finally developped a spare and interim standalone report, using FPDF and direct connexion to the DB (by simply modifying a public PHP example) ; of course, not flexible as could be wished.

FYI, I enclose a copy of this program (just change .txt to .php) (it requires an argument to select the Source)

Anyway, I remain interested in Membership Detail report improvements.

Thanks a lot for your attention

[JonGold]

Hi JMM,

I just saw this thread, and you'll be happy to know that completely independently of this, I added the ability to sort the Membership Detail report by membership type just this week!  It should be merged into Civi 4.6.

[JMM]

Hi JonGold,

That's good news

Will there also be the ability to select only one Source (Organization) ?

If yes, it would be super !

Anyway, thank you ; I look forward to seing that.