Exporting event registrants to excel sheet?

How would I export our event registrants to excel?

We use event module to register and paid through service central. How would I export all of registrants list with all function purchased?

Thanks,

 

Tim

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

You can create  IQA query

You can create  IQA query using CsRegistration and CsRegFunctions business objects to retrieve registrants list. But this list creates duplicate entries if any registration has more than one function selected.

May be you can write some macros in Excel to remove duplicate entries.