Hi,
i would like to know how to order the fields in XLS Export different to the order in the Form.
Could not get it to work except in the order of the original Form.
Thank you,
Thomas
Hi Thomas,
There is a Fields list box in the XLS EXport action. If you put the list of fields in there does that set the order?
if you are using a DB Read to get the data there's also a Fields list box there.
Bob
Hi Bob,
thanks for your reply.
I tried the field list boxes in the XLS export action already, but couldnt get the fields and field heads(column name in xls) into sync :-(.
Is there any other way to order fields and column names than the field list boxes?
Best regards
Thomas
Hi tonkom,
You could re-order the columns in the database table; or use a Custom Code action after the DB Read to re-sort the data after it has been loaded.
Bob
