Interactive sorting in SSRS RRS feed

  • Question

  • I have a table which displays data with 3 level of groupings, something like below

    + Country Name

    when the "Country Name" is expanded we see

    + Country Name
     + State Name

    when the state name is expanded we see

    + Country Name
     + State Name
      + City Name

    when City name is expanded we see the details of that city like below

      Column 1 Column 2
    + County Name Country Column 1 Country Column 2
      + State Name State Column 1 State Column 2
       + City Name City Column 1 City Column 2
    City Details Header City Details Header Column 1 City Details Header Column 2
    City1 C1C1 C1C2
    City2 C2C1 C2C2

    Now the interactive sort is set on the "City Details Header Column 1" and "City Details Header Column 2" but this sorting doesn't work, even thought the interactive sorting icon is shown & post back happen when sorting is clicked but after that on expanding the sorted image(a circle with the arrow showing ascending or descending) doesn't appear.
    Wednesday, September 30, 2009 9:17 AM