How to Schedule Report on mail according to role?

I have following reqirement:-

  1. I have setup role according to hierarchy like RM > BM > ASM > Distributor
  2. I want to schedule report over mail according to role.