I cannot use order by clause in select ouery of my html view...... ????

I cannot use order by clause in select ouery of my html view...... ????

there is always an error of xmlparsing..
i m getting data from reports and showing it through xml parsing but order by rand() clause used in the select query of my html view is not working all others are working....and that orderby rand() is also showing results in reports query table.....
can anybody have an idea how to run it ...