Hello,

My company uses the events module for webinar training events. We typically have at least 10 events per week. This is working well for us in the exception of identifing which customer have enrolled for a specific event becuase you have to have edit access to to do so. Is there anyway I could use the reports module and create a list of  enrolled users for each event? I would like all events to be in a single report. Can something like this be done? If so,  what tables would I need to query?   Maybe even an example would be greatly appreciated!

Thanks,

Heck

That works very well.

Below is the SQL statement if it is of benefit to anyone else. It will save you some time. Displays Event, First Name, Last Name, e-mail address, and Begin Date. Default sort order is set to Begin Date (descending).

SELECT

Events.EventName AS Event, Users.FirstName AS [First Name], Users.LastName AS [Last Name], Users.Email AS [E-Mail], .EventTimeBegin AS Date

FROM

Events

Wow, this is great. It works for me when I just add 'Events' to the .EventTimeBegin part. My question however, is how does one specify a specific portal to query. I noticed with this query that all events registered for are shown.

thanks,

Kay