Would like to create a report showing all of the witnesses and the events they witnessed for one specific person. This would help in creating a FAN club. A SQL query would be great!
I don’t believe that there is a Report or Search method to accomplish this within RM. Probably best to direct discussion of a SQL query to the SQLite Tools for RootsMagic site that @TomH hosts. The WitnessTable is described on the DataDictionary page and there are several queries that have been written related to shared events that could probably be modified to accomplish the report you are interested in. The site also has a forum where you could post questions or ask for help.