I have a basic DNN 4.4.1 website & database using the 04.04.02 Reports module, and I want to be able to filter the results of a query based on a selection by the user viewing the report.

I'm using a simple Calendar module which allows user to register for events, and I want to be able for admins to view a list of the attendees of a selectable event.  Right now, I can pull the data from the Calendar db just fine, but it returns a list of people attending *every* event in the Calendar db.  I want to populate a listbox with upcoming events and have the report return a list of attendees for that specific event only.  How do I get ASP listbox and button user controls to appear and in the Reports module so I can use them?

I have basic knowledge of ASP.Net, VB.Net, and SQL; and I have Visual Web Developer Express available to play around with stuff on my machine.  Here's the basic SQL code I used to return all attendees of all events (in case it helps):

SELECT c.EventName as 'Event', c.EventTimeBegin as 'Date & Time', u.LastName as 'Last Name', u.FirstName as 'First Name', u.UserName as 'Username'

FROM ISFT_EVT_Calendar c, ISFT_EVT_CalendarSignups e, Users u

WHERE c.EventID = e.EventID AND u.UserId = e.UserID

Many thanks for the plug...   Paul.

Very helpful, thanks; and thanks to you, too, Paul!  I'll check it out once I figure out what I am doing with these forms and actually get some data in the DB.  ;)

I was about to post asking whether or not there is a manual or any documentation on the reports module, as I couldn't find anything.  I was also going to ask for some examples of sites using it in advanced ways to get a visual of whether or not it will serve my needs...you have both on your site and your module looks to be just what the doctor ordered.

I am looking at using 'Dynamic Forms' for my form creation and data fields, but just learned that it lacks reporting, which is why I am now getting active reading the reports forum...think this might be my answer.