Skip to Content
0
Former Member
Sep 16, 2008 at 01:51 PM

Change the sort order (ascending/descending) based on parameter field

1047 Views

I have created a formula on a subreport to change sorting based on variables.

select {?Pm-@Sorting}

case "property_type_desc ASC" :

{owned_property.property_type_desc}

case "property_type_desc DESC" :

{owned_property.property_type_desc}

default:

({owned_property.property_type_cd}; )

how can I change the sort order ascending and descending using the formula??

Thanks, Jessica