Sort parameter

[vshapiro]

I need to give user possibility to sort report by Provider name, Location, Project Type or All Project Types.

I created parameter SORT with then formula Sort which look like:
if {?Sort} = "Provider Name" then
{V_REPORTS_CALLIN.PROVIDER_NAME}
else
if {?Sort} = "Project Type" then
{V_REPORTS_CALLIN.PROJECT_TYPE_DESCRIPTION}
else
if {?Sort} = "Location" then
{V_REPORTS_CALLIN.FIELD_OFFICE_DESCRIPTION}

My question is:
When user select Project Type he can see only one particular project type. I need to let him select All Project Types. How can I do this??

Thank you

 

[PhilPPhillips]

What does your selection formula look like.

 

[vshapiro]

No, I did not do any more formulas. I Grouped by this formula, so I can change grouping by...