4 Replies Latest reply: May 21, 2012 2:19 PM by Avinash_Varma RSS

    Sorting within a group.. Wierd

    TexasApexDeveloper
      I have an existing rtf that I am trying to modify slightly to order data according to my users new needs....

      A sample of the xml data for the report follows:
      <ROWSET>
         <ROW>
            <POOL>Ag</POOL>
            <PERF_NON_PERF>Performing</PERF_NON_PERF>
            <CSS_TAG>Normal</CSS_TAG>
            <CURRBAL>146218378.95</CURRBAL>
            <LOWVAL>76949700.35</LOWVAL>
            <HIGHVAL>98304577.9</HIGHVAL>
            <LOWPERCENT>52.63</LOWPERCENT>
            <HIGHPERCENT>67.23</HIGHPERCENT>
            <LOSSHIGHPERCENT>14.82</LOSSHIGHPERCENT>
            <LOSSLOWPERCENT>8.05</LOSSLOWPERCENT>
         </ROW>
         <ROW>
            <POOL>Ag</POOL>
            <PERF_NON_PERF>Non-Performing</PERF_NON_PERF>
            <CSS_TAG>Normal</CSS_TAG>
            <CURRBAL>15111004.81</CURRBAL>
            <LOWVAL>6384389.28</LOWVAL>
            <HIGHVAL>7809359.81</HIGHVAL>
            <LOWPERCENT>42.25</LOWPERCENT>
            <HIGHPERCENT>51.68</HIGHPERCENT>
            <LOSSHIGHPERCENT>42.96</LOSSHIGHPERCENT>
            <LOSSLOWPERCENT>29.98</LOSSLOWPERCENT>
         </ROW>
         <ROW>
            <POOL>Ag</POOL>
            <PERF_NON_PERF>Sub-Total</PERF_NON_PERF>
            <CSS_TAG>Bold</CSS_TAG>
            <CURRBAL>161329383.76</CURRBAL>
            <LOWVAL>83334089.63</LOWVAL>
            <HIGHVAL>106113937.71</HIGHVAL>
            <LOWPERCENT>51.65</LOWPERCENT>
            <HIGHPERCENT>65.77</HIGHPERCENT>
            <LOSSHIGHPERCENT>17.45</LOSSHIGHPERCENT>
            <LOSSLOWPERCENT>10.11</LOSSLOWPERCENT>
         </ROW>
      I have the report grouping on Pool and the perf_no_perf, which works okay, however, the data is order in this order:

      Sub-Total
      Performing
      Non-Performing

      Users would prefer

      Performing
      Non-Performing
      Sub-Total


      Any way I can modify the existing rtf and make this change without loosing all the formatting I have done to get the look and feel the way they want?

      (I can send rtf and sample data upon request)..

      Thank you,

      Tony Miller
      Dallas, TX