I have some users who are complaining that when they download results from WebI the objects are not in the same “order” as they constructed the query. For example, if their query has Cust Name, Cust Number, Location, Department, metric1, metric2, metric3, etc their Excel file has these objects swapped around.
WebI 2.7.0
Server - AIX 4.3.3
dB - Oracle 9i
I’ve not been able to replicate this scenario.
Ron Briggs (BOB member since 2002-09-11)
From what I remember with WebI 2.7 when the results are downloaded it is in the order from the Dataprovider. The Column order is the order in-which the Dataprovider was created. IF you create a query with Cust Name, Cust Number, metric3 run it and then Edit to add Location and Department, re-oder the columns to Cust Name, Cust Number, Location, Department, metric1, metric2, metric3, the SQL query will still run as Cust Name, Cust Number, metric1, metric2, metric3, Location, Department unless you delete metric1, metric2, metric3, Location, Department and re-add them in the order that you would like to see them in on your download.
cduey 
(BOB member since 2002-09-05)