we have alot of data , therefore we need to try and make the performance better , it seems like when we drill through , the query generated to be executed contains all these uneeded order by statements , this is making the query very slow , is there a way to totally disable this or atleast overide this so i can only do an order by maybe on one thing rather than everything like what it is doing now which is pointless?