Can you tell me the methods of generating Cross-tab reports efficiently and quickly from a Oracle database. The only method i could think of is open resultsets for row, column and the pivot column, put them in an array; then sort and search the arrays and display the results in the desired format. What if we are to have multiple levels in rows and columns?