preparing query results toward reporting