Hello, is there way how register user can view list of all other people enrollmented to event?

Hmm, i seem to be looking for all the features that are not there. :-)

Ok, workaround for the SQL experts. Can someone provide a SQL query that would list the Event Date, Users First, Last, display Name, and Approved that i can plug into the reports Module?

This is presuming that a multiple weekend event should show as one event? (I admit I have not even browsed the SQL tables so i have no clue how it sets up events. Hence the desparation plea.      )

And Roger, is this feature been requested as an enhancement in Gemini yet?  I see it best as a flagged option for Enrollment settings and showing when they drill into event details.

Thank you in advance (it will save me snorkling if i get an answer soon)

Dean

Here is a query:-

SELECT     Events.EventDateBegin, Events.EventName, Users.FirstName, Users.LastName, Users.DisplayName, EventsSignups.Approved
FROM         Events INNER JOIN
                      EventsSignups ON Events.EventID = EventsSignups.EventID INNER JOIN
                      Users ON EventsSignups.UserID = Users.UserID

Note that all recurrence and duration is currently stored on one record (this may change in the future). You can get more detail on the table and relationships here - http://opensource.indyneinc.com/home/Support/DeveloperExchange/TehnicalPublication/DNNEvents/tabid/145/Default.aspx

Cheers
Roger