CiviCRM Community Forums (archive)

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.

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

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

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.