You can perform data sorting in both the report script and in SQL. But both are only capable of sorting data by specified field(s). To so...

Sometimes the source data needs to be transposed before displaying it in the report. But cross table can only handle the most basic transpo...