Setting variable in parameter formula

[Hawk45]

I am creating a parameter to do a sort on 3 columns, with the end user having the ability to select the primary field to sort upon. I have created a formula:

If{?Sort}="B" then {All_Ideas_for_Crystal.BURUcon}
Else
if {?Sort}="S" then {All_Ideas_for_Crystal.Status}

Else{All_Ideas_for_Crystal.LocationCode}


My problem is setting "B" and "S" in the parameter so that when the user is prompted to select a sort it is returning the contents of the fields. The LocationCode is the only that will populate.

What do I need to do to get the parameter to recognize "B" and "S" as variables for their corresponding fields?

 

[dgillz]

Your sort is based on this formula field, correct?

And if so, what is wrong with that? Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[Hawk45]

The problem that I am running into is that when I refresh and select an field to sort on I do not get the options of "B" or "S", I have to choose the a value in that column.

Example:
B is for BURU(Departments)
- When I refresh I select for new lookup and get the options of all of the BURUs (Accounting, IT, Payroll, etc). I select "IT" and get back nothing in the BURU column on the report. If I put ?Sort in the detail line it fills with "IT" once, even if there are 40 "IT" records. I want all 40 though.

Now if I put a LocationCode in (Paris, Omaha, Vegas, etc) it will populate the LocationCode column with all of the records for say "Paris". If there is 40, then all 40 show.

I hope that this is a little better explanation.

I appreciate your help...

Thanks,

John