Hi,
I have a select statement like this:
SELECT t1.*, t2.*, t3.t3_field1, t3.t3_field5
FROM table1 t1
JOIN table2 t2 ON t1.userid = t2.userid
JOIN table3 t3 on t2.field_x = t3.field_4

both tables have over 60 columns each, but I'm only reporting on about half of them. I am using the grid for display and export purpose only (users can search and reduce the number of rows they see and then export.)

Further down the code I have :
$col = array();
$col["title"] = "Full Name";
$col["name"] = "t1_fullname";
$col["hidden"] = false;
$col["editable"] = false;
$cols[] = $col;

$col = array();
$col["title"] = "t3 data";
$col["name"] = "t3_field5 ";
$col["hidden"] = false;
$col["editable"] = false;
$cols[] = $col;

$col = array();
$col["title"] = "Middle Name";
$col["name"] = "t2_somedata";
$col["hidden"] = false;
$col["editable"] = false;
$cols[] = $col;

$col = array();
$col["title"] = "More t1 data";
$col["name"] = "t1_other";
$col["hidden"] = false;
$col["editable"] = false;
$cols[] = $col;

$col = array();
$col["title"] = "t3 data2";
$col["name"] = "t3_field1 ";
$col["hidden"] = false;
$col["editable"] = false;
$cols[] = $col;

There is a very big list of (about 60) columns here.

everything seems to work correct in displaying the grid and sorting the data.

When I export though, the fields are displayed in excel in the order of the SELECT statement and not in the order of the columns.
If I work with a small number of fields that's not an issue as I can manually enter the field names into the select statement. When working with a large number of fields, this becomes impossible. It can be done if the code never changes, but often we will get requests from the users to move fields around, introduce new fields etc.

If there a way to tell the export function to make use of only the columns in the $col array?

Thanks