PDF exports indeed represent static snapshots. In this case, you would need to perform an Excel export or utilize the new tabular reporting tool. For more information, refer to the following post.
I agree with @PhanThanhSon . Tabular Reporting is your best option. It is *possible* to do this with QAA and a button but its a tricky 'plan B'-like solution.
.png "Former Employee"){kind=icon}
