Multiple event reconciliation report

Scott McPherson

I would a report that would allow me to produce a report that shows by event, all the classes and associated students that are in a given event. We do two shows at the end of the year as we don't want our shows to be 4+ hours long. As a result, we have some classes that are in one show or another, and some that are in both. A report that would allow me to generate a view that would show me which classes are in show 1, which are in show 2 and which are in both.

Today we do a lot of manual reconciliation using the recital wizard playbook, and walking through each class to make sure we haven't omitted any classes that should be in a show, or haven't added any classes to the wrong show. The report would make this process much easier.

I could also use the output in a mail merge for the letter we send to the parents letting them know which show their child(ren) will be performing is.

I looked at the "recital participation by student" report, but I think it is generated based on the recital flag being on or off at the student level.

If there is something like this that I did find, please let me know.

Thanks for the opportunity