Order By percentage from low to high
Hi
I know how to add the order by in a datasheet but can I do the same for a field in a table? I am doing the following expression in a table
=Abs(Fields!Sum_Billed.Value/Fields!Sum_WriteOutThisPd.Value)
And want the results to be order from the lowest percentage being at the start to the highest percentages being at the end.
Cheers
June 17th, 2011 8:46am
Hi Chris Johnson - Barringtons,
It seems that you would like to order by percentage from low to high, please take the following steps as a reference,
1. On the design surface, right-click a row handle, and then click Tablix Properties.
2. Click Sorting.
3. For each sort expression, follow these steps:
a. Click Add.
b. Click “fx” button, and type in the expression:
=Abs(Fields!Sum_Billed.Value/Fields!Sum_WriteOutThisPd.Value)
c. From the Order column drop-down list, choose A-Z sorts
4. Click OK to apply these settings.
Note: A-Z sorts the expression in ascending order.
Z-A sorts the expression in descending order.
For more information, please refer to the following article,
How to: Sort Data in a Data Region (Report Builder 2.0):
http://msdn.microsoft.com/en-us/library/dd255193(v=SQL.100).aspx
If you have any question, please feel free to ask.
Thanks,
Eileen
Free Windows Admin Tool Kit Click here and download it now
June 21st, 2011 5:37pm
Thank you again!! Sorry I am very new to reporting and am learning as I go along.
June 22nd, 2011 11:48am