>Hi Julie,
> Please, help me to understand this.
> Where do I put the code that you gave? On the report?
> Can you explain more about it?
> Thank you so much, I am looking forward to your reply.
> Thanya.
I think she meant to put the expression in your remote view definition. Basically, you are adding a column to the view with the following expression:
IIF(contacttype = “CO-LOCATION” , 1, IIF(contacttype = “DATA” , 2, IIF (contacttype = “VOICE” , 3, 4))) AS TempOrder
Then in the ORDER BY clause of the view, you would replace it with:
ORDER BY 7
(I think you have to use 7, the position of the column, rather than the column name, "TempOrder)
Chris McCandless
Red Sky Software