improved subscription report