Subscribers and Groups Report

Would it be possible to have a report option for the Subscriber (Prime) AND the Group Members (Affiliates)? This would be helpful in seeing those individuals that are associated to a Subscriber. This is important to determine who is "approved" to sign up for Events and also who is associated to a Subscriber.

Thanks in advance...

Any progress on this request?

So I see that this has been accomplished with the most recent release of Membership Pro, thanks. The request was initiated 10 months ago, am I required to purchase again to receive this feature??? Please advise.
Reference:
www.joomdonation.com/forum/membership-pr...-members.html#102193

Thanks in advance

Hi

Please see www.joomdonation.com/forum/membership-pr...-members.html#103947 to see my response

Regards,

Tuan

BTW, I only monitor the Features Wish List forum, but not always reply to topic posted here. When you post a features request, if it is an important feature which is needed by most customers, I will consider implement it first

However, if there are more important features on my todo lists, I won't work on the suggested features right a way and have to leave it to future development. I also could not promise that every feature posted here will be implemented, I can only implement the features which I see that it is useful for other customers as well (and requested by at least few customers)

Regards,

Tuan

May I recommend the free Joomla Extension called Fabrik for creation of such reports.

I have used it to create lots of custom reports using a combination of data stored in database tables by:
- core user features of Joomla
- Membership Pro
- Acymailing

It takes a little bit of learning and it helps if you have SQL skills.
A lot of my reports are based on new mysql views I create from the underlying tables.

Alan

Can you elaborate or provide steps on how this can be accomplished? I've installed Fabrik, and looked at the Videos, but cannot seem to get the Parent and Groups tied together for a report.

Thanks in advance for any support...

Thanks

If you can tell me what you want to achieve, maybe attach a file with a layout of the report I can give some advice.

You may need to go into the database and create a view. I do this a lot as its easier to create the query that way and then get fabric to report on a single view or maybe just a small number of tables. You need to be able to join the same table to its-self as group members are in the same table as the main member. Custom fields are also complex as they are all separate rows in the one table.

I can probably create the sql for you to create the view once I know what you want to report.

Thanks for the response Alan. I'll put something together and send it over. In short, I'm looking to have view the Subscriber (Parent) with their respective groups. Or, the Parent/ Child relationship in Membership Pro (Subscribers and associated Group Members).

Stay tuned...

Thanks

Hello Alan - Thanks for assisting with this issue.... We are looking at the Subscribers Report and the data available. It would be great to have the ability to match up the user_id with the group_admin_id and report out the relationship. We have a "one to many" situation here, where the user_id could be listed as the group_admin_id on multiple users. It would be ideal to look up the user and pivot or select the group_admin_id, to show the actual parent. Or, we could view the parent and show the related child (those with the parent user_id associated).

Hope that helps to explain things. I've looked at exporting and then creating vlookup and index/ match via excel with now success. I'm not versed enough in MySQL and Fabrik to get a handle on creating a such a report.

Appreciate any feedback that you could share...

Best,

Marc