To write advanced reports you must first ensure that:
You are an admin user
You are familiar with SQL and Sugar's database structure in order to write the necessary custom queries
You can find the full instructions on how to create advanced reports 'here'.