LIST AGT_TRANS BY NAME_L BY CLOSE_PERIOD BREAK-ON NAME_L BREAK-ON CLOSE_PERIOD WITH CLOSE_PERIOD = '201402' AND WITH STATUS = 'P' TOTAL ROYALTY_BASE TOTAL AGT_ROYALTY TOTAL TOT_ROYALTY
Replace the bold date with the four digit year and two digit month that you would like the report to show royalty for.