Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need your help!
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Miscellaneous
Thread ID:
00425972
Message ID:
00426183
Views:
41
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform