Feature Request: Column Order Preference?

[Peardian]

Perhaps you could have a way to set the preferred order for columns in a report?

For example, in the report I am doing, if the first order in the list is a new order, the Order ID column is added at the end (as I intended), but if the first order is already in the system, the Order ID column is put in the middle. It would nice to be able to have a way to make the column always be last (or anywhere else in order) without having to create a bunch of empty columns.

[carl689]

Can you give me a code markup example?

[Peardian]

Possible usage example:

$r = new cReport;
$myPref = array("name", "age", "height", "weight");
$r->setOrderPreference($myPref);
//(data sets added as normal)

Data sets given: name, age, weight, city
Resulting table: name, age, weight, city
(does not create unnecessary columns even if defined in the preference)

Data sets given: userID, height, name, age, city
Resulting table: name, age, height, userID, city
(names in the preference come before new ones)