Comments

• I think that you can make a sql sentence for obtain just the info like you want group by role, using pivot, and just print it

  in How to set a Condition for bound Text Object while getting Data From DB ? Comment by wscan March 2011