Sorting Paramter 1

[SSSFisgard]

Need some help. I have a rport that needs to have a couple of different options for sorting. BY ID, Due Date, and so on. Question is how can I set the parameter to do this, and how does it affect the sort order that is currently already set in the report? Or can I define mutiple sort order, in one sort parameter?

 

[Kendel]

You will need to create a parameter prompt called {?SortBy} with some default choices (field1, field2, field3). Then write a formula field called {@SortBy} that selects the appropriate field based on the user's choice:

if {?SortBy} = 'field1' then {table.field1} else
if {?SortBy} = 'field2' then {table.field2} else
if {?SortBy} = 'field2' then {table.field2} else
{table.somefield}


and sort the report by {?SortBy}

 

[SSSFisgard]

thats wicked thanks, but I have one more for yah.

I'm trying to sort 'field1' in ascending order
and 'field2' in descending order.

Any idea how I can do that.
if {?SortBy} = 'field1' then {table.field1} else
if {?SortBy} = 'field2' then {table.field2} else
if {?SortBy} = 'field2' then {table.field2} else
{table.somefield}

 

[Kendel]

When you create the default values, under "order" drop down box, you can select what kind sort for each default value.

 

[SSSFisgard]

awesome thanks.

 

[lbass]

To have two different orders, I think you need to set up two separate formulas, one for the fields that will sort ascending and one for the fields that will sort descending. Add them to the sort screen and choose the desired order. Since only one of them will contain the selected value, the other will revert to the default ("" for a string, 0 for a number) and not impact the order.

-LB