Sort parameter question 1

[vshapiro]

I created sort parameter to give user possibility to sort by desired field. Then Create Sort formula:

if {?Sort} = "PROJECT_NUMBER" then
{Command.PROJECT_NUMBER}
else if
{?Sort} = "DATE_OF_COMPLAINT" then
totext({Command.DATE_OF_COMPLAINT}, "yyyy-mm-dd")
else if
{?Sort} = "ALLEGATION_SOURCE_DESCRIPTION" then
{Command.ALLEGATION_SOURCE_DESCRIPTION}
else if
{?Sort} = "TARGET_NAME" then
{Command.TARGET_NAME}

and grouped by this Sort formula. When I grouped I did it ascending. My question is:
Can I give user ability to select sort in ascending or descending order?

Thank you

 

[synapsevampire]

Sure, but keep in mind that you're not offering a sortation, you're offering a grouping, a side effect of which is sortation.

Here are the whitepapers on sorting and ascending/descending:

http://support.businessobjects.com/library/kbase/articles/c2008546.asp

http://support.businessobjects.com/library/kbase/articles/c2006057.asp

-k

 

[vshapiro]

thank you very much