Can I pull in fields from another table?

Yes — fields are grouped by their table. On an Evidence report you can add the linked pupil’s year group, SEN status, date of birth or UPN, plus the reporter.