binary load and order by

[#1]

Hi guys,

i am doing binary load of my data model in my report qvw.

i want to do "order by" operation on the table which has come as part of binary load in my report qvw but it does not work.

Is there any relation between binary load and order by?

Binary data.qvw;

Txn:

Load * resident Tmp_Txn

where isnull(IsInvTable)

order by TxnId, TxnDate;

The Tmp_Txn has come from binary load.

the "where" clause works but 'order by" has no effect.

Am i missing anything here?

Saurabh

[rwunderlich]

It seems to me that the order of a symbol table in a secondary sort would be less than useful when order by includes two or more fields. Consider:

Order By F1, F2

where:

F1, F2

1, 2

2,1

2,2

If I used "Load Order" for both fields in a chart, the order would be:

F1, F2

1, 2

2,2

2,1

I'm not challenging Henric's reply, but just clarifying that II think the construct of "Load Order" has limited usefulness for a secondary order by field.

-Rob

[#3]

Hi Rob,

The user has option to remove columns from pivot table and if the column is removed then sorting will be off. I need to maintain the sorting even if the column is removed from the pivot table.

[rwunderlich]

I'm still not getting it. Can you post a sample qvw?

-Rob