Using a paremeterr field as Sort Field, V9

[LarryAndrew]

I have been trying to use a parameterr field in order to create a sort order in a vendor report. I^m not having much luck.__Here^s what I did:__1) I created a paremeter field "SortOrder" where 1= Vendor Name and 2= Vendor Code.__2) I created a calculated field "WhichSort" as follows:__IIF(SortOrder =1, "VENDORNAME","VENDORCODE")__3) I selected the "WhichSort" field as the field to sort on.____Note: I did nto select any index for the Vendors.dbf file in the master table.____No matter if I select 1 or 2 as the SortOrder, the report still prints in the same order.____I^m sure I^m overlooking something simple. Any help would be appreciated.____Thanks in advance.____Larry

[kfleming]

You need to take the quotes out of the field names.__Your expression is sorting on the text string __IIF(SortOrder =1, "VENDORNAME","VENDORCODE")____Without the quotes, you will sort on the actual field values.__IIF(SortOrder =1, VENDORNAME, VENDORCODE)____Regards,__Kathleen__R&R Support