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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics