SSRS Report Custom Sort Order
<p>I am having some problem for a custom sorting required for one of row groups that I have in a SSRS table.</p>

<p>The logic for the custom sort order - </p>

<p>If the row group value contains a particular value then it should always be displayed at the bottom and all the other values have to be displayed in the ascending order.</p>

<p>For e.g. - </p>

<p>Suppose from the list of values <code>A,E,G,D,C,and F</code>, "D" should be always be displayed last and the other elements are to be sorted in asc order. </p>

<p>So, the above list should be sorted in the following order - 
<code>A,B,C,E,F,G,D</code></p>

<p>Or if the list of elements is - <code>P,J,M,N,D,C,K</code>
the required sort order is - 
<code>C,J,K,M,N,P and D</code>.</p>

<p>This logic has to be implemented for the row group data which gets displayed in the report.</p>

<p>Would appreciate if someone can help me out on this. </p>

<p>Thank you.</p>