Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

sort order

Status
Not open for further replies.

mart10

MIS
Nov 2, 2007
394
GB
I am using CR 16

I want to sort order of report based on a parameter. I include the parameter in a formula and then put this formula in sort order

If {?SortOrder}= "Counterparty" then {qrcr_cpartyderivativeslimits.CounterpartyGroupName}
else totext({qrcr_cpartyderivativeslimits.AvailableLimit})

The only problem is I have to turn amount {qrcr_cpartyderivativeslimits.AvailableLimit} into text and when you do this the sorting order is not correct

Capture_aldk68.png
 
Add a formatting condition to your text function like this:

Totext({table.number},”0,000,000,000.00”

Add additional zeros at the beginning if numbers can be higher than 1 billion. use this in your sort formula, but display the actual field in your report.

-LB
 
this worked to large extent but didn't handle negative numbers. I would expect (want) something like this as the number sort order
-6
-3
-2
1
2
3
4
5

but I got

1
-2
2
-3
3
4
5
-6
 
Make two sort formulas like the following and add them to the sort order separately:

//{@sortbycounterparty}:
if {?Sort Order}="Counterparty" then
{qrcr_cpartyderivativeslimits.CounterpartyGroupName}

//{@sortbyavailablelimit}:
if {?Sort Order}<>"Counterparty" then
{qrcr_cpartyderivativeslimits.AvailableLimit}

Only one of the formulas will have an impact, based on the selected parameter.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top