adding commission report generator and pagination fixes