Hey there,

I would like to create some specific reports 1st for administration purpose and in a 2cd step, for the user.

For instance :
- list of Events not linked to a Group
- list of Events with the list off all Attendees
- list of Users with their Events they attend
- etc.

Can you explain and elaborate more in details on what do you mean on your above statement as I don't understand on what are you trying to bring it up here?

Hi Irwin,

what do you not understand?

- I want to create customized reports (see sample above)
- If there is no embedded tool to do it, I need to code a separate page with a SQL request, in order to display a customized report
- My question is : can you help me to start by providing me a sample of the code I need ?

This is actually beyond the scope of our support but I can provide you with one sample:

[gist]
<?php
$db = JFactory::getDBO();

// Getting events that are not linked to any groups
$query = array();
$query[] = 'SELECT * FROM #__social_clusters';
$query[] = 'WHERE cluster_type="event"';
$query[] = 'AND parent_id=0';

$query = implode(' ', $query);
$db->setQuery($query);

$items = $db->loadObjectList();
[/gist]

Please understand that as this is a non supported ticket, we will not be able to provide any support for this.

Thanks Mark

I know that my request is beyond the scope of your support.

Really appreciate.

Thanks
Henri

Thanks for understanding.