Courses-Request-approved-enrolled report is perfect for our needs, by student with advisor name.  Unfortunately it's pulling the advisor from the future year, which makes no sense. Advisors are not assigned that far in advance.